Dolibarr ERP & CRM » Bugs » bug #1634 can not delete a project / impossible de supprimer un projetLatest modifications
Answer now
Snapshot| Details |
| Submitted by: | Carole ARNAUD (dlb-krol) | | Submitted on: | 2014-11-12 15:10 |
| Last Modified On: | 2015-01-21 12:54 | |
| Summary: | can not delete a project / impossible de supprimer un projet |
| Description: | il s'agissait d'un projet clôture contenant des taches, des contacts et des objets associés
see below the error message / ci dessous le message d'erreur
------
ERROR: 23503: update or delete on table 'llx_projet' violates foreign key constraint 'fk_facture_fk_projet' on table 'llx_facture' DETAIL: Key (rowid)=(1) is still referenced from table 'llx_facture'. SCHEMA NAME: public TABLE NAME: llx_facture CONSTRAINT NAME: fk_facture_fk_projet LOCATION: ri_ReportViolation, ri_triggers.c:3243, ERROR: 23503: update or delete on table 'llx_projet' violates foreign key constraint 'fk_facture_fk_projet' on table 'llx_facture' DETAIL: Key (rowid)=(1) is still referenced from table 'llx_facture'. SCHEMA NAME: public TABLE NAME: llx_facture CONSTRAINT NAME: fk_facture_fk_projet LOCATION: ri_ReportViolation, ri_triggers.c:3243
ERROR: 23503: update or delete on table 'llx_projet' violates foreign key constraint 'fk_facture_fk_projet' on table 'llx_facture' DETAIL: Key (rowid)=(1) is still referenced from table 'llx_facture'. SCHEMA NAME: public TABLE NAME: llx_facture CONSTRAINT NAME: fk_facture_fk_projet LOCATION: ri_ReportViolation, ri_triggers.c:3243
ERROR: 23503: update or delete on table 'llx_projet' violates foreign key constraint 'fk_facture_fk_projet' on table 'llx_facture' DETAIL: Key (rowid)=(1) is still referenced from table 'llx_facture'. SCHEMA NAME: public TABLE NAME: llx_facture CONSTRAINT NAME: fk_facture_fk_projet LOCATION: ri_ReportViolation, ri_triggers.c:3243 |
| Step to reproduce bug: | |
| Detected in version: | 3.7.0 | | Category: | Module: Projects |
| Severity: | 5 - Major | | OS Type/Version: | |
| PHP version: | | | Database type and version: | |
| Status |
| Status: | Open | | Assigned to: | Marcos García (marcosgdf) |
| Resolution: | Fixed | |
Comments- Marcos García 2015-07-19 14:58
- The bug has been corrected. Pull request send inside GIT sources
(http://www.github.com/Dolibarr/dolibarr) and waiting to merge
into develop branch. - Carole ARNAUD 2014-12-26 08:41
- I think the deletion of an open project should be restricted (with an informing message: "an open project can't be deleted").
However, it should be possible to delete a closed project with a warning: "This action will delete all the tasks and remove all references to the project. Confirm the deletion?"
- Marcos García 2014-12-25 22:39
- What is the desirable behaviour? To remove all references to the project or to restrict the deletion of the project?
|
|
(http://www.github.com/Dolibarr/dolibarr) and waiting to merge
into develop branch.
HENRY Florian (fhenry)→ Marcos García (marcosgdf)None→ Fixed