Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sales_order_status' already exists

‎01-04-2016 09:04 AM
‎01-04-2016 09:04 AM

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sales_order_status' already exists

Hi 

 

Have received an error whilst upgrading from V1.4.2.0 to V1.5.1.0 which did not upgraded successfully I then used an Installatron backup to restore website. Initially the restore appeared to work until I started testing this upgrade after the first failure. I now get this perpetual error upgrading to V1.5.1.0 :- 

 

Error in file: "/app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-1.4.0.22-1.4.0.23.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sales_order_status' already exists

 

It now seems that the backup restore did work properly as it seems to have left tables that are not native to V1.4 so now when I try to upgrade to V1.5.1.0 it throws the same "Base table or view already exists error" every time I try to upgrade.

 

Big question am I doomed or is there a work round,

 

Any help would be much appreciated,

 

kind regards

 

Nick

Labels:
0 Kudos
1 REPLY 1
‎06-10-2016 04:05 AM
‎06-10-2016 04:05 AM

Re: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sales_order_status' already exis

The main reason behind this error is, when you first tried upgrade, table was created and now when you try again, it already has table saved and thus flashes error.
 
Please try steps below:

1. Take backup of "sales_order_status" table
2. Remove that table from database
3. Try to upgrade magento now

0 Kudos