Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029805Retail ModulesWeb POSpublic2015-04-22 12:342015-05-19 18:06
Reporteregoitz 
Assigned Toadrianromero 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR15Q1.4Fixed in VersionRR15Q1.4 
Merge Request Status
Review Assigned Tomarvintm
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
Summary0029805: 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 => RR15Q1.4
2015-05-07 17:01dmitry_mezentsevTag Attached: Approved
2015-05-19 09:22hgbotCheckin
2015-05-19 09:22hgbotNote Added: 0077554
2015-05-19 09:22hgbotStatusscheduled => resolved
2015-05-19 09:22hgbotResolutionopen => fixed
2015-05-19 09:22hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/064f74fcf5038b1d95af7323e61ab3ed2b8a61cb [^] => http://code.openbravo.com/retail/backports/3.0RR15Q1.4/org.openbravo.retail.posterminal/rev/3aa772f4e6be608b0257bb8afac2d0fc137279f7 [^]
2015-05-19 18:06marvintmReview Assigned Tomalsasua => marvintm
2015-05-19 18:06marvintmStatusresolved => closed
2015-05-19 18:06marvintmFixed in Version => RR15Q1.4

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