# Error after importing leads

**URL:** https://forum.mautic.org/t/error-after-importing-leads/1645
**Category:** General Discussion
**Created:** [March 10, 2015, 11:54pm UTC](https://forum.mautic.org/t/error-after-importing-leads/1645 "2015-03-10T23:54:05Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Nickske157](https://avatars.discourse-cdn.com/v4/letter/n/fbc32d/32.png) [@Nickske157](https://forum.mautic.org/u/Nickske157)
#### Post date: [March 10, 2015, 11:54pm UTC](https://forum.mautic.org/t/error-after-importing-leads/1645/1 "2015-03-10T23:54:05Z")

</div>

Dear Support,  
  
  
  
I uploaded succesfully all my leads, I could see them once, but now i get following error:  
  
[2015-03-10 23:51:14] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: “Could not convert database value “a:1:{s:6:“fields”;a:…” to Doctrine Type array” at /home/user/domains/example.com/public\_html/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:6:“fields”;a:…” to Doctrine Type array at /home/user/domains/example.com/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []  
  
  
  
Kind Regards  
  
  
  
Nick Geoffroy

---

<div class="post-metadata">

### Author: ![Nickske157](https://avatars.discourse-cdn.com/v4/letter/n/fbc32d/32.png) [@Nickske157](https://forum.mautic.org/u/Nickske157)
#### Post date: [March 10, 2015, 11:54pm UTC](https://forum.mautic.org/t/error-after-importing-leads/1645/2 "2015-03-10T23:54:05Z")

</div>

Dear Support,

I uploaded succesfully all my leads, I could see them once, but now i get following error:  
[2015-03-10 23:51:14] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: “Could not convert database value “a:1:{s:6:“fields”;a:…” to Doctrine Type array” at /home/user/domains/example.com/public\_html/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:6:“fields”;a:…” to Doctrine Type array at /home/user/domains/example.com/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []

Kind Regards

Nick Geoffroy

---

<div class="post-metadata">

### Author: ![Nickske157](https://avatars.discourse-cdn.com/v4/letter/n/fbc32d/32.png) [@Nickske157](https://forum.mautic.org/u/Nickske157)
#### Post date: [March 12, 2015, 12:03am UTC](https://forum.mautic.org/t/error-after-importing-leads/1645/3 "2015-03-12T00:03:28Z")

</div>

Hi,

I solved it by changing /domains/example.com/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php on line 44  
//$value = (strlen($value) \> 32) ? substr($value, 0, 20) . “…” : $value;

Then I could see in the log which lead was giving the problems. I deleted the lead, deleted the cache and flushed the audit\_log table.

After that the problem was solved.

Kind Regards

Nick

---

<div class="post-metadata">

### Author: ![Nickske157](https://avatars.discourse-cdn.com/v4/letter/n/fbc32d/32.png) [@Nickske157](https://forum.mautic.org/u/Nickske157)
#### Post date: [March 13, 2015, 4:58pm UTC](https://forum.mautic.org/t/error-after-importing-leads/1645/4 "2015-03-13T16:58:33Z")

</div>

Other issues arrised when I wanted to mail all those leads.

It seems that the import does not check the email value if it is ligit.

So when I wanted to send a mail, I get RFC errors on some leads.  
When I checked those leads, they had not a proper emailaddress.

I know that I needed to check the import file for mistakes, but it would come in handy that every email field is checked. And in the end that you get a report with the leads that have problems.

Kind Regards

Nick

---

<div class="post-metadata">

### Author: ![Nickske157](https://avatars.discourse-cdn.com/v4/letter/n/fbc32d/32.png) [@Nickske157](https://forum.mautic.org/u/Nickske157)
#### Post date: [March 17, 2015, 11:30am UTC](https://forum.mautic.org/t/error-after-importing-leads/1645/5 "2015-03-17T11:30:06Z")

</div>

Again problem with email sending ☹

[2015-03-17 10:17:33] mautic.CRITICAL: Uncaught PHP Exception Swift\_RfcComplianceException: “Address in mailbox given [] does not comply with RFC 2822, 3.6.2.” at /home/user/domains/example.com/public\_html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Mime/Headers/MailboxHeader.php line 348 {“exception”:"[object] (Swift\_RfcComplianceException(code: 0): Address in mailbox given [] does not comply with RFC 2822, 3.6.2. at /home/user/domains/example.com/public\_html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Mime/Headers/MailboxHeader.php:348)"} []

When you select a lead list that contains leads without email addresses, then some mails got send and it stops when there is n email address.

This is very annoying because I couldnt see who already received the mail. Can this issue be solved quickly so that emails are checked with import, and if there are leads without email, they get ignored or better is that we get a report of which users failed.

---

<div class="post-metadata">

### Author: ![ravibjain](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ravibjain/32/98_2.png) [@ravibjain](https://forum.mautic.org/u/ravibjain)
#### Post date: [September 16, 2016, 3:08am UTC](https://forum.mautic.org/t/error-after-importing-leads/1645/6 "2016-09-16T03:08:36Z")

</div>

I constantly get errors while uploading a contact list. Is there a limit to number of contacts (cumulative) which can be imported?

---

<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, 11:00pm UTC](https://forum.mautic.org/t/error-after-importing-leads/1645/7 "2020-02-02T23:00:32Z")

</div>


