No announcement yet.

MySQL Error 1054

  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Error 1054

    I removed several parts of vbulletin through my Admin. Control Panel (Plugins & Products) this morning and these errors started showing up:

    Database error in vBulletin 4.2.3:

    Invalid SQL:

    SELECT languageid,
    phrasegroup_global AS phrasegroup_global,
    phrasegroup_adv_gallery AS phrasegroup_adv_gallery,
    phrasegroup_adv_gallery_showimg AS phrasegroup_adv_gallery_showimg,
    phrasegroup_postbit AS phrasegroup_postbit,
    phrasegroup_showthread AS phrasegroup_showthread,
    phrasegroup_album AS phrasegroup_album,
    phrasegroup_posting AS phrasegroup_posting,
    phrasegroup_inlinemod AS phrasegroup_inlinemod,
    phrasegroupinfo AS lang_phrasegroupinfo,
    options AS lang_options,
    languagecode AS lang_code,
    charset AS lang_charset,
    locale AS lang_locale,
    imagesoverride AS lang_imagesoverride,
    dateoverride AS lang_dateoverride,
    timeoverride AS lang_timeoverride,
    registereddateoverride AS lang_registereddateoverride,
    calformat1override AS lang_calformat1override,
    calformat2override AS lang_calformat2override,
    logdateoverride AS lang_logdateoverride,
    decimalsep AS lang_decimalsep,
    thousandsep AS lang_thousandsep
    FROM language
    WHERE languageid = 1;

    MySQL Error : Unknown column 'phrasegroup_adv_gallery' in 'field list'
    Error Number : 1054
    Request Date : Tuesday, August 25th 2015 @ 01:02:50 PM
    Error Date : Tuesday, August 25th 2015 @ 01:02:50 PM
    Script :
    Referrer :
    IP Address :
    Username :
    Classname : vB_Database_MySQLi
    MySQL Version :


  • #2
    When you uninstall a product you also have to remove the files associated with the mod otherwise someone can still point their browser to a file for a product you no longer have installed and you will see errors like this where a query is looking for a table or column that no longer exists.


    • #3
      Thanks Squid. At least someone answered me!


      • #4
        same here. has an SQL error.


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