Errors when updating/revising with CSV Import

Omeka S Modules
1

Hi everyone,

After updating to Omeka-S version 4.0 and the modules used, I’ve been trying for several days to revise/update my data with the CSV Import module.

Each task fails, with the following error messages:

2023-07-12T08:55:36+00:00 ERR (3): Omeka\Api\Exception\NotFoundException: Entity Omeka\EntityItem with criterion {“id”: “3024”} not found in /sites/haissa/www/web_main/application/src/Api/Adapter/AbstractEntityAdapter.php:714
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘3-1’ for key ‘UNIQ_4689E2F116131EA549213EC’ in /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception. php:18
2023-07-12T08:55:41+00:00 ERR (3): Doctrine\ORM\Exception\EntityManagerClosed: The EntityManager is closed. in /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/Exception/EntityManagerClosed.php:11

I must admit that I’ve reached the limits of my technical skills here - if you ever had an idea of how to solve this problem, it would be a great help!

Thank you !

2

Can you tell me what other modules you’re using?

3

Hi,

Here are the modules that are installed and actives :

Capture d’écran 2023-07-18 145935
Capture d’écran 2023-07-18 1459351529×913 152 KB

Thank you !

4

Do you have any changed settings related to how jobs run? Like changing from background to “synchronous” jobs, for example?

5

I did not change any settings when installing and have no idea how to do so !

6

Okay…

So, there should be some more details for these error messages you showed, a bunch of extra numbered lines after each one. Can you share those?

7

Yeah sure but it’ll be extra long so here we go :muscle:

2023-07-11T20:09:42+00:00 ERR (3): Omeka\Api\Exception\NotFoundException: Entité Omeka\Entity\Item avec critère {“id”:“3024”} non trouvée in /sites/haissa/www/web_main/application/src/Api/Adapter/AbstractEntityAdapter.php:714
Stack trace:
#0 /sites/haissa/www/web_main/application/src/Api/Adapter/AbstractEntityAdapter.php(432): Omeka\Api\Adapter\AbstractEntityAdapter->findEntity()
#1 /sites/haissa/www/web_main/application/src/Api/Manager.php(230): Omeka\Api\Adapter\AbstractEntityAdapter->read()
#2 /sites/haissa/www/web_main/application/src/Api/Manager.php(115): Omeka\Api\Manager->execute()
#3 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(781): Omeka\Api\Manager->read()
#4 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(424): CSVImport\Job\Import->updateRevise()
#5 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(296): CSVImport\Job\Import->update()
#6 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(194): CSVImport\Job\Import->processBatchData()
#7 /sites/haissa/www/web_main/application/src/Job/DispatchStrategy/Synchronous.php(34): CSVImport\Job\Import->perform()
#8 /sites/haissa/www/web_main/application/src/Job/Dispatcher.php(105): Omeka\Job\DispatchStrategy\Synchronous->send()
#9 /sites/haissa/www/web_main/application/src/Job/Dispatcher.php(91): Omeka\Job\Dispatcher->send()
#10 /sites/haissa/www/web_main/modules/CSVImport/src/Controller/IndexController.php(160): Omeka\Job\Dispatcher->dispatch()
#11 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): CSVImport\Controller\IndexController->mapAction()
#12 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#13 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#14 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil()
#15 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch()
#16 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch()
#17 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#18 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil()
#19 /sites/haissa/www/web_main/index.php(21): Laminas\Mvc\Application->run()
#20 {main}
2023-07-11T20:09:47+00:00 INFO (6): 199 items were updated (revise): 809, 976, 1001, 1120, 1182, 1191, 1268, 1417, 1419, 1717, 1720, 2090, 2091, 2192, 2194, 2386, 2387, 2388, 2419, 2420, 2421, 2520, 2521, 2832, 2836, 2898, 2905, 2947, 2948, 2950, 3019, 3023, 3048, 3049, 3105, 3133, 3134, 3201, 3205, 3471, 3472, 3473, 3474, 3475, 3476, 3477, 3478, 3479, 3480, 3481, 3482, 3483, 3484, 3485, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3493, 3494, 3495, 3496, 3497, 3498, 3499, 3500, 3501, 3502, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3518, 3519, 3520, 3521, 3522, 3523, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3531, 3532, 3533, 3534, 3535, 3536, 3537, 3538, 3539, 3540, 3541, 3542, 3543, 3544, 3545, 3546, 3547, 3548, 3549, 3550, 3551, 3552, 3553, 3554, 3555, 3556, 3557, 3558, 3559, 3560, 3561, 3562, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 3572, 3573, 3574, 3575, 3576, 3577, 3578, 3579, 3638, 3639, 3640, 3643, 3644, 3647, 3651, 3652, 3655, 3657, 3679, 3680, 3727, 3728, 3729, 3804, 3805, 3806, 3807, 3808, 3809, 3810, 3811, 3812, 3813, 3814, 3815, 3816, 3817, 3818, 3819, 3878, 3879, 3880, 3894, 3942, 4008, 4045, 4046, 4073, 4074, 4075, 4076, 4127, 4128, 4129, 4182, 4183, 4184, 4185, 4213.
2023-07-11T20:09:48+00:00 ERR (3): PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘3-1’ for key ‘UNIQ_4689E2F116131EA549213EC’ in /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute()
#1 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(179): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(226): Doctrine\DBAL\Statement->execute()
#3 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(276): Doctrine\DBAL\Statement->executeStatement()
#4 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1128): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
#5 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(425): Doctrine\ORM\UnitOfWork->executeInserts()
#6 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(392): Doctrine\ORM\UnitOfWork->commit()
#7 /sites/haissa/www/web_main/application/src/Api/Adapter/AbstractEntityAdapter.php(447): Doctrine\ORM\EntityManager->flush()
#8 /sites/haissa/www/web_main/application/src/Api/Manager.php(233): Omeka\Api\Adapter\AbstractEntityAdapter->update()
#9 /sites/haissa/www/web_main/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute()
#10 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(796): Omeka\Api\Manager->update()
#11 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(424): CSVImport\Job\Import->updateRevise()
#12 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(296): CSVImport\Job\Import->update()
#13 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(194): CSVImport\Job\Import->processBatchData()
#14 /sites/haissa/www/web_main/application/src/Job/DispatchStrategy/Synchronous.php(34): CSVImport\Job\Import->perform()
#15 /sites/haissa/www/web_main/application/src/Job/Dispatcher.php(105): Omeka\Job\DispatchStrategy\Synchronous->send()
#16 /sites/haissa/www/web_main/application/src/Job/Dispatcher.php(91): Omeka\Job\Dispatcher->send()
#17 /sites/haissa/www/web_main/modules/CSVImport/src/Controller/IndexController.php(160): Omeka\Job\Dispatcher->dispatch()
#18 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): CSVImport\Controller\IndexController->mapAction()
#19 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#20 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#21 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil()
#22 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch()
#23 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch()
#24 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#25 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil()
#26 /sites/haissa/www/web_main/index.php(21): Laminas\Mvc\Application->run()
#27 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘3-1’ for key ‘UNIQ_4689E2F116131EA549213EC’ in /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(179): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(226): Doctrine\DBAL\Statement->execute()
#3 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(276): Doctrine\DBAL\Statement->executeStatement()
#4 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1128): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
#5 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(425): Doctrine\ORM\UnitOfWork->executeInserts()
#6 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(392): Doctrine\ORM\UnitOfWork->commit()
#7 /sites/haissa/www/web_main/application/src/Api/Adapter/AbstractEntityAdapter.php(447): Doctrine\ORM\EntityManager->flush()
#8 /sites/haissa/www/web_main/application/src/Api/Manager.php(233): Omeka\Api\Adapter\AbstractEntityAdapter->update()
#9 /sites/haissa/www/web_main/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute()
#10 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(796): Omeka\Api\Manager->update()
#11 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(424): CSVImport\Job\Import->updateRevise()
#12 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(296): CSVImport\Job\Import->update()
#13 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(194): CSVImport\Job\Import->processBatchData()
#14 /sites/haissa/www/web_main/application/src/Job/DispatchStrategy/Synchronous.php(34): CSVImport\Job\Import->perform()
#15 /sites/haissa/www/web_main/application/src/Job/Dispatcher.php(105): Omeka\Job\DispatchStrategy\Synchronous->send()
#16 /sites/haissa/www/web_main/application/src/Job/Dispatcher.php(91): Omeka\Job\Dispatcher->send()
#17 /sites/haissa/www/web_main/modules/CSVImport/src/Controller/IndexController.php(160): Omeka\Job\Dispatcher->dispatch()
#18 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): CSVImport\Controller\IndexController->mapAction()
#19 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#20 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#21 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil()
#22 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch()
#23 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch()
#24 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#25 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil()
#26 /sites/haissa/www/web_main/index.php(21): Laminas\Mvc\Application->run()
#27 {main}

Next Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing ‘INSERT INTO resource_template_property (alternate_label, alternate_comment, position, data_type, is_required, is_private, default_lang, resource_template_id, property_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [null, null, 1, “[]”, 0, 0, null, 3, 1]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘3-1’ for key ‘UNIQ_4689E2F116131EA549213EC’ in /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:74
Stack trace:
#0 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
#2 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(185): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /sites/haissa/www/web_main/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(226): Doctrine\DBAL\Statement->execute()
#5 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(276): Doctrine\DBAL\Statement->executeStatement()
#6 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1128): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
#7 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(425): Doctrine\ORM\UnitOfWork->executeInserts()
#8 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(392): Doctrine\ORM\UnitOfWork->commit()
#9 /sites/haissa/www/web_main/application/src/Api/Adapter/AbstractEntityAdapter.php(447): Doctrine\ORM\EntityManager->flush()
#10 /sites/haissa/www/web_main/application/src/Api/Manager.php(233): Omeka\Api\Adapter\AbstractEntityAdapter->update()
#11 /sites/haissa/www/web_main/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute()
#12 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(796): Omeka\Api\Manager->update()
#13 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(424): CSVImport\Job\Import->updateRevise()
#14 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(296): CSVImport\Job\Import->update()
#15 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(194): CSVImport\Job\Import->processBatchData()
#16 /sites/haissa/www/web_main/application/src/Job/DispatchStrategy/Synchronous.php(34): CSVImport\Job\Import->perform()
#17 /sites/haissa/www/web_main/application/src/Job/Dispatcher.php(105): Omeka\Job\DispatchStrategy\Synchronous->send()
#18 /sites/haissa/www/web_main/application/src/Job/Dispatcher.php(91): Omeka\Job\Dispatcher->send()
#19 /sites/haissa/www/web_main/modules/CSVImport/src/Controller/IndexController.php(160): Omeka\Job\Dispatcher->dispatch()
#20 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): CSVImport\Controller\IndexController->mapAction()
#21 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#22 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#23 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil()
#24 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch()
#25 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch()
#26 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#27 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil()
#28 /sites/haissa/www/web_main/index.php(21): Laminas\Mvc\Application->run()
#29 {main}
2023-07-11T20:09:48+00:00 ERR (3): Doctrine\ORM\Exception\EntityManagerClosed: The EntityManager is closed. in /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/Exception/EntityManagerClosed.php:11
Stack trace:
#0 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(826): Doctrine\ORM\Exception\EntityManagerClosed::create()
#1 /sites/haissa/www/web_main/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(390): Doctrine\ORM\EntityManager->errorIfClosed()
#2 /sites/haissa/www/web_main/application/src/Api/Adapter/AbstractEntityAdapter.php(447): Doctrine\ORM\EntityManager->flush()
#3 /sites/haissa/www/web_main/application/src/Api/Manager.php(233): Omeka\Api\Adapter\AbstractEntityAdapter->update()
#4 /sites/haissa/www/web_main/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute()
#5 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(796): Omeka\Api\Manager->update()
#6 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(424): CSVImport\Job\Import->updateRevise()
#7 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(296): CSVImport\Job\Import->update()
#8 /sites/haissa/www/web_main/modules/CSVImport/src/Job/Import.php(194): CSVImport\Job\Import->processBatchData()
#9 /sites/haissa/www/web_main/application/src/Job/DispatchStrategy/Synchronous.php(34): CSVImport\Job\Import->perform()
#10 /sites/haissa/www/web_main/application/src/Job/Dispatcher.php(105): Omeka\Job\DispatchStrategy\Synchronous->send()
#11 /sites/haissa/www/web_main/application/src/Job/Dispatcher.php(91): Omeka\Job\Dispatcher->send()
#12 /sites/haissa/www/web_main/modules/CSVImport/src/Controller/IndexController.php(160): Omeka\Job\Dispatcher->dispatch()
#13 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): CSVImport\Controller\IndexController->mapAction()
#14 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#15 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#16 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil()
#17 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch()
#18 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch()
#19 /sites/haissa/www/web_main/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#20 /sites/haissa/www/web_main/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil()
#21 /sites/haissa/www/web_main/index.php(21): Laminas\Mvc\Application->run()
#22 {main}

8

OK so, the job setting I was talking about has been changed on your system: this job is not running in the background. That’s something that has to be set in your config/local.config.php file.

The default is to run jobs like CSV Import in a background process, but it looks like you’ve changed the “dispatch strategy” config setting to make them run in the same process as the web request.

9

Here is my local.config.php :

<?php return [ 'logger' => [ 'log' => false, 'priority' => \Zend\Log\Logger::NOTICE, ], 'http_client' => [ 'sslcapath' => null, 'sslcafile' => null, ], 'cli' => [ 'phpcli_path' => '/opt/php/7.4/bin/php', ], 'thumbnails' => [ 'types' => [ 'large' => ['constraint' => 800], 'medium' => ['constraint' => 200], 'square' => ['constraint' => 200], ], 'thumbnailer_options' => [ 'imagemagick_dir' => null, ], ], 'translator' => [ 'locale' => 'en_US', ], 'service_manager' => [ 'aliases' => [ 'Omeka\File\Store' => 'Omeka\File\Store\Local', 'Omeka\File\Thumbnailer' => 'Omeka\File\Thumbnailer\ImageMagick', 'Omeka\Job\DispatchStrategy' => 'Omeka\Job\DispatchStrategy\Synchronous', ], ], ]; Is there anything that I should change ? Thank you so much for all your answers !
10

The setting I’m talking about is this one:

'Omeka\Job\DispatchStrategy' => 'Omeka\Job\DispatchStrategy\Synchronous',

You could try taking that setting out, by adding two slashes to the front of the line to make it a comment:

// 'Omeka\Job\DispatchStrategy' => 'Omeka\Job\DispatchStrategy\Synchronous',
11

CSV Import 2.5.0 is released and contains a fix for the “integrity constraint violation” bug you were seeing here.

12

It works !
Thank you so much for your help !