Announcement

Collapse
No announcement yet.

Error Number : 1146

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

  • [Forum] 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?

  • #2
    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.

    Comment


    • #3
      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))
      );

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X