1054 error on importing news feed
By Sam on Sunday, 12 July 2015
Posted in General Issues
Replies 9
Likes 0
Views 516
Votes 0
I attempted to create a test run rss import and got this error.

Unknown column 'item_team' in 'field list' SQL=INSERT INTO `wngmp_easyblog_feeds` (`id`,`title`,`url`,`interval`,`cron`,`item_creator`,`item_team`,`item_category`,`item_frontpage`,`item_published`,`item_get_fulltext`,`language`,`item_content`,`author`,`params`,`published`,`created`) VALUES ('','Science','http://www.sciencedaily.com/rss/top/science.xml','5','1','708','','42','1','1','0','','intro','1','{\"allowed\":\"<img>,<a>,<br>,<table>,<tbody>,<th>,<tr>,<td>,<div>,<span>,<p>,<h1>,<h2>,<h3>,<h4>,<h5>,<h6>\",\"copyrights\":\"\",\"sourceLinks\":\"1\",\"autopost\":\"0\",\"feedamount\":\"50\",\"item_get_fulltext\":\"0\"}','1','2015-07-11 17:38:10')

RSS url was http://feeds.reuters.com/reuters/companyNews
Hi Sam,

I am really sorry for the delay of this reply as it is a weekend for us here.

It seems like you missing that `item_team` columns from wngmp_easyblog_feeds table, I already run this query in your site, it should work fine now.

ALTER TABLE `wngmp_easyblog_feeds` ADD `item_team` int(11) NOT NULL;


Please have a check.
Arlex Wong
·
Sunday, 12 July 2015 11:19
·
0 Likes
·
0 Votes
·
0 Comments
·
I am sorry. I do not see any rss imports
Sam
·
Tuesday, 14 July 2015 00:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Sam,

Hm, sorry but not really sure if I understand you here. Do you mean you still hit those errors?
Mark
·
Tuesday, 14 July 2015 01:39
·
0 Likes
·
0 Votes
·
0 Comments
·
I do not see those errors, but neither do I see any imports, and I was using Reuters for a test
Sam
·
Tuesday, 14 July 2015 01:46
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Sam,

I seen those posts already imported in the posts listing. Are those posts not from the feed?
Mark
·
Tuesday, 14 July 2015 02:06
·
0 Likes
·
0 Votes
·
0 Comments
·
I apologize...it looks as if the cronjob imports, but the test button does not.
Sam
·
Tuesday, 14 July 2015 02:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Sam,

I've tried to access your backend URL (http://yoursite.com/administrator) but failed.
Nik Faris
·
Tuesday, 14 July 2015 10:44
·
0 Likes
·
0 Votes
·
0 Comments
·
I used developer login and was able to login. Might be a server-side issue. Please try again. Provided backend creds.
Sam
·
Tuesday, 14 July 2015 19:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Sam,

I am hitting these issues when logging into the site now, http://screencast.com/t/Sq4NOA0WB
Mark
·
Wednesday, 15 July 2015 00:24
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post