0

I imported database backup through terminal . in terminal it gave error

ERROR 1062 (23000) at line 1016624: Duplicate entry '0' for key 'PRIMARY'

then I used the below commands to resolve this -
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; But still in admin panel I am getting error-

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY', query was: INSERT INTO adminnotification_inbox (severity, date_added, title, description, url) VALUES (?, ?, ?, ?, ?).

0

Please check your database because it contains duplicate records so it shows "Duplicate entry violation" error

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.