10.2.40.2 - 2021-02-13 13:47:49 - ERROR - Query error: SELECT date_format(date_enreg, '%Y-%m') AS `date`, SUM(montant_cotis) AS `amount` FROM `gestcom_cotisations` GROUP BY EXTRACT(YEAR_MONTH FROM date_enreg) ORDER BY `date` ASC PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ordiservre8.gestcom_cotisations.date_enreg' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /home/ordiserve/association4/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Connection.php:378 Stack trace: #0 /home/ordiserve/association4/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Connection.php(378): PDO->query('SELECT date_for...') #1 /home/ordiserve/association4/vendor/laminas/laminas-db/src/Adapter/Adapter.php(204): Laminas\Db\Adapter\Driver\Pdo\Connection->execute('SELECT date_for...') #2 /home/ordiserve/association4/lib/Galette/Core/Db.php(800): Laminas\Db\Adapter\Adapter->query('SELECT date_for...', 'execute') #3 /home/ordiserve/association4/lib/Galette/IO/Charts.php(374): Galette\Core\Db->execute(Object(Laminas\Db\Sql\Select)) #4 /home/ordiserve/association4/lib/Galette/IO/Charts.php(100): Galette\IO\Charts->getChartContribsAllTime() #5 /home/ordiserve/association4/lib/Galette/IO/Charts.php(88): Galette\IO\Charts->load() #6 /home/ordiserve/association4/lib/Galette/Controllers/GaletteController.php(465): Galette\IO\Charts->__construct(Array) #7 [internal function]: Galette\Controllers\GaletteController->charts(Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #8 /home/ordiserve/association4/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Array, Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #9 /home/ordiserve/association4/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #10 /home/ordiserve/association4/lib/Galette/Middleware/Authenticate.php(172): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response)) #11 [internal function]: Galette\Middleware\Authenticate->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route)) #12 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Galette\Middleware\Authenticate), Array) #13 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route)) #14 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route)) #15 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #16 /home/ordiserve/association4/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response)) #17 /home/ordiserve/association4/vendor/slim/slim/Slim/App.php(503): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response)) #18 /home/ordiserve/association4/vendor/akrabat/rka-slim-session-middleware/RKA/SessionMiddleware.php(47): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response)) #19 [internal function]: RKA\SessionMiddleware->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App)) #20 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(RKA\SessionMiddleware), Array) #21 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App)) #22 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App)) #23 /home/ordiserve/association4/lib/Galette/Middleware/TrailingSlash.php(81): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #24 [internal function]: Galette\Middleware\TrailingSlash->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #25 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Array, Array) #26 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #27 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #28 /home/ordiserve/association4/lib/Galette/Middleware/Language.php(103): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #29 [internal function]: Galette\Middleware\Language->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #30 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Array, Array) #31 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #32 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #33 /home/ordiserve/association4/lib/Galette/Middleware/Telemetry.php(144): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #34 [internal function]: Galette\Middleware\Telemetry->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #35 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Array, Array) #36 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #37 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #38 /home/ordiserve/association4/lib/Galette/Middleware/CheckAcls.php(143): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #39 [internal function]: Galette\Middleware\CheckAcls->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #40 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Array, Array) #41 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #42 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #43 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #44 /home/ordiserve/association4/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response)) #45 /home/ordiserve/association4/vendor/slim/slim/Slim/App.php(297): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response)) #46 /home/ordiserve/association4/includes/main.inc.php(187): Slim\App->run() #47 /home/ordiserve/association4/webroot/index.php(57): require_once('/home/ordiserve...') #48 {main} 10.2.40.2 - 2021-02-13 13:47:49 - ERROR - Galette error: Type: PDOException Code: 42000 Message: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ordiservre8.gestcom_cotisations.date_enreg' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by File: /home/ordiserve/association4/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Connection.php Line: 378 Trace: #0 /home/ordiserve/association4/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Connection.php(378): PDO->query('SELECT date_for...') #1 /home/ordiserve/association4/vendor/laminas/laminas-db/src/Adapter/Adapter.php(204): Laminas\Db\Adapter\Driver\Pdo\Connection->execute('SELECT date_for...') #2 /home/ordiserve/association4/lib/Galette/Core/Db.php(800): Laminas\Db\Adapter\Adapter->query('SELECT date_for...', 'execute') #3 /home/ordiserve/association4/lib/Galette/IO/Charts.php(374): Galette\Core\Db->execute(Object(Laminas\Db\Sql\Select)) #4 /home/ordiserve/association4/lib/Galette/IO/Charts.php(100): Galette\IO\Charts->getChartContribsAllTime() #5 /home/ordiserve/association4/lib/Galette/IO/Charts.php(88): Galette\IO\Charts->load() #6 /home/ordiserve/association4/lib/Galette/Controllers/GaletteController.php(465): Galette\IO\Charts->__construct(Array) #7 [internal function]: Galette\Controllers\GaletteController->charts(Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #8 /home/ordiserve/association4/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Array, Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #9 /home/ordiserve/association4/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #10 /home/ordiserve/association4/lib/Galette/Middleware/Authenticate.php(172): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response)) #11 [internal function]: Galette\Middleware\Authenticate->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route)) #12 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Galette\Middleware\Authenticate), Array) #13 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route)) #14 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route)) #15 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #16 /home/ordiserve/association4/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response)) #17 /home/ordiserve/association4/vendor/slim/slim/Slim/App.php(503): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response)) #18 /home/ordiserve/association4/vendor/akrabat/rka-slim-session-middleware/RKA/SessionMiddleware.php(47): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response)) #19 [internal function]: RKA\SessionMiddleware->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App)) #20 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(RKA\SessionMiddleware), Array) #21 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App)) #22 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App)) #23 /home/ordiserve/association4/lib/Galette/Middleware/TrailingSlash.php(81): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #24 [internal function]: Galette\Middleware\TrailingSlash->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #25 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Array, Array) #26 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #27 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #28 /home/ordiserve/association4/lib/Galette/Middleware/Language.php(103): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #29 [internal function]: Galette\Middleware\Language->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #30 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Array, Array) #31 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #32 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #33 /home/ordiserve/association4/lib/Galette/Middleware/Telemetry.php(144): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #34 [internal function]: Galette\Middleware\Telemetry->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #35 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Array, Array) #36 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #37 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #38 /home/ordiserve/association4/lib/Galette/Middleware/CheckAcls.php(143): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #39 [internal function]: Galette\Middleware\CheckAcls->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #40 /home/ordiserve/association4/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Array, Array) #41 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #42 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #43 /home/ordiserve/association4/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #44 /home/ordiserve/association4/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response)) #45 /home/ordiserve/association4/vendor/slim/slim/Slim/App.php(297): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response)) #46 /home/ordiserve/association4/includes/main.inc.php(187): Slim\App->run() #47 /home/ordiserve/association4/webroot/index.php(57): require_once('/home/ordiserve...') #48 {main}