Projet

Général

Profil

Anomalie #1539 » galette_run.log

Danielle Colin, 13/02/2021 14:57

 
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}
    (1-1/1)