When I create a new feed on my test server, I get:

user warning: Unknown column 'batch' in 'field list' query: SELECT config, batch FROM drupal_feeds_source WHERE id = "feed" AND feed_nid = 0 in /Volumes/DataHD/www/SITENAME/sites/all/modules/feeds/includes/FeedsSource.inc on line 208.

This is on the: Create Content-->Feed

I also when I create my feed get this set of errors:

* user warning: Unknown column 'batch' in 'field list' query: SELECT config, batch FROM drupal_feeds_source WHERE id = "feed" AND feed_nid = 0 in /Volumes/DataHD/www/SITENAME/sites/all/modules/feeds/includes/FeedsSource.inc on line 208.
* user warning: Unknown column 'batch' in 'field list' query: SELECT config, batch FROM drupal_feeds_source WHERE id = "feed" AND feed_nid = 1076 in /Volumes/DataHD/www/SITENAME/sites/all/modules/feeds/includes/FeedsSource.inc on line 208.
* user warning: Unknown column 'batch' in 'field list' query: UPDATE drupal_feeds_source SET id = 'feed', feed_nid = 1076, config = 'a:1:{s:16:\"FeedsHTTPFetcher\";a:1:{s:6:\"source\";s:97:\"http://podcast.scischina.org:8171/podcastproducer/atom_feeds/74C2B2A8-C4...\";}}', source = 'http://podcast.scischina.org:8171/podcastproducer/atom_feeds/74C2B2A8-C4...', batch = 'b:0;' WHERE id = 'feed' AND feed_nid = 1076 in /Volumes/DataHD/www/SITENAME/includes/common.inc on line 3467.
* user warning: Unknown column 'last_executed_time' in 'field list' query: UPDATE drupal_feeds_schedule SET feed_nid = 1076, id = 'feed', callback = 'import', last_executed_time = 0, scheduled = 0 WHERE id = 'feed' AND callback = 'import' AND feed_nid = 1076 in /Volumes/DataHD/www/SITENAME/includes/common.inc on line 3467.
* user warning: Unknown column 'last_executed_time' in 'field list' query: UPDATE drupal_feeds_schedule SET feed_nid = 0, id = 'feed', callback = 'expire', last_executed_time = 0, scheduled = 0 WHERE id = 'feed' AND callback = 'expire' AND feed_nid = 0 in /Volumes/DataHD/www/SITENAME/includes/common.inc on line 3467.
* user warning: Unknown column 'batch' in 'field list' query: SELECT config, batch FROM drupal_feeds_source WHERE id = "feed" AND feed_nid = 1076 in /Volumes/DataHD/www/SITENAME/sites/all/modules/feeds/includes/FeedsSource.inc on line 208.
* user warning: Unknown column 'batch' in 'field list' query: UPDATE drupal_feeds_source SET id = 'feed', feed_nid = 1076, config = 'a:1:{s:16:\"FeedsHTTPFetcher\";a:1:{s:6:\"source\";s:0:\"\";}}', source = '', batch = 'b:0;' WHERE id = 'feed' AND feed_nid = 1076 in /Volumes/DataHD/www/SITENAME/includes/common.inc on line 3467.
* Download of failed with code -1003.

My feed for testing is an Apple Podcast Producer feed: at this location:

http://podcast.scischina.org:8171/podcastproducer/atom_feeds/74C2B2A8-C4...

Comments

CheezItMan’s picture

CheezItMan commented

I fixed it by adding the batch column and the 'last_executed_time' manually. Maybe some error in the configuration scripts.

Now, I just need to figure out how to map my podcast videos in as embedded media, or at least get the descriptions imported.

serbanghita’s picture

serbanghita commented

i also had this problem when i upgraded from .11 to .12.

alex_b’s picture

alex_b commented

Did you upgrade Feeds module from previous versions to alpha12? Did you run update.php?

serbanghita’s picture

serbanghita commented

alex_b is right. i didn't ran the update.php script which runs all the sql scripts. thanks for clearing this!

close this

alex_b’s picture

alex_b commented
Category: bug » support
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.