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
_______________________________________________
Galette-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
