PDA

View Full Version : Magento Layered Navigation fix - can't run script - please help...



chris@nudd.com
04-25-2009, 03:26 PM
I am trying to run a script and get the following error below. Also, I am timing out whenever I try to run any processes that take over a minute. My max_execution time in my php.ini file is 300. http://www.posdirect.com/phpinfo.php

I'm trying to fix some indexing issues with Magento. Bee trying to get up and running for over five months. This bottleneck is killing me. Any assistance appreciated.

Here is the fix I'm trying to run: http://chrismckee.co.uk/magento-commerce-layered-navigation-cache-error-part-deux

Running this script in posdirect.com/eee/cm_LCache.php

Get this error:

xxxx@posdirect.com [~/public_html/eee]# time php -q -f cm_LCache.php
Failed loading /usr/local/Zend/lib/ZendExtensionManager_TS.so:
/usr/local/Zend/lib/ZendExtensionManager_TS.so: cannot open shared object
file: No such file or directory
<br />
<b>Fatal error</b>: Uncaught exception 'Zend_Db_Adapter_Exception' with
message 'pdo_mysql extension is not installed' in
/home1/posdirec/public_html/eee/lib/Varien/Db/Adapter/Pdo/Mysql.php:178
Stack trace:
#0 /home1/posdirec/public_html/eee/lib/Zend/Db/Adapter/Abstract.php(441):
Varien_Db_Adapter_Pdo_Mysql-&gt;_connect()
#1
/home1/posdirec/public_html/eee/lib/Zend/Db/Adapter/Pdo/Abstract.php(230):
Zend_Db_Adapter_Abstract-&gt;query('SET NAMES utf8', Array)
#2
/home1/posdirec/public_html/eee/lib/Varien/Db/Adapter/Pdo/Mysql.php(259):
Zend_Db_Adapter_Pdo_Abstract-&gt;query('SET NAMES utf8', Array)
#3
/home1/posdirec/public_html/eee/app/code/core/Mage/Core/Model/Resource/Type
/Db/Pdo/Mysql.php(45):
Varien_Db_Adapter_Pdo_Mysql-&gt;query('SET NAMES utf8')
#4
/home1/posdirec/public_html/eee/app/code/core/Mage/Core/Model/Resource.php(
85):
Mage_Core_Model_Resource_Type_Db_Pdo_Mysql-&gt;getConnection(Object(Mage_Co
re_Model_Config_Element))
#5
/home1/posdirec/public_html/eee/app/code/core/Mage/Core/Model/Resource/Setu
p.php(62):
Mage_Core_Model_Resource-&gt; in
<b>/home1/posdirec/public_html/eee/lib/Varien/Db/Adapter/Pdo/Mysql.php</b>
on line <b>178</b><br />

real 0m1.738s
user 0m0.414s
sys 0m0.028s

JohnnyG
07-08-2009, 03:06 PM
I'm experiencing the same issue. Has there been any resolution. In the thread above, the script is being run from the command line, but different issue happens from a browser. The process seems to be killed. This is a magento ecommerce store (very popular open source cart) and the caching mechanism is killed on rebuild if the store has too many products.

Is there a way to allow for more time for script execution?