Your software
My Mautic version is: 4.1.1
My PHP version is: 7.4.27
My Database type and version is: 8.0.27
Your problem
My problem is:
A certain campaign does not work as intended.
These errors are showing in the log:
[2021-12-30 23:48:25] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘REPLACE INTO campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':dateAdded as date_added, :message as reason from campaign_lead_event_log WHERE ’ at line 2
Steps I have tried to fix the problem:
Nothing.