Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0041168
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2019-06-25 09:432019-06-25 10:24
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version3.0PR19Q3
StatusclosedFix in branchFixed in SCM revision058029790c67
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0041168: API Change: on delete cascade added to ad_alert.ad_alertrule_id foreign key

DescriptionThe ad_alert.ad_alertrule_id foreign key has been modified in this issue [1] to fix a problem that could result in a failed update.database when removing a module.

To Openbravo users, the only difference now is that when they remove an alert rule that had an alert, the alert will be removed along with the alert rule. Before the change, the alert rule deletion failed and an error message was shown to the user.

[1] https://issues.openbravo.com/view.php?id=41149 [^]
Steps To Reproduce-
TagsApproved
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
caused by defect 0041149 closedAugustoMauch It is not possible to delete a module if an alert rule references one of its tabs 

-  Notes
(0112997)
AugustoMauch (manager)
2019-06-25 10:20

Approved by DME
(0112998)
hgbot (developer)
2019-06-25 10:22

Repository: erp/devel/api-checks
Changeset: 058029790c67cfae359587d5145e2ac3f83e7676
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue Jun 25 10:22:12 2019 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/058029790c67cfae359587d5145e2ac3f83e7676 [^]

Fixes issue 41168: API Change, on delete cascade added to foreign key

An on delete cascade clause has been added to ad_alert.ad_alertrule_id foreign key.

Without it, update.database would fail when removing a module that defined a tab
that was referenced by an alert rule, if that alert rule had generated any alerts.

---
M model/src-db/database/model/tables/AD_ALERT.xml
---
(0113000)
caristu (developer)
2019-06-25 10:24

Reviewed

- Issue History
Date Modified Username Field Change
2019-06-25 09:43 AugustoMauch New Issue
2019-06-25 09:43 AugustoMauch Assigned To => AugustoMauch
2019-06-25 09:43 AugustoMauch Modules => Core
2019-06-25 09:43 AugustoMauch Triggers an Emergency Pack => No
2019-06-25 10:18 dmitry_mezentsev Tag Attached: Approved
2019-06-25 10:20 AugustoMauch Note Added: 0112997
2019-06-25 10:22 hgbot Checkin
2019-06-25 10:22 hgbot Note Added: 0112998
2019-06-25 10:22 hgbot Status new => resolved
2019-06-25 10:22 hgbot Resolution open => fixed
2019-06-25 10:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/058029790c67cfae359587d5145e2ac3f83e7676 [^]
2019-06-25 10:23 AugustoMauch Relationship added caused by 0041149
2019-06-25 10:24 caristu Review Assigned To => caristu
2019-06-25 10:24 caristu Note Added: 0113000
2019-06-25 10:24 caristu Status resolved => closed
2019-06-25 10:24 caristu Fixed in Version => 3.0PR19Q3


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker