Magento

After upgrade system - we were start to reseive error like that:

and cant login to admin area… and 50% frontend - the same:

PS:
MySQL 5.1.37
php 5.2.11

what we can do width this error?
Any opinions how to fix that?

ok… I found…

this error is comming from PHP Version 5.2.11-0.dotdeb.1 width Suhosin Patch 0.9.7 & eAccelerator v0.9.6-rc1

perfect work under 5.2.9

error in (lib/Zend/Db/Select.php on line 216)
“current” function… they dont work currect!

find that:

simple fix:

This appears to be an eAccelerator 0.9.6-rc1 problem. I had issues with magento 500 errors while testing this version of eAccelerator. After downgrading to 0.9.5.3 all is well (tested on PHP 5.2.10). This could be because the new eAccelerator is optimized for php 5.3?

DOLARiON, Your’e a Legend!
I ran into this problem now too and your post saved my skin,

Thank you Mister!

Impi

the fix work for me
thank you very much
magento 1.3.2.4 + nginx 0.8.17 + eaccelerator 0.9.6-rc1 + php 5.2.11 + php-fpm 0.6

Only backend works with this fix for me.

How to fix the frontend?

Its better fix:

(to fix backend) Find in Select.php on line 216:

replace to:

(to fix frontend) Find in Toolbar.php on line 373:

replace to:

Hi guys,

I had exactly the same problem, but funnily enough, this happened suddenly, no system upgrade nothing! I haven’t even touched the code for the pages which the error was referring to.

I’m really happy the code here helped me fix the issue, but what I need to know is, WHY did this happen? HOW could it happen since I hadn’t changed any settings or code?

Really need to know to prevent further issues…

creativelifeform - 24 November 2009 02:42 AM

I had exactly the same problem, but funnily enough, this happened suddenly, no system upgrade nothing! I haven’t even touched the code for the pages which the error was referring to.

I’m really happy the code here helped me fix the issue, but what I need to know is, WHY did this happen? HOW could it happen since I hadn’t changed any settings or code?

Check the PHP and eAccelerator versions in phpinfo. It could be your hosting company or sysadmin upgraded it for you

nmd.

Fantastic. Thanks a lot

We’ve noticed eAccelerator 0.9.6rc1 to correlate with our clients having issue out of the blue.  Not sure why a host would implement any rc software on a server, but we’ve seen so-called Magento hosts doing this.

Worked perfectly - thanks!

Hi

Mi select.php is different, how must i fix this? In this magento i dont have this problem but i can acces to admin panel to upgrade (gives me 404 error), and i think that the problem maybe similar, couse in the same server i installed a new magento and i have this problem on it. This is my file attached:

Best Regards

Select.php  (File Size: 42KB - Downloads: 158)

Hi
the fix work for me after put new code

to:  lib/Zend/Db/Select.php

$arrayKeys = array_keys($this->_parts[self::FROM]);
$correlationName = current($arrayKeys);

and downgrading eAccelerator to v0.9.5.3

thank you very much

Magento 1.4.0.0 on PHP Version 5.2.4-2ubuntu5.10 + eAccelerator v0.9.5.3

quelizinha - 23 November 2009 08:22 AM

Its better fix:

(to fix backend) Find in Select.php on line 216:

$correlationName = current(array_keys($this->_parts[self::FROM]));

replace to:

$arrayKeys = array_keys($this->_parts[self::FROM]);
$correlationName = current($arrayKeys);

(to fix frontend) Find in Toolbar.php on line 373:

return current(array_keys($this->_availableMode));

replace to:

$arrayKeys = array_keys($this->_availableMode);
        return current($arrayKeys);

I love u man. thanks that works for me now i am trying to solve this for almost 20 hrs but now its done. Only one small issue i.e. the categories i am generating there is showing like a top menu bar ( it seems ok ) but on the main body of homepage its still blank. i hope you getting my point so is there a way to fill it with like recent products or top products etc to fill that space on that homepage.

Thanks alot

ali