please help i get this error when every time after i change my product sorting settings to sort by price.
Error: 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 'PTC3670RD" ORDER BY product_price DESC LIMIT 1' at line 1 SQL=SELECT p.`virtuemart_product_id`, `l`.`product_name` FROM `in872_virtuemart_products` as p INNER JOIN `in872_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `in872_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `in872_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `in872_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ( `pc`.`virtuemart_category_id` = 59 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) AND p.`virtuemart_product_id`!="1501" AND product_price <= "Tablet case Prestigio 7" PTC3670RD" ORDER BY product_price DESC LIMIT 1
what does this mean how can i fix?
Vm 3.0.9
aside from how something can be <= to "Tablet case Prestigio 7" PTC3670RD" the problem is the 7"
The " is breaking the query
The " should be encoded... in my installs if I enter a " in the title field it is.. perhaps this is because your on 3.0.9 .. well out of date -- try at least 3.0.10
with all normal health warnings .. or you are entering this data directly in the DB? (import) ?
ive now tried upgrading too never helped a thing...and the funny part is everything works fine when the sorting setting is set to ordering, but when i set to price i get this error on some of my products...
And GJC Web Design
i have noticed that any product name that has an inch sign but has no dot in between eg (8") gives that sql error 1064 but if a dot is added in between like (8.0") works just fine
i sell tablets so size is very important to my clients.
i also put my products via an import tool...
if your directly importing the " should be a " I think
ive seen that today about an hour ago i dont remember what i clicked, but that doesnt show after i import.
i have modified my last reply but i included it below:
i have noticed that any product name that has an inch sign but has no dot in between eg (8") gives that sql error 1064 but if a dot and a digit is added in between like (8.0") works just fine
i sell tablets so size is very important to my clients.
what import? If u want help provide information!
If your importing directly " to the DB then that is what is there... try as above
Im not an advance user so i dont really know what to give in advance, but i can tell you i use "vm excel like import" program, i dont have any deep info about it all i know is it makes things easy for me..
Never heard of it .. have you tried replacing the " with a " ?