No announcement yet.

Database error in vBulletin Error Number : 1054

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error in vBulletin Error Number : 1054

    Can someone help me fix this as i seem to be getting this Error Number : 1054


    Database error in vBulletin 3.8.1:

    Invalid SQL:

    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
    language.phrasegroup_global AS phrasegroup_global,
    language.phrasegroup_adv_portal AS phrasegroup_adv_portal,
    language.phrasegroup_calendar AS phrasegroup_calendar,
    language.phrasegroup_postbit AS phrasegroup_postbit,
    language.phrasegroup_adv_gallery AS phrasegroup_adv_gallery,
    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
    , timer.*
    FROM user AS user
    LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
    LEFT JOIN sktimer AS timer ON (user.userid = timer.skuserid)
    WHERE user.userid = 1;

    MySQL Error : Unknown column 'language.phrasegroup_adv_gallery' in 'field list'
    Error Number : 1054
    Request Date : Thursday, June 25th 2009 @ 12:33:47 AM
    Error Date : Thursday, June 25th 2009 @ 12:33:47 AM
    Script :
    Referrer :
    IP Address : Username :
    Classname : vB_Database
    MySQL Version :

  • #2
    This error is due to the vbgallery. You need to ask for support on about this since its their product
    "Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time!"
    "It's important to only think about what you desire, not what you fear to achieve your ultimate goal!!"
    "When doors close, tear down the walls. Never give up!"


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