Magento getting timeout errors, even with max_execution_time set to zero, on WAMP
While working on importing products in Magento, I was getting timeout errors a lot like
Fatal error: Maximum execution time of 60 seconds exceeded in c:\xxxxxxx\lib\Zend\Db\Statement\Pdo.php on line 228
etc etc. This error was mostly generated when importing products, exporting products re indexing large indexes like fulltext search index etc.
One solution I found on every place was to increase the max_execution_time and memory_limit in php.ini or .htacces file. But I already had max_execution_time value set to 0 which means unlimited, and memory_limit set to 512MB which is also good enough.
After trying many things I found a solution that worked. In my php.ini value max_input_time was set to 60. This defines the maximum amount of seconds each script may spend parsing request data. By default value is -1 which means unlimited, but WAMP server 2 sets it to 60.
For many pages this value was getting exhausted. Once I changed it to 6000 (100 minutes), every thing looked fine. You can optionally set it to -1 for local machine and some good enough value for production server. This value should not be less or equal to max_execution_time other wise they will nullify each other.
My “max execution” of 60 seconds problem was caused by max_input_time (default 60) NOT max_execution_time.
Using Xampp i changed my only php.ini file in C:/xampp/php/
Hope that helps someone else who was getting stuck like me!
@Chriso20
Yes this post tells exactly the same you have done. I got stuck there for some time, than i was able to find it out, and posted here.
@wasimasif
Haha, sorry, I was trying to leave a message on a page that was only suggesting the max_execution_time.
So sorry for just repeating what was already said!
thanks a bunch, i changed both values and it worked.
I am glad that it helped you.
[...] Magento getting timeout errors, even with max_execution_time set to zero, on WAMP [...]