SELF HOSTED | Error | 500 error after adding emoji to subject line

General Discussion
1

Hello,



I receive a 500 error after saving an email with an emoji in the subject line.



Here are the error logs:

Code:
[2015-10-20 05:01:45] mautic.ERROR: Uncaught PHP Exception SymfonyComponentHttpKernelExceptionNotFoundHttpException: "Requested URL not found: /testproxy.php" at /home/mautic/public_html/app/bundles/CoreBundle/Controller/Cller.php line 352 {"exception":"[object] (Symfony\Component\HttpKernel\Exception\NotFoundHttpException(code: 0): Requested URL not found: /testproxy.php at /home/mautic/public_html/app/bundles/CoreBundle/Controller/CommonChp:352)"} [] [2015-10-20 10:46:30] mautic.NOTICE: PHP Notice: unserialize(): Error at offset 112 of 186 bytes - in file /home/mautic/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php - at line 58 [] [] [2015-10-20 10:46:30] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array" at /home/mautic/public_html/vendor/doctib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array at /homelic_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} [] [2015-10-20 10:49:00] mautic.NOTICE: PHP Notice: unserialize(): Error at offset 112 of 186 bytes - in file /home/mautic/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php - at line 58 [] [] [2015-10-20 10:49:00] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array" at /home/mautic/public_html/vendor/doctib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array at /homelic_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} [] [2015-10-20 11:22:02] mautic.NOTICE: PHP Notice: unserialize(): Error at offset 112 of 186 bytes - in file /home/mautic/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php - at line 58 [] [] [2015-10-20 11:22:02] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array" at /home/mautic/public_html/vendor/doctib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array at /homelic_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} [] [2015-10-20 11:38:19] mautic.NOTICE: PHP Notice: unserialize(): Error at offset 112 of 186 bytes - in file /home/mautic/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php - at line 58 [] [] [2015-10-20 11:38:20] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array" at /home/mautic/public_html/vendor/doctib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array at /homelic_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []

I saw another post with a similar issue but in relation to leads.

Is the fix for this the same process? If so, please help me out?

I'm running the latest version.

Thanks!
2

Hi, thanks for this report, however, would you be so kind and report it to https://github.com/mautic/mautic/issues ? That’s where developers can track it. It could be forgotten here. If you do so, please, add here a link to it so community members with similar problem can navigate there.

3

Thanks for the reply.

I have logged it as asked.

Here is a link to the issue on Github:

4

Perfect, thanks!

5

Hello,

I receive a 500 error after saving an email with an emoji in the subject line.

Here are the error logs:

[2015-10-20 05:01:45] mautic.ERROR: Uncaught PHP Exception SymfonyComponentHttpKernelExceptionNotFoundHttpException: "Requested URL not found: /testproxy.php" at /home/mautic/public_html/app/bundles/CoreBundle/Controller/Cller.php line 352 {"exception":"[object] (Symfony\Component\HttpKernel\Exception\NotFoundHttpException(code: 0): Requested URL not found: /testproxy.php at /home/mautic/public_html/app/bundles/CoreBundle/Controller/CommonChp:352)"} [] [2015-10-20 10:46:30] mautic.NOTICE: PHP Notice: unserialize(): Error at offset 112 of 186 bytes - in file /home/mautic/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php - at line 58 [] [] [2015-10-20 10:46:30] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array" at /home/mautic/public_html/vendor/doctib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array at /homelic_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} [] [2015-10-20 10:49:00] mautic.NOTICE: PHP Notice: unserialize(): Error at offset 112 of 186 bytes - in file /home/mautic/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php - at line 58 [] [] [2015-10-20 10:49:00] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array" at /home/mautic/public_html/vendor/doctib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array at /homelic_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} [] [2015-10-20 11:22:02] mautic.NOTICE: PHP Notice: unserialize(): Error at offset 112 of 186 bytes - in file /home/mautic/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php - at line 58 [] [] [2015-10-20 11:22:02] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array" at /home/mautic/public_html/vendor/doctib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array at /homelic_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} [] [2015-10-20 11:38:19] mautic.NOTICE: PHP Notice: unserialize(): Error at offset 112 of 186 bytes - in file /home/mautic/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php - at line 58 [] [] [2015-10-20 11:38:20] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array" at /home/mautic/public_html/vendor/doctib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"subject";a..." to Doctrine Type array at /homelic_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []

I saw another post with a similar issue but in relation to leads.

Is the fix for this the same process? If so, please help me out?

I’m running the latest version.

Thanks!

6

My Advise, switch from serialize to json object, you will never have such issues. we save in json_encode as object, then we decode. serialize saves so much unnecessary data and easy to get corrupted.

this saved me https://github.com/Blogestudio/Fix-Serialization