Announcement

Collapse
No announcement yet.

mysql error number: 1054

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql error number: 1054

    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 HAVE NO idea why it is doing this...I havent changed a thing to my forum.

  • #2
    I also got this at 21:29 through to 21:43 last night , also nothing changed since upgrade 2 weeks ago.

    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 = 5

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

    mysql error number: 1054

    Date: Saturday 18th of December 2004 09:43:42 PM
    Script: http://www.ukcobra.co.uk/forums/index.php
    Referer:
    IP Address: 81.157.40.217
    Webmaster - Mustang Owners Club of Great Britain

    Comment


    • #3
      Your host upgraded to PHP 4.3.10 -which is a good thing, but I think your host also uses Zend or another PHP accelerator and that requires an update too. Check the recent forum announcement in the announcement forum.

      Comment


      • #4
        Originally posted by Floris
        Your host upgraded to PHP 4.3.10 -which is a good thing, but I think your host also uses Zend or another PHP accelerator and that requires an update too. Check the recent forum announcement in the announcement forum.
        Thank you

        Comment


        • #5
          You're welcome.
          I hope you get this issue resolved pretty soon.

          Comment


          • #6
            Thanks for the explaination, the errors have not come back.

            Mark
            Webmaster - Mustang Owners Club of Great Britain

            Comment


            • #7
              Ok I'm getting the same message:

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

              mysql error number: 1054

              Date: Monday 20th of December 2004 11:25:38 AM
              Script: http://www.rcswap.com/index.php

              Both me and my host are clueless! He has everythign upto date and it's running php 4.3.1. I just launched my site and I need help ASAP!!!

              Comment


              • #8
                http://www.vbulletin.com/forum/showt...664#post780664



                As Mike said, please ensure that if your server runs the Zend Optimizer you also upgrade this when you upgrade to PHP 4.3.10.

                If you see an error like this:

                Warning: Constants may only evaluate to scalar values in /path/to/init.php on line 752

                ... this indicates that your version of the Zend Optimizer is too old for PHP 4.3.10.

                You should upgrade your Zend Optimizer by downloading the latest version from Zend.com.

                Comment


                • #9
                  Ya my host is at 4.3.10 not 4.3.1

                  Comment


                  • #10
                    Did you read my quote?



                    ... this indicates that your version of the Zend Optimizer is too old for PHP 4.3.10.

                    You should upgrade your Zend Optimizer by downloading the latest version from Zend.com
                    .

                    Comment


                    • #11
                      Calm down. I was never getting that error but I will check again for it.

                      Comment


                      • #12
                        It also relates to your issue, which is part of it.

                        Comment


                        • #13
                          http://nt1.cyber-core.net/phpinfo.php

                          I beleive this is everything upto date is it not?

                          My error:
                          Database error in vBulletin 3.0.3:

                          Invalid SQL:
                          SELECT languageid,
                          phrasegroup_Array AS phrasegroup_Array,
                          phrasegroup_Array AS phrasegroup_Array,
                          phrasegroup_Array AS phrasegroup_Array,
                          phrasegroup_Array AS phrasegroup_Array,
                          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_Array' in 'field list'

                          mysql error number: 1054

                          Date: Monday 20th of December 2004 01:48:52 PM
                          Script: http://rcswap.com/index.php
                          Last edited by RCDriver; Mon 20 Dec '04, 9:58am.

                          Comment


                          • #14
                            I will pay/donate $$ to anyone that can fix this. This error came at the wrong time and lots of people are upset.

                            Comment


                            • #15
                              I've asked the Developers to comment on this. Not sure why you'd still be getting this error.
                              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                              Change CKEditor Colors to Match Style (for 4.1.4 and above)

                              Steve Machol Photography


                              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                              Comment

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