News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

mysql error

Started by imageinaction, April 07, 2013, 16:33:09 PM

Previous topic - Next topic

imageinaction

Hi folks ... As usual I may have created my own problem  :-[  I'm sure it is a really small problem, but I have little or no idea what I have done or how to correct it. The error message I get on the shopping pages on my website http://www.crackersforchristmastestingserver.com is:

        vmError: exeSortSearchListQuery 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 ') AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) I' at line 3 SQL=SELECT * FROM `btp9y_virtuemart_products_en_gb` as l JOIN `btp9y_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `btp9y_virtuemart_product_categories` ON p.`virtuemart_product_id` = `btp9y_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `btp9y_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `btp9y_virtuemart_product_categories`.`virtuemart_category_id` LEFT JOIN `btp9y_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `btp9y_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `btp9y_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `btp9y_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `btp9y_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `btp9y_virtuemart_product_categories`.`virtuemart_category_id` IN () AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) IS NULL )) group by p.`virtuemart_product_id` ORDER BY RAND() ASC LIMIT 0, 5

Joomla! 2.5.7
Virtumart  2.0.12b
php 5.3.10

Milbo

Version 2.0.12b, actual version is 2.0.20b, so? you have no idea how to fix it?
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/