No announcement yet.

Database error help

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error help

    I`m getting this SQL errors. Please help. My site is also locked out with the:

    There seems to have been a problem with the The South Florida F-Body Association database.
    Please try again by clicking the Refresh button in your web browser.
    An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.
    We apologise for any inconvenience.

    Database error in vBulletin 3.5.1:

    Invalid SQL:

    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
    language.phrasegroup_global AS phrasegroup_global,
    language.options AS lang_options,
    language.languagecode AS lang_code,
    language.charset AS lang_charset,
    language.locale AS lang_locale,
    language.imagesoverride AS lang_imagesoverride,
    language.dateoverride AS lang_dateoverride,
    language.timeoverride AS lang_timeoverride,
    language.registereddateoverride AS lang_registereddateoverride,
    language.calformat1override AS lang_calformat1override,
    language.calformat2override AS lang_calformat2override,
    language.logdateoverride AS lang_logdateoverride,
    language.decimalsep AS lang_decimalsep,
    language.thousandsep AS lang_thousandsep

    FROM user AS user
    LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

    WHERE user.userid = 28;

    MySQL Error : Unknown column 'user.userid' in 'where clause'
    Error Number : 1054
    Date : Wednesday, November 16th 2005 @ 09:34:41 AM
    Script :
    Referrer :
    IP Address :
    Username :
    Classname : vb_database

  • #2
    Also getting this one:

    Invalid SQL:

    user.username, (user.options & 512) AS invisible, user.usergroupid,
    session.userid, session.inforum, session.lastactivity,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM session AS session
    LEFT JOIN user AS user ON(user.userid = session.userid)
    WHERE session.lastactivity > 1132160393
    ORDER BY username ASC;

    MySQL Error : Unknown column 'user.userid' in 'on clause'
    Error Number : 1054
    Date : Wednesday, November 16th 2005 @ 11:14:53 AM
    Script :
    Referrer :
    IP Address :
    Username : Unregistered
    Classname : vb_database


    • #3
      Try repairing your tables from the AdminCP.

      If that don't help, then it looks like someone removed a column from your user table. Anything special done today?
      Want to take your board beyond the standard vBulletin features?
      Visit the official Member to Member support site for vBulletin Modifications:


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