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

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sales_flat_order_grid’ already exists
 
Trenza
Member
 
Avatar
Total Posts:  57
Joined:  2010-03-11
Dhaka, Bangladesh
 

My store was in version 1.4.0.1 & I try to upgrade it to latest version by “magento-core/Mage_All_Latest” - after completion when I brows my store it shows the message “SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sales_flat_order_grid’ already exists”

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brent W Peterson
Moderator
 
Avatar
Total Posts:  3217
Joined:  2009-02-26
Minneapolis MN
 

Make a backup of you database

Drop the table sales_flat_order_grid

Magento should re-create it

Do you have a backup of your database before you upgraded?

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