MySQL command error on product list in admin

whenever I try to go here:

. . . /administrator/index.php?option=com_hikashop&ctrl=product

I get this:

An error has occurred.
500 SQL=SELECT a.ordering, b.* FROM hikashop_product_category AS a LEFT JOIN hikashop_product AS b ON a.product_id=b.product_id WHERE a.category_id=2 AND b.product_type = 'main' ORDER BY a.category_name asc LIMIT 0, 20
Error in query: Unknown column 'a.category_name' in 'order clause'

Hikashop version : 2.0.0

Joomla! 3.0.2 Stable

PHP 5.3.20

MySQL 5.5.29

BUT . . . It just now quit giving me that error. I have changed nothing since yesterday. Just logged back in this morning and everything seems to be working again.

Hello,

I've got the same problem.

When i tried to sort the name column in de category picker, i got the following error.
I looked in the tables and i saw that there is no column category_name to sort on.

Can you please fix this.



1054 Unknown column 'a.category_name' in 'order clause' SQL=SELECT a.ordering, b.* FROM spa_hikashop_product_category AS a LEFT JOIN spa_hikashop_product AS b ON a.product_id=b.product_id WHERE a.category_id=2 AND b.product_type = 'main' ORDER BY a.category_name asc LIMIT 0, 20

Hi Jerome,

I have installed Hikashop Business v2.1.3.

As far as I can find out, occurs the problem in the backend view "product/selectcategory. php

On line 59 the field "category_name" is used, but this field is not a part of table "hikashop_product_category".

<?php echo JHTML::_('grid.sort', JText::_('HIKA_NAME'), 'a.category_name', $this->pageInfo->filter->order->dir,$this->pageInfo->filter->order->value ); ?>

When i sort on the Name column, the folowing error occurs:

1054 Unknown column 'a.category_name' in 'order clause' SQL=SELECT a.ordering, b.* FROM spa_hikashop_product_category AS a LEFT JOIN spa_hikashop_product AS b ON a.product_id=b.product_id WHERE a.category_id=2 AND b.product_type = 'main' ORDER BY a.category_name asc LIMIT 0, 20

Regards,

René

Hi Jerome,

I cleaned my cookies after I was logged out, and try it again.

As I expected, it didn't solve the problem.

For so far as I can see, is the real problem a wrong column name in the underlying query statement.

As you can see in the attached error picture, there is no field with the name "category_name" in the table "hikashop_product_category".

The only conclusion I can draw, is that there is an typo in the query statement.

Regards,

René