Misconfiguration on Group module

TierraComun · March 31, 2021, 9:39pm

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.

TierraComun · April 16, 2021, 6:25pm

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

Daniel_KM · April 30, 2021, 8:42am

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.

nuna · June 17, 2021, 3:58am

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}

Daniel_KM · July 21, 2021, 1:58pm

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

Daniel_KM · July 21, 2021, 2:00pm

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.

nuna · November 20, 2021, 3:27pm

Same issue on Omeka S 3.1.0, Group module v3.3.4.1 on MySQL 8.x.
In my case the error appears when select Items or Groups on Admin panel.
Is there any forecast to fix it in future versions? any workaround meanwhile?
It will be great!!!
Thanks

Daniel_KM · November 29, 2021, 6:04pm

This is fixed in version 3.3.4.2.

system · August 6, 2022, 6:04pm

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