News:

Looking for documentation? Take a look on our wiki

Main Menu

Product details sql error

Started by delimpasis, January 22, 2013, 16:40:36 PM

Previous topic - Next topic

delimpasis

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

Milbo

I think you have some old hack in it. store the config one time
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/