Project

General

Profile

Actions

Anomalie #1364

closed

SQL error creating contribution

Added by Johan Cwiklinski over 4 years ago. Updated over 4 years ago.

Status:
Fermé
Priority:
Normal
Category:
Core
Target version:
Start date:
11/26/2019
Due date:
% Done:

100%

Estimated time:
Version utilisée:

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
Actions #1

Updated by Johan Cwiklinski over 4 years ago

  • Status changed from In Progress to Résolu
  • % Done changed from 0 to 100
Actions #2

Updated by Johan Cwiklinski over 4 years ago

  • Status changed from Résolu to Fermé
  • % Done changed from 100 to 0
Actions #3

Updated by Johan Cwiklinski over 4 years ago

  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF