500 Error

Product Support
1

Your software
My Mautic version is: 2.16.3
My PHP version is: 7.2
My Database type and version is: MariaDB and it is 10.4 version.

Your problem
My problem is: Getting 500 error when I try to log into Mautic and getting a 500 error on my site for Mautic running, I don’t believe any changes had been made to my setup (that I know of), very unsure what happened here.

These errors are showing in the log: Erros in the log:

[2020-11-06 00:00: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
[2020-11-06 00:10: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
[2020-11-06 00: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
[2020-11-06 00:30: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
[2020-11-06 00:40: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
[2020-11-06 00:50:02] 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
[2020-11-06 01:00: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
[2020-11-06 01:10: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
[2020-11-06 01: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
[2020-11-06 01:20:02] 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
[2020-11-06 01:30:02] 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
[2020-11-06 01:40:02] 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
[2020-11-06 01:40:02] 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
[2020-11-06 01:50: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
[2020-11-06 02:00:02] 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
[2020-11-06 02:10: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
[2020-11-06 02:20:02] 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
[2020-11-06 02:30:02] 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
[2020-11-06 02:40:02] 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
[2020-11-06 02:40:02] 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
[2020-11-06 02:50: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
[2020-11-06 03:00:02] 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
[2020-11-06 03:00:02] 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
[2020-11-06 03:10: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
[2020-11-06 03:20:02] 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
[2020-11-06 03:30: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
[2020-11-06 03:40:02] 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
[2020-11-06 03:40:02] 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
[2020-11-06 03:50: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
[2020-11-06 04:00: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
[2020-11-06 04:10: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
[2020-11-06 04: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
[2020-11-06 04:30:02] 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
[2020-11-06 04:30:02] 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
[2020-11-06 04:40:02] 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
[2020-11-06 04:50:02] 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
[2020-11-06 05:00: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
[2020-11-06 05:10:02] 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
[2020-11-06 05:10:02] 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.

2

Error log continued:

2020-11-06 05:20:02] 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
[2020-11-06 05:20:02] 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
[2020-11-06 05:30:02] 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
[2020-11-06 05:40:02] 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
[2020-11-06 05:50: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
[2020-11-06 06:00:02] 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
[2020-11-06 06:10:02] 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
[2020-11-06 06:20:02] 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
[2020-11-06 06:30:02] 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
[2020-11-06 06:40:02] 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
[2020-11-06 06:50: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
[2020-11-06 07:00: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
[2020-11-06 07:10: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
[2020-11-06 07:20:02] 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
[2020-11-06 07:30:02] 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
[2020-11-06 07:40:02] 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
[2020-11-06 07:50:02] 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
[2020-11-06 07:50:02] 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
[2020-11-06 08:00: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
[2020-11-06 08:10: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
[2020-11-06 08:10: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
[2020-11-06 08:20:02] 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
[2020-11-06 08:30:02] 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
[2020-11-06 08:40:02] 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
[2020-11-06 08:50:02] 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

3

Error log cont:

[2020-11-11 20:39:21] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’: Malformed communication packet” at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’:\n\nMalformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Malformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:172)"}
[2020-11-11 20:39:32] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’: Malformed communication packet” at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’:\n\nMalformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Malformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:172)"}
[2020-11-11 20:40:02] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.publish_up AS publish_up_13, m0_.publish_down AS publish_down_14, m0_.canvas_settings AS canvas_settings_15, m0_.allow_restart AS allow_restart_16, m1_.is_published AS is_published_17, m1_.date_added AS date_added_18, m1_.created_by AS created_by_19, m1_.created_by_user AS created_by_user_20, m1_.date_modified AS date_modified_21, m1_.modified_by AS modified_by_22, m1_.modified_by_user AS modified_by_user_23, m1_.checked_out AS checked_out_24, m1_.checked_out_by AS checked_out_by_25, m1_.checked_out_by_user AS checked_out_by_user_26, m1_.id AS id_27, m1_.title AS title_28, m1_.description AS description_29, m1_.alias AS alias_30, m1_.color AS color_31, m1_.bundle AS bundle_32, m0_.category_id AS category_id_33 FROM mauaf_campaigns m0_ LEFT JOIN mauaf_categories m1_ ON m0_.category_id = m1_.id’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:campaigns:trigger
[2020-11-11 20:40:02] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.filters AS filters_14, m0_.is_global AS is_global_15, m0_.is_preference_center AS is_preference_center_16 FROM mauaf_lead_lists m0_ ORDER BY m0_.name ASC’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:segments:update
[2020-11-11 20:40:02] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.publish_up AS publish_up_13, m0_.publish_down AS publish_down_14, m0_.canvas_settings AS canvas_settings_15, m0_.allow_restart AS allow_restart_16, m1_.is_published AS is_published_17, m1_.date_added AS date_added_18, m1_.created_by AS created_by_19, m1_.created_by_user AS created_by_user_20, m1_.date_modified AS date_modified_21, m1_.modified_by AS modified_by_22, m1_.modified_by_user AS modified_by_user_23, m1_.checked_out AS checked_out_24, m1_.checked_out_by AS checked_out_by_25, m1_.checked_out_by_user AS checked_out_by_user_26, m1_.id AS id_27, m1_.title AS title_28, m1_.description AS description_29, m1_.alias AS alias_30, m1_.color AS color_31, m1_.bundle AS bundle_32, m0_.category_id AS category_id_33 FROM mauaf_campaigns m0_ LEFT JOIN mauaf_categories m1_ ON m0_.category_id = m1_.id’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:campaigns:rebuild
[2020-11-11 20:45:02] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.filters AS filters_14, m0_.is_global AS is_global_15, m0_.is_preference_center AS is_preference_center_16 FROM mauaf_lead_lists m0_ ORDER BY m0_.name ASC’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:segments:update
[2020-11-11 20:50:01] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.publish_up AS publish_up_13, m0_.publish_down AS publish_down_14, m0_.canvas_settings AS canvas_settings_15, m0_.allow_restart AS allow_restart_16, m1_.is_published AS is_published_17, m1_.date_added AS date_added_18, m1_.created_by AS created_by_19, m1_.created_by_user AS created_by_user_20, m1_.date_modified AS date_modified_21, m1_.modified_by AS modified_by_22, m1_.modified_by_user AS modified_by_user_23, m1_.checked_out AS checked_out_24, m1_.checked_out_by AS checked_out_by_25, m1_.checked_out_by_user AS checked_out_by_user_26, m1_.id AS id_27, m1_.title AS title_28, m1_.description AS description_29, m1_.alias AS alias_30, m1_.color AS color_31, m1_.bundle AS bundle_32, m0_.category_id AS category_id_33 FROM mauaf_campaigns m0_ LEFT JOIN mauaf_categories m1_ ON m0_.category_id = m1_.id’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:campaigns:trigger
[2020-11-11 20:50:01] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.publish_up AS publish_up_13, m0_.publish_down AS publish_down_14, m0_.canvas_settings AS canvas_settings_15, m0_.allow_restart AS allow_restart_16, m1_.is_published AS is_published_17, m1_.date_added AS date_added_18, m1_.created_by AS created_by_19, m1_.created_by_user AS created_by_user_20, m1_.date_modified AS date_modified_21, m1_.modified_by AS modified_by_22, m1_.modified_by_user AS modified_by_user_23, m1_.checked_out AS checked_out_24, m1_.checked_out_by AS checked_out_by_25, m1_.checked_out_by_user AS checked_out_by_user_26, m1_.id AS id_27, m1_.title AS title_28, m1_.description AS description_29, m1_.alias AS alias_30, m1_.color AS color_31, m1_.bundle AS bundle_32, m0_.category_id AS category_id_33 FROM mauaf_campaigns m0_ LEFT JOIN mauaf_categories m1_ ON m0_.category_id = m1_.id’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:campaigns:rebuild
[2020-11-11 20:50:01] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.filters AS filters_14, m0_.is_global AS is_global_15, m0_.is_preference_center AS is_preference_center_16 FROM mauaf_lead_lists m0_ ORDER BY m0_.name ASC’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:segments:update
[2020-11-11 20:50:33] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’: Malformed communication packet” at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’:\n\nMalformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Malformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:172)"}
[2020-11-11 20:51:55] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’: Malformed communication packet” at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’:\n\nMalformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Malformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:172)"}
[2020-11-11 20:52:04] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’: Malformed communication packet” at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’:\n\nMalformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Malformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:172)"}
[2020-11-11 20:53:27] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’: Malformed communication packet” at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’:\n\nMalformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Malformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:172)"}
[2020-11-11 20:55:01] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.filters AS filters_14, m0_.is_global AS is_global_15, m0_.is_preference_center AS is_preference_center_16 FROM mauaf_lead_lists m0_ ORDER BY m0_.name ASC’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:segments:update
[2020-11-11 20:57:20] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’: Malformed communication packet” at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’:\n\nMalformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Malformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:172)"}
[2020-11-11 21:00:01] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.publish_up AS publish_up_13, m0_.publish_down AS publish_down_14, m0_.canvas_settings AS canvas_settings_15, m0_.allow_restart AS allow_restart_16, m1_.is_published AS is_published_17, m1_.date_added AS date_added_18, m1_.created_by AS created_by_19, m1_.created_by_user AS created_by_user_20, m1_.date_modified AS date_modified_21, m1_.modified_by AS modified_by_22, m1_.modified_by_user AS modified_by_user_23, m1_.checked_out AS checked_out_24, m1_.checked_out_by AS checked_out_by_25, m1_.checked_out_by_user AS checked_out_by_user_26, m1_.id AS id_27, m1_.title AS title_28, m1_.description AS description_29, m1_.alias AS alias_30, m1_.color AS color_31, m1_.bundle AS bundle_32, m0_.category_id AS category_id_33 FROM mauaf_campaigns m0_ LEFT JOIN mauaf_categories m1_ ON m0_.category_id = m1_.id’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:campaigns:rebuild
[2020-11-11 21:00:01] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.filters AS filters_14, m0_.is_global AS is_global_15, m0_.is_preference_center AS is_preference_center_16 FROM mauaf_lead_lists m0_ ORDER BY m0_.name ASC’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:segments:update
[2020-11-11 21:00:01] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.publish_up AS publish_up_13, m0_.publish_down AS publish_down_14, m0_.canvas_settings AS canvas_settings_15, m0_.allow_restart AS allow_restart_16, m1_.is_published AS is_published_17, m1_.date_added AS date_added_18, m1_.created_by AS created_by_19, m1_.created_by_user AS created_by_user_20, m1_.date_modified AS date_modified_21, m1_.modified_by AS modified_by_22, m1_.modified_by_user AS modified_by_user_23, m1_.checked_out AS checked_out_24, m1_.checked_out_by AS checked_out_by_25, m1_.checked_out_by_user AS checked_out_by_user_26, m1_.id AS id_27, m1_.title AS title_28, m1_.description AS description_29, m1_.alias AS alias_30, m1_.color AS color_31, m1_.bundle AS bundle_32, m0_.category_id AS category_id_33 FROM mauaf_campaigns m0_ LEFT JOIN mauaf_categories m1_ ON m0_.category_id = m1_.id’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:campaigns:trigger
[2020-11-11 21:02:10] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’: Malformed communication packet” at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’:\n\nMalformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Malformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:172)"}
[2020-11-11 21:02:12] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’: Malformed communication packet” at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’:\n\nMalformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Malformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:172)"}
[2020-11-11 21:05:01] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.alias AS alias_13, m0_.filters AS filters_14, m0_.is_global AS is_global_15, m0_.is_preference_center AS is_preference_center_16 FROM mauaf_lead_lists m0_ ORDER BY m0_.name ASC’: Malformed communication packet (uncaught exception) at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command mautic:segments:update
[2020-11-11 21:07:19] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’: Malformed communication packet” at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_published AS is_published_2, m0_.supported_features AS supported_features_3, m0_.api_keys AS api_keys_4, m0_.feature_settings AS feature_settings_5, m0_.plugin_id AS plugin_id_6 FROM mauaf_plugin_integration_settings m0_ INNER JOIN mauaf_plugins m1_ ON m0_.plugin_id = m1_.id’:\n\nMalformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Malformed communication packet at /home/thetrave1/domains/mail.thetravellinghousesitters.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:172)"}

4

Have you tried updating recently before getting this error? It appears that something has changed in your database.

Could be a migration that has not completed.

What is the version of your Mysql?

5

Thanks for your reply, no update that I am aware of, had tried that in the past and had some trouble so steer clear of that now!

Mysql version is 10.4

6

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,

This is what leads me to believe something has changed with Mysql.

From what I can see in the errors it appears you either need to upgrade PHP to 7.3 or downgrade Mysql/Mariadb to 10.3

7

Thank you for this,

Interestingly enough I have another site that runs on the same host and the exact same Mautic set up which is fine… is there a way that I could upload some of the Mautic files from the working installation from site 1 to site 2 where I am getting this 500 error? (hopefully that makes sense)

8

I’m not sure what your setup is. Are you running this on Shared hosting or a VPS?

You could certainly replace everything except your local.php and database on the non-working install. But you’d need to clear cache after doing this as you’ll have the other site’s cache copied :wink:

Not sure that this will solve your issue though. Because the errors point to the PHP version and Mysql version combination selected. If you’re on shared hosting testing what I’m saying may be as easy as selecting another PHP version for this subdomain/domain.

1 Like
9

Thank you for you help codes9, upgrading the php version to 7.3 fixed this issue

10

I’m happy your Installation is working again. Enjoy Mautic :grinning:

TL;DR:
For anyone else coming across this post in the future:
Mariadb 10.4 needs PHP 7.3 in a Mautic install or Symfony will throw errors.

11

Dear All,

After many trials and errors as well as going through this forum I would like to share my experience and some advice related to errors such as "You have an error in your SQL syntax", "An exception occurred while executing ‘REPLACE INTO’ or similar. These have occurred for me both in SEGMENTS and CAMPAIGNS.

The general methodology to address such issues:

  • set up cron jobs for mautic:segments:update and mautic:campaigns:update to high frequency (eg. every 3 -5 minutes), remember that both jobs should rather not run at once:
    e.g.
    mautic:segments:update 0,5,10,15,20,25,30,35,40,45,50,55
    mautic:campaigns:update 1,6,11,16,21,26,31,36,41,46,51,56

  • open and monitor mautic logfile - you can go to SystemInfo/Log in the Mautic Settings panel or open open logfile in a separate window, which I found more convenient (logfile location is shown in Settings / Connfiguration / System Settings and is probably sth like … mautic/app/…/var/logs)

  • turn off all segments / campaigns

  • turn on segments / campaigns one by one while monitoring error log file

This will allow you to spot those Segments or Campaigns that cause errors to appear in the log file.

Some conclusions:

  • in several cases changing driver ‘db_driver’ => ‘mysqli’ or ‘db_driver’ => ‘pdo_mysql’ in app/config/local.php helped and errors stopped to appear however in several cases it didn’t help

  • some of the STAGES and CAMPAIGNS issue errors when names include special characters
    such as
    !CAMPAIGN NAME
    #CAMPAIGN NAME

and others. Clearly in some cases these are not properly escaped and result in errors. My advice - use only standard characters.

  • do not use any special characters in TAGS

These has caused me so much trouble to figure out. Many errors of this type:

mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘REPLACE INTO mauuv_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from mauuv_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 mauuv_campaign_lead_event_log ’ at line 2 [] []

where caused in my case by non-standard characters (e.g. #) used in TAGS. Removing them fixed the issue immediately.

  • sometimes campaigns throw errors, when TAGS are used in the Condition or Action, after you have changed the TAG name in the “Tags”

error message may look like this:
mautic.CRITICAL: Uncaught PHP Exception Symfony\Component\Form\Exception\TransformationFailedException: "Unable to transform data for property path "

and was quite common in my case. Removing the condition or action that used that faulty Tag, creating it again and saving the campaign solved the issue for me.

  • in some cases I have spotted single Segment or Campaign that generated errors such as:
    "An exception occurred while executing 'REPLACE INTO… "

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use

but even after making proper adjustments to names, tags etc. the error would still occur

The solution for me was to CLONE the faulty Segment/Campaign and removing the old one. This single step solved the issue without any internal changes to the Segment/Campaign.

And one more remark - after fixing all the issues, I have reverted back to the driver setting (‘db_driver’ => ‘mysqli’ ) and no more errors occur, which means that in my case the driver setting was not the root cause of the problem.

All in all, there are many bigger or smaller issues with Mautic and you need to monitor logfile on regular basis to make sure all is ok. Do not use special characters in names. Sometimes cloning Segment or Campaign solves the issue.

1 Like
12

After some more tests, not only “#” and “!” but also “>” character may start throwing exceptions:

>CAMPAIGN NAME
>SEGMENT NAME
>TAG NAME

“@” seems to be OK

13

In some cases removing contacts (leads) from campaigns does not work. I have not determined one particular scenario, however from time to time after contacts were added to campaign an error occurs: CAMPAIGN: An exception occurred while executing ‘REPLACE INTO mauaf_campaign_lead_event_failed_log

In my case this is permanent, and errors are generated each time “capmaign update” is run.
Typically in such a case contacts cannot be removed from campaign anymore nor manually (Contacts/Contact Details/(down arrow in upper right corner)/Campaigns), nor by running another campaign.

Solutions:
A. cloning the campaign and removing the original one (or)
B. Removing contacts from campaign directly in the database

Relation between campaigns and contacts(leads) is kept in mauuv_campaign_leads. You can safely remove all the records there (remembering that this will remove all the contacts from all the campaigns). The contacts themselves remain intact. You can also cherry pick the contacts that cause errors.

From what I have noticed:

  • solves the error problem immediately
  • there are no side effects