# Issue on importing contacts though ssh

**URL:** https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962
**Category:** Product Support
**Created:** [May 3, 2024, 8:36pm UTC](https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962 "2024-05-03T20:36:49Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![killmasta93](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/killmasta93/32/12780_2.png) [@killmasta93](https://forum.mautic.org/u/killmasta93)
#### Post date: [May 3, 2024, 8:36pm UTC](https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962/1 "2024-05-03T20:36:49Z")

</div>

**Your software**  
My Mautic version is: 4.4.9  
My PHP version is: 7.4.33  
My Database type and version is: mysql8.0

**Your problem**  
My problem is:  
hi , trying to upload the csv contacts on the backround but i keep getting this issue

These errors are showing in the log:  
Import failed. Reason: There was a database error: %message%. The import has been set to stopped status and will be imported later.  
Steps I have tried to fix the problem:  
i checked the file if it has any odd letters and checked that is ok

---

<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: [May 5, 2024, 4:15pm UTC](https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962/2 "2024-05-05T16:15:05Z")

</div>

Could you plz write here the command you used for import?

---

<div class="post-metadata">

### Author: ![killmasta93](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/killmasta93/32/12780_2.png) [@killmasta93](https://forum.mautic.org/u/killmasta93)
#### Post date: [May 5, 2024, 5:29pm UTC](https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962/3 "2024-05-05T17:29:58Z")

</div>

thanks for the reply,  
it seems that it start uploading then gets this error, it shows in spanish

```auto
root@394c80e1825b:/var/www/html# /var/www/html/bin/console mautic:import
La importación %icon 50001 filas está empezando.
    28/50001 [>---------------------------] 0%Import failed. Reason: Hubo un error de base de datos:% message%. La importación se estableció en estado detenida y se importará más tarde.

```

---

<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: [May 5, 2024, 7:13pm UTC](https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962/4 "2024-05-05T19:13:09Z")

</div>

> [@killmasta93](#):
>
> `%Import failed. Reason: Hubo un error de base de datos:% message%. La importación se estableció en estado detenida y se importará más tarde.`

Your import file format is wrong.  
Check for the right delimiter

---

<div class="post-metadata">

### Author: ![killmasta93](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/killmasta93/32/12780_2.png) [@killmasta93](https://forum.mautic.org/u/killmasta93)
#### Post date: [May 6, 2024, 12:31am UTC](https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962/5 "2024-05-06T00:31:15Z")

</div>

thanks for the reply, not sure what you mean import file format is wrong?

---

<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: [May 6, 2024, 12:13pm UTC](https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962/6 "2024-05-06T12:13:41Z")

</div>

For example the pairing of the fields are not properly done.

---

<div class="post-metadata">

### Author: ![killmasta93](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/killmasta93/32/12780_2.png) [@killmasta93](https://forum.mautic.org/u/killmasta93)
#### Post date: [May 6, 2024, 1:57pm UTC](https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962/7 "2024-05-06T13:57:59Z")

</div>

thanks it seems i only let email and name and got it working but now im getting

```auto
 22696/50001 [============>---------------] 45%
Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 81920 bytes) in /var/www/html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php on line 1680

In UnitOfWork.php line 1680:

  Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 81920 bytes)

```

i was looking for memory\_limit in the php config file, but not sure exactly where it is?

---

<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: [May 6, 2024, 3:12pm UTC](https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962/8 "2024-05-06T15:12:31Z")

</div>

Try to do smaller batches!  
Here are the docs:  
[https://docs.mautic.org/en/5.x/contacts/import\_contacts.html](https://docs.mautic.org/en/5.x/contacts/import_contacts.html)

---

<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: [May 8, 2024, 3:12am UTC](https://forum.mautic.org/t/issue-on-importing-contacts-though-ssh/31962/9 "2024-05-08T03:12:49Z")

</div>

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