Announcement

Collapse
No announcement yet.

Notices Table Doesn't Exist?

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

  • Notices Table Doesn't Exist?

    Is there an SQL Query or something to restore it? I get this when trying to add a notice.

    Database error in vBulletin 3.8.2:

    Invalid SQL:
    SELECT * FROM notice ORDER BY displayorder, title;

    MySQL Error : Table 'zackwil_bull2.notice' doesn't exist
    Error Number : 1146
    Request Date : Saturday, May 2nd 2009 @ 12:35:05 PM
    Error Date : Saturday, May 2nd 2009 @ 12:35:05 PM
    Script : http://******/forum/admincp/notice.php?do=modify
    Referrer : http://******/forum/admincp/index.php?do=nav
    IP Address : *******
    Username : Darkstar
    Classname : vB_Database
    MySQL Version : 4.1.22-community-nt-log

  • #2
    Here is the query to create that table:

    CREATE TABLE notice (
    noticeid INT UNSIGNED NOT NULL auto_increment,
    title VARCHAR(250) NOT NULL DEFAULT '',
    displayorder INT UNSIGNED NOT NULL DEFAULT '0',
    persistent SMALLINT UNSIGNED NOT NULL default '0',
    active SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    dismissible SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (noticeid),
    KEY active (active)
    );
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Thanks Steve. A lifesaver as always.

      Should I execute this in phpMyAdmin, or can I do it from the ACP?

      I'm a little slow today. Just got over being sick with the flu. ._.

      Comment


      • #4
        Originally posted by Chelf12 View Post
        Thanks Steve. A lifesaver as always.

        Should I execute this in phpMyAdmin, or can I do it from the ACP?

        I'm a little slow today. Just got over being sick with the flu. ._.
        I don't think it would matter. Personally, I'd prefer to do it via phpMyAdmin. But that's just me.
        Regards,
        Nick

        Comment

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