Shops & Trends causing error

please see
http://aepstore.net/template

(I published the module on that page so you can see what its doing, and the home page will work in the meantime)

someone else changed the title of this module... then the following error occurred... I have changed it back, but same error???

I have no idea if he changed something else as well (in joomla or virtuemart)
any help in tracking this down would be very much appreciated

1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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 i6yqh_virtuemart_products_en_gb AS content LEFT JOIN i6yqh_virtuemart_product_categories AS category ON category.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN i6yqh_virtuemart_product_manufacturers AS manufacturer_x ON content.virtuemart_product_id = manufacturer_x.virtuemart_product_id LEFT JOIN i6yqh_virtuemart_manufacturers_en_gb AS manufacturer ON manufacturer_x.virtuemart_manufacturer_id = manufacturer.virtuemart_manufacturer_id LEFT JOIN i6yqh_virtuemart_products AS contentR ON contentR.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN i6yqh_virtuemart_product_shoppergroups AS psgroup ON psgroup.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN i6yqh_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;
It appears the page you were looking for doesn't exist. Sorry about that.

Hi

A change of a title should not cause that. It's most likely some other settings which just got saved while changing a title. Please try change order value since it's the only thing mentioned in error and if none of the order option will make it show send me an access to joomla panel.

how about you answering this one in the mean time?

https://www.gavick.com/forums/storebox- ... ting-49645

change order value <--- can you be more specific???

Hi

In News Show Pro GK5 module in source tab You will find settings for order. Simply try different values and if none of them will make module usable send me an access to joomla panel.