vB MySQL Error 1054

[thuffner]

Hey everyone. Just installed 3.6.4 and I am getting an error message email with the following contents every ten minutes or so.

Database error in vBulletin 3.6.4:

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 : Friday, January 12th 2007 @ 08:20:24 AM
Script : http://www.bondmovies.com/board/cron.php?&rand=590964
Referrer :
IP Address : 74.6.72.35
Username : Unregistered
Classname : vb_database

Any suggestions on a solution for this error? I have a newsbot installed from vB 3.5...Could this be the cause? I have tried to disable the bot, but I still get these errors...

[peterska2]

You will need to remove the newsbot completely, and then look at your database to see which rss tables you have. Uninstalling the bot will remove some of the rss tables used by 3.6.4 as they have the same names, but these can easily be recreated by running some queries in phpmyadmin.

[thuffner]

So it is impossible for me to have this newsbot on my board without errors?

It seemed to be working properly, too.

[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)
);

[thuffner]

Ok I ran that query successfully...Does this fix my board's RSS feed or allow me to have the newsbot functioning again without the error messages?

Thanks for all of your help!

[Steve Machol]

This sets the vB RSS feed table. As for your 'newsbot' that is a non-vB program that we don't support. My guess is that this is not compatible with vB 3.6.4.

[thuffner]

No worries.

Thanks a million for your quick responses.

You guys rock and so does vB!

[feldon23]

http://www.vbulletin.org/forum/showt...12#post1066446

3.6 has RSS feeds as a default feature. This modification uses the same tables as 3.6 and so will cause errors on upgrading to 3.6 unless you uninstall it first, and will not work due to the same tables being used.