# error 500 on leads page after editing lead

**URL:** https://forum.mautic.org/t/error-500-on-leads-page-after-editing-lead/1914
**Category:** Product Support
**Created:** [June 6, 2015, 8:33am UTC](https://forum.mautic.org/t/error-500-on-leads-page-after-editing-lead/1914 "2015-06-06T08:33:29Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![menolo](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@menolo](https://forum.mautic.org/u/menolo)
#### Post date: [June 6, 2015, 8:33am UTC](https://forum.mautic.org/t/error-500-on-leads-page-after-editing-lead/1914/1 "2015-06-06T08:33:29Z")

</div>

My leads page gives an error 500 in both the “cards” and “table” mode when the edited contact is shown on the page (this depends on pagination).  
  
  
  
This started after editing to add some social accounts to the lead. After saving the lead there was an error balloon in the screen saying something like “Lead with id xxx not found”.  
  
  
  
The last few errors in the log:

Code:

[2015-06-06 09:28:05] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"Twitter";a..." to Doctrine Type array" at /home/soetkees/domains/soetkees.nl/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"Twitter";a..." to Doctrine Type array at /home/soetkees/domains/soetkees.nl/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []

[2015-06-06 09:28:15] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: “Could not convert database value “a:1:{s:7:“Twitter”;a…” to Doctrine Type array” at /home/soetkees/domains/soetkees.nl/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php line 46 {“exception”:"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value “a:1:{s:7:“Twitter”;a…” to Doctrine Type array at /home/soetkees/domains/soetkees.nl/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []

[2015-06-06 09:28:18] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: “Could not convert database value “a:1:{s:7:“Twitter”;a…” to Doctrine Type array” at /home/soetkees/domains/soetkees.nl/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php line 46 {“exception”:"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value “a:1:{s:7:“Twitter”;a…” to Doctrine Type array at /home/soetkees/domains/soetkees.nl/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []

[2015-06-06 09:28:30] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: “Could not convert database value “a:1:{s:7:“Twitter”;a…” to Doctrine Type array” at /home/soetkees/domains/soetkees.nl/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php line 46 {“exception”:"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value “a:1:{s:7:“Twitter”;a…” to Doctrine Type array at /home/soetkees/domains/soetkees.nl/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []

---

<div class="post-metadata">

### Author: ![menolo](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@menolo](https://forum.mautic.org/u/menolo)
#### Post date: [June 6, 2015, 8:33am UTC](https://forum.mautic.org/t/error-500-on-leads-page-after-editing-lead/1914/2 "2015-06-06T08:33:29Z")

</div>

My leads page gives an error 500 in both the “cards” and “table” mode when the edited contact is shown on the page (this depends on pagination).

This started after editing to add some social accounts to the lead. After saving the lead there was an error balloon in the screen saying something like “Lead with id xxx not found”.

The last few errors in the log:

```auto
[2015-06-06 09:28:05] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"Twitter";a..." to Doctrine Type array" at /home/soetkees/domains/soetkees.nl/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"Twitter";a..." to Doctrine Type array at /home/soetkees/domains/soetkees.nl/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []

[2015-06-06 09:28:15] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"Twitter";a..." to Doctrine Type array" at /home/soetkees/domains/soetkees.nl/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"Twitter";a..." to Doctrine Type array at /home/soetkees/domains/soetkees.nl/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []

[2015-06-06 09:28:18] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"Twitter";a..." to Doctrine Type array" at /home/soetkees/domains/soetkees.nl/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"Twitter";a..." to Doctrine Type array at /home/soetkees/domains/soetkees.nl/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []

[2015-06-06 09:28:30] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: "Could not convert database value "a:1:{s:7:"Twitter";a..." to Doctrine Type array" at /home/soetkees/domains/soetkees.nl/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php line 46 {"exception":"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value "a:1:{s:7:"Twitter";a..." to Doctrine Type array at /home/soetkees/domains/soetkees.nl/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []
```

---

<div class="post-metadata">

### Author: ![menolo](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@menolo](https://forum.mautic.org/u/menolo)
#### Post date: [June 6, 2015, 8:48am UTC](https://forum.mautic.org/t/error-500-on-leads-page-after-editing-lead/1914/3 "2015-06-06T08:48:15Z")

</div>

After emptying the social fields in the database (the fields social\_cache, facebook and twitter) the error is gone.  
It might have got something to do with the social\_cache field containing a certain character: ☀

The value was:

```auto
a:1:{s:7:"Twitter";a:3:{s:7:"profile";a:8:{s:13:"profileHandle";s:14:"traveloclockNL";s:4:"name";s:17:"Daphne Groeneveld";s:8:"location";s:26:"The Hague, The Netherlands";s:11:"description";s:157:"Blogger http://t.co/cSvzK7fgS1 | Fotografeert graag | Schrijft | PR Baltus Communications | Dol op tijdschriften | London fan | Avontuurlijk | Loves water |";s:3:"url";s:22:"http://t.co/cSvzK7fgS1";s:9:"time_zone";s:9:"Amsterdam";s:4:"lang";s:2:"nl";s:12:"profileImage";s:68:"https://pbs.twimg.com/profile_images/583760250358075392/DQzBmn_z.jpg";}s:8:"activity";a:3:{s:6:"tweets";a:10:{i:0;a:4:{s:5:"tweet";s:70:"I'm at Copacabana in Scheveningen, netherlands https://t.co/Ez0dbwMobw";s:3:"url";s:54:"https://twitter.com/48977276/status/606860635142549504";s:11:"coordinates";a:2:{s:4:"type";s:5:"Point";s:11:"coordinates";a:2:{i:0;d:4.26995670999999976658045852673240005970001220703125;i:1;d:52.10732402000000007546987035311758518218994140625;}}s:9:"published";s:30:"Fri Jun 05 16:30:25 +0000 2015";}i:1;a:4:{s:5:"tweet";s:127:"La playa en la Haya! Viva!! // ☀️
```

---

<div class="post-metadata">

### Author: ![gmillard](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gmillard/32/5_2.png) [@gmillard](https://forum.mautic.org/u/gmillard)
#### Post date: [June 6, 2015, 2:30pm UTC](https://forum.mautic.org/t/error-500-on-leads-page-after-editing-lead/1914/4 "2015-06-06T14:30:36Z")

</div>

Hi Menolo,

You’re right. There’s an issue with storing 4 byte emoji’s in the database which causes the serialized string to become corrupt. We’ve got a fix coming in the next release.

Thanks,  
Alan

---

<div class="post-metadata">

### Author: ![menolo](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@menolo](https://forum.mautic.org/u/menolo)
#### Post date: [June 8, 2015, 7:04am UTC](https://forum.mautic.org/t/error-500-on-leads-page-after-editing-lead/1914/5 "2015-06-08T07:04:16Z")

</div>

[quote=1689:alanhartless]Hi Menolo,

You’re right. There’s an issue with storing 4 byte emoji’s in the database which causes the serialized string to become corrupt. We’ve got a fix coming in the next release.

Thanks,  
Alan[/quote]  
Cool, thanks Alan.

---

<div class="post-metadata">

### Author: ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)
#### Post date: [February 2, 2020, 10:59pm UTC](https://forum.mautic.org/t/error-500-on-leads-page-after-editing-lead/1914/6 "2020-02-02T22:59:33Z")

</div>


