Issue on importing contacts though ssh

Product Support
1

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

2

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

3

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

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.
4

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

5

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

6

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

7

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

 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?

8

Try to do smaller batches!
Here are the docs:
https://docs.mautic.org/en/5.x/contacts/import_contacts.html

1 Like
9

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