Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.6.3
-
Fix Version/s: 4.6.5
-
Component/s: CiviContribute
-
Labels:None
-
Documentation Required?:None
-
Funding Source:Core Team Funds
Description
Just found out that in our configuration changing selections of Price Set fails because we have a ' in label name. (the label is: geen 'sterke schouder'-toeslag).
I have no clue where to search for this, but doesn't this possible point to a security issue as the value is not properly cleaned before executed as a query?
UPDATE civicrm_line_item li
SET li.qty = 1,
li.line_total = 0,
li.tax_amount = NULL,
li.unit_price = 0,
li.label = 'geen 'sterke schouder'-toeslag'
WHERE (li.entity_table = 'civicrm_participant' AND li.entity_id = 2120) AND
(price_field_value_id = 23)
[nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sterke schouder'-toeslag'
WHERE (li.entity_table = 'civicrm_participant' AND li.' at line 6]