[Skip to main content](#vessel-content) # 1054 Unknown column 'a.ordering' ??? ## - **[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")** - [![Zoller85's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/23242-zoller85 "View Zoller85's Profile") Topic Author - [ Offline](/forum/user/23242-zoller85) Less More - Posts: 8 - Thank you received: 0 - - 13 years 4 months ago [\#111371](#111371) by [Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile") *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#111371 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* was created by *[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")* Hello there, First of all, thank you for this awesome cart-system ![:)](/media/kunena/emoticons/8.png ":)") I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: > 1054 Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.\* FROM tdb\_hikashop\_product AS b WHERE b.product\_published=1 AND b.product\_parent\_id=9 AND b.product\_type = 'variant' ORDER BY a.ordering ASC LIMIT 0, 20 I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z. - [ ![smthngwrng.png](/forum/attachment/10856) ](/forum/attachment/10856 "smthngwrng.png") [ ](/forum/attachment/10856?download=1 "smthngwrng.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 4 months ago [\#111403](#111403) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#111403 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* Hi, Which page are you seeing exactly ? The ordering you have is (logically) wrong. And I don't know how you passed this wrong information to the page. The best in order to fix it is to know the action you made, the action which ask for this wrong ordering. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")** - [![Zoller85's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/23242-zoller85 "View Zoller85's Profile") Topic Author - [ Offline](/forum/user/23242-zoller85) Less More - Posts: 8 - Thank you received: 0 - - 13 years 4 months ago [\#111463](#111463) by [Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile") Replied by *[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")* on topic *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#111463 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* Hello And thanks for the reply ^^ I do not clearly undrstang, what you are saying ,but here are screenshots from my category and product pages (both front-end and back-end sides), maybe it could say mor than i ![:)](/media/kunena/emoticons/8.png ":)") Z. - [ ![cat_back.png](/forum/attachment/10864) ](/forum/attachment/10864 "cat_back.png") [ ](/forum/attachment/10864?download=1 "cat_back.png") - [ ![cat_front.png](/forum/attachment/10865) ](/forum/attachment/10865 "cat_front.png") [ ](/forum/attachment/10865?download=1 "cat_front.png") - [ ![product_back.png](/forum/attachment/10866) ](/forum/attachment/10866 "product_back.png") [ ](/forum/attachment/10866?download=1 "product_back.png") - [ ![product_front.png](/forum/attachment/10867) ](/forum/attachment/10867 "product_front.png") [ ](/forum/attachment/10867?download=1 "product_front.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/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: 86316 - Thank you received: 14276 - - 13 years 4 months ago [\#111473](#111473) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#111473 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* Hi, Could you try to download HikaShop 2.2.0 that we just released and install it on your website ? I think that it should fix the problem once you clear your browser cache and cookies. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")** - [![Zoller85's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/23242-zoller85 "View Zoller85's Profile") Topic Author - [ Offline](/forum/user/23242-zoller85) Less More - Posts: 8 - Thank you received: 0 - - 13 years 3 months ago [\#112170](#112170) by [Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile") Replied by *[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")* on topic *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#112170 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* Thanks for the tip ^^ U Disabled and uninstalled HikaShop, installed the 2.2 version and now it works ^^ One more question.. how can i set up the main view to show onlz categories, and products will be visible only in the categories sub-pages? Sincerely, Z. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/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: 86316 - Thank you received: 14276 - - 13 years 3 months ago [\#112180](#112180) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#112180 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* In the HikaShop options of your menu, click on the link to the associated products listing module and there change the "sub element filter" option and that should do it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")** - [![Zoller85's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/23242-zoller85 "View Zoller85's Profile") Topic Author - [ Offline](/forum/user/23242-zoller85) Less More - Posts: 8 - Thank you received: 0 - - 13 years 3 months ago [\#112191](#112191) by [Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile") Replied by *[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")* on topic *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#112191 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* Sorry, cannot find any option, sounds like this ![:(](/media/kunena/emoticons/5.png ":(") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/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: 86316 - Thank you received: 14276 - - 13 years 3 months ago [\#112192](#112192) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#112192 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* Please prodive a link to that page and I can tell you precisely. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")** - [![Zoller85's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/23242-zoller85 "View Zoller85's Profile") Topic Author - [ Offline](/forum/user/23242-zoller85) Less More - Posts: 8 - Thank you received: 0 - - 13 years 3 months ago [\#112216](#112216) by [Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile") Replied by *[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")* on topic *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#112216 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* The site is running at localhost, because it is befor designing yet. But i can take screenshots. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 3 months ago [\#112244](#112244) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#112244 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* Here is the option ![:)](/media/kunena/emoticons/8.png ":)") #### Attachment not found Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")** - [![Zoller85's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/23242-zoller85 "View Zoller85's Profile") Topic Author - [ Offline](/forum/user/23242-zoller85) Less More - Posts: 8 - Thank you received: 0 - - 13 years 3 months ago [\#112412](#112412) by [Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile") Replied by *[Zoller85](/forum/user/23242-zoller85 "View Zoller85's Profile")* on topic *[1054 Unknown column 'a.ordering' ???](/forum/3-bug-report/84312-1054-unknown-column-a-ordering#112412 "Hello there, First of all, thank you for this awesome cart-system :) I newly installed a pure Joomla 3.1.1 system, added some content and two languages. Also installed HikaShop 2.1.3, and added some categories and a dozen products to it. Everything is fine, until i'm trying to view a product. Then this error message welcomes me: I checked if corresponding databases are exists, and it seems allright. Therefore i cannot find correct answers on any forum, i was thinking, maybe you could help. I attach a picture about the screen how now looks like with this error-message on it. Z.")* Hello. Works like a charm ^^ Thank u all your patience and 'helpdesking' ![:)](/media/kunena/emoticons/8.png ":)") Z. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NDMxMi0xMDU0LXVua25vd24tY29sdW1uLWEtb3JkZXJpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & 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.148 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)