You may get an error like,

Fatal error: Allowed memory size of 42677051 bytes exhausted (tried to allocate 78 bytes) in /home/linuxfaq/public_html/app/code/local/Zend/Db/Statement/index.php on line 124

This cause is PHP has exhausted the maximum memory limit, we need to set memory limit value in configuration file. By default limit set up to 8MB or 16MB but the Magento required 64MB.

We have solution in three ways,


Open php.ini file find the below configuration and update values,

max_execution_time = 30
max_input_time = 60
memory_limit = 128M

Magento File:

If you don't have server permission, add below code in magento_root/index.php file at begining line.


By default can get .htaccess file in magento root directory just update the below php_values,

  php_value memory_limit 128M
  php_value max_execution_time 18000