rssfeeds dberror after upgrade to 3.6.3 from 3.5.4

[mediacast]

Within the admin panel > rss feeds > rss feed manager i now have this error :

Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT rssfeed.*, user.username, forum.title AS forumtitle
FROM vb_rssfeed AS rssfeed
LEFT JOIN vb_user AS user ON(user.userid = rssfeed.userid)
LEFT JOIN vb_forum AS forum ON(forum.forumid = rssfeed.forumid)
ORDER BY rssfeed.title;

MySQL Error : Unknown column 'rssfeed.userid' in 'on clause'
Error Number : 1054
Date : Monday, November 20th 2006 @ 12:00:49 PM

Can anybody help me ?

[mediacast]

Now per mistake i deleted db table vb_newsfeeds , how do I rebuild this table ?

[Marco van Herwaarden]

Did you get any errors while running upgrade.php?

MySQL Error : Unknown column 'rssfeed.userid' in 'on clause'

To fix this, run the following query:

ALTER TABLE vb_rssfeed ADD COLUMN `userid` int(10) unsigned NOT NULL

- Now per mistake i deleted db table vb_newsfeeds
The newsfeed is not a default vBulletin table, please contact the author of the modification that created this table.

[mediacast]

I found a create table in the install directory that creates the table :

CREATE TABLE vb_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 )
)

There is a addon that corrupts this table which is :
http://www.vbulletin.org/forum/showthread.php?t=94510&highlight=ffrss.php

When you reinstall that addon it corrupts the normal vb_rssfeed table.
For me this is fixed now, only the addon is not working...

[Marco van Herwaarden]

Then you will need to contact the author of that mdoification.

PS That modification is for vBulletin 3.5.0, so it is not a real surprise that it will not function with 3.6. You might want to check if there is a 3.6 version available, but i doubt it since it looks like it is providing the same functionality that now comes with default vB 3.6.

[mediacast]

I uninstalled that addon, then receated the table but :

A) the addon doesnt disappear from the control panel bar
B) The system is now sending me emails about database errors about the addon script :eek:

[Marco van Herwaarden]

You will need to contact the author of the modification to have this fixed.