Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Error Processing Request when trying to access customer manager. 
 
d2footballjrc
Jr. Member
 
Total Posts:  2
Joined:  2012-05-03
 

Whenever we log into the admin panel, everything else appears to be working correctly. We just can\\\’t open up the customers. We can view customers logged on currently, and customer group. Just not customer manager.

It will just spin awhile then give an error code. I go to the logs and it just looks like a sql query of some sort.

Here is the error code log file:

a:5:{i:0;s:2940:\\\"SELECT `e`.*, `_table_prefix`.`value` AS `prefix`, `_table_firstname`.`value` AS `firstname`, `_table_middlename`.`value` AS `middlename`, `_table_lastname`.`value` AS `lastname`, `_table_suffix`.`value` AS `suffix`, CONCAT(IF(_table_prefix.value IS NOT NULL AND _table_prefix.value != \\\"\\\", CONCAT(_table_prefix.value,\\\" \\\"), \\\"\\\"),_table_firstname.value,IF(_table_middlename.value IS NOT NULL AND _table_middlename.value != \\\"\\\", CONCAT(\\\" \\\",_table_middlename.value), \\\"\\\"),\\\" \\\",_table_lastname.value,IF(_table_suffix.value IS NOT NULL AND _table_suffix.value != \\\"\\\", CONCAT(\\\" \\\",_table_suffix.value), \\\"\\\")) AS `name`, `_table_default_billing`.`value` AS `default_billing`, `_table_billing_postcode`.`value` AS `billing_postcode`, `_table_billing_city`.`value` AS `billing_city`, `_table_billing_telephone`.`value` AS `billing_telephone`, `_table_billing_region`.`value` AS `billing_region`, `_table_billing_country_id`.`value` AS `billing_country_id` FROM `citk_customer_entity` AS `e`
 LEFT JOIN `citk_customer_entity_varchar` AS `_table_prefix` ON (_table_prefix.entity_id = e.entity_id) AND (_table_prefix.attribute_id=\\\'4\\\')
 LEFT JOIN `citk_customer_entity_varchar` AS `_table_firstname` ON (_table_firstname.entity_id = e.entity_id) AND (_table_firstname.attribute_id=\\\'5\\\')
 LEFT JOIN `citk_customer_entity_varchar` AS `_table_middlename` ON (_table_middlename.entity_id = e.entity_id) AND (_table_middlename.attribute_id=\\\'6\\\')
 LEFT JOIN `citk_customer_entity_varchar` AS `_table_lastname` ON (_table_lastname.entity_id = e.entity_id) AND (_table_lastname.attribute_id=\\\'7\\\')
 LEFT JOIN `citk_customer_entity_varchar` AS `_table_suffix` ON (_table_suffix.entity_id = e.entity_id) AND (_table_suffix.attribute_id=\\\'8\\\')
 LEFT JOIN `citk_customer_entity_int` AS `_table_default_billing` ON (_table_default_billing.entity_id = e.entity_id) AND (_table_default_billing.attribute_id=\\\'13\\\')
 LEFT JOIN `citk_customer_address_entity_varchar` AS `_table_billing_postcode` ON (_table_billing_postcode.entity_id = _table_default_billing.value) AND (_table_billing_postcode.attribute_id=\\\'28\\\')
 LEFT JOIN `citk_customer_address_entity_varchar` AS `_table_billing_city` ON (_table_billing_city.entity_id = _table_default_billing.value) AND (_table_billing_city.attribute_id=\\\'24\\\')
 LEFT JOIN `citk_customer_address_entity_varchar` AS `_table_billing_telephone` ON (_table_billing_telephone.entity_id = _table_default_billing.value) AND (_table_billing_telephone.attribute_id=\\\'29\\\')
 LEFT JOIN `citk_customer_address_entity_varchar` AS `_table_billing_region` ON (_table_billing_region.entity_id = _table_default_billing.value) AND (_table_billing_region.attribute_id=\\\'26\\\')
 LEFT JOIN `citk_customer_address_entity_varchar` AS `_table_billing_country_id` ON (_table_billing_country_id.entity_id = _table_default_billing.value) AND (_table_billing_country_id.attribute_id=\\\'25\\\') WHERE (e.entity_type_id = \\\'1\\\') ORDER BY `e`.`entity_id` desc, `e`.`entity_id` desc LIMIT 20

\\\"
;i:1;s:5713:\\\"#0 /home/aisupps/public_html/mstore/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/aisupps/public_html/mstore/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /home/aisupps/public_html/mstore/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(\\\'SELECT `e`.*, `...\\\', Array)
#3 /home/aisupps/public_html/mstore/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query(\\\'SELECT `e`.*, `...\\\', Array)
#4 /home/aisupps/public_html/mstore/lib/Zend/Db/Adapter/Abstract.php(706): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/aisupps/public_html/mstore/lib/Varien/Data/Collection/Db.php(696): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#6 /home/aisupps/public_html/mstore/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(953): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#7 /home/aisupps/public_html/mstore/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(793): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#8 /home/aisupps/public_html/mstore/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(484): Mage_Eav_Model_Entity_Collection_Abstract->load()
#9 /home/aisupps/public_html/mstore/app/code/core/Mage/Adminhtml/Block/Customer/Grid.php(61): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection()
#10 /home/aisupps/public_html/mstore/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(576): Mage_Adminhtml_Block_Customer_Grid->_prepareCollection()
#11 /home/aisupps/public_html/mstore/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(582): Mage_Adminhtml_Block_Widget_Grid->_prepareGrid()
#12 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Abstract.php(673): Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml()
#13 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Abstract.php(516): Mage_Core_Block_Abstract->toHtml()
#14 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Abstract.php(467): Mage_Core_Block_Abstract->_getChildHtml(\\\'grid\\\', true)
#15 /home/aisupps/public_html/mstore/app/code/core/Mage/Adminhtml/Block/Widget/Grid/Container.php(70): Mage_Core_Block_Abstract->getChildHtml(\\\'grid\\\')
#16 /home/aisupps/public_html/mstore/app/design/adminhtml/default/default/template/widget/grid/container.phtml(36): Mage_Adminhtml_Block_Widget_Grid_Container->getGridHtml()
#17 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Template.php(189): include(\\\'/home/aisupps/p...\\\')
#18 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Template.php(225): Mage_Core_Block_Template->fetchView(\\\'adminhtml/defau...\\\')
#19 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Template.php(242): Mage_Core_Block_Template->renderView()
#20 /home/aisupps/public_html/mstore/app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml()
#21 /home/aisupps/public_html/mstore/app/code/core/Mage/Adminhtml/Block/Widget/Container.php(295): Mage_Adminhtml_Block_Template->_toHtml()
#22 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Abstract.php(674): Mage_Adminhtml_Block_Widget_Container->_toHtml()
#23 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#24 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Abstract.php(674): Mage_Core_Block_Text_List->_toHtml()
#25 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Abstract.php(516): Mage_Core_Block_Abstract->toHtml()
#26 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Abstract.php(467): Mage_Core_Block_Abstract->_getChildHtml(\\\'content\\\', true)
#27 /home/aisupps/public_html/mstore/app/design/adminhtml/default/default/template/page.phtml(74): Mage_Core_Block_Abstract->getChildHtml(\\\'content\\\')
#28 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Template.php(189): include(\\\'/home/aisupps/p...\\\')
#29 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Template.php(225): Mage_Core_Block_Template->fetchView(\\\'adminhtml/defau...\\\')
#30 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Template.php(242): Mage_Core_Block_Template->renderView()
#31 /home/aisupps/public_html/mstore/app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml()
#32 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Block/Abstract.php(674): Mage_Adminhtml_Block_Template->_toHtml()
#33 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Model/Layout.php(536): Mage_Core_Block_Abstract->toHtml()
#34 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Controller/Varien/Action.php(389): Mage_Core_Model_Layout->getOutput()
#35 /home/aisupps/public_html/mstore/app/code/core/Mage/Adminhtml/controllers/CustomerController.php(83): Mage_Core_Controller_Varien_Action->renderLayout()
#36 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_CustomerController->indexAction()
#37 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(\\\'index\\\')
#38 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Controller/Varien/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#39 /home/aisupps/public_html/mstore/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
#40 /home/aisupps/public_html/mstore/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#41 /home/aisupps/public_html/mstore/index.php(78): Mage::run(\\\'\\\', \\\'store\\\')
#42 {main}\\\"
;s:3:\\\"url\\\";s:76:\\\"/mstore/index.php/admin/customer/index/key/730d9673a57ba7733f6acee7de4b9bdc/\\\";s:11:\\\"script_name\\\";s:17:\\\"/mstore/index.php\\\";s:4:\\\"skin\\\";s:5:\\\"admin\\\";}
 
Magento Community Magento Community
Magento Community
Magento Community
 
d2footballjrc
Jr. Member
 
Total Posts:  2
Joined:  2012-05-03
 

We are semi-desperate as this is requiring us to make customer changes manually in the sql. Would be willing to donate some money via paypal for help!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top