1

I am receiving this error, when i try to login through ADMIN.

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY', query was: INSERT INTO admin_user_session (session_id, user_id, status, ip) VALUES (?, ?, ?, ?)

But, once i go back to PHPMYADMIN and EMPTY the MYSQL TABLE - admin_user_session, it works again.

0

2 Answers 2

0

Can you check the ID field in the admin_user_session table have AUTO_INCREMENT? If it's not, please set the AUTO_INCREMENT for that table. Like this:

enter image description here

0

Yes. The EXTRA field is empty and when i click on edit structure and try to edit, that field is not displayed for editing.

1
  • Do you use phpAdmin?
    – Nero Phung
    Commented Dec 7, 2017 at 6:03

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