Group Module - SQLSTATE[42000]: Syntax error or access violation: 1064

I am using Omeka S 3.1.1, Group module v3.3.4.1 with MySQL 8.x. When I select Items section or Group section in Admin panel an error is shown. If Group module is disabled the error disappears. Tested as well in a fresh installation with only one item.
With MySQL 5.7 it works properly.

The message error:

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 [1]: 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

Details:

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 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112
Stack trace:
#0 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(112): PDOStatement->execute(NULL)
#1 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1292): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(44): Doctrine\DBAL\Connection->executeQuery(‘SELECT g0_.id A…’, Array, Array, NULL)
#3 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1073): Doctrine\ORM\Query->_doExecute()
#5 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1027): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#6 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(791): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#7 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(177): Doctrine\ORM\AbstractQuery->getResult(1)
#8 /Users/test/www/app/public/omeka-s/application/src/Api/Adapter/AbstractEntityAdapter.php(299): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#9 /Users/test/www/app/public/omeka-s/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#10 /Users/test/www/app/public/omeka-s/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#11 /Users/test/www/app/public/omeka-s/modules/Group/src/Mvc/Controller/Plugin/ListGroups.php(76): Omeka\Api\Manager->search(‘groups’, Array, Array)
#12 /Users/test/www/app/public/omeka-s/modules/Group/Module.php(549): Group\Mvc\Controller\Plugin\ListGroups->__invoke(Object(Omeka\Api\Representation\ItemRepresentation), ‘reference’)
#13 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Group\Module->filterEntityJsonLd(Object(Laminas\EventManager\Event))
#14 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(143): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#15 /Users/test/www/app/public/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(95): Laminas\EventManager\EventManager->trigger(‘rep.resource.js…’, Object(Omeka\Api\Representation\ItemRepresentation), Object(ArrayObject))
#16 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize()
#17 /Users/test/www/app/public/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(290): json_encode(Object(Omeka\Api\Representation\ItemRepresentation))
#18 /Users/test/www/app/public/omeka-s/application/Module.php(183): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd()
#19 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Omeka\Module->Omeka{closure}(Object(Laminas\EventManager\Event))
#20 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#21 /Users/test/www/app/public/omeka-s/application/src/View/Helper/Trigger.php(60): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#22 [internal function]: Omeka\View\Helper\Trigger->__invoke(‘view.browse.aft…’)
#23 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(396): call_user_func_array(Object(Omeka\View\Helper\Trigger), Array)
#24 /Users/test/www/app/public/omeka-s/application/view/omeka/admin/item/browse.phtml(136): Laminas\View\Renderer\PhpRenderer->__call(‘trigger’, Array)
#25 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(505): include(’/Users/test…’)
#26 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/View.php(206): Laminas\View\Renderer\PhpRenderer->render(NULL)
#27 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/View.php(235): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#28 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/View.php(199): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#29 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(104): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#30 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#31 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#32 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(366): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#33 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(347): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#34 /Users/test/www/app/public/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#35 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: 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 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(114): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1292): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(44): Doctrine\DBAL\Connection->executeQuery(‘SELECT g0_.id A…’, Array, Array, NULL)
#3 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1073): Doctrine\ORM\Query->_doExecute()
#5 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1027): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#6 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(791): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#7 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(177): Doctrine\ORM\AbstractQuery->getResult(1)
#8 /Users/test/www/app/public/omeka-s/application/src/Api/Adapter/AbstractEntityAdapter.php(299): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#9 /Users/test/www/app/public/omeka-s/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#10 /Users/test/www/app/public/omeka-s/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#11 /Users/test/www/app/public/omeka-s/modules/Group/src/Mvc/Controller/Plugin/ListGroups.php(76): Omeka\Api\Manager->search(‘groups’, Array, Array)
#12 /Users/test/www/app/public/omeka-s/modules/Group/Module.php(549): Group\Mvc\Controller\Plugin\ListGroups->__invoke(Object(Omeka\Api\Representation\ItemRepresentation), ‘reference’)
#13 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Group\Module->filterEntityJsonLd(Object(Laminas\EventManager\Event))
#14 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(143): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#15 /Users/test/www/app/public/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(95): Laminas\EventManager\EventManager->trigger(‘rep.resource.js…’, Object(Omeka\Api\Representation\ItemRepresentation), Object(ArrayObject))
#16 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize()
#17 /Users/test/www/app/public/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(290): json_encode(Object(Omeka\Api\Representation\ItemRepresentation))
#18 /Users/test/www/app/public/omeka-s/application/Module.php(183): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd()
#19 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Omeka\Module->Omeka{closure}(Object(Laminas\EventManager\Event))
#20 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#21 /Users/test/www/app/public/omeka-s/application/src/View/Helper/Trigger.php(60): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#22 [internal function]: Omeka\View\Helper\Trigger->__invoke(‘view.browse.aft…’)
#23 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(396): call_user_func_array(Object(Omeka\View\Helper\Trigger), Array)
#24 /Users/test/www/app/public/omeka-s/application/view/omeka/admin/item/browse.phtml(136): Laminas\View\Renderer\PhpRenderer->__call(‘trigger’, Array)
#25 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(505): include(’/Users/test…’)
#26 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/View.php(206): Laminas\View\Renderer\PhpRenderer->render(NULL)
#27 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/View.php(235): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#28 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/View.php(199): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#29 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(104): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#30 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#31 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#32 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(366): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#33 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(347): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#34 /Users/test/www/app/public/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#35 {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 [1]:

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 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98
Stack trace:
#0 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDO\Exception))
#1 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‘An exception oc…’)
#2 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2214): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‘SELECT g0_.id A…’, Array)
#3 /Users/test/www/app/public/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1301): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), ‘SELECT g0_.id A…’, Array, Array)
#4 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(44): Doctrine\DBAL\Connection->executeQuery(‘SELECT g0_.id A…’, Array, Array, NULL)
#5 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#6 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1073): Doctrine\ORM\Query->_doExecute()
#7 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1027): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#8 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(791): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#9 /Users/test/www/app/public/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(177): Doctrine\ORM\AbstractQuery->getResult(1)
#10 /Users/test/www/app/public/omeka-s/application/src/Api/Adapter/AbstractEntityAdapter.php(299): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#11 /Users/test/www/app/public/omeka-s/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#12 /Users/test/www/app/public/omeka-s/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#13 /Users/test/www/app/public/omeka-s/modules/Group/src/Mvc/Controller/Plugin/ListGroups.php(76): Omeka\Api\Manager->search(‘groups’, Array, Array)
#14 /Users/test/www/app/public/omeka-s/modules/Group/Module.php(549): Group\Mvc\Controller\Plugin\ListGroups->__invoke(Object(Omeka\Api\Representation\ItemRepresentation), ‘reference’)
#15 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Group\Module->filterEntityJsonLd(Object(Laminas\EventManager\Event))
#16 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(143): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#17 /Users/test/www/app/public/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(95): Laminas\EventManager\EventManager->trigger(‘rep.resource.js…’, Object(Omeka\Api\Representation\ItemRepresentation), Object(ArrayObject))
#18 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize()
#19 /Users/test/www/app/public/omeka-s/application/src/Api/Representation/AbstractResourceRepresentation.php(290): json_encode(Object(Omeka\Api\Representation\ItemRepresentation))
#20 /Users/test/www/app/public/omeka-s/application/Module.php(183): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd()
#21 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Omeka\Module->Omeka{closure}(Object(Laminas\EventManager\Event))
#22 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#23 /Users/test/www/app/public/omeka-s/application/src/View/Helper/Trigger.php(60): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#24 [internal function]: Omeka\View\Helper\Trigger->__invoke(‘view.browse.aft…’)
#25 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(396): call_user_func_array(Object(Omeka\View\Helper\Trigger), Array)
#26 /Users/test/www/app/public/omeka-s/application/view/omeka/admin/item/browse.phtml(136): Laminas\View\Renderer\PhpRenderer->__call(‘trigger’, Array)
#27 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(505): include(’/Users/test…’)
#28 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/View.php(206): Laminas\View\Renderer\PhpRenderer->render(NULL)
#29 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/View.php(235): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#30 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-view/src/View.php(199): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#31 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(104): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#32 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#33 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#34 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(366): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#35 /Users/test/www/app/public/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(347): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#36 /Users/test/www/app/public/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#37 {main}

Hi,
It seems the problem could be related to the fact that the word “groups” is a reserved word added in MySQL 8.0.2 (MySQL :: MySQL 8.0 Reference Manual :: 9.3 Keywords and Reserved Words).
I have looked where the query is built but no luck.
Any help or idea?

Thanks, it’s fixed in version 3.3.4.2. I use mainly mariadb, that is used on main major linux distribution, so mysql is less tested.

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