Announcement

Collapse
No announcement yet.

MySQL error (Help)

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • MySQL error (Help)

    I have no idea what happened but I went to my forum I got this error:
    Warning: Constants may only evaluate to scalar values in /home/my/site_html/vb_forums/includes/init.php on line 752
    Then I received an email with this information in it from my host:
    Database error in vBulletin 3.0.3:

    Invalid SQL:
    SELECT
    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 = 1

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

    mysql error number: 1054
    I didn't do anything in any part of the forum this just happened and I have no idea where to go from here.

    Can anybody point me in the right direction?

    Thanks.

  • #2
    PHP Vulnerabilities in <= 4.3.9 and <= 5.0.2 Your host upgraded to 4.3.10 which is good, but your host should also upgrade Zend Optomizer.

    Comment


    • #3
      Originally posted by Floris
      PHP Vulnerabilities in <= 4.3.9 and <= 5.0.2 Your host upgraded to 4.3.10 which is good, but your host should also upgrade Zend Optomizer.
      --- Guess I'll have to talk to my host.

      Will the upgrading of the Zend Optomizer automatically fix the problem or will some additional coding have to take place? I think I'm in trouble!

      Comment


      • #4
        I had the same problem. The host updating Zend fixed everything.


        Steve

        Comment


        • #5
          Thanks. Working on it!

          Comment


          • #6
            That did it! All fixed.

            Again., thanks very much to the VB team here. You guys are incredible.

            People complain about paying for this software? It's a bargain!

            ~CB

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X
            😀
            🥰
            🤢
            😎
            😡
            👍
            👎