MySQL Error : Table 'a0015316-1.forumpermission' doesn't exist

[Gach]

Hi - I tried to do an upgrade and this error came up [I ignored it since it wasn't vital at the time]. Anyway when going through and repairing tables [fixing unique indexes] it came up again.

Does anyone know how I can fix this problem?

Database error in vBulletin 3.6.8:
Invalid SQL:
SHOW KEYS FROM forumpermission;
MySQL Error : Table 'a0015316-1.forumpermission' doesn't exist
Error Number : 1146
Date : Tuesday, September 11th 2007 @ 11:13:20 PM
Script : http://www.pontiaczone.com/forum/adm...p?do=fixunique
Referrer : http://www.pontiaczone.com/forum/adm...ir.php?do=list
IP Address : 70.64.21.129
Username : Tyler
Classname : vb_database

Thanks for any help,

Tyler

[Steve Machol]

What were you upgrading from? I don't see how you could have upgraded without that table.

Run this query to create that table:

CREATE TABLE forumpermission (
forumpermissionid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
usergroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
forumpermissions INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (forumpermissionid),
UNIQUE KEY ugid_fid (usergroupid, forumid)
);

If you had any custom forum permissions, then you will need to reset them.

Admin CP -> Forums & Moderators -> Forum Permissions

[Gach]

3.5.x [can't remember exact version]. I was a little suprised myself. Thanks very much for your help.