Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0041168 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | minor | have not tried | 2019-06-25 09:43 | 2019-06-25 10:24 | |||
Reporter | AugustoMauch | View Status | public | |||||
Assigned To | AugustoMauch | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR19Q3 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 058029790c67 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | caristu | |||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0041168: API Change: on delete cascade added to ad_alert.ad_alertrule_id foreign key | |||||||
Description | The 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 | - | |||||||
Tags | Approved | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(0112997) AugustoMauch (administrator) 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 (viewer) 2019-06-25 10:24 |
Reviewed |
![]() |
|||
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 | OBNetwork customer | => No |
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 |