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: I think there should be comparison instead of assignment.

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,

Please give us the full 1054 error message.
The previous issue has been fixed in HikaShop 2.3.4.

Do you have HikaShop 2.3.4 ?

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,

Where have you this error ? Front end ? Back end ?
If it is in the front-endn are you using a filter or something like that ?

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 : By :

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.

Hi,

Please see : www.hikashop.com/forum/install-update/87...to-2-3-5.html#187297

Regards,

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

Hi,

On which page do you have the problem ? Could you provide a link ? Do you need to do something to reproduce the issue ? What exactly ?
How did you configure the products listing menu/module options (menu Display>Content menus) ? Could you provide a screenshot ?

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.