Your software
My Mautic version is: 4.4.10
My PHP version is: 7.4.33
My Database type and version is: 8.0.39
Your problem
My problem is:
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 mautic_campaign_lead_event_log ’ at line 2
These errors are showing in the log:
[2024-08-21 08:06:03] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘REPLACE INTO mautic_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from mautic_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 mautic_campaign_lead_event_log ’ at line 2
Steps I have tried to fix the problem:
Nothing really, we tried several small things but nothing special, as reupdate cron jobs, browse files …
I even dont know where to start to be honest
Thakns for your help