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

View Issue Details[ Jump 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 
Merge Request Status
Review Assigned Tomalsasua
OBNetwork customerOBPS
Support ticket35781
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 (viewer)
2015-05-06 16:38

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

 reopened to create back ports to RR15Q1 and RR15Q2
(0077063)
malsasua (viewer)
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 OBNetwork customer => Yes
2015-04-22 12:34 egoitz Support ticket => 35781
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