Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029804Retail ModulesWeb POSpublic2015-04-22 12:342015-05-19 18:50
Reporteregoitz 
Assigned Toadrianromero 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR15Q2.1Fixed in VersionRR15Q2.1 
Merge Request Status
Review Assigned Tomarvintm
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
Summary0029804: 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
TagsApproved
Relationships
blocks defect 0029668 closed adrianromero NOt possible to login on webpos if the address of the organization has a simple quote on the name 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-05-06 18:10malsasuaTypedefect => backport
2015-05-06 18:10malsasuaTarget Version => RR15Q2.1
2015-05-07 17:01dmitry_mezentsevTag Attached: Approved
2015-05-19 09:38hgbotCheckin
2015-05-19 09:38hgbotNote Added: 0077558
2015-05-19 09:38hgbotStatusscheduled => resolved
2015-05-19 09:38hgbotResolutionopen => fixed
2015-05-19 09:38hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/064f74fcf5038b1d95af7323e61ab3ed2b8a61cb [^] => http://code.openbravo.com/retail/backports/3.0RR15Q2.1/org.openbravo.retail.posterminal/rev/f0a3230e66e625a8f19f080143257f0f1c241491 [^]
2015-05-19 18:50marvintmReview Assigned Tomalsasua => marvintm
2015-05-19 18:50marvintmStatusresolved => closed
2015-05-19 18:50marvintmFixed in Version => RR15Q2.1

Notes
(0077558)
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
---