Announcement

Collapse
No announcement yet.

Database error

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

  • Database error

    Hi,

    I recieved the below error after i decided to switch all my users to my new forum site.

    Code:
    Database error in vBulletin 3.6.7:
    
    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 > 1180601741
            ORDER BY username ASC;
    
    MySQL Error  : Unknown column 'infractiongroupid' in 'field list'
    Error Number : 1054
    Date         : Thursday, May 31st 2007 @ 04:10:41 AM
    Script       : http://www.hostertalk.net/
    Referrer     : 
    IP Address   : 172.209.69.65
    Username     : admin
    Classname    : vb_database
    How can i fix this.

    Chris

  • #2
    You probably weren't using the same version of vBulletin. Try running /install/upgrade.php
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      now it's not showing up any error, it's just saying theres a databse error now.

      http://www.hostertalk.net

      Comment


      • #4
        ive submitted a support ticket here 650926

        Comment

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