• Resolved kervadecg

    (@kervadecg)


    Hello,

    I am experiencing an error message when accessing the settings menu in the back-end :

    An exception occurred while executing ‘UPDATE wp_mailpoet_newsletter_segment SET segment_id = ?, updated_at = ? WHERE id = ?’ with params [null, “2022-08-31 18:21:48”, 156]:

    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’85-0′ for key ‘newsletter_segment’

    Could you please help me in solving this issue ?

    Configuration :
    WP 5.9.4
    MailPoet Free version: 3.96.1
    MailPoet Premium version: 3.96.0

    Kind regards

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Ojoma a11n

    (@geraltrivia)

    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.

    Thread Starter kervadecg

    (@kervadecg)

    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.

    Thread Starter kervadecg

    (@kervadecg)

    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 ??

    Plugin Author Bruna a11n

    (@bruberries)

    Hi @kervadecg,

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

    Thread Starter kervadecg

    (@kervadecg)

    Yes, the problem does not appear anymore.

    Thanks for your support.

    Thread Starter kervadecg

    (@kervadecg)

    I mark the topic as resolved.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘SQLSTATE Integrity constraint violation in Mailpoet-settings menu’ is closed to new replies.