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

Strange Mysql errors
 
crackers
Member
 
Total Posts:  55
Joined:  2007-09-11
 

hey, if you have a look at http://www.continentalappliances.com.au/ im experiencing strange problems.

Can anybody tell me whats up?

SELECT `e`.*, `_table_wishlist_item_id`.`wishlist_item_id`, `_table_product_id`.`product_id`, `_table_description`.`description`, `_table_store_id`.`store_id`, `_table_added_at`.`added_at`, `_table_wishlist_id`.`wishlist_id` FROM `catalog_product_entity` AS `e` INNER JOIN `wishlist_item` AS `_table_wishlist_item_id` ON (_table_wishlist_item_id.product_id=e.entity_id) AND (_table_wishlist_item_id.wishlist_id = ‘’) INNER JOIN `wishlist_item` AS `_table_product_id` ON (_table_product_id.wishlist_item_id=_table_wishlist_item_id.wishlist_item_id) INNER JOIN `wishlist_item` AS `_table_description` ON (_table_description.wishlist_item_id=_table_wishlist_item_id.wishlist_item_id) INNER JOIN `wishlist_item` AS `_table_store_id` ON (_table_store_id.wishlist_item_id=_table_wishlist_item_id.wishlist_item_id) INNER JOIN `wishlist_item` AS `_table_added_at` ON (_table_added_at.wishlist_item_id=_table_wishlist_item_id.wishlist_item_id) INNER JOIN `wishlist_item` AS `_table_wishlist_id` ON (_table_wishlist_id.wishlist_item_id=_table_wishlist_item_id.wishlist_item_id) WHERE (e.entity_type_id = 10) AND (_table_store_id.store_id in (’1’, ‘5’, ‘6’)) ORDER BY `_table_added_at`.`added_at` desc LIMIT 3

exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[HY000]: General error: 1030 Got error 122 from storage engine’ in /home/crackah/public_html/continentalappliances/lib/Zend/Db/Statement/Pdo.php:227
Stack trace:
#0 /home/crackah/public_html/continentalappliances/lib/Zend/Db/Statement.php(279): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/crackah/public_html/continentalappliances/lib/Zend/Db/Adapter/Abstract.php(383): Zend_Db_Statement->execute(Array)
#2 /home/crackah/public_html/continentalappliances/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
#3 /home/crackah/public_html/continentalappliances/lib/Zend/Db/Adapter/Abstract.php(590): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array)
#4 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(723): Zend_Db_Adapter_Abstract->fetchAll(Object(Zend_Db_Select))
#5 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(598): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#6 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Wishlist/Block/Links.php(60): Mage_Eav_Model_Entity_Collection_Abstract->load()
#7 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Wishlist/Block/Links.php(68): Mage_Wishlist_Block_Links->getWishlist()
#8 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Wishlist/Block/Links.php(34): Mage_Wishlist_Block_Links->getWishlistItems()
#9 [internal function]: Mage_Wishlist_Block_Links->addWishlistLink()
#10 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Core/Model/Layout.php(348): call_user_func_array(Array, Array)
#11 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Core/Model/Layout.php(258): Mage_Core_Model_Layout->_generateAction(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#12 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Core/Model/Layout.php(250): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#13 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Core/Model/Layout.php(254): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#14 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Core/Controller/Varien/Action.php(179): Mage_Core_Model_Layout->generateBlocks()
#15 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Cms/controllers/PageController.php(39): Mage_Core_Controller_Varien_Action->loadLayout()
#16 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Core/Controller/Varien/Action.php(225): Mage_Cms_PageController->viewAction()
#17 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(138): Mage_Core_Controller_Varien_Action->dispatch(’view’)
#18 /home/crackah/public_html/continentalappliances/app/code/core/Mage/Core/Controller/Varien/Front.php(139): Mage_Core_Controller_Varien_Router_Standard->match(Object(Zend_Controller_Request_Http))
#19 /home/crackah/public_html/continentalappliances/app/Mage.php(349): Mage_Core_Controller_Varien_Front->dispatch()
#20 /home/crackah/public_html/continentalappliances/index.php(27): Mage::run(’base’)
#21 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
crackers
Member
 
Total Posts:  55
Joined:  2007-09-11
 

if anyone can see http://www.continentalappliances.com.au , tell me whats wrong now? lol.

Thanks.

 
Magento Community Magento Community
Magento Community
Magento Community
 
sticky
Sr. Member
 
Avatar
Total Posts:  76
Joined:  2007-09-05
UK
 

What stage did the installer get to? Did it finish or timeout maybe?

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