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?

Hi,

This error message doesn't mean anything to me. It looks like a generic SQL error. It can be anything. Most likely it is related to VM Core or wrongly configured product-price establishment. Make sure all products have prices and you use same currency for them.

For testing, create a new category, then create new 1 or 2 products in this new category (make sure those products have positive prices). Then see the front-end if you are still having any SQL error message with those newly created category with the newly created products.

If error remains; try the "Install or if necessary update tables" button on "Virtuemart Backend >> Tools >> Tools & Migration" page

BE CAUTIOUS!!! The buttons on this page should be used very carefully, you might accidentally remove your Virtuemart products/categories and get back to factory settings. I would highly recommend you to BACKUP first!!!

Regards.

Hi
Ok thanks i solved it.

It is glad to hear you have solved it.

Case solved, topic is closed.

Regards.