Error 1064

Hello,
I have updated my storefront template to the latest and received an error 1064

Error: 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 ') ORDER BY contentR.created_on DESC LIMIT 0,8' at line 39 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 #__virtuemart_products_en_gb AS content LEFT JOIN #__virtuemart_product_categories AS category ON category.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN #__virtuemart_product_manufacturers AS manufacturer_x ON content.virtuemart_product_id = manufacturer_x.virtuemart_product_id LEFT JOIN #__virtuemart_manufacturers_en_gb AS manufacturer ON manufacturer_x.virtuemart_manufacturer_id = manufacturer.virtuemart_manufacturer_id LEFT JOIN #__virtuemart_products AS contentR ON contentR.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN #__virtuemart_product_shoppergroups AS psgroup ON psgroup.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN #__virtuemart_shoppergroups AS sgroup ON sgroup.virtuemart_shoppergroup_id = psgroup.virtuemart_shoppergroup_id WHERE contentR.published = 1 AND ( category.virtuemart_category_id = ) ORDER BY contentR.created_on DESC LIMIT 0,8;

During my update I went into Virtuemart to configured my shopping cart and then I received this error. Please help.

RJ

Hi

By this part "( category.virtuemart_category_id = ) ORDER BY" I can see that category is not selected in NSP source settings. Please change it and resave it.

Quick question, what does NSP stand for? Is that a particular module or component?

RJ

Hi

It is News Show Pro module used to show articles. I would start to look at it's settings to locate the misconfiguration leading to error.

ok will do.

Thanks.
RJ

Hi

Any luck with this? If You need some help, please send me an access to joomla panel.

Yes I went in the backend and disabled a lot of components and modules that wasn't needed and the error went away.

Thanks for the insight,
RJ

Hi

I'm pretty sure the issue was coming from NSP module being misconfigured, but if You do not need than it's ok to remove it and if it solves the problem, even better Closing this thread now.