# Log error: campaign\_lead\_event\_failed\_log

**URL:** https://forum.mautic.org/t/log-error-campaign-lead-event-failed-log/23133
**Category:** Product Support
**Tags:** mautic-4
**Created:** [March 19, 2022, 9:51am UTC](https://forum.mautic.org/t/log-error-campaign-lead-event-failed-log/23133 "2022-03-19T09:51:48Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![floeby](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/floeby/32/1444_2.png) [@floeby](https://forum.mautic.org/u/floeby)
#### Post date: [March 19, 2022, 9:51am UTC](https://forum.mautic.org/t/log-error-campaign-lead-event-failed-log/23133/1 "2022-03-19T09:51:48Z")

</div>

**Your software**  
My Mautic version is: 4.1.2  
My PHP version is: 7.4  
My Database type and version is: 10.4.24-MariaDB-cll-lve

**Your problem**  
My problem is:  
I am creating mautic install from scratch. Tried running a campaign, the campaign works, but errors keep showing up in the error log (every 15 minutes after update campaign cron job runs)

These errors are showing in the log: [2022-03-19 07:35:02] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘REPLACE INTO mau\_campaign\_lead\_event\_failed\_log( `log_id`, `date_added`, `reason`) SELECT id, :dateAdded as date\_added, :message as reason from mau\_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 mau\_campaign\_lead\_event\_log…’ at line 2

Steps I have tried to fix the problem:

I have tried changing the the value to `‘db\_driver’ =\> ‘pdo\_mysql’ in app/config/local.php, but this crashes my mautic  
I have tried changing the message into reason keywords ([SQL error fix; Message seems to be a keyword by escopecz · Pull Request #6574 · mautic/mautic · GitHub](https://github.com/mautic/mautic/pull/6574)), but this just changes the error message from message to reason

Could it be

---

<div class="post-metadata">

### Author: ![bunce69](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bunce69/32/143_2.png) [@bunce69](https://forum.mautic.org/u/bunce69)
#### Post date: [September 12, 2023, 6:37pm UTC](https://forum.mautic.org/t/log-error-campaign-lead-event-failed-log/23133/2 "2023-09-12T18:37:21Z")

</div>

Any update on this bug please ?
