Try the Demo

Magento Forum

   
Upgrade to 1.7.0.1 Product price re-index issue
 
sahilsaid
Jr. Member
 
Total Posts:  3
Joined:  2012-07-30
 

HI,

I am getting this error when I try to Reindex ‘product prices’.
There was a problem with reindexing process.

I tried lot of solutions but nothing is working. Because fo this I cannot add a new product.

When I try to add a new product, it gives me the following error:

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

Log file shows:

Stack trace:
#0 /home/www/find-accessories.com/app/Mage.php(462): Mage_Core_Model_Config->getModelInstance('eav/entity_attr...', 'SQLSTATE[42S02]...')
#1 /home/www/find-accessories.com/app/code/core/Mage/Eav/Model/Entity/Abstract.php(661): Mage::getModel('eav/entity_attr...', 'SQLSTATE[42S02]...')
#2 /home/www/find-accessories.com/app/code/core/Mage/Eav/Model/Entity/Abstract.php(1648): Mage_Eav_Model_Entity_Abstract->walkAttributes('backend/afterSa...', Array)
#3 /home/www/find-accessories.com/app/code/core/Mage/Catalog/Model/Resource/Product.php(195): Mage_Eav_Model_Entity_Abstract->_afterSave(Object(Mage_Catalog_Model_Product))
#4 /home/www/find-accessories.com/app/code/core/Mage/Eav/Model/Entity/Abstract.php(1124): Mage_Catalog_Model_Resource_Product->_afterSave(Object(Mage_Catalog_Model_Product))
#5 /home/www/find-accessories.com/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Eav_Model_Entity_Abstract->save(Object(Mage_Catalog_Model_Product))
#6 /home/www/find-accessories.com/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(714): Mage_Core_Model_Abstract->save()
#7 /home/www/find-accessories.com/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Adminhtml_Catalog_ProductController->saveAction()
#8 /home/www/find-accessories.com/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('save')
#9 /home/www/find-accessories.com/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#10 /home/www/find-accessories.com/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#11 /home/www/find-accessories.com/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#12 /home/www/find-accessories.com/index.php(87): Mage::run('', 'store')
#13 {main}
Can someone please help?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Enthusiast
 
Avatar
Total Posts:  928
Joined:  2008-04-24
 

Hi,

Have you tried to run the reindexer from the command line (SSH)? If you have shell access you can run the following command from the <magento_folder>/shell/ directory:

php -f indexer.php reindexall

Additionally, if there is a problem it will give you a more detailed error message.

However, based on the message in your error log it looks like the SQL upgrade scripts failed during the upgrade. You may try to force the upgrade again, but most times it is necessary to manually fix the missing/broken database tables. If you have some experience with PHP and MySQL you should be able to edit the upgrade scripts.

 Signature 

Professional Magento Optimized Web Hosting
Magento Web Hosting - Reseller Plans - Dedicated Servers
Providing high-performance Magento hosting since 2008.
50% Off First Month: use coupon code: “magentocommerce”

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