[Forum] Error Number : 1146

[fxs158]

Database error in vBulletin 4.1.8:


Invalid SQL:


SELECT * FROM usercss
WHERE userid = 6
ORDER BY selector;


MySQL Error : Table 'sql_sql.usercss' doesn't exist
Error Number : 1146
Request Date : Thursday, November 24th 2011 @ 09:05:02 PM
Error Date : Thursday, November 24th 2011 @ 09:05:02 PM
Script : http://www.mysite/forums/member.php?action=getinfo&u=6
Referrer : http://www.mysite/forums/forum.php
IP Address : MYIP
Username : MYUSERNAME
Classname : vB_Database
MySQL Version : 5.1.56


Ok I am getting this error and it is starting to frustrate me. I get that error when I click on my name on the forum. I am the administrator, it does not happen if I click on other members names, just when I click on mine. How can I fix this?

[fxs158]

After checking with PHPmyadmin the table is not there, the command to create the table in vbulletin schema is

$schema['CREATE']['query']['usercss'] = "
CREATE TABLE " . TABLE_PREFIX . "usercss (
userid INT UNSIGNED NOT NULL DEFAULT '0',
selector VARCHAR(30) NOT NULL DEFAULT '',
property VARCHAR(30) NOT NULL DEFAULT '',
value VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (userid, selector, property),
KEY property (property, userid, value(20))
)
";


How do I run this on PHPmyadmin? I tried entering as posted here and I get errors.

[fxs158]

Found the query here;

CREATE TABLE usercss (
userid INT UNSIGNED NOT NULL DEFAULT '0',
selector VARCHAR(30) NOT NULL DEFAULT '',
property VARCHAR(30) NOT NULL DEFAULT '',
value VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (userid, selector, property),
KEY property (property, userid, value(20))
);