| Re: [Galette-discussion] Ajout de contribution ..en erreur |
[ Thread Index |
Date Index
| More lists.galette.eu/users Archives
]
- To: users@xxxxxxxxxxxxxxxx
- Subject: Re: [Galette-discussion] Ajout de contribution ..en erreur
- From: Michel Verdier <anatole404@xxxxxxxxx>
- Date: Tue, 31 Mar 2020 16:23:41 +0200
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=PaB9lDhYAPcZbt2xMszj6dJtcIWxaUqn70lOykiSqw4=; b=KViKdfDI5iaHbuGlxZUKBWBP4rituehVXiY1Qd19/4o60Wa7z2d+A44viNpqsciF7O laGsG1MQ9bf44+3yaegeEHmMRt3zrk0bSD6o1K/PslJK3/Ooxfa+vCvilAJe/JgIFzVZ 2Oz1v2DcpEvb+bKseHxOuY7Qda5OEp8uyVriw+HGNELZzq+3VD3yuD/aJNgxL5ED8WFs 8g6MtX86OyLFQJb1tGZhvT3qy2KDJVLhkSBnaguC3JXBDwsoCvc8++OeyDNk4kq49E1L H3HpyzQoGVP80vqQHMLmhkUzmett8hyRniWWne7M1mGLZ4ufZ4jQkLdRywo2VqBlCtLN rTSw==
Bonjour
J'ai avancé...
Même erreur en 931, çà provient apparemment de la base :
109.234.161.31 - 2020-03-31 14:05:07 - 4 - Call to __get for 'appears_in_list' is forbidden!
109.234.161.31 - 2020-03-31 14:05:07 - 4 - Call to __get for 'active' is forbidden!
109.234.161.31 - 2020-03-31 14:05:07 - 4 - Call to __get for 'admin' is forbidden!
109.234.161.31 - 2020-03-31 14:05:07 - 4 - Call to __get for 'due_free' is forbidden!
109.234.161.31 - 2020-03-31 14:05:17 - 3 - Query error: INSERT INTO `galette_cotisations` (`id_adh`, `id_type_cotis`, `montant_cotis`, `type_paiement_cotis`, `info_cotis`, `date_enreg`, `date_debut_cotis`, `date_fin_cotis`) VALUES ('287', '1', '50', '3', '', '2020-03-31', '2020-03-31', '2021-01-01') PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`leclub40_TEUFTEUF`.`galette_cotisations`, CONSTRAINT `galette_cotisations_ibfk_2` FOREIGN KEY (`id_adh`) REFERENCES `galette_adherentsSV2` (`id_adh`) ON UPDATE CASCADE) in /home/leclub40/public_html/galetteTT931/vendor/zendframework/zend-db/src/Adapter/Driver/Pdo/Connection.php:379
Stack trace:
........
Je joints le fichier log.
une idée ?
Merci
Michel
Le sam. 28 mars 2020 à 10:08, Johan Cwiklinski <
johan@xxxxxxxx> a écrit :
Salut,
Le 25/03/2020 à 19:58, Michel Verdier a écrit :
> Bonjour à tous
> J'ai le message ci-dessous à l'ajout d'une cotisation......galette 9.3
> image.png
> Fonctionnement normal sur la partie 'adhérent"
> Rien dans galette_logs .
>
>
> Des pistes de recherche ?
> Je voudrais éviter de tout réinstaller....ayant chargé la base...
Ben réinstaller ne servirait probablement pas à grand chose, surtout si
on ne sait pas quelle est l'erreur ; et pour le coup je n'en ai aucune idée.
Il faudrait passer en mode DEV pour savoir ce qui se passe exactement
(avec un peu de chance).
Et sinon, il faudrait savoir si ça se reproduit tout le temps, ou si
c'est sur un adhérent ou une contribution spécifique, etc.
++
--
Johan
109.234.161.31 - 2020-03-31 14:05:07 - 4 - Call to __get for 'appears_in_list' is forbidden!
109.234.161.31 - 2020-03-31 14:05:07 - 4 - Call to __get for 'active' is forbidden!
109.234.161.31 - 2020-03-31 14:05:07 - 4 - Call to __get for 'admin' is forbidden!
109.234.161.31 - 2020-03-31 14:05:07 - 4 - Call to __get for 'due_free' is forbidden!
109.234.161.31 - 2020-03-31 14:05:17 - 3 - Query error: INSERT INTO `galette_cotisations` (`id_adh`, `id_type_cotis`, `montant_cotis`, `type_paiement_cotis`, `info_cotis`, `date_enreg`, `date_debut_cotis`, `date_fin_cotis`) VALUES ('287', '1', '50', '3', '', '2020-03-31', '2020-03-31', '2021-01-01') PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`leclub40_TEUFTEUF`.`galette_cotisations`, CONSTRAINT `galette_cotisations_ibfk_2` FOREIGN KEY (`id_adh`) REFERENCES `galette_adherentsSV2` (`id_adh`) ON UPDATE CASCADE) in /home/leclub40/public_html/galetteTT931/vendor/zendframework/zend-db/src/Adapter/Driver/Pdo/Connection.php:379
Stack trace:
#0 /home/leclub40/public_html/galetteTT931/vendor/zendframework/zend-db/src/Adapter/Driver/Pdo/Connection.php(379): PDO->query('INSERT INTO `ga...')
#1 /home/leclub40/public_html/galetteTT931/vendor/zendframework/zend-db/src/Adapter/Adapter.php(205): Zend\Db\Adapter\Driver\Pdo\Connection->execute('INSERT INTO `ga...')
#2 /home/leclub40/public_html/galetteTT931/lib/Galette/Core/Db.php(777): Zend\Db\Adapter\Adapter->query('INSERT INTO `ga...', 'execute')
#3 /home/leclub40/public_html/galetteTT931/lib/Galette/Entity/Contribution.php(584): Galette\Core\Db->execute(Object(Zend\Db\Sql\Insert))
#4 /home/leclub40/public_html/galetteTT931/includes/routes/contributions.routes.php(509): Galette\Entity\Contribution->store()
#5 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#6 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#7 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#8 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(237): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#9 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route))
#10 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#11 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route))
#12 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route))
#13 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#14 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#15 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/App.php(503): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response))
#16 /home/leclub40/public_html/galetteTT931/vendor/akrabat/rka-slim-session-middleware/RKA/SessionMiddleware.php(47): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#17 [internal function]: RKA\SessionMiddleware->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#18 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(RKA\SessionMiddleware), Array)
#19 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#20 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#21 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(438): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#22 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#23 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#24 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#25 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#26 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(464): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#27 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#28 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#29 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#30 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#31 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(528): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#32 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#33 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#34 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#35 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#36 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(584): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#37 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#38 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#39 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#40 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#41 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#42 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#43 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/App.php(297): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response))
#44 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(597): Slim\App->run()
#45 /home/leclub40/public_html/galetteTT931/webroot/index.php(58): require_once('/home/leclub40/...')
#46 {main}
109.234.161.31 - 2020-03-31 14:05:17 - 3 - Something went wrong :'( | SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`leclub40_TEUFTEUF`.`galette_cotisations`, CONSTRAINT `galette_cotisations_ibfk_2` FOREIGN KEY (`id_adh`) REFERENCES `galette_adherentsSV2` (`id_adh`) ON UPDATE CASCADE)
#0 /home/leclub40/public_html/galetteTT931/vendor/zendframework/zend-db/src/Adapter/Driver/Pdo/Connection.php(379): PDO->query('INSERT INTO `ga...')
#1 /home/leclub40/public_html/galetteTT931/vendor/zendframework/zend-db/src/Adapter/Adapter.php(205): Zend\Db\Adapter\Driver\Pdo\Connection->execute('INSERT INTO `ga...')
#2 /home/leclub40/public_html/galetteTT931/lib/Galette/Core/Db.php(777): Zend\Db\Adapter\Adapter->query('INSERT INTO `ga...', 'execute')
#3 /home/leclub40/public_html/galetteTT931/lib/Galette/Entity/Contribution.php(584): Galette\Core\Db->execute(Object(Zend\Db\Sql\Insert))
#4 /home/leclub40/public_html/galetteTT931/includes/routes/contributions.routes.php(509): Galette\Entity\Contribution->store()
#5 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#6 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#7 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#8 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(237): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#9 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route))
#10 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#11 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route))
#12 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route))
#13 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#14 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#15 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/App.php(503): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response))
#16 /home/leclub40/public_html/galetteTT931/vendor/akrabat/rka-slim-session-middleware/RKA/SessionMiddleware.php(47): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#17 [internal function]: RKA\SessionMiddleware->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#18 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(RKA\SessionMiddleware), Array)
#19 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#20 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#21 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(438): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#22 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#23 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#24 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#25 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#26 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(464): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#27 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#28 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#29 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#30 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#31 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(528): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#32 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#33 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#34 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#35 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#36 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(584): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#37 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#38 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#39 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#40 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#41 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#42 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#43 /home/leclub40/public_html/galetteTT931/vendor/slim/slim/Slim/App.php(297): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response))
#44 /home/leclub40/public_html/galetteTT931/includes/main.inc.php(597): Slim\App->run()
#45 /home/leclub40/public_html/galetteTT931/webroot/index.php(58): require_once('/home/leclub40/...')
#46 {main}