Announcement

Collapse
No announcement yet.

Error Number : 1146

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • fxs158
    replied
    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))
    );

    Leave a comment:


  • fxs158
    replied
    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.

    Leave a comment:


  • fxs158
    started a topic [Forum] Error Number : 1146

    Error Number : 1146

    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X