cancel
Showing results for 
Search instead for 
Did you mean: 

category fatal error

category fatal error

While selecting Some category page showing fatal error.

(Fatal error: Allowed memory size of 3221225472 bytes exhausted (tried to allocate 32 bytes) in /home/dietaryglobal/public_html/lib/Zend/Db/Statement/Pdo.php on line 290) http://dietaryglobal.com/index.php/dietary-ingredients-and-supplements.html

 

already tried "php.ini file extend the size at php "

Please advice.....

Thanks Uttam

6 REPLIES

Re: category fatal error

there is bug in this page, probably infinity loop

Re: category fatal error

Thanks for your reply...

 

Please advice how could I fixed the error.

 

Thanks

Re: category fatal error

Hi @cemk04,

This is bug maybe caused by some loop in some extension on your site. You should check the extension on your site again by disabling each extension, one by one. If you still cannot get cause for this bug. You should contact with a magento developer to resolve this problem. 

 

Hope this helps,

MageWoo

 

 

Best Magento Extensions and Services: One Step Checkout, POS Pro, Social Login, Delivery Date...
www.magewoo.com

Re: category fatal error

Hi MageWoo,

 

I checked disabling each extension, one by one. but still same issue.

 

Please do you have any solution let me know.

 

 

Thanks

Re: category fatal error

Hi,

 

Please check the error report I have attached hope this will help the understand the bug.

 

 

Thanks

a:5:{i:0;s:16488:"SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1)
 INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 1)
 LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='1' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('3', '10', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', 
";i:1;s:5138:"#0 /home/dietaryglobal/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/dietaryglobal/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/dietaryglobal/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/dietaryglobal/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `e`.*, I...', Array)
#4 /home/dietaryglobal/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.*, I...', Array)
#5 /home/dietaryglobal/public_html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `e`.*, I...', Array)
#6 /home/dietaryglobal/public_html/lib/Varien/Data/Collection/Db.php(734): Zend_Db_Adapter_Abstract->fetchAll('SELECT `e`.*, I...', Array)
#7 /home/dietaryglobal/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1047): Varien_Data_Collection_Db->_fetchAll('SELECT `e`.*, I...')
#8 /home/dietaryglobal/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#9 /home/dietaryglobal/public_html/app/code/core/Mage/Catalog/Model/Resource/Category/Collection.php(225): Mage_Eav_Model_Entity_Collection_Abstract->load(false, false)
#10 /home/dietaryglobal/public_html/app/code/core/Mage/Catalog/Model/Resource/Category/Tree.php(168): Mage_Catalog_Model_Resource_Category_Collection->load()
#11 /home/dietaryglobal/public_html/app/code/core/Mage/Catalog/Model/Resource/Category.php(576): Mage_Catalog_Model_Resource_Category_Tree->addCollectionData(NULL, false, '2', true, true)
#12 /home/dietaryglobal/public_html/app/code/core/Mage/Catalog/Model/Category.php(818): Mage_Catalog_Model_Resource_Category->getCategories('2', 0, false, false, true)
#13 /home/dietaryglobal/public_html/app/code/core/Mage/Catalog/Helper/Category.php(82): Mage_Catalog_Model_Category->getCategories('2', 0, false, false, true)
#14 /home/dietaryglobal/public_html/app/design/frontend/base/default/template/catalog/layer/view.phtml(5): Mage_Catalog_Helper_Category->getStoreCategories()
#15 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/dietarygl...')
#16 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/base/d...')
#17 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#18 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Abstract.php(886): Mage_Core_Block_Template->_toHtml()
#19 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#20 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Abstract.php(886): Mage_Core_Block_Text_List->_toHtml()
#21 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Abstract.php(605): Mage_Core_Block_Abstract->toHtml()
#22 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Abstract.php(549): Mage_Core_Block_Abstract->_getChildHtml('left', true)
#23 /home/dietaryglobal/public_html/app/design/frontend/default/ma_veneno/template/page/2columns-left.phtml(76): Mage_Core_Block_Abstract->getChildHtml('left')
#24 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/dietarygl...')
#25 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#26 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#27 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Block/Abstract.php(886): Mage_Core_Block_Template->_toHtml()
#28 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#29 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#30 /home/dietaryglobal/public_html/app/code/local/Magentothem/Layerednavigationajax/controllers/CategoryController.php(127): Mage_Core_Controller_Varien_Action->renderLayout()
#31 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Magentothem_Layerednavigationajax_CategoryController->viewAction()
#32 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('view')
#33 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#34 /home/dietaryglobal/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#35 /home/dietaryglobal/public_html/app/Mage.php(686): Mage_Core_Model_App->run(Array)
#36 /home/dietaryglobal/public_html/index.php(87): Mage::run('', 'store')
#37 {main}";s:3:"url";s:72:"/index.php/food-beverages.html?dir=desc&order=ingredients&producttype=77";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

Re: category fatal error

Hi,

 

 

I found a solution today .

 

System -> Configuration -> catalog -> Use Flat Catalog Product   make to yes

 

and Reindexing.... 

 

But I have more than 100000 product in a category its loading more than 20 s so need to reduce the time but how any body help me please...

 

Thanks.