Announcement

Collapse
No announcement yet.

vBulletin and PHP 4.3.10

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

  • 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'

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

    Comment


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

      Comment


      • #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


        • #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


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

            Comment


            • #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


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

                Comment


                • #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


                  • #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


                    • #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


                      • #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


                        • #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


                          • #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


                            • #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...
                              X