[2026-10-22T09:55:13.780322+00:00] messenger.CRITICAL: Error thrown while handling message Symfony\Component\Mailer\Messenger\SendEmailMessage. Removing from transport after 0 retries. Error: "Handling "Symfony\Component\Mailer\Messenger\SendEmailMessage" failed: All recipients failed mails.so validation — message will not be retried." {"class":"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage","retryCount":0,"error":"Handling \"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\" failed: All recipients failed mails.so validation — message will not be retried.","exception":"[object] (Symfony\\Component\\Messenger\\Exception\\HandlerFailedException(code: 0): Handling \"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\" failed: All recipients failed mails.so validation — message will not be retried. at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:130)\n[previous exception] [object] (Symfony\\Component\\Messenger\\Exception\\UnrecoverableMessageHandlingException(code: 0): All recipients failed mails.so validation — message will not be retried. at /home/whizzmailer/public_html/swiss-belhotel-v2/docroot/app/bundles/EmailBundle/EventListener/MailSoTransportValidationSubscriber.php:103)"} {"hostname":"66-23-236-99.cprapid.com","pid":1200777}
[2026-10-22T11:02:30.824733+00:00] console.CRITICAL: Error thrown while running command "doctrine:query:sql 'SELECT DATE(s.date_sent) d, COUNT(*) sent, SUM(b.email IS NOT NULL) bounced FROM email_stats s LEFT JOIN email_bounce_tracking b ON b.email = s.email_address AND b.updated_at >= s.date_sent AND b.updated_at < DATE_ADD(s.date_sent, INTERVAL 7 DAY) WHERE s.date_sent >= "2026-09-21" AND s.date_sent < "2026-09-24" GROUP BY DATE(s.date_sent) WITH ROLLUP'". Message: "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1267): An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1267): SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)","command":"doctrine:query:sql 'SELECT DATE(s.date_sent) d, COUNT(*) sent, SUM(b.email IS NOT NULL) bounced FROM email_stats s LEFT JOIN email_bounce_tracking b ON b.email = s.email_address AND b.updated_at >= s.date_sent AND b.updated_at < DATE_ADD(s.date_sent, INTERVAL 7 DAY) WHERE s.date_sent >= \"2026-09-21\" AND s.date_sent < \"2026-09-24\" GROUP BY DATE(s.date_sent) WITH ROLLUP'","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='"} {"hostname":"66-23-236-99.cprapid.com","pid":1228435}
[2026-10-22T11:10:09.895779+00:00] console.CRITICAL: Error thrown while running command "doctrine:query:sql 'SELECT s.email_id, e.name, COUNT(*) sent, SUM(s.is_read=1) reads FROM email_stats s LEFT JOIN emails e ON e.id=s.email_id WHERE s.date_sent >= "2026-09-21" AND s.date_sent < "2026-09-24" GROUP BY s.email_id, e.name ORDER BY sent DESC'". Message: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'reads FROM email_stats s LEFT JOIN emails e ON e.id=s.email_id WHERE s.date_s...' at line 1" {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 1064): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'reads FROM email_stats s LEFT JOIN emails e ON e.id=s.email_id WHERE s.date_s...' at line 1 at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:86)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1064): SQLSTATE[42000]: Syntax error or access violation: 1064 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 'reads FROM email_stats s LEFT JOIN emails e ON e.id=s.email_id WHERE s.date_s...' at line 1 at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 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 'reads FROM email_stats s LEFT JOIN emails e ON e.id=s.email_id WHERE s.date_s...' at line 1 at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)","command":"doctrine:query:sql 'SELECT s.email_id, e.name, COUNT(*) sent, SUM(s.is_read=1) reads FROM email_stats s LEFT JOIN emails e ON e.id=s.email_id WHERE s.date_sent >= \"2026-09-21\" AND s.date_sent < \"2026-09-24\" GROUP BY s.email_id, e.name ORDER BY sent DESC'","message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'reads FROM email_stats s LEFT JOIN emails e ON e.id=s.email_id WHERE s.date_s...' at line 1"} {"hostname":"66-23-236-99.cprapid.com","pid":1231675}
[2026-10-22T11:23:57.174440+00:00] console.CRITICAL: Error thrown while running command "doctrine:query:sql 'SELECT COLUMN_NAME, DATA_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME LIKE :t ORDER BY ORDINAL_POSITION' -- --env=prod". Message: "Too many arguments to "doctrine:query:sql" command, expected arguments "sql"." {"exception":"[object] (Symfony\\Component\\Console\\Exception\\RuntimeException(code: 0): Too many arguments to \"doctrine:query:sql\" command, expected arguments \"sql\". at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/symfony/console/Input/ArgvInput.php:193)","command":"doctrine:query:sql 'SELECT COLUMN_NAME, DATA_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME LIKE :t ORDER BY ORDINAL_POSITION' -- --env=prod","message":"Too many arguments to \"doctrine:query:sql\" command, expected arguments \"sql\"."} {"hostname":"66-23-236-99.cprapid.com","pid":1237379}
[2026-10-22T11:24:54.758176+00:00] console.CRITICAL: Error thrown while running command "doctrine:query:sql 'SELECT COUNT(*) bounced_sends, SUM(b.bounce_type="hard") hard, SUM(b.bounce_type="soft") soft, SUM(b.is_suppressed=1) suppressed_now, SUM(b.is_dnc=1) dnc_now FROM email_stats s JOIN email_bounce_tracking b ON b.email = s.email_address WHERE s.date_sent >= "2026-09-21 00:00:00" AND s.date_sent < "2026-09-24 00:00:00" AND b.last_bounce_at >= "2026-09-21 00:00:00" AND b.last_bounce_at < "2026-09-27 00:00:00"' --env=prod". Message: "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1267): An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1267): SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)","command":"doctrine:query:sql 'SELECT COUNT(*) bounced_sends, SUM(b.bounce_type=\"hard\") hard, SUM(b.bounce_type=\"soft\") soft, SUM(b.is_suppressed=1) suppressed_now, SUM(b.is_dnc=1) dnc_now FROM email_stats s JOIN email_bounce_tracking b ON b.email = s.email_address WHERE s.date_sent >= \"2026-09-21 00:00:00\" AND s.date_sent < \"2026-09-24 00:00:00\" AND b.last_bounce_at >= \"2026-09-21 00:00:00\" AND b.last_bounce_at < \"2026-09-27 00:00:00\"' --env=prod","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='"} {"hostname":"66-23-236-99.cprapid.com","pid":1237940}
[2026-10-22T13:34:09.298733+00:00] console.CRITICAL: Error thrown while running command "doctrine:query:sql 'SELECT channel, channel_id, status, COUNT(*) n, MIN(date_added) first, MAX(scheduled_date) sched FROM message_queue WHERE channel='\''email'\'' GROUP BY channel, channel_id, status ORDER BY n DESC LIMIT 15'". Message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'date_added' in 'SELECT'" {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'date_added' in 'SELECT' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'date_added' in 'SELECT' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'date_added' in 'SELECT' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)","command":"doctrine:query:sql 'SELECT channel, channel_id, status, COUNT(*) n, MIN(date_added) first, MAX(scheduled_date) sched FROM message_queue WHERE channel='\\''email'\\'' GROUP BY channel, channel_id, status ORDER BY n DESC LIMIT 15'","message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'date_added' in 'SELECT'"} {"hostname":"66-23-236-99.cprapid.com","pid":1290251}
[2026-10-22T13:35:29.111452+00:00] console.CRITICAL: Error thrown while running command "doctrine:query:sql 'SELECT e.id, e.category_id, c.title cat, (SELECT GROUP_CONCAT(x.leadlist_id) FROM email_list_excluded_xref x WHERE x.email_id=e.id) excl FROM emails e LEFT JOIN categories c ON c.id=e.category_id WHERE e.id IN (897,906,902,886,878)'". Message: "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'whizzmailer_swissbelhotelv2.email_list_excluded_xref' doesn't exist" {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 1146): An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'whizzmailer_swissbelhotelv2.email_list_excluded_xref' doesn't exist at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1146): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'whizzmailer_swissbelhotelv2.email_list_excluded_xref' doesn't exist at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'whizzmailer_swissbelhotelv2.email_list_excluded_xref' doesn't exist at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)","command":"doctrine:query:sql 'SELECT e.id, e.category_id, c.title cat, (SELECT GROUP_CONCAT(x.leadlist_id) FROM email_list_excluded_xref x WHERE x.email_id=e.id) excl FROM emails e LEFT JOIN categories c ON c.id=e.category_id WHERE e.id IN (897,906,902,886,878)'","message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'whizzmailer_swissbelhotelv2.email_list_excluded_xref' doesn't exist"} {"hostname":"66-23-236-99.cprapid.com","pid":1291186}
[2026-10-22T13:37:38.175508+00:00] console.CRITICAL: Error thrown while running command "doctrine:query:sql 'SELECT id,name,variant_parent_id,translation_parent_id,language,is_published,publish_up,publish_down FROM emails WHERE id=897 OR variant_parent_id=897 OR translation_parent_id=897'". Message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'SELECT'" {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'SELECT' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'SELECT' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'SELECT' at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)","command":"doctrine:query:sql 'SELECT id,name,variant_parent_id,translation_parent_id,language,is_published,publish_up,publish_down FROM emails WHERE id=897 OR variant_parent_id=897 OR translation_parent_id=897'","message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'SELECT'"} {"hostname":"66-23-236-99.cprapid.com","pid":1292445}
[2026-10-22T18:07:30.682014+00:00] console.CRITICAL: Error thrown while running command "list mailer". Message: "There are no commands defined in the "mailer" namespace." {"exception":"[object] (Symfony\\Component\\Console\\Exception\\NamespaceNotFoundException(code: 0): There are no commands defined in the \"mailer\" namespace. at /home/whizzmailer/public_html/swiss-belhotel-v2/vendor/symfony/console/Application.php:650)","command":"list mailer","message":"There are no commands defined in the \"mailer\" namespace."} {"hostname":"66-23-236-99.cprapid.com","pid":1401594}