the feed table created by nagregator seems to be missing the promote column.

When adding a new feed I get the error "Unknown column 'promote' in 'field list' query: INSERT INTO feed"

looking in the module code it is trying to insert data into this column but looking at the mysql create command this column is not created.

I am also finding that the url of the feed is not saved and I don't know if this is related or not.

Comments

Bèr Kessels’s picture

Bèr Kessels commented
Assigned: Unassigned » Bèr Kessels

Thank you, it is a known bug. assigning this to myself.

nasi’s picture

nasi commented

Cool, that's a fast response!

Any idea how long it might be before a new version is released?

What is the fix for this? Presumably it just needs an extra column in the table. What is the data type for promote (so I can fix things in the mean time)? varchar, int, ...?

Bèr Kessels’s picture

Bèr Kessels commented 
CREATE TABLE `feed` (
  `nid` int(10) unsigned NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `refresh` int(10) NOT NULL default '0',
  `link` varchar(255) NOT NULL default '',
  `expire` int(10) NOT NULL default '0',
  `promote` tinyint(1) default NULL,
  `comments` tinyint(1) default NULL,
  PRIMARY KEY  (`nid`),
  KEY `link` (`link`),
  KEY `url` (`url`)
);
Imago’s picture

Imago commented

This is what worked for me:

CREATE TABLE feed (
  nid int(10) unsigned NOT NULL default '0',
  url varchar(255) NOT NULL default '',
  refresh int(10) NOT NULL default '0',
  link varchar(255) NOT NULL default '',
  data text,
  expire int(10) NOT NULL default '0',
  promote tinyint(1) NOT NULL default '0',
  comments tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (nid),
  KEY link (link),
  KEY url (url)
) TYPE=MyISAM;
Bèr Kessels’s picture

Bèr Kessels commented
Status: Active » Closed (won't fix)

This module is deprecated in favour of http://drupal.org/project/feedparser