Skip to content

Your bug title goes here! #12292

Description

@TS16V

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

  • I confirm that I have read and agree to follow this project's Code of Conduct

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugIssues or PR's relating to bugsneeds-triageFor new issues/PRs that need to be triaged

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions