Announcement

Collapse
No announcement yet.

vBulletin Database Error

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

  • vBulletin Database Error

    Hello

    I have this Error when i try to upgade 3.5.4 to 3.6.0

    >>>
    Database error in vBulletin 3.6.0 Beta 3:
    Invalid SQL:
    SELECT
    user.username, (user.options & 512) AS invisible, user.usergroupid,
    session.userid, session.inforum, session.lastactivity,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
    FROM session AS session
    LEFT JOIN user AS user ON(user.userid = session.userid)
    WHERE session.lastactivity > 1155600003
    ORDER BY username ASC;
    MySQL Error : Unknown column 'infractiongroupid' in 'field list'
    Error Number : 1054
    Date : Monday, August 14th 2006 @ 06:15:03 PM
    Script : http://www. .com/vb/index.php
    Referrer :
    IP Address :
    Username :
    Classname : vb_database


    please help me
    Last edited by mehbara; Mon 14th Aug '06, 5:49pm.

  • #2
    This means you missed one or more upgrade steps. Try running this query:

    ALTER TABLE user ADD infractiongroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0';
    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
      Other Error

      Database error in vBulletin 3.6.0 Beta 3:
      Invalid SQL:
      SELECT
      IF(votenum >= 1, votenum, 0) AS votenum,
      IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
      post.pagetext AS preview,
      thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
      thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
      hiddencount, deletedcount
      , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
      , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

      , threadredirect.expires

      FROM thread AS thread
      LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
      LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

      LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

      LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

      WHERE thread.threadid IN (0,1400,1427,1469,1146,1335,1169,1324,1165,1315,1286,1287,1233,1191,1161,1160)
      ORDER BY sticky DESC, lastpost DESC;
      MySQL Error : Table 'mehbarac_vb1.threadredirect' doesn't exist
      Error Number : 1146
      Date : Tuesday, August 15th 2006 @ 06:16:03 AM
      Script : http://www.mehbara.com/vbnew/forumdisplay.php?f=27
      Referrer : http://www.mehbara.com/vbnew/index.php
      IP Address :
      Username :
      Classname : vb_database

      Comment


      • #4
        You didn't upgrade:

        Database error in vBulletin 3.6.0 Beta 3
        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


        • #5
          Hello I do it a gain and every thig good but Now this Error

          Database error in vBulletin 3.6.0:
          Invalid SQL:
          SELECT points, infraction.*, thread.title, thread.forumid, thread.postuserid, user.username,
          thread.visible AS thread_visible, post.visible, thread.postuserid, IF(ISNULL(post.postid) AND infraction.postid != 0, 1, 0) AS postdeleted
          FROM infraction AS infraction
          LEFT JOIN post AS post ON (infraction.postid = post.postid)
          LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
          LEFT JOIN user AS user ON (infraction.whoadded = user.userid)
          WHERE infraction.userid = 1
          ORDER BY infraction.dateline DESC
          LIMIT 5;
          MySQL Error : Column 'points' in field list is ambiguous
          Error Number : 1052
          Date : Tuesday, August 15th 2006 @ 12:51:40 PM
          Script : http://www.mehbara.com/vb/usercp.php
          Referrer :
          IP Address :
          Username :
          Classname : vb_database

          Comment


          • #6
            Something's wrong with the database, possibly from a previous hack you had installed. Fill out a support ticket at:

            http://members.vbulletin.com/members...ontactform.php

            Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.
            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


            • #7
              hello

              he said the rong from the hacks.... like what you said

              but

              I used this query..... maybe this is the rong ?

              CREATE TABLE threadredirect(
              threadid INT UNSIGNED NOT NULL default '0',
              expires INT UNSIGNED NOT NULL default '0',
              PRIMARY KEY ( threadid ) ,
              KEY expires( expires )
              );


              is that the rong or something else

              note:- I used this query from another topic

              Comment

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