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

Getting errors after importing sample data into a Linux Magento database. 
 
Sintax
Member
 
Total Posts:  58
Joined:  2008-02-18
Hungary
 

Hi,

I switched to Linux to avoid the problems during the installation on the XP box. After importing the sampledata : mysql -p magentodb < sampledata.sql
when I run the main page I receive an error trace in the cart section. Also when trying to click on a store item I get a Page not found. This is the text I get:

exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magentodb/sales_quote_entity_varchar`, CONSTRAINT `FK_sales_quote_entity_varchar_attribute` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDAT)’ in /var/www/magento2/lib/Zend/Db/Statement/Pdo.php:238
Stack trace:
#0 /var/www/magento2/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/magento2/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /var/www/magento2/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(’INSERT INTO `sa...’, Array)
#3 /var/www/magento2/lib/Zend/Db/Adapter/Abstract.php(484): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `sa...’, Array)
#4 /var/www/magento2/app/code/core/Mage/Eav/Model/Entity/Abstract.php(978): Zend_Db_Adapter_Abstract->insert(’sales_quote_ent...’, Array)
#5 /var/www/magento2/app/code/core/Mage/Eav/Model/Entity/Abstract.php(939): Mage_Eav_Model_Entity_Abstract->_insertAttribute(Object(Mage_Sales_Model_Quote), Object(Mage_Eav_Model_Entity_Attribute), ‘USD’)
#6 /var/www/magento2/app/code/core/Mage/Eav/Model/Entity/Abstract.php(663): Mage_Eav_Model_Entity_Abstract->_processSaveData(Array)
#7 /var/www/magento2/app/code/core/Mage/Core/Model/Abstract.php(219): Mage_Eav_Model_Entity_Abstract->save(Object(Mage_Sales_Model_Quote))
#8 /var/www/magento2/app/code/core/Mage/Checkout/Model/Session.php(57): Mage_Core_Model_Abstract->save()
#9 /var/www/magento2/app/code/core/Mage/Checkout/Block/Cart/Sidebar.php(73): Mage_Checkout_Model_Session->getQuote()
#10 /var/www/magento2/app/code/core/Mage/Checkout/Block/Cart/Sidebar.php(44): Mage_Checkout_Block_Cart_Sidebar->getQuote()
#11 /var/www/magento2/app/design/frontend/default/default/template/checkout/cart/sidebar.phtml(34): Mage_Checkout_Block_Cart_Sidebar->getItemCollection()
#12 /var/www/magento2/app/code/core/Mage/Core/Block/Template.php(112): include(’/var/www/magent...’)
#13 /var/www/magento2/app/code/core/Mage/Core/Block/Template.php(144): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#14 /var/www/magento2/app/code/core/Mage/Core/Block/Template.php(183): Mage_Core_Block_Template->renderView()
#15 /var/www/magento2/app/code/core/Mage/Core/Block/Abstract.php(549): Mage_Core_Block_Template->_toHtml()
#16 /var/www/magento2/app/code/core/Mage/Core/Block/Text/List.php(36): Mage_Core_Block_Abstract->toHtml()
#17 /var/www/magento2/app/code/core/Mage/Core/Block/Abstract.php(549): Mage_Core_Block_Text_List->_toHtml()
#18 /var/www/magento2/app/code/core/Mage/Core/Block/Abstract.php(435): Mage_Core_Block_Abstract->toHtml()
#19 /var/www/magento2/app/code/core/Mage/Core/Block/Abstract.php(412): Mage_Core_Block_Abstract->_getChildHtml(’right’, true)
#20 /var/www/magento2/app/design/frontend/default/default/template/page/2columns-right.phtml(62): Mage_Core_Block_Abstract->getChildHtml(’right’)
#21 /var/www/magento2/app/code/core/Mage/Core/Block/Template.php(112): include(’/var/www/magent...’)
#22 /var/www/magento2/app/code/core/Mage/Core/Block/Template.php(144): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#23 /var/www/magento2/app/code/core/Mage/Core/Block/Template.php(183): Mage_Core_Block_Template->renderView()
#24 /var/www/magento2/app/code/core/Mage/Core/Block/Abstract.php(549): Mage_Core_Block_Template->_toHtml()
#25 /var/www/magento2/app/code/core/Mage/Core/Model/Layout.php(437): Mage_Core_Block_Abstract->toHtml()
#26 /var/www/magento2/app/code/core/Mage/Core/Controller/Varien/Action.php(314): Mage_Core_Model_Layout->getOutput()
#27 /var/www/magento2/app/code/core/Mage/Cms/Helper/Page.php(84): Mage_Core_Controller_Varien_Action->renderLayout()
#28 /var/www/magento2/app/code/core/Mage/Cms/controllers/IndexController.php(26): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘home’)
#29 /var/www/magento2/app/code/core/Mage/Core/Controller/Varien/Action.php(337): Mage_Cms_IndexController->indexAction()
#30 /var/www/magento2/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(149): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#31 /var/www/magento2/app/code/core/Mage/Core/Controller/Varien/Front.php(147): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#32 /var/www/magento2/app/Mage.php(388): Mage_Core_Controller_Varien_Front->dispatch()
#33 /var/www/magento2/index.php(28): Mage::run(’base’)
#34 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
neuromancer
Jr. Member
 
Avatar
Total Posts:  24
Joined:  2007-11-20
 

getting a similar error . This error is showing in my shopping cart content block

exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mudpie_mudpiestoreDB.wishlist_item’ doesn’t exist’ in /home2/mudpie/public_html/mudpieart/lib/Zend/Db/Statement/Pdo.php:238
Stack trace:
#0 /home2/mudpie/public_html/mudpieart/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home2/mudpie/public_html/mudpieart/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home2/mudpie/public_html/mudpieart/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(’select count(DI...’, Array)
#3 /home2/mudpie/public_html/mudpieart/lib/Zend/Db/Adapter/Abstract.php(711): Zend_Db_Adapter_Pdo_Abstract->query(’select count(DI...’, Array)
#4 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Eav/Model/Entity/Collection/Abstractold.php(1322): Zend_Db_Adapter_Abstract->fetchOne(’select count(DI...’)
#5 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Eav/Model/Entity/Collection/Abstractold.php(1261): Mage_Eav_Model_Entity_Collection_Abstractold->getSize()
#6 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Eav/Model/Entity/Collection/Abstractold.php(1284): Mage_Eav_Model_Entity_Collection_Abstractold->getLastPageNumber()
#7 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Eav/Model/Entity/Collection/Abstractold.php(923): Mage_Eav_Model_Entity_Collection_Abstractold->_getPageStart()
#8 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Eav/Model/Entity/Collection/Abstractold.php(783): Mage_Eav_Model_Entity_Collection_Abstractold->_loadEntities(false, false)
#9 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Wishlist/Block/Customer/Sidebar.php(53): Mage_Eav_Model_Entity_Collection_Abstractold->load()
#10 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Wishlist/Block/Customer/Sidebar.php(34): Mage_Wishlist_Block_Customer_Sidebar->getWishlist()
#11 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Wishlist/Block/Customer/Sidebar.php(61): Mage_Wishlist_Block_Customer_Sidebar->getWishlistItems()
#12 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Block/Abstract.php(549): Mage_Wishlist_Block_Customer_Sidebar->_toHtml()
#13 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Block/Text/List.php(36): Mage_Core_Block_Abstract->toHtml()
#14 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Block/Abstract.php(549): Mage_Core_Block_Text_List->_toHtml()
#15 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Block/Abstract.php(435): Mage_Core_Block_Abstract->toHtml()
#16 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Block/Abstract.php(412): Mage_Core_Block_Abstract->_getChildHtml(’right’, true)
#17 /home2/mudpie/public_html/mudpieart/app/design/frontend/default/default/template/page/3columns.phtml(64): Mage_Core_Block_Abstract->getChildHtml(’right’)
#18 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Block/Template.php(112): include(’/home2/mudpie/p...’)
#19 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Block/Template.php(144): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#20 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Block/Template.php(183): Mage_Core_Block_Template->renderView()
#21 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Block/Abstract.php(549): Mage_Core_Block_Template->_toHtml()
#22 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Model/Layout.php(437): Mage_Core_Block_Abstract->toHtml()
#23 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Controller/Varien/Action.php(314): Mage_Core_Model_Layout->getOutput()
#24 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Catalog/controllers/CategoryController.php(65): Mage_Core_Controller_Varien_Action->renderLayout()
#25 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Controller/Varien/Action.php(337): Mage_Catalog_CategoryController->viewAction()
#26 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(149): Mage_Core_Controller_Varien_Action->dispatch(’view’)
#27 /home2/mudpie/public_html/mudpieart/app/code/core/Mage/Core/Controller/Varien/Front.php(147): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#28 /home2/mudpie/public_html/mudpieart/app/Mage.php(388): Mage_Core_Controller_Varien_Front->dispatch()
#29 /home2/mudpie/public_html/mudpieart/index.php(28): Mage::run(’base’)
#30 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sintax
Member
 
Total Posts:  58
Joined:  2008-02-18
Hungary
 

so is there a solution to this?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lior
Magento Team
 
Avatar
Total Posts:  293
Joined:  2007-09-24
 

did you install sample data before or after Magento installation?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Tassoman
Member
 
Avatar
Total Posts:  32
Joined:  2007-10-24
Bologna, Italy
 

Sample data, after skratch installation… So?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lior
Magento Team
 
Avatar
Total Posts:  293
Joined:  2007-09-24
 

You have to run the install one more time now.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Tassoman
Member
 
Avatar
Total Posts:  32
Joined:  2007-10-24
Bologna, Italy
 

Without running install ... no debug / exception message is showing in front end now. I seem it needed some page view by cache adjust?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lior
Magento Team
 
Avatar
Total Posts:  293
Joined:  2007-09-24
 

you can try to clear the cache in the admin
System> Cache Management

I am not sure that it will help you.
Sample data has to be installed before the Magento installation, or you have to reinstall Magento after it.

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