PHP 4.3.10 upgrade and Zend Optimizer

kelson
(@kelson)

19 years, 4 months ago

If you upgrade an existing PHP 4.3.x installation and use Zend Optimizer, make sure you upgrade Zend Optimizer at the same time.
I had an old copy of Zend (2.5.3) running perfectly well with PHP 4.3.9, but the moment I upgraded I started getting weird SQL syntax errors with “,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,” showing up in the SQL statements. Checking the error logs showed complaints that basic functions like array() were undefined. On a hunch, I turned off Zend Optimizer and it worked fine.
After upgrading Zend Optimizer to the current version (2.5.7), the errors are gone, and the site works again.
I just thought I’d post this in case someone else runs into the same problem.

Viewing 10 replies - 1 through 10 (of 10 total)

Joshua Sigar
(@alphaoide)

19 years, 4 months ago

good instinct mr kelson

Anonymous

19 years, 4 months ago

Hey folks,
I just tried to install and not only got the weird sql syntax errors but also got this:
Warning: Invalid argument supplied for foreach() in /home/twinro00/public_html/demo/wpmu/wp-inst/wp-includes/functions.php on line 377
Warning: Invalid argument supplied for foreach() in /home/twinro00/public_html/demo/wpmu/wp-inst/wp-includes/functions.php on line 377
It doesn’t look like you’ve installed WP yet. Try running install.php.
The database tables do exist. I also get file permission errors but the permissions seem to be set correctly. I’m waiting to hear back from my provider about the zend optimizer issue but according to my c-panel we’re still using 4.3.9.
Any thoughts about what I might have done wrong?

moikirsch
(@moikirsch)

19 years, 3 months ago

Here is a quick fix… if you have access to your PHP.INI file you can turn off the zend optimizer (until you can update it).

To do so, just search for the following line:

zend_optimizer.optimization_level=…

and change it to:

zend_optimizer.optimization_level=0

Restart the server and your done.

It may run a little slower but at least it will work.

7milesdown
(@7milesdown)

19 years, 3 months ago

I hate this! My forums and blog went down due to the Zend not being upgraded. Why not do both at the same time hosts!!!

josephlindsay
(@josephlindsay)

19 years, 3 months ago

I’m still getting this error. PHP 4.3.10, Zend Optimizer 2.5.7 and WP1.5a6. I don’t have access to the php.ini, so I tried using ini_set with moikirsch’s suggestion above but still get the same error. Any help appreciated.

josephlindsay
(@josephlindsay)

19 years, 3 months ago

Upgraded to WP1.5b1 and problem has gone

eetdcob
(@eetdcob)

19 years, 2 months ago

“If you upgrade an existing PHP 4.3.x installation and use Zend Optimizer, make sure you upgrade Zend Optimizer at the same time.”

I have WP1.22 on OSX server (10.3.7) with PHP 4.3.2.
Contemplating a system upgrade which I think will move me to PHP 4.3.10.

I’ve read other peoples’ stories and feel leery about upgrading.

Is this problem only occurring in setups with Zend?

Moderator James Huff
(@macmanx)

Volunteer Moderator

19 years, 2 months ago

It’ll be ok if you don’t have Zend Optimizer installed. If you do, then you need to upgrade Zend Optimizer after upgrading PHP.

eetdcob
(@eetdcob)

19 years, 2 months ago

Thanks macmanx, I don’t have Zend so went ahead with OS upgrade to 10.3.8. All seems well, at least none of the obvious functions are breaking.

rellinb
(@rellinb)

18 years, 4 months ago

I have this same problem, and am working to get my host to upgrade the Zend version. However, I’m not sure how quick that can happen. Is there a way to create the database tables w/ mysql command line so I can still install, or is the foreach error independant of how the tables get created?