|
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}
|