inch character not working

[Nilsy]

VM 3.0.16
J3.6.2
PHP Version 5.6.24
Apache

I know this has been taken up before, but I can't see any solution thread.

If I have a product title, for example: Chair only 22"
-The character " gets removed, and the page default to the 1064 syntax error.

The fault message I get is:
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 '"Chair only 22"" ORDER BY product_name DESC, `virtuemart_product_id` DESC LIMI' at line 1 SQL=SELECT p.`virtuemart_product_id`, `l`.`product_name`,`l`.product_name FROM `#__virtuemart_products` as p INNER JOIN `#__virtuemart_products_nb_no` as l using (`virtuemart_product_id`) LEFT JOIN `#__virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` WHERE ( `pc`.`virtuemart_category_id` = 40 AND ( `ps`.`virtuemart_shoppergroup_id`= "5" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) AND p.`virtuemart_product_id`!="6726" AND `l`.product_name <= "Chair only 22"" ORDER BY product_name DESC, `virtuemart_product_id` DESC LIMIT 1

[Studio 42]

I have already reported it for some weeks.
I think it's fixed in VM 3.0.17.6
The problem is "Chair only 22"", you have 2 time double quotes and this do an invalid mySql query.
A solution is to use the HTML code:

Code Select Expand

"    standard
"     numeric
"    hexa

[Nilsy]

Thank you... but where do I stick that code?
Or is it better just to write inch at the moment and wait for the update?

[GJC Web Design]

you manually use one of them in the title as u write it

[Studio 42]

Replace in your product title

Code Select Expand

Chair only 22" to

Code Select Expand

Chair only 22"
Note this can have side effect to, when product title is used in an encoded HTML tag, so the only valid solution is to remove the double quote or update VM.

[Nilsy]

  me being stupid...
-Note to self, please use glasses when reading...