Follow up on VirtueMart for Joomla 3.x

Cache was deleted, error message in frontend:
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 '( CATEGORY.VIRTUEMART_CATEGORY_ID = 21 OR CATEGORY.VIRTUEMART_CATEGORY_ID = 19 O' 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 X0USM_VIRTUEMART_PRODUCTS_DE_DE AS CONTENT LEFT JOIN X0USM_VIRTUEMART_PRODUCT_CATEGORIES AS CATEGORY ON CATEGORY.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN X0USM_VIRTUEMART_PRODUCT_MANUFACTURERS AS MANUFACTURER_X ON CONTENT.VIRTUEMART_PRODUCT_ID = MANUFACTURER_X.VIRTUEMART_PRODUCT_ID LEFT JOIN X0USM_VIRTUEMART_MANUFACTURERS_DE_DE AS MANUFACTURER ON MANUFACTURER_X.VIRTUEMART_MANUFACTURER_ID = MANUFACTURER.VIRTUEMART_MANUFACTURER_ID LEFT JOIN X0USM_VIRTUEMART_PRODUCTS AS CONTENTR ON CONTENTR.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN X0USM_VIRTUEMART_PRODUCT_SHOPPERGROUPS AS PSGROUP ON PSGROUP.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN X0USM_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 = 21 OR CATEGORY.VIRTUEMART_CATEGORY_ID = 19 OR CATEGORY.VIRTUEMART_CATEGORY_ID = 20 ( CATEGORY.VIRTUEMART_CATEGORY_ID = 21 OR CATEGORY.VIRTUEMART_CATEGORY_ID = 19 OR CATEGORY.VIRTUEMART_CATEGORY_ID = 20) ORDER BY CONTENTR.CREATED_ON DESC LIMIT 0,8;

@Adamik - sorry I've made a typo in the code what causes your issue - please apply this fix: https://github.com/GavickPro/News-Show- ... 0e46979e3a

->
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 'ORDER BY contentR.created_on ASC LIMIT 0,8' at line 45 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 x0usm_virtuemart_products_de_de AS content LEFT JOIN x0usm_virtuemart_product_categories AS category ON category.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN x0usm_virtuemart_product_manufacturers AS manufacturer_x ON content.virtuemart_product_id = manufacturer_x.virtuemart_product_id LEFT JOIN x0usm_virtuemart_manufacturers_de_de AS manufacturer ON manufacturer_x.virtuemart_manufacturer_id = manufacturer.virtuemart_manufacturer_id LEFT JOIN x0usm_virtuemart_products AS contentR ON contentR.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN x0usm_virtuemart_product_shoppergroups AS psgroup ON psgroup.virtuemart_product_id = content.virtuemart_product_id LEFT JOIN x0usm_virtuemart_shoppergroups AS sgroup ON sgroup.virtuemart_shoppergroup_id = psgroup.virtuemart_shoppergroup_id WHERE contentR.product_parent_id = 0 AND contentR.published = 1 AND ORDER BY contentR.created_on ASC LIMIT 0,8;

@Adamik - please send me an FTP access to your website using PM message.

I hope you got my message... when I click on the private message I sent you I get a "Oops! Error 404"..

Yes, I have received it.

I've applied the following fix: https://github.com/GavickPro/News-Show- ... e3350bc31a

It seems that it solved your issue.

perfect, thx!