Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029668Retail ModulesWeb POSpublic2015-04-22 12:342015-05-20 10:12
Reporteregoitz 
Assigned Toadrianromero 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR15Q3 
Merge Request Status
Review Assigned Tomalsasua
OBNetwork customer
Support ticket
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
Summary0029668: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0029804RR15Q2.1 closed adrianromero NOt possible to login on webpos if the address of the organization has a simple quote on the name 
depends on backport 0029805RR15Q1.4 closed adrianromero NOt possible to login on webpos if the address of the organization has a simple quote on the name 
caused by feature request 0028232 closed guilleaer Web POS should gather the information of the store address 
related to defect 0029718 closed Sandrahuguet SQL Injection issues 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-04-22 12:34egoitzNew Issue
2015-04-22 12:34egoitzAssigned To => Retail
2015-04-22 12:34egoitzResolution time => 1429912800
2015-04-22 12:34egoitzRegression level => Production - Confirmed Stable
2015-04-22 12:34egoitzRegression introduced in release => RR15Q1
2015-04-22 12:34egoitzTriggers an Emergency Pack => No
2015-04-27 16:49adrianromeroAssigned ToRetail => adrianromero
2015-04-27 18:00hgbotCheckin
2015-04-27 18:00hgbotNote Added: 0076791
2015-04-27 18:00hgbotStatusnew => resolved
2015-04-27 18:00hgbotResolutionopen => fixed
2015-04-27 18:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/064f74fcf5038b1d95af7323e61ab3ed2b8a61cb [^]
2015-05-06 16:38malsasuaRegression date => 2014-11-20
2015-05-06 16:38malsasuaRegression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d0a5509d2e7675fad0efaa5aee9c44911768f799 [^]
2015-05-06 16:38malsasuaReview Assigned To => malsasua
2015-05-06 16:38malsasuaNote Added: 0077059
2015-05-06 16:38malsasuaStatusresolved => closed
2015-05-06 16:38malsasuaFixed in Version => RR15Q3
2015-05-06 18:10malsasuaNote Added: 0077062
2015-05-06 18:10malsasuaStatusclosed => new
2015-05-06 18:10malsasuaResolutionfixed => open
2015-05-06 18:10malsasuaFixed in VersionRR15Q3 =>
2015-05-06 18:10malsasuaStatusnew => scheduled
2015-05-06 18:10malsasuaStatusscheduled => resolved
2015-05-06 18:10malsasuaFixed in Version => RR15Q3
2015-05-06 18:10malsasuaResolutionopen => fixed
2015-05-06 18:10malsasuaNote Added: 0077063
2015-05-06 18:10malsasuaStatusresolved => closed
2015-05-07 17:16dmitry_mezentsevRelationship addedcaused by 0028232
2015-05-19 09:22hgbotCheckin
2015-05-19 09:22hgbotNote Added: 0077553
2015-05-19 09:38hgbotCheckin
2015-05-19 09:38hgbotNote Added: 0077557
2015-05-20 09:29marvintmRelationship addedrelated to 0029718
2015-05-20 10:12hgbotCheckin
2015-05-20 10:12hgbotNote Added: 0077595

Notes
(0076791)
hgbot   
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   
2015-05-06 16:38   
verified
(0077062)
malsasua   
2015-05-06 18:10   
reopened to create back ports to RR15Q1 and RR15Q2
(0077063)
malsasua   
2015-05-06 18:10   
reclosed
(0077553)
hgbot   
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   
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   
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
---