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;

Written by Bala Krishna

Bala Krishna is web developer and occasional blogger from Bhopal, MP, India. He like to share idea, issue he face while working with the code.

Leave a Comment

Your email address will not be published. Required fields are marked *