vBulletin and PHP 4.3.10

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cycopia
    New Member
    • Oct 2004
    • 5
    • 3.0.3

    vBulletin and PHP 4.3.10

    Has anyone tried vBulletin in php 4.3.10 yet? I did a straight upgrade using the same options I built 4.3.9 with, and this was the result:

    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.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'
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    That is a mysql error IIRC looks like you missed a step.

    Comment

    • NIS-Francisco
      Member
      • Dec 2004
      • 93
      • 3.0.3

      #3
      I'm having a problem installing vB in my newly php version. 4.3.10

      Comment

      • Mike Sullivan
        Former vBulletin Developer
        • Apr 2000
        • 13327
        • 3.6.x

        #4
        Originally posted by Zachery
        That is a mysql error IIRC looks like you missed a step.
        No, it's PHP putting something odd into the query. I'll see what I can find tonight and get back to you (the original poster that is ).

        Comment

        • NIS-Francisco
          Member
          • Dec 2004
          • 93
          • 3.0.3

          #5
          Originally posted by Mike Sullivan
          No, it's PHP putting something odd into the query. I'll see what I can find tonight and get back to you (the original poster that is ).
          And not to me? hehe

          Comment

          • Mike Sullivan
            Former vBulletin Developer
            • Apr 2000
            • 13327
            • 3.6.x

            #6
            Between you reading my post and quoting me, I think my post changed.

            Comment

            • cycopia
              New Member
              • Oct 2004
              • 5
              • 3.0.3

              #7
              Hrm. From the looks of it, they backported an "improved" version of foreach() from PHP 5. Other than that, I don't really see anything in the ChangeLog that might be the culprit here.

              Comment

              • Zachery
                Former vBulletin Support
                • Jul 2002
                • 59097

                #8
                There is a nested foreach on that line and somthing is not getting passed.

                Comment

                • cycopia
                  New Member
                  • Oct 2004
                  • 5
                  • 3.0.3

                  #9
                  Originally posted by Zachery
                  There is a nested foreach on that line and somthing is not getting passed.
                  Can you tell me which line in what file this is in? I want to check if it's a bug in the new PHP or just code weirdness.

                  Thanks.

                  Comment

                  • cycopia
                    New Member
                    • Oct 2004
                    • 5
                    • 3.0.3

                    #10
                    Further Reference

                    Probably unrelated to the above error, but also showing up in PHP 4.3.10:

                    PHP Warning: Constants may only evaluate to scalar values in <deleted>/includes/init.php on line 777

                    Comment

                    • Steve Machol
                      Former Customer Support Manager
                      • Jul 2000
                      • 154488

                      #11
                      Originally posted by cycopia
                      Probably unrelated to the above error, but also showing up in PHP 4.3.10:

                      PHP Warning: Constants may only evaluate to scalar values in <deleted>/includes/init.php on line 777
                      Yes, this error has been reported also.
                      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

                      • Mike Sullivan
                        Former vBulletin Developer
                        • Apr 2000
                        • 13327
                        • 3.6.x

                        #12
                        Well, there's a few PHP bug reports about this, but I couldn't reproduce it. I did find this bit of info though:
                        ok, I just realized that this only happens when you use the
                        ZendOptimizer 2.5.5. Without it and with the new version 2.5.7 it works
                        like expected...
                        Sorry for the noise ;-)
                        In this bug report: http://bugs.php.net/bug.php?id=30914 . So please check that.

                        Comment

                        • cycopia
                          New Member
                          • Oct 2004
                          • 5
                          • 3.0.3

                          #13
                          I've installed 2.5.7 and it does correct the issue. Currently, I don't see any more problems. Unfortunately Zend themselves don't mention this problem in either their release notes or on the Zend site. I'll make sure I let them know. Thanks.

                          Comment

                          • RCK
                            Member
                            • Apr 2001
                            • 74
                            • 3.7.x

                            #14
                            I confirm, my vB3 version is no more working with php 4.3.10
                            gemme a FIX !

                            Warning: Invalid argument supplied for foreach() in /var/www/eab/includes/init.php on line 750

                            Warning: Invalid argument supplied for foreach() in /var/www/eab/includes/init.php on line 750

                            Warning: Invalid argument supplied for foreach() in /var/www/eab/includes/init.php on line 750

                            Warning: Invalid argument supplied for foreach() in /var/www/eab/includes/init.php on line 750

                            Warning: Invalid argument supplied for foreach() in /var/www/eab/includes/init.php on line 750

                            Warning: Invalid argument supplied for foreach() in /var/www/eab/includes/init.php on line 750

                            Warning: Invalid argument supplied for foreach() in /var/www/eab/includes/init.php on line 750



                            There seems to have been a slight problem with the English Amiga Board database.
                            Please try again by pressing the refresh button in your browser.

                            An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

                            We apologise for any inconvenience.

                            Comment

                            • Zachery
                              Former vBulletin Support
                              • Jul 2002
                              • 59097

                              #15
                              Tell your host to upgrade php accelerator, its not php and its not vB

                              Comment

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