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

fresh install not working
 
UltraFlux
Member
 
Avatar
Total Posts:  38
Joined:  2008-03-05
 

fresh install magento-installer-0.8.17240.tar

fresh install magento-sample-data-0.8.17240.tar

copied over files from sample

installed magento_sample_data_for_0.8.17240.sql

everything install wise works fine then everything goes craptasitc when i reload....

exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1216 Cannot add or update a child row: a foreign key constraint fails' in /home/13403/domains/testsite.com/html/lib/Zend/Db/Statement/Pdo.php:238
Stack trace
:
#0 /home/13403/domains/testsite.com/html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/13403/domains/testsite.com/html/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/13403/domains/testsite.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query('INSERT INTO `sa...', Array)
#3 /home/13403/domains/testsite.com/html/lib/Zend/Db/Adapter/Abstract.php(484): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `sa...', Array)
#4 /home/13403/domains/testsite.com/html/app/code/core/Mage/Eav/Model/Entity/Abstract.php(976): Zend_Db_Adapter_Abstract->insert('sales_quote_ent...', Array)
#5 /home/13403/domains/testsite.com/html/app/code/core/Mage/Eav/Model/Entity/Abstract.php(933): Mage_Eav_Model_Entity_Abstract->_insertAttribute(Object(Mage_Sales_Model_Quote), Object(Mage_Eav_Model_Entity_Attribute), 'USD')
#6 /home/13403/domains/testsite.com/html/app/code/core/Mage/Eav/Model/Entity/Abstract.php(801): Mage_Eav_Model_Entity_Abstract->_processSaveData(Array)
#7 /home/13403/domains/testsite.com/html/app/code/core/Mage/Core/Model/Abstract.php(220): Mage_Eav_Model_Entity_Abstract->save(Object(Mage_Sales_Model_Quote))
#8 /home/13403/domains/testsite.com/html/app/code/core/Mage/Checkout/Model/Session.php(62): Mage_Core_Model_Abstract->save()
#9 /home/13403/domains/testsite.com/html/app/code/core/Mage/Checkout/Model/Cart.php(109): Mage_Checkout_Model_Session->getQuote()
#10 /home/13403/domains/testsite.com/html/app/code/core/Mage/Checkout/Model/Mysql4/Cart.php(31): Mage_Checkout_Model_Cart->getQuote()
#11 /home/13403/domains/testsite.com/html/app/code/core/Mage/Checkout/Model/Cart.php(66): Mage_Checkout_Model_Mysql4_Cart->getItemsQty(Object(Mage_Checkout_Model_Cart))
#12 /home/13403/domains/testsite.com/html/app/code/core/Mage/Checkout/Helper/Cart.php(132): Mage_Checkout_Model_Cart->getItemsQty()
#13 /home/13403/domains/testsite.com/html/app/code/core/Mage/Checkout/Helper/Cart.php(122): Mage_Checkout_Helper_Cart->getItemsQty()
#14 /home/13403/domains/testsite.com/html/app/code/core/Mage/Checkout/Block/Links.php(32): Mage_Checkout_Helper_Cart->getSummaryCount()
#15 /home/13403/domains/testsite.com/html/app/code/core/Mage/Core/Model/Layout.php(300): Mage_Checkout_Block_Links->addCartLink()
#16 /home/13403/domains/testsite.com/html/app/code/core/Mage/Core/Model/Layout.php(175): Mage_Core_Model_Layout->_generateAction(Array, Array)
#17 /home/13403/domains/testsite.com/html/app/code/core/Mage/Core/Model/Layout.php(167): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#18 /home/13403/domains/testsite.com/html/app/code/core/Mage/Core/Model/Layout.php(171): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#19 /home/13403/domains/testsite.com/html/app/code/core/Mage/Core/Controller/Varien/Action.php(277): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#20 /home/13403/domains/testsite.com/html/app/code/core/Mage/Cms/Helper/Page.php(75): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#21 /home/13403/domains/testsite.com/html/app/code/core/Mage/Cms/controllers/IndexController.php(26): Mage_Cms_Helper_Page->renderPage()
#22 /home/13403/domains/testsite.com/html/app/code/core/Mage/Core/Controller/Varien/Action.php(341): Mage_Cms_IndexController->indexAction(Object(Mage_Cms_IndexController), 'home')
#23 /home/13403/domains/testsite.com/html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(150): Mage_Core_Controller_Varien_Action->dispatch()
#24 /home/13403/domains/testsite.com/html/app/code/core/Mage/Core/Controller/Varien/Front.php(147): Mage_Core_Controller_Varien_Router_Standard->match('index')
#25 /home/13403/domains/testsite.com/html/app/Mage.php(400): Mage_Core_Controller_Varien_Front->dispatch(Object(Mage_Core_Controller_Request_Http))
#26 /home/13403/domains/testsite.com/html/index.php(29): Mage::run()
#27 {main}
 
Magento Community Magento Community
Magento Community
Magento Community
 
UltraFlux
Member
 
Avatar
Total Posts:  38
Joined:  2008-03-05
 

testing new release

0.9.17740 now

 
Magento Community Magento Community
Magento Community
Magento Community
 
UltraFlux
Member
 
Avatar
Total Posts:  38
Joined:  2008-03-05
 

SQL query:

CREATE TABLE `admin_assert` (
`assert_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`assert_type` varchar( 20 ) NOT NULL default ‘’,
`assert_data` text,
PRIMARY KEY ( `assert_id` )
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT = ‘ACL Asserts’;

MySQL said: Documentation
#1050 - Table ‘admin_assert’ already exists

Magento dies again......

 
Magento Community Magento Community
Magento Community
Magento Community
 
UltraFlux
Member
 
Avatar
Total Posts:  38
Joined:  2008-03-05
 

FINALLY

Does this statement mean different things to different people?

Sample Data

Each archive contains a SQL script that should be applied on a clean database with your database management tool (phpMyAdmin or whatever you use), and ‘media’ folder with sample product images that you should copy to your Magento media folder.

I understood it as installing the sample sql file on a clean install, ie no products added, etc.  When really what they are saying is REMOVE all of your TABLES from your database, drop them completely!

db_magento(0)

Then you can run the sample data.sql file and things will work.

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

The right way to install Sample Data, is to run the sql file on empty DB before you install Magento
After you run the sql file, then do the Magento installation.

If you run the sample data sql file after the Magento installation, you will have to rerun the install one more time.

 
Magento Community Magento Community
Magento Community
Magento Community
 
UltraFlux
Member
 
Avatar
Total Posts:  38
Joined:  2008-03-05
 

yep I figured out that part for myself

although i now have an assortment of errors.

testsite

a) products link up to nothing “Whoooops nothing here”

b) backend is dead now

Fatal errorCall to a member function getBackend() on a non-object in /home/13403/domains/iamprettyfamous.com/html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php on line 367
 
Magento Community Magento Community
Magento Community
Magento Community
 
UltraFlux
Member
 
Avatar
Total Posts:  38
Joined:  2008-03-05
 

doing another damn install

0.9.17740

 
Magento Community Magento Community
Magento Community
Magento Community
 
UltraFlux
Member
 
Avatar
Total Posts:  38
Joined:  2008-03-05
 

seems to be working now.... strange

I think someone secretly changed something in the install rasberry

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