This section is an archive with no posting allowed. The software represented in this forum is no longer supported or updated. If you need help upgrading to a newer version of vBulletin please open a support ticket. You can also post in the section supporting the upgrade version you're planning to use.
We are sorry for any inconvenience this may cause.
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
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...
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.
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) );
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.
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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also consent to the transfer of your data to our servers in the United States, where data protection laws may be different from those in your country.
Comment