Adding missing tables....?

[Flow Fusion]

Database error in vBulletin 3.6.5:

Invalid SQL:

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

MySQL Error : Table 'gifteds_lxp.rssfeed' doesn't exist
Error Number : 1146
Date : Tuesday, May 22nd 2007 @ 01:21:00 PM
Script : http://www.giftedsouls.net/gs/admincp/rssposter.php
Referrer : http://www.giftedsouls.net/gs/admincp/index.php?do=nav
Username : Flow Fusion
Classname : vb_database

[Wayne Luke]

What version did you upgrade from and did you run all steps of install/upgrade.php when you did so? The upgrade script is required to make the new tables and changes to the old ones so the system works properly.

[Steve Machol]

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

[Flow Fusion]

Wow thanks alot. I had an old hack and I went to uninstall it. And I see it took the table with it.

[Flow Fusion]

Now any idea on how to fix this?

Invalid SQL:
ALTER TABLE post DROP COLUMN mh_pbc_colorschemeid;

MySQL Error : Can't DROP 'mh_pbc_colorschemeid'. Check that column/key exists
Error Number : 1091

[Steve Machol]

Does that coloum exist?