Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021672Openbravo ERPA. Platformpublic2012-09-17 14:172012-09-17 17:17
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP16Fixed in Version3.0MP16 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021672: API change: Added delete on cascade constraint
DescriptionIn the fix of issue https://issues.openbravo.com/view.php?id=21634, [^] an delete on constraint constraint was added to the obuiapp_note.ad_table_id column, this breaks the API.

This constraint was needed because it is not possible to uninstall a module when a note has been posted on a table related to it.

The only change the users may notice is that now if a table containing notes is deleted, the table will be actually deleted along with its notes.
Steps To ReproduceInstall module having any new table. Add a note to a record in that table.
Uninstall the module having the table.
Rebuild. -> fails
As fk from obuiapp_note.ad_table_id does not have onDelete cascade notes related to the deleted table do not get deleted as well.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0021634 closed AugustoMauch obuiapp_note.ad_table_id is missing onDeleteCascade 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-09-17 14:17AugustoMauchNew Issue
2012-09-17 14:17AugustoMauchAssigned To => AugustoMauch
2012-09-17 14:17AugustoMauchModules => Core
2012-09-17 14:17AugustoMauchOBNetwork customer => No
2012-09-17 14:20AugustoMauchRelationship addedrelated to 0021634
2012-09-17 14:20AugustoMauchAssigned ToAugustoMauch => iciordia
2012-09-17 16:44iciordiaNote Added: 0052172
2012-09-17 16:44iciordiaAssigned Toiciordia => AugustoMauch
2012-09-17 17:14hgbotCheckin
2012-09-17 17:14hgbotNote Added: 0052173
2012-09-17 17:14hgbotStatusnew => resolved
2012-09-17 17:14hgbotResolutionopen => fixed
2012-09-17 17:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/425718995c3090713e68c8fd6e6371559bf2f11b [^]
2012-09-17 17:17AugustoMauchClosed by => AugustoMauch
2012-09-17 17:17AugustoMauchStatusresolved => closed
2012-09-17 17:17AugustoMauchFixed in Version => 3.0MP16

Notes
(0052172)
iciordia   
2012-09-17 16:44   
Approved.

Ismael
(0052173)
hgbot   
2012-09-17 17:14   
Repository: erp/devel/api-checks
Changeset: 425718995c3090713e68c8fd6e6371559bf2f11b
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Sep 17 17:13:17 2012 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/425718995c3090713e68c8fd6e6371559bf2f11b [^]

Fixes issue 21672: Added delete on cascade to obuiapp_note.ad_table_id column

---
M model/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NOTE.xml
---