Cleaning a mailing list (inactive users)

I am attempting to set up a clean on my mailing list which removes users that have not opened an email or been active on my website for greater than 3/6 months. I want to remove these users from my newsletter segment as is described in this article (https://kb.mailchimp.com/accounts/compliance-tips/about-list-cleaning)



I found this post on github https://github.com/mautic/mautic/issues/1818 and followed the instructions. I created a brand new segment using the following filter.

Date Last Active - less than or equal to - 3 months



However my developer has just informed me that it is causing the following issue in Mautic which is preventing other segments from being updated.



mautic.NOTICE: DoctrineDBALExceptionUniqueConstraintViolationException: An exception occurred while executing ‘INSERT INTO zw_lead_lists_leads (date_added, manually_removed, manually_added, leadlist_id, lead_id) VALUES (?, ?, ?, ?, ?)’ with params [“2017-10-19 15:38:07”, 0, 0, 78, “197796”]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘78-197796’ for key ‘PRIMARY’ (uncaught exception) at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 66 while running console command mautic:segments:update [] []



Does anyone have any advice on why this might be happening and how I can solve this?

I am attempting to set up a clean on my mailing list which removes users that have not opened an email or been active on my website for greater than 3/6 months. I want to remove these users from my newsletter segment as is described in this article (https://kb.mailchimp.com/accounts/compliance-tips/about-list-cleaning)

I found this post on github https://github.com/mautic/mautic/issues/1818 and followed the instructions. I created a brand new segment using the following filter.
Date Last Active - less than or equal to - 3 months

However my developer has just informed me that it is causing the following issue in Mautic which is preventing other segments from being updated.

mautic.NOTICE: DoctrineDBALExceptionUniqueConstraintViolationException: An exception occurred while executing ‘INSERT INTO zw_lead_lists_leads (date_added, manually_removed, manually_added, leadlist_id, lead_id) VALUES (?, ?, ?, ?, ?)’ with params [“2017-10-19 15:38:07”, 0, 0, 78, “197796”]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘78-197796’ for key ‘PRIMARY’ (uncaught exception) at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 66 while running console command mautic:segments:update [] []

Does anyone have any advice on why this might be happening and how I can solve this?

1 Like