Resolved Can not add a mailbox - DB query failed: SQLSTATE[23000]...

[RomanLed]

Hello,
I have an error adding a mailbox:

DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '9' for key 'PRIMARY', query was: insert into spamfilter (`id`,`username`,`preferences`,`serviceNodeId`) VALUES ('0','[email protected]','true','1')

Here is the solution. but it does not work
Unable to create a mailbox: Integrity constraint violation: 1062 Duplicate entry

Plesk reapir db - it also does not help

 

[m3lezZ]

Have a look here

 

[RomanLed]

Nothing helped
DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10' for key 'PRIMARY', query was: insert into spamfilter (`id`,`username`,`preferences`,`serviceNodeId`) VALUES ('0','[email protected]','true','1')

plesk db "show table status where Name='mail' \G;" | grep Auto_increment
Auto_increment: 31

# plesk db "select max(id) from mail;"
+---------+
| MAX(id) |
+---------+
| 28 |
+---------+

 

[RomanLed]

But it has nothing to do with the backup

first e-mail account has been created and the next accoun is not

 

[RomanLed]

And there is no solution?

 

[IgorG]

What is output of

select max(id) from spamfilter;

For example, if it is 178, please execute this command:

# plesk db "alter table spamfilter auto_increment=179;"

After that, please try to create mailbox again.

 

[RomanLed]

Well, finally someone knew.
Big Thanks IgorG