Mautic Version
4.4.x series
PHP version
8.0.26
What browsers are you seeing the problem on?
Not relevant
What happened?
The log file under var/logs shows errors.
How can these errors be fixed?
Is it related to this issue?
https://forum.mautic.org/t/probleme-mit-mautic-und-doi-bestatigungs-email-nach-formulareintrag/27894
How can we reproduce this issue?
Step 1:
After entering the form
https://f3t-workout.de/formular-fettverbrennung-anregen
an email containing a confirmation link will be sent via a campaign.
When clicking on the link in this Mail, an ERROR 500 page is displayed.
Relevant log output
[2023-05-03 13:57:02] 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 [] {"hostname":"ovm8067","pid":3051872}
[2023-05-03 13:57:02] 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 [] {"hostname":"ovm8067","pid":3051872}
[2023-05-03 13:57:02] 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 [] {"hostname":"ovm8067","pid":3051855}
[2023-05-03 13:57:02] 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 [] {"hostname":"ovm8067","pid":3051855}
[2023-05-03 13:58:01] 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 [] {"hostname":"ovm8067","pid":3052433}
[2023-05-03 13:58:01] 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 [] {"hostname":"ovm8067","pid":3052433}
[2023-05-03 13:58:37] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "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" at /html/mautic_447v2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 98 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'REPLACE INTO campaign_lead_event_failed_log( `log_id`, `date_added`, `reason`)\nSELECT id, :dateAdded as date_added, :message as reason from campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation':\n\nYou 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\nWHERE ' at line 2 at /html/mautic_447v2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98, Doctrine\\DBAL\\Driver\\Mysqli\\Exception\\ConnectionError(code: 0): 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\nWHERE ' at line 2 at /html/mautic_447v2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/Exception/ConnectionError.php:21)"} {"hostname":"ovm8067","pid":3052162}
[2023-05-03 14:42:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "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" at /html/mautic_447v2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 98 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'REPLACE INTO campaign_lead_event_failed_log( `log_id`, `date_added`, `reason`)\nSELECT id, :dateAdded as date_added, :message as reason from campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation':\n\nYou 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\nWHERE ' at line 2 at /html/mautic_447v2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98, Doctrine\\DBAL\\Driver\\Mysqli\\Exception\\ConnectionError(code: 0): 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\nWHERE ' at line 2 at /html/mautic_447v2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/Exception/ConnectionError.php:21)"} {"hostname":"ovm8067","pid":3077296}
[2023-05-03 14:44:49] mautic.WARNING: PHP Warning - Undefined array key "full" - in file /html/mautic_447v2/app/bundles/CoreBundle/Security/Permissions/AbstractPermissions.php - at line 209 [] {"hostname":"ovm8067","pid":3078973}
Code of Conduct
Mautic Version
4.4.x series
PHP version
8.0.26
What browsers are you seeing the problem on?
Not relevant
What happened?
The log file under var/logs shows errors.
How can these errors be fixed?
Is it related to this issue?
https://forum.mautic.org/t/probleme-mit-mautic-und-doi-bestatigungs-email-nach-formulareintrag/27894
How can we reproduce this issue?
Step 1:
After entering the form
https://f3t-workout.de/formular-fettverbrennung-anregen
an email containing a confirmation link will be sent via a campaign.
When clicking on the link in this Mail, an ERROR 500 page is displayed.
Relevant log output
Code of Conduct