[Bug #1634] can not delete a project / impossible de supprimer un projet

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[Bug #1634] can not delete a project / impossible de supprimer un projet

Doliforge
[Bug #1634] can not delete a project / impossible de supprimer un projet
Doliforge
Is this email not displaying correctly?
update email preferences.

can not delete a project / impossible de supprimer un projet

Latest modifications

2015-07-19 14:58 (Europe/Madrid)
The bug has been corrected. Pull request send inside GIT sources
(http://www.github.com/Dolibarr/dolibarr) and waiting to merge
into develop branch.
Changes:
  • Assigned to: 
HENRY Florian (fhenry)Marcos García (marcosgdf)
  • Resolution: 
NoneFixed

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?


_______________________________________________
Dolibarr-bugtrack mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/dolibarr-bugtrack