New installation: Doctrine \ DBAL \ Exception \ DriverException

Permalink 0 0 Browser Info Environment
After installing, without error, then navigating to:

https://cms.localnet/index.php/dashboard/users/search...

The following error was thrown:

Doctrine\DBAL\Exception\DriverException thrown with message "An exception occurred while executing 'SELECT u.uID, u.uDateAdded FROM Users u LEFT JOIN UserSearchIndexAttributes ua ON u.uID = ua.uID WHERE (u.uIsActive = ?) AND (u.uIsValidated != 0) GROUP BY u.uID ORDER BY u.uDateAdded desc, u.uID desc LIMIT 10 OFFSET 0' with params [true]:

SQLSTATE[42000]: Syntax error or access violation: 1055 'testdb.u.uDateAdded' isn't in GROUP BY"

Stacktrace:
#37 Doctrine\DBAL\Exception\DriverException in /srv/web/test/cms/public/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
#36 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /srv/web/test/cms/public/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
#35 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /srv/web/test/cms/public/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855
#34 Doctrine\DBAL\Driver\PDOException in /srv/web/test/cms/public/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107
#33 PDOException in /srv/web/test/cms/public/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
#32 PDOStatement:execute in /srv/web/test/cms/public/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
#31 Doctrine\DBAL\Driver\PDOStatement:execute in /srv/web/test/cms/public/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:847
#30 Doctrine\DBAL\Connection:executeQuery in /srv/web/test/cms/public/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:206
#29 Doctrine\DBAL\Query\QueryBuilder:execute in /srv/web/test/cms/public/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Adapter/DoctrineDbalAdapter.php:73
#28 Pagerfanta\Adapter\DoctrineDbalAdapter:getSlice in /srv/web/test/cms/public/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Pagerfanta.php:319
#27 Pagerfanta\Pagerfanta:getCurrentPageResultsFromAdapter in /srv/web/test/cms/public/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Pagerfanta.php:303
#26 Pagerfanta\Pagerfanta:getCurrentPageResults in /srv/web/test/cms/public/concrete/src/Search/Pagination/Pagination.php:111
#25 Concrete\Core\Search\Pagination\Pagination:getCurrentPageResults in /srv/web/test/cms/public/concrete/src/Search/Result/Result.php:117
#24 Concrete\Core\Search\Result\Result:getItems in /srv/web/test/cms/public/concrete/src/Search/Result/Result.php:163
#23 Concrete\Core\Search\Result\Result:getJSONObject in /srv/web/test/cms/public/concrete/single_pages/dashboard/users/search.php:376
#22 include in /srv/web/test/cms/public/concrete/src/View/View.php:267
#21 Concrete\Core\View\View:renderInnerContents in /srv/web/test/cms/public/concrete/src/View/View.php:245
#20 Concrete\Core\View\View:renderViewContents in /srv/web/test/cms/public/concrete/src/View/AbstractView.php:164
#19 Concrete\Core\View\AbstractView:render in /srv/web/test/cms/public/concrete/src/Http/ResponseFactory.php:149
#18 Concrete\Core\Http\ResponseFactory:view in /srv/web/test/cms/public/concrete/src/Http/ResponseFactory.php:216
#17 Concrete\Core\Http\ResponseFactory:controller in /srv/web/test/cms/public/concrete/src/Http/ResponseFactory.php:367
#16 Concrete\Core\Http\ResponseFactory:collection in /srv/web/test/cms/public/concrete/src/Http/DefaultDispatcher.php:130
#15 Concrete\Core\Http\DefaultDispatcher:handleDispatch in /srv/web/test/cms/public/concrete/src/Http/DefaultDispatcher.php:58
#14 Concrete\Core\Http\DefaultDispatcher:dispatch in /srv/web/test/cms/public/concrete/src/Http/Middleware/DispatcherDelegate.php:39
#13 Concrete\Core\Http\Middleware\DispatcherDelegate:next in /srv/web/test/cms/public/concrete/src/Http/Middleware/ThumbnailMiddleware.php:76
#12 Concrete\Core\Http\Middleware\ThumbnailMiddleware:process in /srv/web/test/cms/public/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#11 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /srv/web/test/cms/public/concrete/src/Http/Middleware/FrameOptionsMiddleware.php:39
#10 Concrete\Core\Http\Middleware\FrameOptionsMiddleware:process in /srv/web/test/cms/public/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#9 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /srv/web/test/cms/public/concrete/src/Http/Middleware/CookieMiddleware.php:35
#8 Concrete\Core\Http\Middleware\CookieMiddleware:process in /srv/web/test/cms/public/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#7 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /srv/web/test/cms/public/concrete/src/Http/Middleware/ApplicationMiddleware.php:29
#6 Concrete\Core\Http\Middleware\ApplicationMiddleware:process in /srv/web/test/cms/public/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#5 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /srv/web/test/cms/public/concrete/src/Http/Middleware/MiddlewareStack.php:86
#4 Concrete\Core\Http\Middleware\MiddlewareStack:process in /srv/web/test/cms/public/concrete/src/Http/DefaultServer.php:85
#3 Concrete\Core\Http\DefaultServer:handleRequest in /srv/web/test/cms/public/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:128
#2 Concrete\Core\Foundation\Runtime\Run\DefaultRunner:run in /srv/web/test/cms/public/concrete/src/Foundation/Runtime/DefaultRuntime.php:102
#1 Concrete\Core\Foundation\Runtime\DefaultRuntime:run in /srv/web/test/cms/public/concrete/dispatcher.php:45
#0 require in /srv/web/test/cms/public/index.php:3


Status: New

concrete5 Environment Information

Linux kernel 5.8.3
PHP 7.3.13
MariaDB 10.4.8

Browser User-Agent String

Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.193 Safari/537.36