[Skip to main content](#vessel-content)

#   Error: 1064

##

- **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")**
- [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") Topic Author
- [ Offline](/forum/user/6488-aheng5)

Less More

- Posts: 73
- Thank you received: 2
-
-

13 years 6 months ago [\#100910](#100910) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")  *[Error: 1064](/forum/2-general-talk-about-hikashop/80947-error-1064#100910 "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.&#42; FROM jml&#95;hikashop&#95;product&#95;category AS a LEFT JOIN jml&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (23) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;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")* was created by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")*

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 [ ](http://fcptsa.webevolutionary.com/honor-roll-payment-form.html) 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 [ ](http://fcptsa.webevolutionary.com/jag-fund-honor-roll.html))

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

Thanks

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwOTQ3LWVycm9yLTEwNjQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

13 years 6 months ago [\#100971](#100971) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Error: 1064](/forum/2-general-talk-about-hikashop/80947-error-1064#100971 "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.&#42; FROM jml&#95;hikashop&#95;product&#95;category AS a LEFT JOIN jml&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (23) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;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.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwOTQ3LWVycm9yLTEwNjQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")**
- [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") Topic Author
- [ Offline](/forum/user/6488-aheng5)

Less More

- Posts: 73
- Thank you received: 2
-
-

13 years 6 months ago [\#101009](#101009) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")  Replied by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* on topic *[Error: 1064](/forum/2-general-talk-about-hikashop/80947-error-1064#101009 "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.&#42; FROM jml&#95;hikashop&#95;product&#95;category AS a LEFT JOIN jml&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (23) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;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")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwOTQ3LWVycm9yLTEwNjQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86560
- Thank you received: 14307
-
-

13 years 6 months ago [\#101014](#101014) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error: 1064](/forum/2-general-talk-about-hikashop/80947-error-1064#101014 "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.&#42; FROM jml&#95;hikashop&#95;product&#95;category AS a LEFT JOIN jml&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (23) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;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")*

Go in the menu Display-&gt;Content modules, edit your module and in the "ordering direction" option, select the ordering direction you want for your module instead of "inherit" and that error won't happen.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwOTQ3LWVycm9yLTEwNjQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")**
- [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") Topic Author
- [ Offline](/forum/user/6488-aheng5)

Less More

- Posts: 73
- Thank you received: 2
-
-

13 years 6 months ago -  13 years 6 months ago [\#101074](#101074) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")  Replied by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* on topic *[Error: 1064](/forum/2-general-talk-about-hikashop/80947-error-1064#101074 "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.&#42; FROM jml&#95;hikashop&#95;product&#95;category AS a LEFT JOIN jml&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (23) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;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")*

I've tried changing the order direction but no luck

[ ![screenshot&#95;module.jpg](/forum/attachment/9846) ](/forum/attachment/9846 "...hot&#95;module.jpg")

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

- [ ![screenshot&#95;module.jpg](/forum/attachment/9846) ](/forum/attachment/9846 "...hot&#95;module.jpg") [ ](/forum/attachment/9846?download=1 "...hot&#95;module.jpg")

Last edit: 13 years 6 months ago by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile"). Reason: adding error message

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwOTQ3LWVycm9yLTEwNjQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86560
- Thank you received: 14307
-
-

13 years 6 months ago [\#101075](#101075) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error: 1064](/forum/2-general-talk-about-hikashop/80947-error-1064#101075 "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.&#42; FROM jml&#95;hikashop&#95;product&#95;category AS a LEFT JOIN jml&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (23) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;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")*

I still see that you have "inherit" in your ordering direction option in your screenshot.

The following user(s) said Thank You: [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwOTQ3LWVycm9yLTEwNjQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")**
- [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") Topic Author
- [ Offline](/forum/user/6488-aheng5)

Less More

- Posts: 73
- Thank you received: 2
-
-

13 years 6 months ago [\#101162](#101162) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")  Replied by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* on topic *[Error: 1064](/forum/2-general-talk-about-hikashop/80947-error-1064#101162 "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.&#42; FROM jml&#95;hikashop&#95;product&#95;category AS a LEFT JOIN jml&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (23) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;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")*

Success. ![:)](/media/kunena/emoticons/3.png ":)") I was changing the wrong order field. Thanks

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwOTQ3LWVycm9yLTEwNjQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.061 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
