Your software
My Mautic version is: 3.1.2
My PHP version is: 7.2
My Database type and version is: MySQL 5.7
Your problem
My problem is:
I have these lines flooding the Mautic log
[2020-11-24 18:02:03] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘INSERT INTO campaign_lead_event_log (rotation, date_triggered, is_scheduled, trigger_date, system_triggered, metadata, channel, channel_id, non_action_path_taken, event_id, lead_id, campaign_id, ip_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-11-24 18:02:03”, 0, null, 1, “a:0:{}”, null, null, 0, 732, “27828”, 25, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘732-27828-1’ for key ‘campaign_rotation’
[2020-11-24 18:17:03] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘INSERT INTO campaign_lead_event_log (rotation, date_triggered, is_scheduled, trigger_date, system_triggered, metadata, channel, channel_id, non_action_path_taken, event_id, lead_id, campaign_id, ip_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-11-24 18:17:03”, 0, null, 1, “a:0:{}”, null, null, 0, 732, “27828”, 25, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘732-27828-1’ for key ‘campaign_rotation’
[2020-11-24 18:32:03] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘INSERT INTO campaign_lead_event_log (rotation, date_triggered, is_scheduled, trigger_date, system_triggered, metadata, channel, channel_id, non_action_path_taken, event_id, lead_id, campaign_id, ip_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-11-24 18:32:03”, 0, null, 1, “a:0:{}”, null, null, 0, 732, “27828”, 25, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘732-27828-1’ for key ‘campaign_rotation’
[2020-11-24 18:47:02] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘INSERT INTO campaign_lead_event_log (rotation, date_triggered, is_scheduled, trigger_date, system_triggered, metadata, channel, channel_id, non_action_path_taken, event_id, lead_id, campaign_id, ip_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-11-24 18:47:02”, 0, null, 1, “a:0:{}”, null, null, 0, 732, “27828”, 25, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘732-27828-1’ for key ‘campaign_rotation’
[2020-11-24 19:02:05] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘INSERT INTO campaign_lead_event_log (rotation, date_triggered, is_scheduled, trigger_date, system_triggered, metadata, channel, channel_id, non_action_path_taken, event_id, lead_id, campaign_id, ip_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-11-24 19:02:05”, 0, null, 1, “a:0:{}”, null, null, 0, 732, “27828”, 25, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘732-27828-1’ for key ‘campaign_rotation’
[2020-11-24 19:17:02] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘INSERT INTO campaign_lead_event_log (rotation, date_triggered, is_scheduled, trigger_date, system_triggered, metadata, channel, channel_id, non_action_path_taken, event_id, lead_id, campaign_id, ip_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-11-24 19:17:02”, 0, null, 1, “a:0:{}”, null, null, 0, 732, “27828”, 25, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘732-27828-1’ for key ‘campaign_rotation’
[2020-11-24 19:32:02] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘INSERT INTO campaign_lead_event_log (rotation, date_triggered, is_scheduled, trigger_date, system_triggered, metadata, channel, channel_id, non_action_path_taken, event_id, lead_id, campaign_id, ip_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-11-24 19:32:02”, 0, null, 1, “a:0:{}”, null, null, 0, 732, “27828”, 25, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘732-27828-1’ for key ‘campaign_rotation’
[2020-11-24 19:49:57] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘INSERT INTO campaign_lead_event_log (rotation, date_triggered, is_scheduled, trigger_date, system_triggered, metadata, channel, channel_id, non_action_path_taken, event_id, lead_id, campaign_id, ip_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-11-24 19:49:56”, 0, null, 1, “a:0:{}”, null, null, 0, 732, “27828”, 25, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘732-27828-1’ for key ‘campaign_rotation’
[2020-11-24 20:02:02] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘INSERT INTO campaign_lead_event_log (rotation, date_triggered, is_scheduled, trigger_date, system_triggered, metadata, channel, channel_id, non_action_path_taken, event_id, lead_id, campaign_id, ip_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-11-24 20:02:02”, 0, null, 1, “a:0:{}”, null, null, 0, 600, “27829”, 22, null]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘600-27829-1’ for key ‘campaign_rotation’
[2020-11-24 20:02:02] mautic.ERROR: CAMPAIGN: The EntityManager is closed.
These errors are showing in the log:
The campaign 12 is this:
Basically I want to call two webhooks for each lead in every day. If there is any (better) other way of doing this I will be happy know
I tried to set but it didn’t help.
Any ideas on how to fix this?
Regards