Issue on importing contacts though ssh

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

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

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.

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

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

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

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?

Try to do smaller batches!
Here are the docs:

1 Like

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