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.

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.

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.

Sorry, cannot find any option, sounds like this

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.