Actions
Anomalie #1364
closedSQL error creating contribution
Start date:
11/26/2019
Due date:
% Done:
100%
Estimated time:
Version utilisée:
Vote:
Description
::1 - 2019-11-26 19:12:39 - 3 - Query error: SELECT MAX(date_fin_cotis) AS `max_date` FROM `galette_cotisations` AS `c` INNER JOIN `galette_types_cotisation` AS `ct` ON `c`.`id_type_cotis`=`ct`.`id_type_cotis` WHERE id_adh = AND `cotis_extension` = true PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 Erreur de syntaxe près de 'AND `cotis_extension` = true' à la ligne 1 in B:\galette\galette\vendor\zendframework\zend-db\src\Adapter\Driver\Pdo\Connection.php:379 Stack trace: #0 B:\galette\galette\vendor\zendframework\zend-db\src\Adapter\Driver\Pdo\Connection.php(379): PDO->query('SELECT MAX(date...') #1 B:\galette\galette\vendor\zendframework\zend-db\src\Adapter\Adapter.php(205): Zend\Db\Adapter\Driver\Pdo\Connection->execute('SELECT MAX(date...') #2 B:\galette\galette\lib\Galette\Core\Db.php(777): Zend\Db\Adapter\Adapter->query('SELECT MAX(date...', 'execute') #3 B:\galette\galette\lib\Galette\Entity\Contribution.php(811): Galette\Core\Db->execute(Object(Zend\Db\Sql\Select)) #4 B:\galette\galette\lib\Galette\Entity\Contribution.php(180): Galette\Entity\Contribution::getDueDate(Object(Galette\Core\Db), NULL) #5 B:\galette\galette\includes\routes\contributions.routes.php(346): Galette\Entity\Contribution->__construct(Object(Galette\Core\Db), Object(Galette\Core\Login), Array) #6 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #7 B:\galette\galette\vendor\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(40): call_user_func(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #8 B:\galette\galette\vendor\slim\slim\Slim\Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #9 B:\galette\galette\includes\main.inc.php(237): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response)) #10 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route)) #11 B:\galette\galette\vendor\slim\slim\Slim\DeferredCallable.php(57): call_user_func_array(Object(Closure), Array) #12 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route)) #13 B:\galette\galette\vendor\slim\slim\Slim\MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route)) #14 B:\galette\galette\vendor\slim\slim\Slim\MiddlewareAwareTrait.php(117): Slim\Route->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #15 B:\galette\galette\vendor\slim\slim\Slim\Route.php(268): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response)) #16 B:\galette\galette\vendor\slim\slim\Slim\App.php(503): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response)) #17 B:\galette\galette\vendor\akrabat\rka-slim-session-middleware\RKA\SessionMiddleware.php(47): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response)) #18 [internal function]: RKA\SessionMiddleware->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App)) #19 B:\galette\galette\vendor\slim\slim\Slim\DeferredCallable.php(57): call_user_func_array(Object(RKA\SessionMiddleware), Array) #20 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App)) #21 B:\galette\galette\vendor\slim\slim\Slim\MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App)) #22 B:\galette\galette\includes\main.inc.php(438): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #23 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #24 B:\galette\galette\vendor\slim\slim\Slim\DeferredCallable.php(57): call_user_func_array(Object(Closure), Array) #25 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #26 B:\galette\galette\vendor\slim\slim\Slim\MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #27 B:\galette\galette\includes\main.inc.php(464): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #28 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #29 B:\galette\galette\vendor\slim\slim\Slim\DeferredCallable.php(57): call_user_func_array(Object(Closure), Array) #30 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #31 B:\galette\galette\vendor\slim\slim\Slim\MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #32 B:\galette\galette\includes\main.inc.php(528): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #33 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #34 B:\galette\galette\vendor\slim\slim\Slim\DeferredCallable.php(57): call_user_func_array(Object(Closure), Array) #35 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #36 B:\galette\galette\vendor\slim\slim\Slim\MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #37 B:\galette\galette\includes\main.inc.php(584): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #38 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #39 B:\galette\galette\vendor\slim\slim\Slim\DeferredCallable.php(57): call_user_func_array(Object(Closure), Array) #40 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #41 B:\galette\galette\vendor\slim\slim\Slim\MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure)) #42 B:\galette\galette\vendor\slim\slim\Slim\MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response)) #43 B:\galette\galette\vendor\slim\slim\Slim\App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response)) #44 B:\galette\galette\vendor\slim\slim\Slim\App.php(297): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response)) #45 B:\galette\galette\includes\main.inc.php(597): Slim\App->run() #46 B:\galette\galette\webroot\index.php(58): require_once('B:\\galette\\gale...') #47 {main} ::1 - 2019-11-26 19:12:39 - 3 - An error occurred trying to retrieve member's due date
Updated by Johan Cwiklinski almost 5 years ago
- Status changed from In Progress to Résolu
- % Done changed from 0 to 100
Appliqué par commit cd63681dccdd5107c50ed5d0aa6efff895c4e960.
Updated by Johan Cwiklinski almost 5 years ago
- Status changed from Résolu to Fermé
- % Done changed from 100 to 0
Actions