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 <[email protected]> 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}
