Database error after upgrade

[brady_44]

Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT rssfeed.*, rssfeed.options AS rssoptions, user.*, forum.forumid
FROM rssfeed AS rssfeed
INNER JOIN user AS user ON (user.userid = rssfeed.userid)
INNER JOIN forum AS forum ON (forum.forumid = rssfeed.forumid)
WHERE rssfeed.options & 1;

MySQL Error : Unknown column 'rssfeed.options' in 'field list'
Error Number : 1054
Date : Tuesday, September 26th 2006 @ 09:08:06 PM
Script : http://www.-----.com/forums/cron.php?rand=392028 (http://javascript%3cb%3e%3c/b%3E:ol%28%27http://www.pactentalk.com/forums/cron.php?rand=392028%27%29;)
Referrer : http://www.-----.com/forums/lounge/----- (http://javascript%3cb%3e%3c/b%3E:ol%28%27http://www.pactentalk.com/forums/lounge/2111-week-4-pick-em.html%27%29;)
IP Address : -----
Username : Unregistered
Classname : vb_database
I've gotten this error a few times since upgrading from 3.5.2. Thoughts?

[Steve Machol]

That rssfeed table is from a hack you had installed. You need to drop that table, then recreate it with this query:

CREATE TABLE rssfeed (
rssfeedid INT UNSIGNED NOT NULL AUTO_INCREMENT,
title VARCHAR(250) NOT NULL,
url VARCHAR(250) NOT NULL,
port SMALLINT UNSIGNED NOT NULL DEFAULT '80',
ttl SMALLINT UNSIGNED NOT NULL DEFAULT '1500',
maxresults SMALLINT NOT NULL DEFAULT '0',
userid INT UNSIGNED NOT NULL,
forumid SMALLINT UNSIGNED NOT NULL,
iconid SMALLINT UNSIGNED NOT NULL,
titletemplate MEDIUMTEXT NOT NULL,
bodytemplate MEDIUMTEXT NOT NULL,
searchwords MEDIUMTEXT NOT NULL,
itemtype ENUM('thread','announcement') NOT NULL DEFAULT 'thread',
threadactiondelay SMALLINT UNSIGNED NOT NULL,
endannouncement INT UNSIGNED NOT NULL,
options INT UNSIGNED NOT NULL,
lastrun INT UNSIGNED NOT NULL,
PRIMARY KEY (rssfeedid),
KEY lastrun (lastrun)
);