Omeka S encountered an error
Doctrine\DBAL\Exception\DriverException
An exception occurred while executing 'SELECT r0_.id AS id_0, r0_.is_public AS is_public_1, r0_.created AS created_2, r0_.modified AS modified_3, a1_.part AS part_4, r0_.resource_type AS resource_type_5, r0_.owner_id AS owner_id_6, r0_.resource_class_id AS resource_class_id_7, r0_.resource_template_id AS resource_template_id_8, r0_.thumbnail_id AS thumbnail_id_9, a1_.annotation_id AS annotation_id_10 FROM annotation_part a1_ INNER JOIN resource r0_ ON a1_.id = r0_.id AND (r0_.is_public = 1) LEFT JOIN annotation a2_ ON a1_.id = a2_.id LEFT JOIN annotation_body a3_ ON a1_.id = a3_.id LEFT JOIN annotation_target a4_ ON a1_.id = a4_.id LEFT JOIN value v5_ ON r0_.id = v5_.resource_id AND (v5_.is_public = 1) AND (v5_.property_id = 232) WHERE (v5_.value_resource_id = ?) GROUP BY a1_.annotation_id ORDER BY a1_.annotation_id ASC' with params [8570]:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'omeka_prod.r0_.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Details:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'omeka_prod.r0_.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105 Stack trace: #0 /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOStatement->execute() #1 /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(847): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery() #3 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(321): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute() #4 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(962): Doctrine\ORM\Query->_doExecute() #5 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(917): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache() #6 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(720): Doctrine\ORM\AbstractQuery->execute() #7 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(171): Doctrine\ORM\AbstractQuery->getResult() #8 /var/www/omeka-s/modules/Annotate/src/Api/Adapter/AnnotationAdapter.php(154): Doctrine\ORM\Tools\Pagination\Paginator->getIterator() #9 /var/www/omeka-s/application/src/Api/Manager.php(221): Annotate\Api\Adapter\AnnotationAdapter->search() #10 /var/www/omeka-s/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute() #11 /var/www/omeka-s/modules/Annotate/Module.php(615): Omeka\Api\Manager->search() #12 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Annotate\Module->filterJsonLd() #13 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(144): Zend\EventManager\EventManager->triggerListeners() #14 /var/www/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(95): Zend\EventManager\EventManager->trigger() #15 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize() #16 /var/www/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(290): json_encode() #17 /var/www/omeka-s/application/Module.php(121): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd() #18 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Omeka\Module->Omeka\{closure}() #19 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners() #20 /var/www/omeka-s/application/src/View/Helper/Trigger.php(61): Zend\EventManager\EventManager->triggerEvent() #21 [internal function]: Omeka\View\Helper\Trigger->__invoke() #22 /var/www/omeka-s/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(397): call_user_func_array() #23 /var/www/omeka-s/application/view/omeka/site/item/show.phtml(50): Zend\View\Renderer\PhpRenderer->__call() #24 /var/www/omeka-s/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/var/www/omeka-...') #25 /var/www/omeka-s/vendor/zendframework/zend-view/src/View.php(207): Zend\View\Renderer\PhpRenderer->render() #26 /var/www/omeka-s/vendor/zendframework/zend-view/src/View.php(236): Zend\View\View->render() #27 /var/www/omeka-s/vendor/zendframework/zend-view/src/View.php(200): Zend\View\View->renderChildren() #28 /var/www/omeka-s/vendor/zendframework/zend-mvc/src/View/Http/DefaultRenderingStrategy.php(105): Zend\View\View->render() #29 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\View\Http\DefaultRenderingStrategy->render() #30 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners() #31 /var/www/omeka-s/vendor/zendframework/zend-mvc/src/Application.php(367): Zend\EventManager\EventManager->triggerEvent() #32 /var/www/omeka-s/vendor/zendframework/zend-mvc/src/Application.php(348): Zend\Mvc\Application->completeRequest() #33 /var/www/omeka-s/index.php(21): Zend\Mvc\Application->run() #34 {main} Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'omeka_prod.r0_.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107 Stack trace: #0 /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(847): Doctrine\DBAL\Driver\PDOStatement->execute() #1 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery() #2 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(321): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute() #3 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(962): Doctrine\ORM\Query->_doExecute() #4 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(917): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache() #5 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(720): Doctrine\ORM\AbstractQuery->execute() #6 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(171): Doctrine\ORM\AbstractQuery->getResult() #7 /var/www/omeka-s/modules/Annotate/src/Api/Adapter/AnnotationAdapter.php(154): Doctrine\ORM\Tools\Pagination\Paginator->getIterator() #8 /var/www/omeka-s/application/src/Api/Manager.php(221): Annotate\Api\Adapter\AnnotationAdapter->search() #9 /var/www/omeka-s/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute() #10 /var/www/omeka-s/modules/Annotate/Module.php(615): Omeka\Api\Manager->search() #11 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Annotate\Module->filterJsonLd() #12 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(144): Zend\EventManager\EventManager->triggerListeners() #13 /var/www/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(95): Zend\EventManager\EventManager->trigger() #14 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize() #15 /var/www/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(290): json_encode() #16 /var/www/omeka-s/application/Module.php(121): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd() #17 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Omeka\Module->Omeka\{closure}() #18 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners() #19 /var/www/omeka-s/application/src/View/Helper/Trigger.php(61): Zend\EventManager\EventManager->triggerEvent() #20 [internal function]: Omeka\View\Helper\Trigger->__invoke() #21 /var/www/omeka-s/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(397): call_user_func_array() #22 /var/www/omeka-s/application/view/omeka/site/item/show.phtml(50): Zend\View\Renderer\PhpRenderer->__call() #23 /var/www/omeka-s/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/var/www/omeka-...') #24 /var/www/omeka-s/vendor/zendframework/zend-view/src/View.php(207): Zend\View\Renderer\PhpRenderer->render() #25 /var/www/omeka-s/vendor/zendframework/zend-view/src/View.php(236): Zend\View\View->render() #26 /var/www/omeka-s/vendor/zendframework/zend-view/src/View.php(200): Zend\View\View->renderChildren() #27 /var/www/omeka-s/vendor/zendframework/zend-mvc/src/View/Http/DefaultRenderingStrategy.php(105): Zend\View\View->render() #28 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\View\Http\DefaultRenderingStrategy->render() #29 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners() #30 /var/www/omeka-s/vendor/zendframework/zend-mvc/src/Application.php(367): Zend\EventManager\EventManager->triggerEvent() #31 /var/www/omeka-s/vendor/zendframework/zend-mvc/src/Application.php(348): Zend\Mvc\Application->completeRequest() #32 /var/www/omeka-s/index.php(21): Zend\Mvc\Application->run() #33 {main} Next Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT r0_.id AS id_0, r0_.is_public AS is_public_1, r0_.created AS created_2, r0_.modified AS modified_3, a1_.part AS part_4, r0_.resource_type AS resource_type_5, r0_.owner_id AS owner_id_6, r0_.resource_class_id AS resource_class_id_7, r0_.resource_template_id AS resource_template_id_8, r0_.thumbnail_id AS thumbnail_id_9, a1_.annotation_id AS annotation_id_10 FROM annotation_part a1_ INNER JOIN resource r0_ ON a1_.id = r0_.id AND (r0_.is_public = 1) LEFT JOIN annotation a2_ ON a1_.id = a2_.id LEFT JOIN annotation_body a3_ ON a1_.id = a3_.id LEFT JOIN annotation_target a4_ ON a1_.id = a4_.id LEFT JOIN value v5_ ON r0_.id = v5_.resource_id AND (v5_.is_public = 1) AND (v5_.property_id = 232) WHERE (v5_.value_resource_id = ?) GROUP BY a1_.annotation_id ORDER BY a1_.annotation_id ASC' with params [8570]: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'omeka_prod.r0_.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115 Stack trace: #0 /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() #1 /var/www/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery() #2 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery() #3 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(321): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute() #4 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(962): Doctrine\ORM\Query->_doExecute() #5 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(917): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache() #6 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(720): Doctrine\ORM\AbstractQuery->execute() #7 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(171): Doctrine\ORM\AbstractQuery->getResult() #8 /var/www/omeka-s/modules/Annotate/src/Api/Adapter/AnnotationAdapter.php(154): Doctrine\ORM\Tools\Pagination\Paginator->getIterator() #9 /var/www/omeka-s/application/src/Api/Manager.php(221): Annotate\Api\Adapter\AnnotationAdapter->search() #10 /var/www/omeka-s/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute() #11 /var/www/omeka-s/modules/Annotate/Module.php(615): Omeka\Api\Manager->search() #12 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Annotate\Module->filterJsonLd() #13 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(144): Zend\EventManager\EventManager->triggerListeners() #14 /var/www/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(95): Zend\EventManager\EventManager->trigger() #15 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize() #16 /var/www/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(290): json_encode() #17 /var/www/omeka-s/application/Module.php(121): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd() #18 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Omeka\Module->Omeka\{closure}() #19 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners() #20 /var/www/omeka-s/application/src/View/Helper/Trigger.php(61): Zend\EventManager\EventManager->triggerEvent() #21 [internal function]: Omeka\View\Helper\Trigger->__invoke() #22 /var/www/omeka-s/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(397): call_user_func_array() #23 /var/www/omeka-s/application/view/omeka/site/item/show.phtml(50): Zend\View\Renderer\PhpRenderer->__call() #24 /var/www/omeka-s/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/var/www/omeka-...') #25 /var/www/omeka-s/vendor/zendframework/zend-view/src/View.php(207): Zend\View\Renderer\PhpRenderer->render() #26 /var/www/omeka-s/vendor/zendframework/zend-view/src/View.php(236): Zend\View\View->render() #27 /var/www/omeka-s/vendor/zendframework/zend-view/src/View.php(200): Zend\View\View->renderChildren() #28 /var/www/omeka-s/vendor/zendframework/zend-mvc/src/View/Http/DefaultRenderingStrategy.php(105): Zend\View\View->render() #29 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\View\Http\DefaultRenderingStrategy->render() #30 /var/www/omeka-s/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners() #31 /var/www/omeka-s/vendor/zendframework/zend-mvc/src/Application.php(367): Zend\EventManager\EventManager->triggerEvent() #32 /var/www/omeka-s/vendor/zendframework/zend-mvc/src/Application.php(348): Zend\Mvc\Application->completeRequest() #33 /var/www/omeka-s/index.php(21): Zend\Mvc\Application->run() #34 {main}