Your software
My Mautic version is: 4.4.4
My PHP version is: 8.0.28
My Database type and version is:5.7.41-cll-lve
installed on a plesk hosting with scheduled tasks
Your problem
When I save and close an emaul with utm tag, internal link: LP asset often mautic goes wrong " Uh oh! I think I broke it. If I do it again, please report me to the system administrator!
500 Internal Server Error" .
Email is corrupted and not sent in campaigns (send example works)
These errors are showing in the log:
[2023-03-02 19:16:20] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘UPDATE emails SET custom_html = ? WHERE id = ?’ with params [”<!doctype html><!doctype html><!doctype html>\r\n<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office">\r\n\r\n\r\n {subject} </title>\r\n <!–[if !mso]>\r\n <meta http-equiv="X-UA-Compatible" content="IE=edge">\r\n \r\n <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">\r\n <meta name="viewport" content="width=device-width, initial-scale=1">\r\n <style type="text/css">\r\n #outlook a {\r\n padding: 0;\r\n }\r\n\r\n body {\r\n margin: 0;\r\n padding: 0;\r\n -webkit-text-size-adjust: 100%;\r\n -ms-text-size-adjust: 100%;\r\n }\r\n\r\n table,\r\n td {\r\n border-collapse: collapse;\r\n mso-table-lspace: 0pt;\r\n mso-table-rspace: 0pt;\r\n }\r\n\r\n img {\r\n border: 0;\r\n height: auto;\r\n line-height: 100%;\r\n outline: none;\r\n text-decoration: none;\r\n -ms-interpolation-mode: bicubic;\r\n }\r\n\r\n p {\r\n display: block;\r\n margin: 13px 0;\r\n }\r\n </style>\r\n \r\n \r\n <!–[if !mso]>\r\n <link href="https://fonts.googleapis.com/css?family=Ubuntu:300,400,500,700" rel="stylesheet" type="text/css">\r\n <style type="text/css">\r\n
SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x85\xB1/g…’ for column ‘custom_html’ at row 1 at /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x85\xB1/g…’ for column ‘custom_html’ at row 1 at /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x85\xB1/g…’ for column ‘custom_html’ at row 1 at /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)
[stacktrace]
#0 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
#2 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1538): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(523): Doctrine\DBAL\Connection->executeStatement()
#5 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(409): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable()
#6 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1223): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update()
#7 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(437): Doctrine\ORM\UnitOfWork->executeUpdates()
#8 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(403): Doctrine\ORM\UnitOfWork->commit()
#9 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/CoreBundle/Entity/CommonRepository.php(781): Doctrine\ORM\EntityManager->flush()
#10 /var/www/vhosts/mautic.2dc.it/mautic/docroot/plugins/GrapesJsBuilderBundle/Model/GrapesJsBuilderModel.php(72): Mautic\CoreBundle\Entity\CommonRepository->saveEntity()
#11 /var/www/vhosts/mautic.2dc.it/mautic/docroot/plugins/GrapesJsBuilderBundle/EventSubscriber/EmailSubscriber.php(54): MauticPlugin\GrapesJsBuilderBundle\Model\GrapesJsBuilderModel->addOrEditEntity()
#12 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/event-dispatcher/EventDispatcher.php(304): MauticPlugin\GrapesJsBuilderBundle\EventSubscriber\EmailSubscriber->onEmailPostSave()
#13 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/event-dispatcher/EventDispatcher.php(264): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}()
#14 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/event-dispatcher/EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()
#15 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/event-dispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
#16 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/EmailBundle/Model/EmailModel.php(465): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
#17 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/CoreBundle/Model/FormModel.php(103): Mautic\EmailBundle\Model\EmailModel->dispatchEvent()
#18 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/EmailBundle/Model/EmailModel.php(282): Mautic\CoreBundle\Model\FormModel->saveEntity()
#19 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/EmailBundle/Controller/EmailController.php(683): Mautic\EmailBundle\Model\EmailModel->saveEntity()
#20 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/CoreBundle/Controller/CommonController.php(447): Mautic\EmailBundle\Controller\EmailController->editAction()
#21 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/http-kernel/HttpKernel.php(169): Mautic\CoreBundle\Controller\CommonController->executeAction()
#22 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/http-kernel/HttpKernel.php(81): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#23 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/http-kernel/Kernel.php(201): Symfony\Component\HttpKernel\HttpKernel->handle()
#24 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/AppKernel.php(115): Symfony\Component\HttpKernel\Kernel->handle()
#25 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/middlewares/CORSMiddleware.php(82): AppKernel->handle()
#26 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/middlewares/CatchExceptionMiddleware.php(34): Mautic\Middleware\CORSMiddleware->handle()
#27 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/middlewares/VersionCheckMiddleware.php(58): Mautic\Middleware\CatchExceptionMiddleware->handle()
#28 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/middlewares/TrustMiddleware.php(42): Mautic\Middleware\VersionCheckMiddleware->handle()
#29 /var/www/vhosts/mautic.2dc.it/mautic/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Mautic\Middleware\TrustMiddleware->handle()
#30 /var/www/vhosts/mautic.2dc.it/mautic/vendor/stack/run/src/Stack/run.php(13): Stack\StackedHttpKernel->handle()
#31 /var/www/vhosts/mautic.2dc.it/mautic/docroot/index.php(24): Stack
un()
#32 {main}
"} {“hostname”:“cloudlinux3.dnscore1.com”,“pid”:3207115}
[2023-03-02 18:18:00] mautic.DEBUG: CONTACT: 106454 set as current lead. {“hostname”:“cloudlinux3.dnscore1.com”,“pid”:3207595}
[2023-03-02 18:18:00] mautic.DEBUG: CAMPAIGN: Campaign triggered for event type email.open(email / 108) {“hostname”:“cloudlinux3.dnscore1.com”,“pid”:3207595}
[2023-03-02 18:18:00] mautic.DEBUG: CONTACT: Tracking session for contact ID# 106454 through GET /email/63ee51efc9c9e735552234.gif {“hostname”:“cloudlinux3.dnscore1.com”,“pid”:3207595}
[2023-03-02 18:18:00] mautic.DEBUG: CAMPAIGN: Current contact ID# 106454 {“hostname”:“cloudlinux3.dnscore1.com”,“pid”:3207595}
[2023-03-02 18:18:00] mautic.DEBUG: CAMPAIGN: Contact does not have any applicable email.open associations. {“hostname”:“cloudlinux3.dnscore1.com”,“pid”:3207595}
[2023-03-02 18:18:00] mautic.DEBUG: CONTACT: Tracking session for contact ID# 106454 through GET /email/63ee51efc9c9e735552234.gif {“hostname”:“cloudlinux3.dnscore1.com”,“pid”:3207595}
[2023-03-02 19:20:42] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘UPDATE emails SET custom_html = ? WHERE id = ?’ with params [”<!doctype html><!doctype html><!doctype html><!doctype html>\r\n<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office">\r\n\r\n\r\n {subject} </title>\r\n <!–[if !mso]>\r\n <meta http-equiv="X-UA-Compatible" content="IE=edge">\r\n \r\n <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">\r\n <meta name="viewport" content="width=device-width, initial-scale=1">\r\n <style type="text/css">\r\n #outlook a {\r\n padding: 0;\r\n }\r\n\r\n body {\r\n margin: 0;\r\n padding: 0;\r\n -webkit-text-size-adjust: 100%;\r\n -ms-text-size-adjust: 100%;\r\n }\r\n\r\n table,\r\n td {\r\n border-collapse: collapse;\r\n mso-table-lspace: 0pt;\r\n mso-table-rspace: 0pt;\r\n }\r\n\r\n img {\r\n border: 0;\r\n height: auto;\r\n line-height: 100%;\r\n outline: none;\r\n text-decoration: none;\r\n -ms-interpolation-mode: bicubic;\r\n }\r\n\r\n p {\r\n display: block;\r\n margin: 13px 0;\r\n }\r\n </style>\r\n \r\n \r\n <!–[if !mso]>\r\n <link href="https://fonts.googleapis.com/css?family=Ubuntu:300,400,500,700" rel="stylesheet" type="text/css">\r\n <style type="text/css">\r\n @import url(https://fonts.googleapis.com/css?family=Ubuntu:300,400,500,700);\r\n </style>\r\n \r\n <style type="text/css">\r\n @media only screen and (min-width:480px) {\r\n .mj-column-per-60 {\r\n width: 60% !important;\r\n max-width: 60%;\r\n }\r\n\r\n .mj-column-per-100 {\r\n width: 100% !important;\r\n max-width: 100%;\r\n }\r\n\r\n .mj-column-per-70 {\r\n width: 70% !important;\r\n max-width: 70%;\r\n }\r\n\r\n .mj-column-per-50 {\r\n width: 50% !important;\r\n max-width: 50%;\r\n }\r\n\r\n .mj-column-per-30 {\r\n width: 30% !important;\r\n max-width: 30%;\r\n }\r\n }\r\n </style>\r\n <style media="screen and (min-width:480px)">\r\n .moz-text-html .mj-column-per-60 {\r\n width: 60% !important;\r\n max-width: 60%;\r\n }\r\n\r\n .moz-text-html .mj-column-per-100 {\r\n width: 100% !important;\r\n max-width: 100%;\r\n }\r\n\r\n .moz-text-html .mj-column-per-70 {\r\n width: 70% !important;\r\n max-width: 70%;\r\n }\r\n\r\n .moz-text-html .mj-column-per-50 {\r\n width: 50% !important;\r\n max-width: 50%;\r\n }\r\n\r\n .moz-text-html .mj-column-per-30 {\r\n width: 30% !important;\r\n max-width: 30%;\r\n }\r\n </style>\r\n <style type="text/css">\r\n @media only screen and (max-width:480px) {\r\n table.mj-full-width-mobile {\r\n width: 100% !important;\r\n }\r\n\r\n td.mj-full-width-mobile {\r\n width: auto !important;\r\n }\r\n }\r\n </style>\r\n <style type="text/css">\r\n </style>\r\n \r\n</head>\r\n\r\n<body style="word-spacing:normal;background-color:#d6dde5;">\r\n <div style="display:none;font-size:1px;color:#ffffff;line-height:1px;max-height:0px;max-width:0px;opacity:0;overflow:hidden;"> Consigli per il tuo sistema IT </div>\r\n <div style="background-color:#d6dde5;">\r\n \r\n \r\n <div style="background:#ffffff;background-color:#ffffff;margin:0px auto;max-width:600px;">\r\n <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:#ffffff;background-color:#ffffff;width:100%;">\r\n \r\n \r\n <td style="direction:ltr;font-size:0px;padding:20px 0;padding-bottom:0;text-align:center;">\r\n \r\n <div class="mj-column-per-60 mj-outlook-group-fix column" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;">\r\n <table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top;" width="100%">\r\n \r\n \r\n <td align="center" style="font-size:0px;padding:10px 25px;word-break:break-word;">\r\n <table border="0" cellpadding="0" cellspacing="0" role="presentation" style="border-collapse:collapse;border-spacing:0px;">\r\n \r\n \r\n <td style="width:310px;">\r\n <img height="auto" src="https://mautic.2dc.it//media/images/logo_bianco_2dc.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px;" width="310">\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </div>\r\n \r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </div>\r\n \r\n \r\n \r\n \r\n \r\n <div style="background:#ffffff;background-color:#ffffff;margin:0px auto;max-width:600px;">\r\n <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:#ffffff;background-color:#ffffff;width:100%;">\r\n \r\n \r\n <td style="direction:ltr;font-size:0px;padding:20px 0;padding-bottom:0;padding-top:5px;text-align:center;">\r\n \r\n <div class="mj-column-per-100 mj-outlook-group-fix" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;">\r\n <table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top;" width="100%">\r\n \r\n \r\n <td align="justify" style="font-size:0px;padding:10px 25px;word-break:break-word;">\r\n <div style="font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:14px;font-weight:300;line-height:1.5;text-align:justify;color:#000000;">\r\n <p style="margin: 0; padding: 0;">Trasforma la tua azienda con un partner di fiducia. Affidati a noi per coordinare il tuo sistema informatico e raggiungere un’efficienza senza pari, migliorando la gestione delle attivit\u00e0 e sfruttando tutti i vantaggi che la tecnologia pu\u00f2 offrire.</p>\r\n </div>\r\n </td>\r\n </tr>\r\n \r\n <td align="center" style="font-size:0px;padding:10px 25px;word-break:break-word;">\r\n <table border="0" cellpadding="0" cellspacing="0" role="presentation" style="border-collapse:collapse;border-spacing:0px;">\r\n \r\n \r\n <td style="width:550px;">\r\n <a href="https://mautic.2dc.it/asset/30:consigli-per-lavorare-meglio?utm_source={utm_source}&utm_medium={utm_medium}l&utm_campaign={utm_campaign}&utm_content={utm_content}" target="_blank" rel="https://mautic.2dc.it/asset/30:consigli-per-lavorare-meglio?utm_source={utm_source}&utm_medium={utm_medium}l&utm_campaign={utm_campaign}&utm_content={utm_content}" title="video">\r\n <img alt="video" height="auto" src="https://mautic.2dc.it//media/images/yt_consigli_per_lavorare_meglio.jpg" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px;" title="video" width="550">\r\n </a>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n \r\n <td align="justify" style="font-size:0px;padding:10px 25px;word-break:break-word;">\r\n <div style="font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:14px;line-height:1;text-align:justify;color:#000000;">\r\n <p style="margin: 0; padding: 0;">Buongiorno,
\r\n <span style="color:black">difficile riuscire a trovare oggi un ambito professionale nel quale il PC e l’informatica non la facciano da padroni</span>\r\n </p>\r\n </div>\r\n </td>\r\n </tr>\r\n \r\n <td align="justify" style="font-size:0px;padding:10px 25px;word-break:break-word;">\r\n <div style="font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:14px;line-height:1;text-align:justify;color:#000000;">\r\n <p style="margin: 0; padding: 0;"><span style="color:black">A fronte di un’informatica cos\u00ec pervasiva e fondamentale</strong> per le attivit\u00e0 umane ci si aspetterebbe che gli ambienti IT fossero ormai completamente stabili, immuni da intoppi o malfunzionamenti. </span></p>\r\n </div>\r\n </td>\r\n </tr>\r\n \r\n <td align="justify" style="font-size:0px;padding:10px 25px;word-break:break-word;">\r\n <div style="font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:14px;line-height:1;text-align:justify;color:#000000;">\r\n <p style="margin: 0; padding: 0;"><span style="color:black">La nostra esperienza quotidiana ci suggerisce invece il contrario</strong>. Quante volte dobbiamo perdere tempo perch\u00e9 la stampante si inceppa, la connessione di rete traballa, Internet non \u00e8 raggiungibile, il computer rallenta, le configurazioni non vengono pi\u00f9 riconosciute, le applicazioni smettono di funzionare o non si trovano pi\u00f9 dati e documenti? </span></p>\r\n </div>\r\n </td>\r\n </tr>\r\n \r\n <td align="justify" style="font-size:0px;padding:10px 25px;word-break:break-word;">\r\n <div style="font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:14px;line-height:1;text-align:justify;color:#000000;">\r\n <p style="margin: 0; padding: 0;"><span style="color:black">Certo, siamo ottimisti e possiamo sempre contare sul fatto che l\u2019informatica si trovi in una traiettoria di costante miglioramento. </span></p>\r\n </div>\r\n </td>\r\n </tr>\r\n \r\n <td align="justify" style="font-size:0px;padding:10px 25px;word-break:break-word;">\r\n <div style="font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:14px;line-height:1;text-align:justify;color:#000000;">\r\n <p style="margin: 0; padding: 0;"><span style="color:black">Ma siamo anche realisti e possiamo affrontare il problema rendendoci conto che noi stessi possiamo cercare di minimizzare</strong> le varie occasioni di intoppo che ben conosciamo. </span></p>\r\n </div>\r\n </td>\r\n </tr>\r\n \r\n <td align="justify" style="font-size:0px;padding:10px 25px;word-break:break-word;">\r\n <div style="font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:14px;line-height:1;text-align:justify;color:#000000;">\r\n <p style="margin: 0; padding: 0;"><span style="color:black">Per farlo non occorrono particolari competenze</strong>, solo un po’ di consapevolezza di quello che si sta facendo, una certa dose di attenzione e qualche accorgimento pratico molto semplice: abbiamo preparato un <a href="https://mautic.2dc.it/asset/30:consigli-per-lavorare-megliohttps://mautic.2dc.it/asset/30:consigli-per-lavorare-meglio?utm_source={utm_source}&utm_medium={utm_medium}l&utm_campaign={utm_campaign}&utm_content={utm_content}"><span style="color:#0563c1">breve video</span></strong></a><a href="https://achabspa-my.sharepoint.com/\u270c/g/personal/marketing_achab_it/EdAHeSZf9yVHpU3DzJ94ZxkBSeHe7rmJb1shbpxlm9K1cA?e=eEdHp4"> </a>e un <a href="https://mautic.2dc.it/consigli-per-lavorare-meglio1?utm_source={utm_source}&utm_medium={utm_medium}l&utm_campaign={utm_campaign}&utm_content={utm_content}"><span style="color:#0563c1">White Paper</span></strong></a><a href="https://achabspa-my.sharepoint.com/\ud83c\udd71/g/personal/marketing_achab_it/EV3BjMozvEpHt2plS28SopQBwrtB5j9mCDcvGklewaniqw?e=i28yIf"> </a>per mostrarti cosa (non) fare.</span></p>\r\n
SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x85\xB1/g…’ for column ‘custom_html’ at row 1 at /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x85\xB1/g…’ for column ‘custom_html’ at row 1 at /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x85\xB1/g…’ for column ‘custom_html’ at row 1 at /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)
[stacktrace]
#0 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
#2 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1538): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(523): Doctrine\DBAL\Connection->executeStatement()
#5 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(409): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable()
#6 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1223): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update()
#7 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(437): Doctrine\ORM\UnitOfWork->executeUpdates()
#8 /var/www/vhosts/mautic.2dc.it/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(403): Doctrine\ORM\UnitOfWork->commit()
#9 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/CoreBundle/Entity/CommonRepository.php(781): Doctrine\ORM\EntityManager->flush()
#10 /var/www/vhosts/mautic.2dc.it/mautic/docroot/plugins/GrapesJsBuilderBundle/Model/GrapesJsBuilderModel.php(72): Mautic\CoreBundle\Entity\CommonRepository->saveEntity()
#11 /var/www/vhosts/mautic.2dc.it/mautic/docroot/plugins/GrapesJsBuilderBundle/EventSubscriber/EmailSubscriber.php(54): MauticPlugin\GrapesJsBuilderBundle\Model\GrapesJsBuilderModel->addOrEditEntity()
#12 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/event-dispatcher/EventDispatcher.php(304): MauticPlugin\GrapesJsBuilderBundle\EventSubscriber\EmailSubscriber->onEmailPostSave()
#13 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/event-dispatcher/EventDispatcher.php(264): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}()
#14 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/event-dispatcher/EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()
#15 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/event-dispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
#16 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/EmailBundle/Model/EmailModel.php(465): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
#17 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/CoreBundle/Model/FormModel.php(103): Mautic\EmailBundle\Model\EmailModel->dispatchEvent()
#18 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/EmailBundle/Model/EmailModel.php(282): Mautic\CoreBundle\Model\FormModel->saveEntity()
#19 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/EmailBundle/Controller/EmailController.php(683): Mautic\EmailBundle\Model\EmailModel->saveEntity()
#20 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/bundles/CoreBundle/Controller/CommonController.php(447): Mautic\EmailBundle\Controller\EmailController->editAction()
#21 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/http-kernel/HttpKernel.php(169): Mautic\CoreBundle\Controller\CommonController->executeAction()
#22 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/http-kernel/HttpKernel.php(81): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#23 /var/www/vhosts/mautic.2dc.it/mautic/vendor/symfony/http-kernel/Kernel.php(201): Symfony\Component\HttpKernel\HttpKernel->handle()
#24 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/AppKernel.php(115): Symfony\Component\HttpKernel\Kernel->handle()
#25 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/middlewares/CORSMiddleware.php(82): AppKernel->handle()
#26 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/middlewares/CatchExceptionMiddleware.php(34): Mautic\Middleware\CORSMiddleware->handle()
#27 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/middlewares/VersionCheckMiddleware.php(58): Mautic\Middleware\CatchExceptionMiddleware->handle()
#28 /var/www/vhosts/mautic.2dc.it/mautic/docroot/app/middlewares/TrustMiddleware.php(42): Mautic\Middleware\VersionCheckMiddleware->handle()
#29 /var/www/vhosts/mautic.2dc.it/mautic/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Mautic\Middleware\TrustMiddleware->handle()
#30 /var/www/vhosts/mautic.2dc.it/mautic/vendor/stack/run/src/Stack/run.php(13): Stack\StackedHttpKernel->handle()
#31 /var/www/vhosts/mautic.2dc.it/mautic/docroot/index.php(24): Stack
un()
#32 {main}
"} {“hostname”:“cloudlinux3.dnscore1.com”,“pid”:3208882}
Steps I have tried to fix the problem:
clear cache (mautic and composer)
Sometimes creating the email from scratch works correctly, but it is a slow procedure and takes a long time.