Magento Integrity Constraint Violation: 1062 Duplicate entry Error Fix
I received this error when I moved magneto installation from one server to another. After applying migration steps below I received this error.
- Copy all root folders files.
- Backup/Restore database.
- Updated database credentials in local.xml file.
- Updated new domain base urls in core_config_data table.
If website show above error or redirect to old domain run the following query in phpmyadmin. Be careful. Make sure you are running query in correct database.
TRUNCATE dataflow_batch_export; TRUNCATE dataflow_batch_import; TRUNCATE log_customer; TRUNCATE log_quote; TRUNCATE log_summary; TRUNCATE log_summary_type; TRUNCATE log_url; TRUNCATE log_url_info; TRUNCATE log_visitor; TRUNCATE log_visitor_info; TRUNCATE log_visitor_online; TRUNCATE report_event;