View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000217 | vhffs-dev | -- other -- | public | 2007-07-06 15:44 | 2015-02-23 08:15 |
Reporter | misric | Assigned To | Beuss | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Summary | 0000217: Erreur lors du lancement du robot de suppression de ML | ||||
Description | erreur 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» | ||||
Tags | No tags attached. | ||||
|
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 |
|
Exact, le problème n'apparaît plus ! |
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 |