Joomla 2.5
Virtuemart 2.0.18a
PHP 5.3.18
MySQL 5.5.28
After upgrading to 2.0.18a when I press the Product Details button I get the following sql error
500 - JDatabaseMySQL::query: 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 'p`.virtuemart_product_id` DESC LIMIT 0,1' at line 4 SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `psi8t_virtuemart_products` as `p` JOIN `psi8t_virtuemart_products_el_gr` as `l` using (`virtuemart_product_id`) JOIN `psi8t_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `psi8t_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 1907 and `slug` < "adadaa" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY ``p`.virtuemart_product_id` DESC LIMIT 0,1
I think you have some old hack in it. store the config one time