category fatal error

[cemk04]

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

[KuafuSoft]

there is bug in this page, probably infinity loop

[cemk04]

Thanks for your reply...

Please advice how could I fixed the error.

Thanks

[MageWoo]

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

[cemk04]

Hi MageWoo,

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

Please do you have any solution let me know.

Thanks

[cemk04]

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";}

[cemk04]

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.