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

problem upgrading from 1.4.0.1 to some other version
 
bsimpson888
Jr. Member
 
Total Posts:  1
Joined:  2011-01-26
 

Hello together,
I am facing a problem with a missing table. I tried to upgrade a 1.4.0.1 CE Magento installation to a newer version. I made serval tests with going to version 1.4.2.0 , 1.5.1.0 and even 1.6.0rc2. Beside some other problems I solved already ( and there were a lot… grin ) I always face the same problem at some point. When going into the shopping cart and pressing checkout I will get a message that the customer_eav_attribute_website table is missing.

Somehow this table is not being created during the upgrade, but needed for all, and I mean all versions after 1.4.1.0 . It should be created I guess when going from 1.4.1.0 to 1.4.2.0 but I am not sure because I am new to Magento.

Maybe someone gives me a hint , how to solve the problem.

Thanks in advance
Marco

P.S. Here the error message:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘magento.customer_eav_attribute_website’ doesn’t exist

Trace:
#0 /var/www/shop/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/shop/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/shop/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’DESCRIBE `custo...’, Array)
#3 /var/www/shop/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query(’DESCRIBE `custo...’, Array)
#4 /var/www/shop/lib/Zend/Db/Adapter/Pdo/Mysql.php(156): Varien_Db_Adapter_Pdo_Mysql->query(’DESCRIBE `custo...’)
#5 /var/www/shop/lib/Varien/Db/Adapter/Pdo/Mysql.php(1325): Zend_Db_Adapter_Pdo_Mysql->describeTable(’customer_eav_at...’, NULL)
#6 /var/www/shop/app/code/core/Mage/Customer/Model/Entity/Attribute.php(64): Varien_Db_Adapter_Pdo_Mysql->describeTable(’customer_eav_at...’)
#7 /var/www/shop/app/code/core/Mage/Eav/Model/Mysql4/Entity/Attribute.php(80): Mage_Customer_Model_Entity_Attribute->_getLoadSelect(’attribute_code’, ‘dob’, Object(Mage_Customer_Model_Attribute))
#8 /var/www/shop/app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php(118): Mage_Eav_Model_Mysql4_Entity_Attribute->loadByCode(Object(Mage_Customer_Model_Attribute), ‘1’, ‘dob’)
#9 /var/www/shop/app/code/core/Mage/Customer/Model/Customer.php(742): Mage_Eav_Model_Entity_Attribute_Abstract->loadByCode(Object(Mage_Eav_Model_Entity_Type), ‘dob’)
#10 /var/www/shop/app/code/core/Mage/Checkout/Controller/Action.php(45): Mage_Customer_Model_Customer->validate()
#11 /var/www/shop/app/code/core/Mage/Checkout/controllers/OnepageController.php(42): Mage_Checkout_Controller_Action->_preDispatchValidateCustomer()
#12 /var/www/shop/app/code/core/Mage/Core/Controller/Varien/Action.php(407): Mage_Checkout_OnepageController->preDispatch()
#13 /var/www/shop/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#14 /var/www/shop/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#15 /var/www/shop/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
#16 /var/www/shop/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#17 /var/www/shop/index.php(80): Mage::run(’’, ‘store’)
#18 {main}

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