User Control Panel Database Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Charlie_Brown
    Senior Member
    • Dec 2006
    • 1275
    • 4.1.x

    User Control Panel Database Error

    Code:
    Database error in vBulletin 3.8.0 Beta 1:
    
    Invalid SQL:
    
    				SELECT COUNT(*) AS count
    				FROM socialgroup AS socialgroup
    				INNER JOIN subscribegroup AS subscribegroup ON
    					(subscribegroup.userid = 1 AND subscribegroup.groupid = socialgroup.groupid)
    LEFT JOIN socialgroupmember AS socialgroupmember ON
    					(socialgroupmember.userid = 1 AND socialgroupmember.groupid = socialgroup.groupid)
    				WHERE 1=1;
    
    MySQL Error   : Table 'dvdnextc_vbulletin.subscribegroup' doesn't exist
    Error Number  : 1146
    Request Date  : Wednesday, October 15th 2008 @ 03:55:40 PM
    Error Date    : Wednesday, October 15th 2008 @ 03:55:41 PM
    Script        : http://www.dvdnextcopysupportforum.com/usercp.php
    Referrer      : http://www.dvdnextcopysupportforum.com/
    IP Address    : 75.165.148.36
    Username      : Charlie
    Classname     : vB_Database
    MySQL Version : 5.0.51a-community-log
    I did the same upgrade on my test forum but on my live forum it comes up with this error. Please help. All navbar plugins are disabled too. This happens when I click usercp.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    It looks like you missed one or more upgrade steps. Run this query to create that table:

    CREATE TABLE subscribegroup (
    subscribegroupid INT unsigned NOT NULL auto_increment,
    userid INT unsigned NOT NULL,
    groupid INT unsigned NOT NULL,
    PRIMARY KEY (subscribegroupid),
    UNIQUE KEY usergroup (userid, groupid),
    KEY groupid (groupid)
    );
    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

    • Charlie_Brown
      Senior Member
      • Dec 2006
      • 1275
      • 4.1.x

      #3
      Originally posted by Steve Machol
      It looks like you missed one or more upgrade steps. Run this query to create that table:

      CREATE TABLE subscribegroup (
      subscribegroupid INT unsigned NOT NULL auto_increment,
      userid INT unsigned NOT NULL,
      groupid INT unsigned NOT NULL,
      PRIMARY KEY (subscribegroupid),
      UNIQUE KEY usergroup (userid, groupid),
      KEY groupid (groupid)
      );
      Did that now it says this:

      Code:
      Database error in vBulletin 3.8.0 Beta 1:
      
      Invalid SQL:
      SELECT SQL_CALC_FOUND_ROWS
      						d.*, gm.*, user.*,
      						gm.ipaddress AS itemipaddress, d.lastpost AS lastpost, d.lastpostid AS lastpostid	,deletionlog.userid AS del_userid, deletionlog.username AS del_username,
      						deletionlog.reason AS del_reason ,IF(d.lastpost <= discussionread.readtime,1,0) AS is_read, discussionread.readtime AS readtime ,subscribediscussion.emailupdate		
      					FROM discussion AS d
      					INNER JOIN groupmessage AS gm
      						ON (gm.gmid = d.firstpostid)
      					LEFT JOIN user AS user ON (gm.postuserid = user.userid) LEFT JOIN discussionread AS discussionread
      						ON (discussionread.discussionid = d.discussionid
      						AND discussionread.userid = 1) INNER JOIN subscribediscussion AS subscribediscussion
      						ON (subscribediscussion.discussionid = d.discussionid
      						AND subscribediscussion.userid = 1)	LEFT JOIN deletionlog AS deletionlog
      									ON (gm.gmid = deletionlog.primaryid AND deletionlog.type = 'groupmessage')
      					
      					WHERE 1=1 AND ((gm.postuserid = 1 AND state = 'moderation') OR gm.state IN ('visible','deleted')) 
      						 ORDER BY d.lastpost ASC;
      
      MySQL Error   : Table 'dvdnextc_vbulletin.discussion' doesn't exist
      Error Number  : 1146
      Request Date  : Wednesday, October 15th 2008 @ 04:36:28 PM
      Error Date    : Wednesday, October 15th 2008 @ 04:36:28 PM
      Script        : http://www.dvdnextcopysupportforum.com/usercp.php
      Referrer      : http://www.dvdnextcopysupportforum.com/online.php?order=asc&sort=username&pp=20&page=1&who=members
      IP Address    : 75.165.148.36
      Username      : Charlie
      Classname     : vB_Database
      MySQL Version : 5.0.51a-community-log

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        You are missing another table. This means that your upgrade was not done correctly. At this point I suggest you restore a backup of your database from prior to this upgrade and try again.
        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

        Related Topics

        Collapse

        Working...