An error occurred

An error occurred during execution; please try again later.


Additional information:

Doctrine\DBAL\Exception\DriverException

File:
/var/www/html/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128
Message:
An exception occurred while executing 'SELECT DISTINCT c0_.isocode AS isocode_0, e1_.label AS label_1, e1_.group_name AS group_name_2, e1_.color AS color_3 FROM users u2_ INNER JOIN users_countries u3_ ON u2_.id = u3_.user_id INNER JOIN countries c0_ ON c0_.id = u3_.country_id INNER JOIN users_evaluation_types u4_ ON u2_.id = u4_.user_id INNER JOIN evaluation_type e1_ ON e1_.id = u4_.evaluation_type_id WHERE u2_.workgroup_id <> ? ORDER BY c0_.id ASC' with params ["USER"]:

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'procuracoop.c0_.id' which is not in SELECT list; this is incompatible with DISTINCT
Stack trace:
#0 /var/www/html/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDO\Exception))
#1 /var/www/html/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), 'An exception oc...')
#2 /var/www/html/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2121): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), 'SELECT DISTINCT...', Array)
#3 /var/www/html/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1264): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'SELECT DISTINCT...', Array, Array)
#4 /var/www/html/html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT DISTINCT...', Array, Array, NULL)
#5 /var/www/html/html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(338): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#6 /var/www/html/html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1000): Doctrine\ORM\Query->_doExecute()
#7 /var/www/html/html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(954): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 2)
#8 /var/www/html/html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(757): Doctrine\ORM\AbstractQuery->execute(NULL, 2)
#9 /var/www/html/html/module/User/src/Service/UserEvaluationTypeService.php(88): Doctrine\ORM\AbstractQuery->getResult(2)
#10 /var/www/html/html/module/Page/src/View/Helper/MapHelper.php(54): User\Service\UserEvaluationTypeService->getWorkshopsByCountry()
#11 [internal function]: Page\View\Helper\MapHelper->__invoke()
#12 /var/www/html/html/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(396): call_user_func_array(Object(Page\View\Helper\MapHelper), Array)
#13 /var/www/html/html/module/Page/view/page/page/home/map.phtml(1): Laminas\View\Renderer\PhpRenderer->__call('homeMap', Array)
#14 /var/www/html/html/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(505): include('/var/www/html/h...')
#15 /var/www/html/html/vendor/laminas/laminas-view/src/Helper/Partial.php(61): Laminas\View\Renderer\PhpRenderer->render(NULL, NULL)
#16 [internal function]: Laminas\View\Helper\Partial->__invoke('partial/home/ma...')
#17 /var/www/html/html/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(396): call_user_func_array(Object(Laminas\View\Helper\Partial), Array)
#18 /var/www/html/html/module/Page/view/page/page/home.phtml(5): Laminas\View\Renderer\PhpRenderer->__call('partial', Array)
#19 /var/www/html/html/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(505): include('/var/www/html/h...')
#20 /var/www/html/html/vendor/laminas/laminas-view/src/View.php(206): Laminas\View\Renderer\PhpRenderer->render(NULL)
#21 /var/www/html/html/vendor/laminas/laminas-view/src/View.php(235): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#22 /var/www/html/html/vendor/laminas/laminas-view/src/View.php(199): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#23 /var/www/html/html/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(104): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#24 /var/www/html/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(331): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#25 /var/www/html/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(180): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#26 /var/www/html/html/vendor/laminas/laminas-mvc/src/Application.php(366): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#27 /var/www/html/html/vendor/laminas/laminas-mvc/src/Application.php(347): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#28 /var/www/html/html/public/index.php(40): Laminas\Mvc\Application->run()
#29 {main}

Previous exceptions: