Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010588 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 03. Procurement management | major | N/A | 2009-09-14 19:25 | 2009-10-06 11:27 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.50MP6 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 29c8320f0292 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010588: 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 |
|
|
(0019931) shuehner (administrator) 2009-09-14 19:26 |
Fix is needed in 2.40 and 2.50 as it blocks the speedup sqlc issue. |
|
(0020100) hgbot (developer) 2009-09-15 21:03 |
Repository: erp/devel/pi Changeset: 29c8320f0292a89cd372952a8d664605b5b88e94 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Tue Sep 15 21:03:23 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/29c8320f0292a89cd372952a8d664605b5b88e94 [^] Fixed 10588: 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 --- |
|
(0020470) hgbot (developer) 2009-09-29 14:12 |
Repository: erp/devel/pi-pageddatagrid Changeset: 29c8320f0292a89cd372952a8d664605b5b88e94 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Tue Sep 15 21:03:23 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/29c8320f0292a89cd372952a8d664605b5b88e94 [^] Fixed 10588: 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 --- |
|
(0020757) psarobe (manager) 2009-10-06 11:27 |
Closed again because hudson has reopened without no reason |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-09-14 19:25 | shuehner | New Issue | |
| 2009-09-14 19:25 | shuehner | Assigned To | => rafaroda |
| 2009-09-14 19:26 | shuehner | Note Added: 0019931 | |
| 2009-09-14 19:26 | shuehner | Relationship added | blocks 0004038 |
| 2009-09-15 20:57 | shuehner | Assigned To | rafaroda => shuehner |
| 2009-09-15 20:57 | shuehner | Status | new => scheduled |
| 2009-09-15 20:57 | shuehner | fix_in_branch | => pi |
| 2009-09-15 21:03 | hgbot | Checkin | |
| 2009-09-15 21:03 | hgbot | Note Added: 0020100 | |
| 2009-09-15 21:03 | hgbot | Status | scheduled => resolved |
| 2009-09-15 21:03 | hgbot | Resolution | open => fixed |
| 2009-09-15 21:03 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/29c8320f0292a89cd372952a8d664605b5b88e94 [^] |
| 2009-09-18 13:30 | psarobe | Status | resolved => closed |
| 2009-09-18 13:30 | psarobe | Fixed in Version | => 2.50MP6 |
| 2009-09-19 00:00 | anonymous | sf_bug_id | 0 => 2861737 |
| 2009-09-29 14:12 | hgbot | Checkin | |
| 2009-09-29 14:12 | hgbot | Note Added: 0020470 | |
| 2009-09-29 14:12 | hgbot | Status | closed => resolved |
| 2009-09-29 14:12 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/29c8320f0292a89cd372952a8d664605b5b88e94 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/29c8320f0292a89cd372952a8d664605b5b88e94 [^] |
| 2009-10-06 11:27 | psarobe | Status | resolved => closed |
| 2009-10-06 11:27 | psarobe | Note Added: 0020757 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |