Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0020780 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| design defect | [Openbravo ERP] A. Platform | major | have not tried | 2012-06-15 10:12 | 2012-07-30 11:00 | |||
| Reporter | jecharri | View Status | public | |||||
| Assigned To | AugustoMauch | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | c7f7fd1bcc69 | ||||
| Projection | none | ETA | none | Target Version | 3.0MP14 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | Google Chrome | |||||||
| Modules | Core | |||||||
| Support ticket | 15882 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0020780: Bug in HBFix_data.xsql insert statement | |||||||
| Description | following code: <SqlMethod name="insert" type="preparedStatement" return="rowCount"> <Sql> <![CDATA[ INSERT INTO ad_process_request VALUES (get_uuid(), '0', '0', 'Y', NOW(), '100', NOW(), '100', '1005800000', NULL, '100', 'Y', ? , 'SCH', NULL, NULL, NULL, 'Process Scheduler', 'S', NOW(), NOW(), '4', NULL, NULL, NULL, 7, NULL, NULL, NULL, 'N', 'N', 'N', 'N', 'N', 'N','N', 'S', NULL, NULL, 'N', NULL, NULL, 'N', NULL, NULL, 'N', 'N', 'N', NULL)]]> The insert statement tries to insert into ad_process_request table without specifying columns, so if a module adds a new column to the table, the insert statement fails | |||||||
| Steps To Reproduce | - | |||||||
| Proposed Solution | The solution is to change the insert statement to: INSERT INTO ad_process_request(ad_process_request_id, ad_client_id, ad_org_id, ... [name of all core columns] ) VALUES (get_uuid(), etc.) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0050837) hgbot (developer) 2012-07-25 15:58 |
Repository: erp/devel/pi Changeset: c7f7fd1bcc69afe5349820fb3204aa99c15e0984 Author: Augusto Mauch <augusto.mauch <at> openbravo.com> Date: Wed Jul 25 15:58:04 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/c7f7fd1bcc69afe5349820fb3204aa99c15e0984 [^] Fixes issue 20780: Insert statement modified in xsql The insert statement in HBFix_data.xsql has been modified, and now specifies the columns where the values are being inserted. --- M src-util/modulescript/build/classes/org/openbravo/modulescript/HBFixData.class M src-util/modulescript/src/org/openbravo/modulescript/HBFix_data.xsql --- |
|
(0050885) hudsonbot (viewer) 2012-07-26 02:42 |
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/5edf203d5780 [^] Maturity status: Test |
|
(0050978) migueldejuana (viewer) 2012-07-30 11:00 |
Code reviewed: b6862b1e8f54. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-06-15 10:12 | jecharri | New Issue | |
| 2012-06-15 10:12 | jecharri | Assigned To | => alostale |
| 2012-06-15 10:12 | jecharri | Web browser | => Google Chrome |
| 2012-06-15 10:12 | jecharri | Modules | => Core |
| 2012-06-15 10:12 | jecharri | OBNetwork customer | => Yes |
| 2012-06-15 10:12 | jecharri | Support ticket | => 15882 |
| 2012-06-15 10:12 | jecharri | Resolution time | => 1339538400 |
| 2012-07-18 13:23 | shuehner | Issue Monitored: shuehner | |
| 2012-07-25 15:55 | AugustoMauch | Assigned To | alostale => AugustoMauch |
| 2012-07-25 15:58 | hgbot | Checkin | |
| 2012-07-25 15:58 | hgbot | Note Added: 0050837 | |
| 2012-07-25 15:58 | hgbot | Status | new => resolved |
| 2012-07-25 15:58 | hgbot | Resolution | open => fixed |
| 2012-07-25 15:58 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/c7f7fd1bcc69afe5349820fb3204aa99c15e0984 [^] |
| 2012-07-26 02:42 | hudsonbot | Checkin | |
| 2012-07-26 02:42 | hudsonbot | Note Added: 0050885 | |
| 2012-07-30 11:00 | migueldejuana | Note Added: 0050978 | |
| 2012-07-30 11:00 | migueldejuana | Status | resolved => closed |
| 2012-07-30 11:00 | migueldejuana | Fixed in Version | => pi |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |