Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0021634 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2012-09-12 20:18 | 2012-09-26 17:19 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | AugustoMauch | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0MP16 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 38acdd74058a | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | AugustoMauch | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0021634: obuiapp_note.ad_table_id is missing onDeleteCascade | |||||||
| Description | After adding a note entry to any record of some specific ad_table. It it not possible anymore to delete that table. Example case. Install 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. Imo they should same as the system does of course delete all the content of the table itself. | |||||||
| Steps To Reproduce | See description. | |||||||
| Proposed Solution | Add onDelete="cascade" to the obuiapp_note.ad_table_id foreign-key | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0052130) hgbot (developer) 2012-09-14 12:31 |
Repository: erp/devel/pi Changeset: 38acdd74058a16e99608f6e302e7b3fb140d2705 Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com> Date: Fri Sep 14 12:13:37 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/38acdd74058a16e99608f6e302e7b3fb140d2705 [^] Fixes Issue 21634 : Added Cascade delete to obuiapp_note.ad_table_id Added onDelete Cascade to ad_table_id field in obuiapp_note table. --- M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NOTE.xml --- |
|
(0052350) AugustoMauch (manager) 2012-09-24 16:52 |
Code reviewed and verified in pi@4c4431d17dbd |
|
(0052760) hudsonbot (developer) 2012-09-26 17:19 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b780e90c6452 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-09-12 20:18 | shuehner | New Issue | |
| 2012-09-12 20:18 | shuehner | Assigned To | => AugustoMauch |
| 2012-09-12 20:18 | shuehner | Modules | => Core |
| 2012-09-14 12:31 | hgbot | Checkin | |
| 2012-09-14 12:31 | hgbot | Note Added: 0052130 | |
| 2012-09-14 12:31 | hgbot | Status | new => resolved |
| 2012-09-14 12:31 | hgbot | Resolution | open => fixed |
| 2012-09-14 12:31 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/38acdd74058a16e99608f6e302e7b3fb140d2705 [^] |
| 2012-09-17 14:20 | AugustoMauch | Relationship added | related to 0021672 |
| 2012-09-24 16:52 | AugustoMauch | Closed by | => AugustoMauch |
| 2012-09-24 16:52 | AugustoMauch | Note Added: 0052350 | |
| 2012-09-24 16:52 | AugustoMauch | Status | resolved => closed |
| 2012-09-24 16:52 | AugustoMauch | Fixed in Version | => 3.0MP16 |
| 2012-09-26 17:19 | hudsonbot | Checkin | |
| 2012-09-26 17:19 | hudsonbot | Note Added: 0052760 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |