Misconfiguration on Group module

Hi!

I just did install Daniel Berthereau’s Group module.

Even when it appears as a “correct” instalation, when I look back to my Items page, a error is adviced: Omeka has encounter an error.

No logs are logged on logs/*.log.

But when in development mode, a much more detailed (but even senseless to me) error displays.

Seems to be something related to bad syntax on MYSQL, but not sure where a how to fix it.

This is (I did shorten the Stack trace lines. Dont know if useful):

 Doctrine\DBAL\Exception\SyntaxErrorException
 An exception occurred while executing 'SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.comment AS comment_2 FROM groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resource_id IN (?)) INNER JOIN (item i2_ INNER JOIN resource r3_ ON i2_.id = r3_.id) ON (g1_.resource_id = r3_.id) GROUP BY g0_.id ORDER BY g0_.id ASC' with params [26]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resou' at line 1
 
 Detalles:
 
 PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resou' at line 1 in /var/www/my-omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
 Stack trace:
 #0 /var/www/my-omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)
 #1 /var/www/my-omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(905): Doctrine\DBAL\Driver\PDOStatement->execute()
 #2 /var/www/my-omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT g0_.id A...', Array, Array, NULL)
 ...
     
 Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resou' at line 1 in /var/www/my-omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
 Stack trace:
 #0 /var/www/my-omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(905): Doctrine\DBAL\Driver\PDOStatement->execute()
 #1 /var/www/my-omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT g0_.id A...', Array, Array, NULL)
 #2 /var/www/my-omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(337): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
 #3 /var/www/my-omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(992): Doctrine\ORM\Query->_doExecute()
 ...
 
 Next Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing 'SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.comment AS comment_2 FROM groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resource_id IN (?)) INNER JOIN (item i2_ INNER JOIN resource r3_ ON i2_.id = r3_.id) ON (g1_.resource_id = r3_.id) GROUP BY g0_.id ORDER BY g0_.id ASC' with params [26]:
 
 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resou' at line 1 in /var/www/my-omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79
 Stack trace:
 #0 /var/www/my-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 /var/www/my-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 /var/www/my-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 g0_.id A...', Array)
 #3 /var/www/my-omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT g0_.id A...', Array, Array, NULL)
 ...

I don’t know neither if this forum is the right place to ask for help, but I don´t see to many action on Daniel’s Gitlab Issues.
Thanks in advance.

Hi!
Any idea?
No help in Daniel’s gitlab too… :sob:

Hi,

Sorry not to answer before, I skip some messages and notifications since some weeks.

In your log, the important lines are the ones with “modules/Group”, but they are skipped here, so I can’t know where is the issue in the module.

I run the sql you logged in an omeka install and it works fine. So I need to know more precise info of your install (database server). And upgrade your modules Guest first, there are issues that were fixed.

Hi
Same error here after moving the Omeka S 2.1.2 to a new server with MySQL 8.x. Group module version is 3.0.4

 Doctrine\DBAL\Exception\SyntaxErrorException
An exception occurred while executing 'SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.comment AS comment_2 FROM groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resource_id IN (?)) INNER JOIN (item i2_ INNER JOIN resource r3_ ON i2_.id = r3_.id) ON (g1_.resource_id = r3_.id) GROUP BY g0_.id ORDER BY g0_.id ASC' with params [18492]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resou' at line 1

Detalls:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resou' at line 1 in /www/omekatest/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /www/omekatest/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)
#1 /www/omekatest/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(905): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT g0_.id A...', Array, Array, NULL)
#3 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(337): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(992): Doctrine\ORM\Query->_doExecute()
#5 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(947): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#6 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(750): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#7 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(177): Doctrine\ORM\AbstractQuery->getResult(1)
#8 /www/omekatest/application/src/Api/Adapter/AbstractEntityAdapter.php(257): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#9 /www/omekatest/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#10 /www/omekatest/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#11 /www/omekatest/modules/Group/Module.php(543): Omeka\Api\Manager->search('groups', Array, Array)
#12 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Group\Module->filterEntityJsonLd(Object(Zend\EventManager\Event))
#13 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(144): Zend\EventManager\EventManager->triggerListeners(Object(Zend\EventManager\Event))
#14 /www/omekatest/application/src/Api/Representation/AbstractResourceRepresentation.php(95): Zend\EventManager\EventManager->trigger('rep.resource.js...', Object(Omeka\Api\Representation\ItemRepresentation), Object(ArrayObject))
#15 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize()
#16 /www/omekatest/application/src/Api/Representation/AbstractResourceRepresentation.php(290): json_encode(Object(Omeka\Api\Representation\ItemRepresentation))
#17 /www/omekatest/application/Module.php(165): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd()
#18 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Omeka\Module->Omeka\{closure}(Object(Zend\EventManager\Event))
#19 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners(Object(Zend\EventManager\Event))
#20 /www/omekatest/application/src/View/Helper/Trigger.php(61): Zend\EventManager\EventManager->triggerEvent(Object(Zend\EventManager\Event))
#21 [internal function]: Omeka\View\Helper\Trigger->__invoke('view.browse.aft...')
#22 /www/omekatest/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(397): call_user_func_array(Object(Omeka\View\Helper\Trigger), Array)
#23 /www/omekatest/application/view/omeka/admin/item/browse.phtml(136): Zend\View\Renderer\PhpRenderer->__call('trigger', Array)
#24 /www/omekatest/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/www/omekatest...')
#25 /www/omekatest/vendor/zendframework/zend-view/src/View.php(207): Zend\View\Renderer\PhpRenderer->render(NULL)
#26 /www/omekatest/vendor/zendframework/zend-view/src/View.php(236): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
#27 /www/omekatest/vendor/zendframework/zend-view/src/View.php(200): Zend\View\View->renderChildren(Object(Zend\View\Model\ViewModel))
#28 /www/omekatest/vendor/zendframework/zend-mvc/src/View/Http/DefaultRenderingStrategy.php(105): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
#29 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Zend\Mvc\MvcEvent))
#30 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent))
#31 /www/omekatest/vendor/zendframework/zend-mvc/src/Application.php(367): Zend\EventManager\EventManager->triggerEvent(Object(Zend\Mvc\MvcEvent))
#32 /www/omekatest/vendor/zendframework/zend-mvc/src/Application.php(348): Zend\Mvc\Application->completeRequest(Object(Zend\Mvc\MvcEvent))
#33 /www/omekatest/index.php(21): Zend\Mvc\Application->run()
#34 {main}

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resou' at line 1 in /www/omekatest/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
Stack trace:
#0 /www/omekatest/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(905): Doctrine\DBAL\Driver\PDOStatement->execute()
#1 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT g0_.id A...', Array, Array, NULL)
#2 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(337): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#3 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(992): Doctrine\ORM\Query->_doExecute()
#4 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(947): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#5 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(750): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#6 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(177): Doctrine\ORM\AbstractQuery->getResult(1)
#7 /www/omekatest/application/src/Api/Adapter/AbstractEntityAdapter.php(257): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#8 /www/omekatest/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#9 /www/omekatest/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#10 /www/omekatest/modules/Group/Module.php(543): Omeka\Api\Manager->search('groups', Array, Array)
#11 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Group\Module->filterEntityJsonLd(Object(Zend\EventManager\Event))
#12 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(144): Zend\EventManager\EventManager->triggerListeners(Object(Zend\EventManager\Event))
#13 /www/omekatest/application/src/Api/Representation/AbstractResourceRepresentation.php(95): Zend\EventManager\EventManager->trigger('rep.resource.js...', Object(Omeka\Api\Representation\ItemRepresentation), Object(ArrayObject))
#14 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize()
#15 /www/omekatest/application/src/Api/Representation/AbstractResourceRepresentation.php(290): json_encode(Object(Omeka\Api\Representation\ItemRepresentation))
#16 /www/omekatest/application/Module.php(165): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd()
#17 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Omeka\Module->Omeka\{closure}(Object(Zend\EventManager\Event))
#18 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners(Object(Zend\EventManager\Event))
#19 /www/omekatest/application/src/View/Helper/Trigger.php(61): Zend\EventManager\EventManager->triggerEvent(Object(Zend\EventManager\Event))
#20 [internal function]: Omeka\View\Helper\Trigger->__invoke('view.browse.aft...')
#21 /www/omekatest/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(397): call_user_func_array(Object(Omeka\View\Helper\Trigger), Array)
#22 /www/omekatest/application/view/omeka/admin/item/browse.phtml(136): Zend\View\Renderer\PhpRenderer->__call('trigger', Array)
#23 /www/omekatest/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/www/omekatest...')
#24 /www/omekatest/vendor/zendframework/zend-view/src/View.php(207): Zend\View\Renderer\PhpRenderer->render(NULL)
#25 /www/omekatest/vendor/zendframework/zend-view/src/View.php(236): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
#26 /www/omekatest/vendor/zendframework/zend-view/src/View.php(200): Zend\View\View->renderChildren(Object(Zend\View\Model\ViewModel))
#27 /www/omekatest/vendor/zendframework/zend-mvc/src/View/Http/DefaultRenderingStrategy.php(105): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
#28 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Zend\Mvc\MvcEvent))
#29 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent))
#30 /www/omekatest/vendor/zendframework/zend-mvc/src/Application.php(367): Zend\EventManager\EventManager->triggerEvent(Object(Zend\Mvc\MvcEvent))
#31 /www/omekatest/vendor/zendframework/zend-mvc/src/Application.php(348): Zend\Mvc\Application->completeRequest(Object(Zend\Mvc\MvcEvent))
#32 /www/omekatest/index.php(21): Zend\Mvc\Application->run()
#33 {main}

Next Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing 'SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.comment AS comment_2 FROM groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resource_id IN (?)) INNER JOIN (item i2_ INNER JOIN resource r3_ ON i2_.id = r3_.id) ON (g1_.resource_id = r3_.id) GROUP BY g0_.id ORDER BY g0_.id ASC' with params [18492]:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g0_ INNER JOIN group_resource g1_ ON (g1_.group_id = g0_.id AND g1_.resou' at line 1 in /www/omekatest/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79
Stack trace:
#0 /www/omekatest/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(169): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 /www/omekatest/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 /www/omekatest/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 g0_.id A...', Array)
#3 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT g0_.id A...', Array, Array, NULL)
#4 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(337): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#5 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(992): Doctrine\ORM\Query->_doExecute()
#6 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(947): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#7 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(750): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#8 /www/omekatest/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(177): Doctrine\ORM\AbstractQuery->getResult(1)
#9 /www/omekatest/application/src/Api/Adapter/AbstractEntityAdapter.php(257): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#10 /www/omekatest/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#11 /www/omekatest/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#12 /www/omekatest/modules/Group/Module.php(543): Omeka\Api\Manager->search('groups', Array, Array)
#13 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Group\Module->filterEntityJsonLd(Object(Zend\EventManager\Event))
#14 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(144): Zend\EventManager\EventManager->triggerListeners(Object(Zend\EventManager\Event))
#15 /www/omekatest/application/src/Api/Representation/AbstractResourceRepresentation.php(95): Zend\EventManager\EventManager->trigger('rep.resource.js...', Object(Omeka\Api\Representation\ItemRepresentation), Object(ArrayObject))
#16 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize()
#17 /www/omekatest/application/src/Api/Representation/AbstractResourceRepresentation.php(290): json_encode(Object(Omeka\Api\Representation\ItemRepresentation))
#18 /www/omekatest/application/Module.php(165): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd()
#19 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Omeka\Module->Omeka\{closure}(Object(Zend\EventManager\Event))
#20 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners(Object(Zend\EventManager\Event))
#21 /www/omekatest/application/src/View/Helper/Trigger.php(61): Zend\EventManager\EventManager->triggerEvent(Object(Zend\EventManager\Event))
#22 [internal function]: Omeka\View\Helper\Trigger->__invoke('view.browse.aft...')
#23 /www/omekatest/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(397): call_user_func_array(Object(Omeka\View\Helper\Trigger), Array)
#24 /www/omekatest/application/view/omeka/admin/item/browse.phtml(136): Zend\View\Renderer\PhpRenderer->__call('trigger', Array)
#25 /www/omekatest/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/www/omekatest...')
#26 /www/omekatest/vendor/zendframework/zend-view/src/View.php(207): Zend\View\Renderer\PhpRenderer->render(NULL)
#27 /www/omekatest/vendor/zendframework/zend-view/src/View.php(236): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
#28 /www/omekatest/vendor/zendframework/zend-view/src/View.php(200): Zend\View\View->renderChildren(Object(Zend\View\Model\ViewModel))
#29 /www/omekatest/vendor/zendframework/zend-mvc/src/View/Http/DefaultRenderingStrategy.php(105): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
#30 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Zend\Mvc\MvcEvent))
#31 /www/omekatest/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent))
#32 /www/omekatest/vendor/zendframework/zend-mvc/src/Application.php(367): Zend\EventManager\EventManager->triggerEvent(Object(Zend\Mvc\MvcEvent))
#33 /www/omekatest/vendor/zendframework/zend-mvc/src/Application.php(348): Zend\Mvc\Application->completeRequest(Object(Zend\Mvc\MvcEvent))
#34 /www/omekatest/index.php(21): Zend\Mvc\Application->run()
#35 {main}

I don’t manage Omeka S v2. Is there a missing module that prevent you to upgrade?

The issue is related to the mysql now default option “only_full_group_by”, that requires to use “any_value()” or “min()” in some queries.