Your software
My Mautic version is: 2.16.3
My PHP version is: 7.3
My Database type and version is: MariaDB and it is 10.4 version.
Your problem
My problem is: I can’t edit any focus items, once in builder I get a 500 error (unsure if this is related or a different issue). Also once a user signs up my email sequence doesn’t start.
These errors are showing in the log:
[2020-11-18 17:20:01] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘REPLACE INTO mauaf_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from mauaf_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 MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from mauaf_campaign_lead_event_l…’ at line 2
Steps I have tried to fix the problem: Cleared Mautic Cache, tried to update schema, restored update on server from when Mautic was last working.