Error: 1064

I'm using Joomla 3 and using module load of the Hika Shop Content Module in an article.

I've getting the following message:
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 'inherit LIMIT 0, 20' at line 1 SQL=SELECT DISTINCT b.* FROM jml_hikashop_product_category AS a LEFT JOIN jml_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (23) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY a.ordering inherit LIMIT 0, 20

This is coming from This is a test site.

I could not find any solution searching the forum that matched my issue. I can use the Editor product insert tag with no problem (but noticed required fields don't show an alert if left blank after clicking on add to cart )

Please let me know what I need to check/resolve my problems.

Thanks

Hi,

Are you using the last version of Hikashop ? I think that we already made a fix for that issue.

I am running v 2.1.2; and I've reinstalled again today. No luck.

I've tried changing the order direction but no luck

error msg page after change
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 'inherit LIMIT 0, 20' at line 1 SQL=SELECT DISTINCT b.* FROM jml_hikashop_product_category AS a LEFT JOIN jml_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (23) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY b.product_id inherit LIMIT 0, 20

Success. I was changing the wrong order field. Thanks