Magento | Magento Error: Base table or view already exists: 1050 Table ’sales_order_status’ already exists

Magento Error: Base table or view already exists: 1050 Table ’sales_order_status’ already exists

Many times when you are upgrading the magento or trying to migrate the magento from one server to the any other server. Many times the upgrade  process halted. Then  quite frequent this error is coming in the magento. This is nothing that the magento does not allowed you to complete the process of upgradation and tables are slightly created over there. You have two method here to overcome with this.

There are many times the it is possible that the inner extension core extension does not upgraded properly. This makes that the table is already created over there and you again creating the table. You can apply following.

1) First make the backup of your current database. Since it is related with the sales extension then it is quite possible that the sales table does not created properly. Go inside the php my admin database select and drop all tables starting with the 'sales_*'  drop all hose tables.

           drop table sales_order_status_label;

            drop table sales_order_status_state;
            drop table sales_order_status;
            drop table paypal_cert;

2) Other method is that just see there on which particular version the system has halted just go to to the core_resouce table in the database and find the path column 'sales' extension name and upgrade the version of the extension if it was halted in the 1.6.0.0 then upgrade it there to 1.6.0.1 it will surely solve your issue.

clear your cache folders by the var/cache location and re-run the magento setup. It will create all the tables again.