1054 - Unknown column...

I can confirm this code from pastebin fix SQL error in Hikashop 2.3.2 and 2.3.3.
Any chance to include it in official release?

Please can you take a look at line 1117:

if($list && $filter->filter_options['title_position']='inside'){

Hi,

Thanks for this correction, I just edited the code on our end and this will be corrected for next releases of HikaShop.

Hello, same problems here...
I've have tried everything (I believe) in this forum. Here the issues...

Error 1054 it says:
Unknown column 'b.b.product_average_score' in 'where clause' SQL=SELECT DISTINCT b.* FROM p76f8_hikashop_product_category AS a LEFT JOIN p76f8_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN p76f8_hikamarket_vendor AS hikam_vendor ON b.product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (31) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') AND b.b.product_average_score BETWEEN 2 AND 5 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 18


And I don't know why but the copy/paste of the pastebin file it's not working either.

I keep looking...

Thanks in advanced!
Regards,

I also have found this topic about updating Hika...
Here it's the url www.hikashop.com/support/support/documen...lity-issues.html#SQL

My hosting provider has confirmed me that my MySQL user has the ALTER privilege. I also have tried to delete and create new filters but the issue it's still there.

Regards

Hi!

Yes I have: HikaShop Business: 2.3.4 and HikaMarket Multivendor: 1.5.1. Template Gavick Storefront updated.

With the "full error report" do you mean this?

Unknown column 'b.b.product_average_score' in 'where clause' SQL=SELECT DISTINCT b.* FROM p76f8_hikashop_product_category AS a LEFT JOIN p76f8_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN p76f8_hikamarket_vendor AS hikam_vendor ON b.product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (31) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') AND b.b.product_average_score BETWEEN 5 AND 5 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 18

Regards

Hi Yes it is the filter at the front end, here is the page
www.italianheart.it/index.php?option=com...t=listing&Itemid=979
Thanks a lot!

Hello,
I just tested it and fixed it, can you edit the "administrator\components\com_hikashop\classes\filter.php" file, and change that line :

$limit=' b.'.$filter->filter_data.' BETWEEN '.(float)$values[0].' AND '.(float)$values[1].' ';

if(strpos($filter->filter_data,'b.')!==0) $filter->filter_data = 'b.'.$filter->filter_data;
$limit=' '.$filter->filter_data.' BETWEEN '.(float)$values[0].' AND '.(float)$values[1].' ';

Hello!
Hikashop 2.3.5 Bisness vertion
Problem in front end :
1054 - Unknown column 'a.ordering' in 'order clause' SQL=SELECT a.* FROM fbj2u_hikashop_category AS a WHERE a.category_parent_id = 46 AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%') ORDER BY a.ordering ASC LIMIT 0, 15

The problem of the choice of the filter value on the category page.

did not help. The error persists. Deleted if you delete cookies, but if you select an error again in 1054.
The bug had appeared after upgrade.
Work on Hikashop version 2.3.1

Hello.
I updated again version 2,3,5 and filter the quantity of goods in the category started working.
Probably the first time update was unsuccessful
Thank you for taking the time to help.