Announcement

Collapse
No announcement yet.

Odd SQL error

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

  • Odd SQL error

    Just had a bunch of error reports auto e-mailed to me from one of my vB 3.0.3's.

    Not sure what to make of it - is this something I should be particularly concerned about? Is it a possible DB corruption issue?

    Code:
     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 = 1439
     
     mysql error: Unknown column 'language.phrasegroup_Array' in 'field list'
     
     mysql error number: 1054 
     
     Date: Thursday 16th of December 2004 09:59:09 PM
     Script: http://www.chronicles-network.net/forum/forumdisplay.php?f=38


  • #2
    Unknown column in field list. You add any hacks lately...?

    Comment


    • #3
      Have you upgraded to PHP 4.3.10? Check this thread; the person has the same problem as you.
      Bugdar: PHP bug tracking software that is beautiful, fast, and robust.

      Comment


      • #4
        There is no phrasegroup_Array field in the default vB3 language table. Have you installed any hacks?
        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


        • #5
          I don't believe that I've added any hacks to this particular forum.

          It was originally imported from a YaBBSE about 14 months ago - is it possible there's an extra table from this??

          Comment


          • #6
            You've upgraded to php 4.3.10, please remove or upgrade your php accelerators.

            Comment


            • #7
              Hi Zachary,

              I jumped in here since this relates to the original post. I have a similar type of error, my system has photo post installed but not fully integrated from what I recall.

              Code:
              Database error in vBulletin 3.0.3:
                     
                     Invalid SQL: 
                     		SELECT languageid,
                     			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: Saturday 18th of December 2004 04:42:11 AM
                    Script: http://www.fakedomain.com/forum/index.php?
                    Referer:

              Zachary you mention this is a problem only with a particular build of PHP 4.3.1.0... please elaborate so that I can provide my ISP with more information. Advising them to simply "remove or upgrade your php accelerators" may not be the simplest thing to do.

              PHP Ver 4.3.1.0, Build Date Dec 17 2004 15:03:50

              My first error appeared December 18, 2004 3:26:49 AM MST. I was on the site during the period between update of PHP and when the VB DB crashed this AM... site is dead in water right now. I'm concerned yelling at ISP may not fully resolve issues.


              Regards,
              rocket98
              Last edited by rocket98; Sat 18 Dec '04, 10:07am.

              Comment


              • #8
                You need to ask your host to upgrade Zend Optimizer to 2.5.7 to fix this problem.
                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


                • #9
                  Thanks for the reply - most helpful. Will contact host about this.

                  Comment

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