1062Customer & Business Manager Duplicate entry '1' for key 'session_active'

[ZbyszekL]

After the failure of the database there is a problem with logging on to the Customer & Business Manager. When I'm logged on to Plesk Panleu and move on to the Customer & Business Manager, I get an error:

Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'session_active'

 

[EugeneL]

Try to remove all entries in table sessions in billing database:
shell> mysql -uadmin -p`cat /etc/psa/.psa.shadow` billing -e'delete from sessions;'

 

[ZbyszekL]

I deleted the contents of the table sessions, I fixed it and now it works.