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 (?, ?, ?, ?, ?).