missing promote column
nasi - November 25, 2005 - 14:13
| Project: | Node Aggregator |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Bèr Kessels |
| Status: | won't fix |
Jump to:
Description
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.
#1
Thank you, it is a known bug. assigning this to myself.
#2
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, ...?
#3
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`)
);
#4
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;
#5
This module is deprecated in favour of http://drupal.org/project/feedparser