Your software
My Mautic version is: 4.4.5
My PHP version is: 7.4.33
My Database type and version is: 10.2.44-MariaDB-1:10.2.44+maria~bionic-log
Your problem
My problem is:
When I enter Mautic, the initial page loads for me to log in. Once I log in, it takes time to load and this error appears:
I refresh and after a minute, It loads.
But sometimes I also have the Apache screen with the same warning…
What I’ve notice is that only with Administrator Users we have this issue.
These errors are showing in the log:
[2023-08-15 00:44:49] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘UPDATE leads SET sourcer = ?, subdivisor = ?, divisor = ?, industria_de_la_empresa = ?, empresa_en_la_que_trabaja = ?, ciudadregion = ?, origen_del_mail = ?, posicion_linkedin = ?, pais = ?, q_de_empleados = ?, linkedin = ? WHERE id = ?’ with params [“Franklin”, “C”, 4, “Marketing & Advertising”, “Cebra \ud83e\udd93”, “Santiago Metropolitan”, “SQL”, “Paid Media Manager”, “Chile”, “51”, “https://www.linkedin.com/in/joaqu\u00edn-ram\u00edrez-881a7727b”, “617555”]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\xA6\x93’ for column pulsodb.leads.empresa_en_la_que_trabaja at row 1” at /var/www/vhosts/posta.thepulso.com/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘UPDATE leads SET sourcer = ?, subdivisor = ?, divisor = ?, industria_de_la_empresa = ?, empresa_en_la_que_trabaja = ?, ciudadregion = ?, origen_del_mail = ?, posicion_linkedin = ?, pais = ?, q_de_empleados = ?, linkedin = ? WHERE id = ?’ with params ["Franklin", "C", 4, "Marketing & Advertising", "Cebra \ud83e\udd93", "Santiago Metropolitan", "SQL", "Paid Media Manager", "Chile", "51", "https:\/\/www.linkedin.com\/in\/joaqu\u00edn-ram\u00edrez-881a7727b", "617555"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\xA6\x93’ for column pulsodb.leads.empresa_en_la_que_trabaja at row 1 at /var/www/vhosts/posta.thepulso.com/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\xA6\x93’ for column pulsodb.leads.empresa_en_la_que_trabaja at row 1 at /var/www/vhosts/posta.thepulso.com/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\xA6\x93’ for column pulsodb.leads.empresa_en_la_que_trabaja at row 1 at /var/www/vhosts/posta.thepulso.com/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“posta-02”,“pid”:4300}
[2023-08-15 02:03:26] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2Ojk1Nzt9Zjo4OiJmemJ2eSI7djo0Nzc7Zjo3OiJmZ2JnIjtmOjU1OiI5N2ViNzRmZmRlZTU2Mjc5MzkyOTg0IjtmOjc6InlmYmUiO2Y6OToiOTQ5MTg3IjtmOjA6ImR1YmFhZnkiO2I6NDp7Zjo4OiJmemJ2eSI7djo0Nzc7fX0= {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:"fbhedf";b:5:{v:3;f:47:"dbzcbvta.fifag";v:4;v:957;}f:8:"fzbvy";v:477;f:7:"fgbg";f:55:"97eb74ffdee56279392984";f:7:"yfbe";f:9:"949187";f:0:"dubaafy";b:4:{f:8:"fzbvy";v:477;}} is not a serialized array at /var/www/vhosts/posta.thepulso.com/httpdocs/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:37)”} {“hostname”:“posta-02”,“pid”:16505}
Steps I have tried to fix the problem: