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

add product broken? 
 
bschiett
Jr. Member
 
Total Posts:  14
Joined:  2008-11-02
 

Hi,

we tried something with the store manager feature and the store views, and now the add product seems to be broken?
when i try to add a product i get this :

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

(i was trying to make a simple product).

we’re on the latest magento version (1.3)

when i try to go to the cache management and click rebuild for the flat catalog / flat product options i get this :

exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[HY000]: General error: 1005 Can’t create table ‘./store_magento/catalog_product_flat_1.frm’ (errno: 121)’ in /home/store/public_html/magento/lib/Zend/Db/Statement/Pdo.php:238 Stack trace: #0 /home/store/public_html/magento/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/store/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array) #2 /home/store/public_html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’CREATE TABLE `c...’, Array) #3 /home/store/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(259): Zend_Db_Adapter_Pdo_Abstract->query(’CREATE TABLE `c...’, Array) #4 /home/store/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Flat/Indexer.php(461): Varien_Db_Adapter_Pdo_Mysql->query(’CREATE TABLE `c...’) #5 /home/store/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Flat/Indexer.php(115): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Flat_Indexer->prepareFlatTable(’1’) #6 /home/store/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Flat/Indexer.php(108): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Flat_Indexer->rebuild(’1’) #7 /home/store/public_html/magento/app/code/core/Mage/Adminhtml/controllers/System/CacheController.php(235): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Flat_Indexer->rebuild() #8 /home/store/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(367): Mage_Adminhtml_System_CacheController->saveAction() #9 /home/store/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(247): Mage_Core_Controller_Varien_Action->dispatch(’save’) #10 /home/store/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #11 /home/store/public_html/magento/app/Mage.php(457): Mage_Core_Controller_Varien_Front->dispatch() #12 /home/store/public_html/magento/index.php(52): Mage::run() #13 {main}

thanks
b

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