Delete a forum - database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MrAbc
    Member
    • Jan 2009
    • 84

    [Forum] Delete a forum - database error

    Hi, I got this error when trying to delete a subforum:

    Code:
    Database error in vBulletin 4.1.0:
    
    Invalid SQL:
    DELETE FROM access WHERE forumid IN (127);
    
    MySQL Error   : Table 'mydatabase.access' doesn't exist
    Error Number  : 1146
    Request Date  : Saturday, January 8th 2011 @ 04:55:05 PM
    Error Date    : Saturday, January 8th 2011 @ 04:55:05 PM
    Script        : http://mydomain.com/forums/admincp/forum.php?do=kill
    Referrer      : http://mydomain.com/forums/admincp/forum.php?do=remove&f=127&s=
    IP Address    : 123.243.7.14
    Username      : admin
    Classname     : vB_Database
    MySQL Version : 5.0.77
    I am not sure what it means. How can I fix it?

    Thanks
  • Removed-836727
    Banned by User Request
    • Apr 2006
    • 1274

    #2
    It seems that you have no access table.

    [php]
    CREATE TABLE " . TABLE_PREFIX . "access (
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY userid (userid, forumid)
    )
    ";[php]

    Comment

    • MrAbc
      Member
      • Jan 2009
      • 84

      #3
      Thanks a lot . Problem solved.

      By the way, do you have some idea why it was not there in my database? I upgraded from 3.8 to 4.1 recently...

      Comment

      • Removed-836727
        Banned by User Request
        • Apr 2006
        • 1274

        #4
        No sorry, have no clue want went wrong...

        Comment

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