Bonjour, J'ai fait une mise à jour ce week-end de v1.1.6.2 vers 1.2.0.1. Depuis, je n'arrive plus à ajouter de nouveaux membres. Il s'agit d'une très vielle installation de galette qui a subit au fil des ans de nombreuses mises à jour. Je ne suis pas confiant à 100 % de l'état de la base de donnée... Voici le message d'erreur : 10.113.20.4 - 2025-12-08 20:25:13 - ERROR - Slim Application Error Type: PDOException Code: 23000 Message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`cadvoile367`.`gal_adherents`, CONSTRAINT `gal_adherents_ibfk_1` FOREIGN KEY (`id_statut`) REFERENCES `gal_statuts` (`id_statut`) ON DELETE RESTRICT ON UPDATE CASCADE) File: /home/cadvoile/www/membres/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Connection.php Line: 376 Trace: #0 /home/cadvoile/www/membres/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Connection.php(376): PDO->query('INSERT INTO `ga...') #1 /home/cadvoile/www/membres/vendor/laminas/laminas-db/src/Adapter/Adapter.php(196): Laminas\Db\Adapter\Driver\Pdo\Connection->execute('INSERT INTO `ga...') #2 /home/cadvoile/www/membres/lib/Galette/Core/Db.php(805): Laminas\Db\Adapter\Adapter->query('INSERT INTO `ga...', 'execute') #3 /home/cadvoile/www/membres/lib/Galette/Entity/Adherent.php(1734): Galette\Core\Db->execute(Object(Laminas\Db\Sql\Insert)) #4 /home/cadvoile/www/membres/lib/Galette/Controllers/Crud/MembersController.php(1798): Galette\Entity\Adherent->store() #5 /home/cadvoile/www/membres/lib/Galette/Controllers/Crud/MembersController.php(185): Galette\Controllers\Crud\MembersController->store(Object(Slim\Psr7\Request), Object(Slim\Psr7\Response)) #6 [internal function]: Galette\Controllers\Crud\MembersController->doAdd(Object(Slim\Psr7\Request), Object(Slim\Psr7\Response)) #7 /home/cadvoile/www/membres/vendor/php-di/invoker/src/Invoker.php(74): call_user_func_array(Array, Array) #8 /home/cadvoile/www/membres/vendor/php-di/slim-bridge/src/ControllerInvoker.php(45): Invoker\Invoker->call(Array, Array) #9 /home/cadvoile/www/membres/vendor/slim/slim/Slim/Routing/Route.php(362): DI\Bridge\Slim\ControllerInvoker->__invoke(Array, Object(Slim\Psr7\Request), Object(Slim\Psr7\Response), Array) #10 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(73): Slim\Routing\Route->handle(Object(Slim\Psr7\Request)) #11 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(73): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #12 /home/cadvoile/www/membres/vendor/slim/slim/Slim/Routing/Route.php(321): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #13 /home/cadvoile/www/membres/vendor/slim/slim/Slim/Routing/RouteRunner.php(74): Slim\Routing\Route->run(Object(Slim\Psr7\Request)) #14 /home/cadvoile/www/membres/vendor/akrabat/rka-slim-session-middleware/RKA/SessionMiddleware.php(66): Slim\Routing\RouteRunner->handle(Object(Slim\Psr7\Request)) #15 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): RKA\SessionMiddleware->process(Object(Slim\Psr7\Request), Object(Slim\Routing\RouteRunner)) #16 /home/cadvoile/www/membres/vendor/slim/csrf/src/Guard.php(482): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) #17 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): Slim\Csrf\Guard->process(Object(Slim\Psr7\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #18 /home/cadvoile/www/membres/lib/Galette/Middleware/Language.php(68): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) #19 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(178): Galette\Middleware\Language->__invoke(Object(Slim\Psr7\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #20 /home/cadvoile/www/membres/lib/Galette/Middleware/Telemetry.php(69): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) #21 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(178): Galette\Middleware\Telemetry->__invoke(Object(Slim\Psr7\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #22 /home/cadvoile/www/membres/includes/main.inc.php(176): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) #23 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(283): Closure->{closure}(Object(Slim\Psr7\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #24 /home/cadvoile/www/membres/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) #25 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): Slim\Middleware\RoutingMiddleware->process(Object(Slim\Psr7\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #26 /home/cadvoile/www/membres/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(77): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) #27 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): Slim\Middleware\ErrorMiddleware->process(Object(Slim\Psr7\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #28 /home/cadvoile/www/membres/vendor/slim/twig-view/src/TwigMiddleware.php(117): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) #29 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): Slim\Views\TwigMiddleware->process(Object(Slim\Psr7\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #30 /home/cadvoile/www/membres/vendor/slim/slim/Slim/MiddlewareDispatcher.php(73): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) #31 /home/cadvoile/www/membres/vendor/slim/slim/Slim/App.php(209): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #32 /home/cadvoile/www/membres/vendor/slim/slim/Slim/App.php(193): Slim\App->handle(Object(Slim\Psr7\Request)) #33 /home/cadvoile/www/membres/includes/main.inc.php(209): Slim\App->run() #34 /home/cadvoile/www/membres/webroot/index.php(50): require_once('/home/cadvoile/...') #35 {main} Voici le dump de la structure de la table gal_adherents: CREATE TABLE `gal_adherents` ( `id_adh` int UNSIGNED NOT NULL, `id_statut` int UNSIGNED NOT NULL, `nom_adh` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `prenom_adh` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `pseudo_adh` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `societe_adh` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `titre_adh` int UNSIGNED DEFAULT NULL, `ddn_adh` date DEFAULT NULL, `sexe_adh` smallint NOT NULL, `adresse_adh` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, `cp_adh` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `ville_adh` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `pays_adh` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `tel_adh` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `gsm_adh` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `email_adh` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `info_adh` longtext COLLATE utf8mb4_unicode_520_ci, `info_public_adh` longtext COLLATE utf8mb4_unicode_520_ci, `prof_adh` varchar(150) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `login_adh` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `mdp_adh` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', `date_crea_adh` date NOT NULL, `date_modif_adh` date NOT NULL, `activite_adh` tinyint(1) NOT NULL DEFAULT '0', `bool_admin_adh` tinyint(1) NOT NULL DEFAULT '0', `bool_exempt_adh` tinyint(1) NOT NULL DEFAULT '0', `bool_display_info` tinyint(1) NOT NULL DEFAULT '0', `date_echeance` date DEFAULT NULL, `pref_lang` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `lieu_naissance` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `gpgid` longtext COLLATE utf8mb4_unicode_520_ci, `fingerprint` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `parent_id` int UNSIGNED DEFAULT NULL, `num_adh` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `region_adh` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Index pour les tables déchargées -- -- -- Index pour la table `gal_adherents` -- ALTER TABLE `gal_adherents` ADD PRIMARY KEY (`id_adh`), ADD UNIQUE KEY `login_adh` (`login_adh`), ADD KEY `id_statut` (`id_statut`), ADD KEY `titre_adh` (`titre_adh`), ADD KEY `parent_id` (`parent_id`); -- -- AUTO_INCREMENT pour les tables déchargées -- -- -- AUTO_INCREMENT pour la table `gal_adherents` -- ALTER TABLE `gal_adherents` MODIFY `id_adh` int UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Contraintes pour les tables déchargées -- -- -- Contraintes pour la table `gal_adherents` -- ALTER TABLE `gal_adherents` ADD CONSTRAINT `gal_adherents_ibfk_1` FOREIGN KEY (`id_statut`) REFERENCES `gal_statuts` (`id_statut`) ON DELETE RESTRICT ON UPDATE CASCADE, ADD CONSTRAINT `gal_adherents_ibfk_2` FOREIGN KEY (`titre_adh`) REFERENCES `gal_titles` (`id_title`) ON DELETE RESTRICT ON UPDATE CASCADE, ADD CONSTRAINT `gal_adherents_ibfk_3` FOREIGN KEY (`parent_id`) REFERENCES `gal_adherents` (`id_adh`) ON DELETE RESTRICT ON UPDATE CASCADE; COMMIT; Merci d'avance pour votre aide, Antoine