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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029668
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2015-04-22 12:342015-05-20 10:12
ReporteregoitzView Statuspublic 
Assigned Toadrianromero 
PriorityimmediateResolutionfixedFixed in VersionRR15Q3
StatusclosedFix in branchFixed in SCM revision064f74fcf503
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomalsasua
Regression levelProduction - Confirmed Stable
Regression date2014-11-20
Regression introduced in releaseRR15Q1
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d0a5509d2e7675fad0efaa5aee9c44911768f799 [^]
Triggers an Emergency PackNo
Summary

0029668: NOt possible to login on webpos if the address of the organization has a simple quote on the name

DescriptionNOt possible to login on webpos if the address of the organization has a simple quote on the name.
You get an error when login becuase the query can not be executed.
Steps To Reproduce-Change the address of the organization of a termianl by adding a quote on the name. For example: Camí d'Onda

-Try to login on the terminal

*You get the error.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0029804RR15Q2.1 closedadrianromero NOt possible to login on webpos if the address of the organization has a simple quote on the name 
depends on backport 0029805RR15Q1.4 closedadrianromero NOt possible to login on webpos if the address of the organization has a simple quote on the name 
caused by feature request 0028232 closedguilleaer Web POS should gather the information of the store address 
related to defect 0029718 closedSandrahuguet SQL Injection issues 

-  Notes
(0076791)
hgbot (developer)
2015-04-27 18:00

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 064f74fcf5038b1d95af7323e61ab3ed2b8a61cb
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Apr 27 17:59:21 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/064f74fcf5038b1d95af7323e61ab3ed2b8a61cb [^]

Fixes issue 0029668: NOt possible to login on webpos if the address of the organization has a simple quote on the name
* Address value in HQL sentence has to escape single quote characters.

---
M src/org/openbravo/retail/posterminal/ProcessHQLQuery.java
M src/org/openbravo/retail/posterminal/term/Terminal.java
---
(0077059)
malsasua (developer)
2015-05-06 16:38

verified
(0077062)
malsasua (developer)
2015-05-06 18:10

reopened to create back ports to RR15Q1 and RR15Q2
(0077063)
malsasua (developer)
2015-05-06 18:10

reclosed
(0077553)
hgbot (developer)
2015-05-19 09:22

Repository: retail/backports/3.0RR15Q1.4/org.openbravo.retail.posterminal
Changeset: 3aa772f4e6be608b0257bb8afac2d0fc137279f7
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Apr 27 17:59:21 2015 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR15Q1.4/org.openbravo.retail.posterminal/rev/3aa772f4e6be608b0257bb8afac2d0fc137279f7 [^]

Fixes issue 29805, related to issue 29668: NOt possible to login on webpos if the address of the organization has a simple quote on the name
* Address value in HQL sentence has to escape single quote characters.

---
M src/org/openbravo/retail/posterminal/ProcessHQLQuery.java
M src/org/openbravo/retail/posterminal/term/Terminal.java
---
(0077557)
hgbot (developer)
2015-05-19 09:38

Repository: retail/backports/3.0RR15Q2.1/org.openbravo.retail.posterminal
Changeset: f0a3230e66e625a8f19f080143257f0f1c241491
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Apr 27 17:59:21 2015 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR15Q2.1/org.openbravo.retail.posterminal/rev/f0a3230e66e625a8f19f080143257f0f1c241491 [^]

Fixes issue 29804, backport of issue 29668: NOt possible to login on webpos if the address of the organization has a simple quote on the name
* Address value in HQL sentence has to escape single quote characters.

---
M src/org/openbravo/retail/posterminal/ProcessHQLQuery.java
M src/org/openbravo/retail/posterminal/term/Terminal.java
---
(0077595)
hgbot (developer)
2015-05-20 10:12

Repository: erp/pmods/org.openbravo.retail.sampledata
Changeset: 20e0e21944abfaeb1e74888e924e231ddf9e0d4d
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Wed May 20 10:11:32 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/20e0e21944abfaeb1e74888e924e231ddf9e0d4d [^]

related to issue 29668: updated location name

---
M referencedata/sampledata/The_White_Valley_Group/C_LOCATION.xml
---

- Issue History
Date Modified Username Field Change
2015-04-22 12:34 egoitz New Issue
2015-04-22 12:34 egoitz Assigned To => Retail
2015-04-22 12:34 egoitz Resolution time => 1429912800
2015-04-22 12:34 egoitz Regression level => Production - Confirmed Stable
2015-04-22 12:34 egoitz Regression introduced in release => RR15Q1
2015-04-22 12:34 egoitz Triggers an Emergency Pack => No
2015-04-27 16:49 adrianromero Assigned To Retail => adrianromero
2015-04-27 18:00 hgbot Checkin
2015-04-27 18:00 hgbot Note Added: 0076791
2015-04-27 18:00 hgbot Status new => resolved
2015-04-27 18:00 hgbot Resolution open => fixed
2015-04-27 18:00 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/064f74fcf5038b1d95af7323e61ab3ed2b8a61cb [^]
2015-05-06 16:38 malsasua Regression date => 2014-11-20
2015-05-06 16:38 malsasua Regression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d0a5509d2e7675fad0efaa5aee9c44911768f799 [^]
2015-05-06 16:38 malsasua Review Assigned To => malsasua
2015-05-06 16:38 malsasua Note Added: 0077059
2015-05-06 16:38 malsasua Status resolved => closed
2015-05-06 16:38 malsasua Fixed in Version => RR15Q3
2015-05-06 18:10 malsasua Note Added: 0077062
2015-05-06 18:10 malsasua Status closed => new
2015-05-06 18:10 malsasua Resolution fixed => open
2015-05-06 18:10 malsasua Fixed in Version RR15Q3 =>
2015-05-06 18:10 malsasua Status new => scheduled
2015-05-06 18:10 malsasua Status scheduled => resolved
2015-05-06 18:10 malsasua Fixed in Version => RR15Q3
2015-05-06 18:10 malsasua Resolution open => fixed
2015-05-06 18:10 malsasua Note Added: 0077063
2015-05-06 18:10 malsasua Status resolved => closed
2015-05-07 17:16 dmitry_mezentsev Relationship added caused by 0028232
2015-05-19 09:22 hgbot Checkin
2015-05-19 09:22 hgbot Note Added: 0077553
2015-05-19 09:38 hgbot Checkin
2015-05-19 09:38 hgbot Note Added: 0077557
2015-05-20 09:29 marvintm Relationship added related to 0029718
2015-05-20 10:12 hgbot Checkin
2015-05-20 10:12 hgbot Note Added: 0077595


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker