Error on Magento website: Base table or view already exists: 1050 Table 'customer_entity' already exists

Created:

2016-12-18 06:50:39 UTC

Modified:

2017-08-08 13:45:04 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error on Magento website: Base table or view already exists: 1050 Table 'customer_entity' already exists

Applicable to:

  • Plesk Onyx for Linux

Symptoms

Magento website shows the following error:

Error in file: "/var/www/vhosts/example.com/httpdocs/app/code/core/Mage/Customer/sql/customer_setup/install-1.6.0.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'customer_entity' already exists, query was: CREATE TABLE `customer_entity`

Table core_resource in Magento database contains only the following entries:

+-------------------------+---------+--------------+
| code | version | data_version |
+-------------------------+---------+--------------+
| adminnotification_setup | 1.6.0.0 | NULL |
| admin_setup | 1.6.1.2 | NULL |
| core_setup | 1.6.0.6 | NULL |
| cron_setup | 1.6.0.0 | NULL |
| dataflow_setup | 1.6.0.0 | NULL |
| directory_setup | 1.6.0.3 | NULL |
| eav_setup | 1.6.0.1 | NULL |
| index_setup | 1.6.0.0 | NULL |
+-------------------------+---------+--------------+

Cause

Inconsistency in Magento database. Table core_resource does not contain proper information about Magento installation and Magento scripts try to make fresh install of application.

Resolution

Restore Magento database from a valid backup.

Have more questions? Submit a request
Please sign in to leave a comment.