SQLSTATE Integrity constraint violation in Mailpoet-settings menu

Hello @kervadecg ,

Thank you for reaching out to us.

The important part of the error there is this section: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry “85-0” for key “name”

I see that this error message will be displayed if you are trying to rename a list and set it to the name of a different existing list.

List names must be unique, so the name you set can’t be the name of a different existing list. For example, if you have “List A” and “List B”, you can’t rename “List A” and set the new name as “List B” (since “List B” already exists).

Please try setting your List name to something different, or delete the other already existing list first. If you delete the other list, you will also need to Empty Trash for your Lists before you rename the first one.

Of course, feel free to reach out to us if you need further assistance or you have other questions and we’d be happy to help.

Have a great day.

Hello,

Thanks for your reply.

I was not renaming a list, but may be another user tried to do so.
Now I have this permanent error message when accessing the segment/list menu.

Is there a way to audit the lists, to detect which list is creating the problem and to suppress its record ?

Kind regards.

Hello,

I tried to solve the issue.
The table wp_mailpoet_newsletter_segment is referring to newsletter 85 and a segment 0
Segment 0 does not exist in table ‘wp_mailpoet_segments’

Using the normal back-end menu, I deleted (2 steps : 1/dustbin and 2/full delete)the newsletter having the id 85

Then, the table wp_mailpoet_newsletter_segment is no longer referring to a newsletter 85 and a segment 0

Let’s wait a few days and cross the fingers ??

Hi @kervadecg,

Great! Please let us know if the problem was solved and if it’s okay to mark this topic as resolved.

Yes, the problem does not appear anymore.

Thanks for your support.

I mark the topic as resolved.