1054 Unknown column 'a.ordering' ???

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:

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.

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,

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

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.

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.

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.

Sorry, cannot find any option, sounds like this

Please prodive a link to that page and I can tell you precisely.

The site is running at localhost, because it is befor designing yet. But i can take screenshots.

Here is the option

Hello.

Works like a charm ^^ Thank u all your patience and 'helpdesking'

Z.