No announcement yet.

Database Error -- Table(s) Doesn't Exist

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error -- Table(s) Doesn't Exist

    Hello guys

    when i need to enter the socail group page i get that the table isn't found . even for the image gallery table isn't found

    and when i ned to edit userprofile or edit a username i get

    Database error in vBulletin 3.8.1:
    Invalid SQL:
    UPDATE mst_discussion
    SET lastposter = 'liloo'
    WHERE lastposterid = 5116;
    MySQL Error : Table 'wwwhezb_mon.mst_discussion' doesn't exist
    Error Number : 1146
    Request Date : Wednesday, March 18th 2009 @ 04:52:18 PM
    Error Date : Wednesday, March 18th 2009 @ 04:52:18 PM
    Script : http:/
    Referrer :
    IP Address :
    Username : Admin
    Classname : vB_Database
    MySQL Version : 5.0.67-community


    so i need a solution and several tables to import them into the databse

  • #2
    You are missing the vB discussion table. I don't know how you could have upgraded without it. Here is the query to create that table:

    CREATE TABLE mst_discussion (
    discussionid INT unsigned NOT NULL auto_increment,
    groupid INT unsigned NOT NULL,
    firstpostid INT unsigned NOT NULL,
    lastpostid INT unsigned NOT NULL,
    lastpost INT unsigned NOT NULL,
    lastposter VARCHAR(255) NOT NULL,
    lastposterid INT unsigned NOT NULL,
    visible INT unsigned NOT NULL default '0',
    deleted INT unsigned NOT NULL default '0',
    moderation INT unsigned NOT NULL default '0',
    subscribers ENUM('0', '1') default '0',
    PRIMARY KEY (discussionid),
    KEY groupid (groupid, lastpost)
    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.


    • #3
      thanks man

      really i don't know how

      their is the socail group table messing and the image gallery messing !

      thanks alot sir


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