Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010598
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformminorhave not tried2009-09-14 20:592009-10-13 07:47
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PriorityhighResolutionfixedFixed in Version2.40MP10
StatusclosedFix in branch2.40Fixed in SCM revisionbd212c0c3a29
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010598: WindowTree_data.xsql has sql errror in optional parameter (uses ar table alias which is not defined in from clause)

DescriptionThis file (in 2.40 and 2.50) defines the following optional parameter:

<Parameter name="editable" optional="true" type="none" after="WHERE " text="tn.IsActive='Y' AND ar.isActive='Y' AND "/>

However the ar table alias is not defined in the FROM clause.
TagsNo tags attached.
Attached Filesdiff file icon 10598.diff [^] (872 bytes) 2009-09-14 21:01 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0010597 closedshuehner WindowTree_data.xsql has sql errror in optional parameter (uses ar table alias which is not defined in from clause) 

-  Notes
(0020097)
hgbot (developer)
2009-09-15 19:50

 Repository: erp/stable/2.40
Changeset: bd212c0c3a29c202204178fdf44ea67c95139068
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Sep 15 19:50:27 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/bd212c0c3a29c202204178fdf44ea67c95139068 [^]

Fixed 10598: Fix sql error in optional parameter

---
M src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
---
(0020437)
hgbot (developer)
2009-09-29 12:02

 Repository: erp/stable/2.40_pageddatagrid
Changeset: bd212c0c3a29c202204178fdf44ea67c95139068
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Sep 15 19:50:27 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/bd212c0c3a29c202204178fdf44ea67c95139068 [^]

Fixed 10598: Fix sql error in optional parameter

---
M src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
---
(0020949)
arunkumar (reporter)
2009-10-13 07:47

 Tested & Working fine.

- Issue History
Date Modified Username Field Change
2009-09-14 20:59 shuehner Type defect => backport
2009-09-14 20:59 shuehner fix_in_branch => 2.40
2009-09-14 21:01 shuehner File Added: 10598.diff
2009-09-15 19:50 hgbot Checkin
2009-09-15 19:50 hgbot Note Added: 0020097
2009-09-15 19:50 hgbot Status scheduled => resolved
2009-09-15 19:50 hgbot Resolution open => fixed
2009-09-15 19:50 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/bd212c0c3a29c202204178fdf44ea67c95139068 [^]
2009-09-29 12:02 hgbot Checkin
2009-09-29 12:02 hgbot Note Added: 0020437
2009-09-29 12:02 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/bd212c0c3a29c202204178fdf44ea67c95139068 [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/bd212c0c3a29c202204178fdf44ea67c95139068 [^]
2009-10-13 07:47 arunkumar Status resolved => closed
2009-10-13 07:47 arunkumar Note Added: 0020949
2009-10-13 07:47 arunkumar Fixed in Version => 2.40MP10

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker