Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010617 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 03. Procurement management | major | N/A | 2009-09-14 19:25 | 2009-10-13 08:12 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.40MP10 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 5a1857b90f63 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| 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 | 0010617: CreateFromMultiple_Receipt_data.xsql has optional filter on M_LOCATOR.M_LOCATOR_TYPE_ID which was removed in 2.3x -> 2.40 | |||||||
| Description | This xsql-file: src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Receipt_data.xsql has the following optional parameter: <Parameter name="mLocatortypeId" optional="true" after="AND 1=1" text=" AND L.M_LOCATOR_TYPE_ID = ? "/> referencing a now non-existant column m_locator_type_id in the m_locator table. This column was removed somewhere between 2.3x -> 2.40 Planned changes to speed up the build would execute the slqc-queries and also include this optional parameter in the query which will obviously fail. The query (and parameter) is used from the CreateFromMultiple servlet. | |||||||
| Proposed Solution | Remove the optional parameter from the xsql file (as the column does not exist) and check/remove/change the locator_type logic in the servlet. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0020101) hgbot (developer) 2009-09-15 21:28 |
Repository: erp/stable/2.40 Changeset: 5a1857b90f63a187dfd18340df2e47fdea1d3539 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Tue Sep 15 21:28:26 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/5a1857b90f63a187dfd18340df2e47fdea1d3539 [^] Fixed 10617: Fix sql error by removing filter on now non-existant column - The file did filter on m_locator.m_locator_type_id which was removed before 2.40 - Removes code the combobox for 'Locator Type' from the html,xml,java - Remove use and pass down to parameter of the m_locator_type_id value --- M src-db/database/sourcedata/AD_TEXTINTERFACES.xml M src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple.java M src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Receipt.html M src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Receipt.xml M src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Receipt_data.xsql --- |
|
(0020438) hgbot (developer) 2009-09-29 12:02 |
Repository: erp/stable/2.40_pageddatagrid Changeset: 5a1857b90f63a187dfd18340df2e47fdea1d3539 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Tue Sep 15 21:28:26 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/5a1857b90f63a187dfd18340df2e47fdea1d3539 [^] Fixed 10617: Fix sql error by removing filter on now non-existant column - The file did filter on m_locator.m_locator_type_id which was removed before 2.40 - Removes code the combobox for 'Locator Type' from the html,xml,java - Remove use and pass down to parameter of the m_locator_type_id value --- M src-db/database/sourcedata/AD_TEXTINTERFACES.xml M src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple.java M src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Receipt.html M src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Receipt.xml M src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Receipt_data.xsql --- |
|
(0020951) arunkumar (viewer) 2009-10-13 08:12 |
Tested & Working fine. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-09-15 20:57 | shuehner | Type | defect => backport |
| 2009-09-15 20:57 | shuehner | fix_in_branch | => 2.40 |
| 2009-09-15 21:28 | hgbot | Checkin | |
| 2009-09-15 21:28 | hgbot | Note Added: 0020101 | |
| 2009-09-15 21:28 | hgbot | Status | scheduled => resolved |
| 2009-09-15 21:28 | hgbot | Resolution | open => fixed |
| 2009-09-15 21:28 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/5a1857b90f63a187dfd18340df2e47fdea1d3539 [^] |
| 2009-09-29 12:02 | hgbot | Checkin | |
| 2009-09-29 12:02 | hgbot | Note Added: 0020438 | |
| 2009-09-29 12:02 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/stable/2.40/rev/5a1857b90f63a187dfd18340df2e47fdea1d3539 [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/5a1857b90f63a187dfd18340df2e47fdea1d3539 [^] |
| 2009-10-13 08:12 | arunkumar | Status | resolved => closed |
| 2009-10-13 08:12 | arunkumar | Note Added: 0020951 | |
| 2009-10-13 08:12 | arunkumar | Fixed in Version | => 2.40MP10 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |