Home » Magento4 June 2013

Magento: Admin login error after website transfer

I recently transferred a Magento website from one webhost to another. Frontend part is working fine. I am able to view products and cms pages. I am also able to view the admin login page. However, when try logging to admin, I get error page showing the following SQL query:

I couldn’t find proper solution over the internet. Then, I typed the above SQL query on my database (using phpMyAdmin) and found that sales_order table doesn’t exist.

This helped me solve my silly mistake. The problem was that the database was not fully/completely imported. Some tables were not imported. I dropped all the tables and re-imported the database. This solved the issue.

Hope it helps.


Get New Post by Email

Find me on

FacebookTwitterGoogle+LinkedInRSS Feed
  • krishana singh

    import db again with SET FOREIGN_KEY_CHECKS=0;