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

[Doliforge]

Ce message ne s'affiche pas correctement? mettez à jour vos préférences utilisateur.

Dolibarr ERP & CRM » Bugs » bug #1634

can not delete a project / impossible de supprimer un projet

Dernières modifications

Carole ARNAUD (dlb-krol)

26/12/2014 07:41 (GMT)

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?"

Répondre

État

Détails
Submitted by:	Carole ARNAUD (dlb-krol)		Submitted on:	12/11/2014 14:10
Last Modified On:	25/12/2014 21:39
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:	develop		Category:	Module: Projects
Severity:	5 - Major		OS Type/Version:
PHP version:			Database type and version:
Etat
Status:	Open		Assigned to:	HENRY Florian (fhenry)
Resolution:	Aucun

Commentaires

Carole ARNAUD 26/12/2014 07: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 25/12/2014 21:39

What is the desirable behaviour? To remove all references to the project or to restrict the deletion of the project?

 Lien direct vers l'artefact  |  Mettre à jour vos préférences