VHFFS Bugs

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000217vhffs-dev-- other --public2007-07-06 15:442015-02-23 08:15
Reportermisric 
Assigned ToBeuss 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version4.1
Summary0000217: Erreur lors du lancement du robot de suppression de ML
Descriptionerreur du cron :

DBD::Pg::st execute failed: ERREUR: Les instructions update ou delete sur «vhffs_ml» viole la contrainte de clé étrangère «fk_vhffs_ml_subscribers_vhffs_ml» sur «vhffs_ml_subscribers»
DETAIL: La clé (ml_id)=(2) est toujours référencée à partir de la table «vhffs_ml_subscribers».
CONTEXT: instruction SQL «DELETE FROM ONLY "public"."vhffs_ml" WHERE "object_id" = $1»
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
(0000325)
Beuss (administrator)
2007-07-06 16:02

Je pense que ton schéma de base de données n'est pas à jour.

ALTER TABLE vhffs_ml_subscribers DROP CONSTRAINT fk_vhffs_ml_subscribers_vhffs_ml;
ALTER TABLE vhffs_ml_subscribers ADD CONSTRAINT fk_vhffs_ml_subscribers_vhffs_ml FOREIGN KEY (ml_id) REFERENCES vhffs_ml(ml_id) ON DELETE CASCADE;

devraient corriger le problème
(0000326)
misric (reporter)
2007-07-06 16:16

Exact, le problème n'apparaît plus !

- Issue History
Date Modified Username Field Change
2007-07-06 15:44 misric New Issue
2007-07-06 15:44 misric Status new => assigned
2007-07-06 15:44 misric Assigned To => Beuss
2007-07-06 16:02 Beuss Note Added: 0000325
2007-07-06 16:16 misric Note Added: 0000326
2007-07-06 17:09 Beuss Status assigned => resolved
2007-07-06 17:09 Beuss Resolution open => fixed
2015-02-23 08:15 gradator Status resolved => closed


Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker