Resolved mailman list creation gives Duplicate entry for Primary key

[tkalfaoglu]

When a customer tried to create a mailing list he got:

Error: DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '158' for key 'PRIMARY', query was: replace MailLists set `id`='0', `dom_id`='213', `name`='xyz.temp', `status`='0'

What's the best way to correct this?
Many thanks, -t

 

[IgorG]

Does 'plesk repair db' help?

 

[tkalfaoglu]

Does 'plesk repair db' help?

Unfortunately not.
It did fix a bunch of other things tho

I am still getting the same error.
After the error, the list is actually created but unpopulated (re-trying to create the list yields to a listmng error saying list already exists.)
But the mailing list tab on plesk stays empty since it was not inserted into the database due to the original error.

 

[IgorG]

Try to ask the assistance of Plesk Support Team for fixing this database inconsistency.

 

[tkalfaoglu]

Try to ask the assistance of Plesk Support Team for fixing this database inconsistency.

Thank you -- the support team solved the issue. It was another case of Autoincrement internal counter being LOWER than the maximum value in the table for the autoincrement field!

It's a variation of this:
An operation fails in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'X' for key 'PRIMARY'