# Problems importing contacts, both as a CSV and Quick Add

**URL:** <https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312>\
**Category:** Product Support\
**Created:** [June 14, 2023, 7:31am UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312 "2023-06-14T07:31:25Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![david001](https://avatars.discourse-cdn.com/v4/letter/d/a88e57/32.png) [@david001](https://forum.mautic.org/u/david001)\
**Post date:** [June 14, 2023, 7:31am UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312/1 "2023-06-14T07:31:25Z")

</div>

**Your software**  
My Mautic version is: 4.4.7  
My PHP version is: 7.4.3-4ubuntu2.18  
My Database type and version is:

**Your problem**  
My problem is: I am unable to import contacts all of a sudden both as a file (CSV) and individually (Quick Add).

- The CSV importing keeps showing me pending as the status but never increases.
- While the Quick Add, give me the error as displayed below

These errors are showing in the log:

 ![Screenshot 2023-06-12 223659](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/e/e105193b9c44f5583f35675a1cb64c2e3ee61731.jpeg)

---

<div class="post-metadata">

**Author:** ![dirk\_s](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dirk_s/32/748_2.png) [@dirk\_s](https://forum.mautic.org/u/dirk_s)\
**Post date:** [June 14, 2023, 1:37pm UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312/2 "2023-06-14T13:37:27Z")

</div>

Whats in the mautic logs?

---

<div class="post-metadata">

**Author:** ![david001](https://avatars.discourse-cdn.com/v4/letter/d/a88e57/32.png) [@david001](https://forum.mautic.org/u/david001)\
**Post date:** [June 14, 2023, 2:35pm UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312/3 "2023-06-14T14:35:59Z")

</div>

[2023-06-14 01:14:29] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO maleads (is\_published, date\_added, created\_by, created\_by\_user, date\_modified, modified\_by, modified\_by\_user, checked\_out, checked\_out\_by, checked\_out\_by\_user, points, last\_active, internal, social\_cache, date\_identified, preferred\_profile\_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner\_id, stage\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2023-06-14 01:14:29”, null, null, null, null, null, null, null, null, 0, null, “a:0:{}”, “a:0:{}”, null, “gravatar”, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]: Failed to read auto-increment value from storage engine” at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO maleads (is\_published, date\_added, created\_by, created\_by\_user, date\_modified, modified\_by, modified\_by\_user, checked\_out, checked\_out\_by, checked\_out\_by\_user, points, last\_active, internal, social\_cache, date\_identified, preferred\_profile\_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner\_id, stage\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, "2023-06-14 01:14:29", null, null, null, null, null, null, null, null, 0, null, "a:0:{}", "a:0:{}", null, "gravatar", null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]:\n\nFailed to read auto-increment value from storage engine at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\Mysqli\Exception\StatementError(code: 0): Failed to read auto-increment value from storage engine at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/Exception/StatementError.php:21)”} {“hostname”:“mautic”,“pid”:207685}

That’s the error I’m getting @dirk_s

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [June 14, 2023, 4:13pm UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312/4 "2023-06-14T16:13:44Z")

</div>

Just a hint: can you try to import without company data? Or you need to import the company name as primary company, not company name.

---

<div class="post-metadata">

**Author:** ![david001](https://avatars.discourse-cdn.com/v4/letter/d/a88e57/32.png) [@david001](https://forum.mautic.org/u/david001)\
**Post date:** [June 15, 2023, 7:42am UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312/5 "2023-06-15T07:42:38Z")

</div>

Solved! It works now. Thank you @joeyk

So, does that mean there’s something wrong with the “Company Name” field?

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [June 15, 2023, 8:15am UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312/6 "2023-06-15T08:15:29Z")

</div>

No, just you have to be sure, that you are using primary company, cause it will be connected with the company name field.

---

<div class="post-metadata">

**Author:** ![david001](https://avatars.discourse-cdn.com/v4/letter/d/a88e57/32.png) [@david001](https://forum.mautic.org/u/david001)\
**Post date:** [June 15, 2023, 11:17am UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312/7 "2023-06-15T11:17:14Z")

</div>

Well, It works without including the Company Name, however, when I use the Primary Company I get the error that " Company Name is missing"

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [June 15, 2023, 12:14pm UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312/8 "2023-06-15T12:14:57Z")

</div>

Sorry, yes Company Name not Primary Company.

---

<div class="post-metadata">

**Author:** ![david001](https://avatars.discourse-cdn.com/v4/letter/d/a88e57/32.png) [@david001](https://forum.mautic.org/u/david001)\
**Post date:** [June 15, 2023, 12:45pm UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312/9 "2023-06-15T12:45:52Z")

</div>

It doesn’t work with either of them

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/1X/43c63600fe51440378769136903f1fa2a9a34102.png) [@system](https://forum.mautic.org/u/system)\
**Post date:** [June 17, 2023, 12:46am UTC](https://forum.mautic.org/t/problems-importing-contacts-both-as-a-csv-and-quick-add/28312/10 "2023-06-17T00:46:11Z")

</div>

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.
