I downloaded the new version 3.5.9.3 and was able to install it.
But when I modify a resource, when it should generate an Ark for it, I get the following error:
Doctrine\DBAL\Exception\DriverException
An exception occurred while executing ‘SELECT value.resource_id, resource.resource_type FROM value value INNER JOIN resource resource ON resource.id = value.resource_id WHERE (value.property_id = 10) AND (value.type = “literal”) AND (value.value = ?) GROUP BY value.resource_id ORDER BY value.resource_id ASC, value.id ASC LIMIT 1’ with params [“ark:/67375/CG291Xd4bN3H”]: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘omekas_db.value.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Détails :
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘omekas_db.value.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /applis/omekas/home/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /applis/omekas/home/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)
#1 /applis/omekas/home/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(905): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /applis/omekas/home/www/omeka-s/modules/Ark/src/ArkManager.php(565): Doctrine\DBAL\Connection->executeQuery(‘SELECT value.re…’, Array)
#3 /applis/omekas/home/www/omeka-s/modules/Ark/src/ArkManager.php(526): Ark\ArkManager->findStatic(‘ark:/67375/CG29…’)
#4 /applis/omekas/home/www/omeka-s/modules/Ark/src/ArkManager.php(380): Ark\ArkManager->arkExists(‘ark:/67375/CG29…’)
#5 /applis/omekas/home/www/omeka-s/modules/Ark/Module.php(254): Ark\ArkManager->createName(Object(Omeka\Api\Representation\ItemRepresentation))
#6 /applis/omekas/home/www/omeka-s/modules/Ark/Module.php(215): Ark\Module->addArk(Object(Omeka\Entity\Item))
#7 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Ark\Module->handleSaveResource(Object(Laminas\EventManager\Event))
#8 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#9 /applis/omekas/home/www/omeka-s/application/src/Api/Manager.php(323): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#10 /applis/omekas/home/www/omeka-s/application/src/Api/Manager.php(269): Omeka\Api\Manager->finalize(Object(Omeka\Api\Adapter\ItemAdapter), Object(Omeka\Api\Request), Object(Omeka\Api\Response))
#11 /applis/omekas/home/www/omeka-s/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#12 /applis/omekas/home/www/omeka-s/application/src/Mvc/Controller/Plugin/Api.php(152): Omeka\Api\Manager->update(‘items’, ‘1230’, Array, Array, Array)
#13 /applis/omekas/home/www/omeka-s/application/src/Controller/Admin/ItemController.php(245): Omeka\Mvc\Controller\Plugin\Api->update(‘items’, ‘1230’, Array, Array)
#14 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ItemController->editAction()
#15 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#16 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#17 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#18 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#19 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#20 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#21 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#22 /applis/omekas/home/www/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#23 {main}
Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘omekas_db.value.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /applis/omekas/home/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
Stack trace:
#0 /applis/omekas/home/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(905): Doctrine\DBAL\Driver\PDOStatement->execute()
#1 /applis/omekas/home/www/omeka-s/modules/Ark/src/ArkManager.php(565): Doctrine\DBAL\Connection->executeQuery(‘SELECT value.re…’, Array)
#2 /applis/omekas/home/www/omeka-s/modules/Ark/src/ArkManager.php(526): Ark\ArkManager->findStatic(‘ark:/67375/CG29…’)
#3 /applis/omekas/home/www/omeka-s/modules/Ark/src/ArkManager.php(380): Ark\ArkManager->arkExists(‘ark:/67375/CG29…’)
#4 /applis/omekas/home/www/omeka-s/modules/Ark/Module.php(254): Ark\ArkManager->createName(Object(Omeka\Api\Representation\ItemRepresentation))
#5 /applis/omekas/home/www/omeka-s/modules/Ark/Module.php(215): Ark\Module->addArk(Object(Omeka\Entity\Item))
#6 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Ark\Module->handleSaveResource(Object(Laminas\EventManager\Event))
#7 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#8 /applis/omekas/home/www/omeka-s/application/src/Api/Manager.php(323): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#9 /applis/omekas/home/www/omeka-s/application/src/Api/Manager.php(269): Omeka\Api\Manager->finalize(Object(Omeka\Api\Adapter\ItemAdapter), Object(Omeka\Api\Request), Object(Omeka\Api\Response))
#10 /applis/omekas/home/www/omeka-s/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#11 /applis/omekas/home/www/omeka-s/application/src/Mvc/Controller/Plugin/Api.php(152): Omeka\Api\Manager->update(‘items’, ‘1230’, Array, Array, Array)
#12 /applis/omekas/home/www/omeka-s/application/src/Controller/Admin/ItemController.php(245): Omeka\Mvc\Controller\Plugin\Api->update(‘items’, ‘1230’, Array, Array)
#13 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ItemController->editAction()
#14 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#15 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#16 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#17 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#18 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#19 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#20 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#21 /applis/omekas/home/www/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#22 {main}
Next Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT value.resource_id, resource.resource_type FROM value value INNER JOIN resource resource ON resource.id = value.resource_id WHERE (value.property_id = 10) AND (value.type = “literal”) AND (value.value = ?) GROUP BY value.resource_id ORDER BY value.resource_id ASC, value.id ASC LIMIT 1’ with params [“ark:/67375/CG291Xd4bN3H”]:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘omekas_db.value.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /applis/omekas/home/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106
Stack trace:
#0 /applis/omekas/home/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(169): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDOException))
#1 /applis/omekas/home/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(145): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘An exception oc…’)
#2 /applis/omekas/home/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(913): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘SELECT value.re…’, Array)
#3 /applis/omekas/home/www/omeka-s/modules/Ark/src/ArkManager.php(565): Doctrine\DBAL\Connection->executeQuery(‘SELECT value.re…’, Array)
#4 /applis/omekas/home/www/omeka-s/modules/Ark/src/ArkManager.php(526): Ark\ArkManager->findStatic(‘ark:/67375/CG29…’)
#5 /applis/omekas/home/www/omeka-s/modules/Ark/src/ArkManager.php(380): Ark\ArkManager->arkExists(‘ark:/67375/CG29…’)
#6 /applis/omekas/home/www/omeka-s/modules/Ark/Module.php(254): Ark\ArkManager->createName(Object(Omeka\Api\Representation\ItemRepresentation))
#7 /applis/omekas/home/www/omeka-s/modules/Ark/Module.php(215): Ark\Module->addArk(Object(Omeka\Entity\Item))
#8 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Ark\Module->handleSaveResource(Object(Laminas\EventManager\Event))
#9 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#10 /applis/omekas/home/www/omeka-s/application/src/Api/Manager.php(323): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#11 /applis/omekas/home/www/omeka-s/application/src/Api/Manager.php(269): Omeka\Api\Manager->finalize(Object(Omeka\Api\Adapter\ItemAdapter), Object(Omeka\Api\Request), Object(Omeka\Api\Response))
#12 /applis/omekas/home/www/omeka-s/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#13 /applis/omekas/home/www/omeka-s/application/src/Mvc/Controller/Plugin/Api.php(152): Omeka\Api\Manager->update(‘items’, ‘1230’, Array, Array, Array)
#14 /applis/omekas/home/www/omeka-s/application/src/Controller/Admin/ItemController.php(245): Omeka\Mvc\Controller\Plugin\Api->update(‘items’, ‘1230’, Array, Array)
#15 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ItemController->editAction()
#16 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#17 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#18 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#19 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#20 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#21 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#22 /applis/omekas/home/www/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#23 /applis/omekas/home/www/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#24 {main}