1064 Error

When I publish **SHOPS** __&__ TRENDS I get the error below on web site. What should I do?

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 ') AND contentR.product_in_stock > 0 ORDER BY contentR.' at line 40 SQL=SELECT DISTINCT content.virtuemart_product_id AS id, content.product_name AS title, content.product_desc AS text, contentR.modified_on AS date, contentR.created_on AS date_publish, contentR.product_special AS featured, manufacturer.mf_name AS manufacturer, manufacturer.virtuemart_manufacturer_id AS manufacturer_id FROM ok80p_virtuemart_products_en_gb AS content LEFT JOIN ok80p_virtuemart_product_categories AS category ON category.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN ok80p_virtuemart_product_manufacturers AS manufacturer_x ON content.virtuemart_product_id = manufacturer_x.virtuemart_product_id LEFT JOIN ok80p_virtuemart_manufacturers_en_gb AS manufacturer ON manufacturer_x.virtuemart_manufacturer_id = manufacturer.virtuemart_manufacturer_id LEFT JOIN ok80p_virtuemart_products AS contentR ON contentR.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN ok80p_virtuemart_product_shoppergroups AS psgroup ON psgroup.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN ok80p_virtuemart_shoppergroups AS sgroup ON sgroup.virtuemart_shoppergroup_id = psgroup.virtuemart_shoppergroup_id WHERE contentR.product_parent_id = 0 AND contentR.published = 1 AND ( category.virtuemart_category_id = ) AND contentR.product_in_stock > 0 ORDER BY contentR.created_on DESC LIMIT 0,8;

Hi

Please update module to the latest version, than go to every copy of NSP, clear browser cache, check settings for source and save settings even if no changes was done.

Hello,

I have the same problem. Tried resolving it with the update but no luck.

Please help.


Best regards,

Could you please provide me with a URL to your website, either here or via PM (click the “Private Message” text underneath my avatar) so that I may analyze it? It is a lot easier for us to diagnose issues when we have a live site to examine.