No announcement yet.

Error with VB Database

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error with VB Database

    I was on my vBulletin based board when all of a sudden I faced the following error: -----

    Database error in vBulletin 3.0.3:

    Invalid SQL:
    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
    language.phrasegroup_Array AS phrasegroup_Array,
    language.phrasegroup_Array AS phrasegroup_Array,
    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 = 2

    mysql error: Unknown column 'language.phrasegroup_Array' in 'field list'

    mysql error number: 1054

    Date: Tuesday 28th of December 2004 02:25:49 AM
    IP Address: **********


    I'm not so sure that this is a problem with VB, because I have another error with another MySQL powered section of the site which is on the same server. Any help/suggestions would be great though.

  • #2
    Please read this announcement: PHP Vulnerabilities in <= 4.3.9 and <= 5.0.2


    • #3
      That should be a host-controlled issue then, right? I dont remember ever installing a 'Zend' product.


      • #4
        Yes, contact your host (can post them to that announcement) and request them to also update their zend optimizer which will fix the issue.


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