1054 error on filters

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- :
-- Error-message(debug-mod must be tuned on) -- : Oh, dear, we have a 1054
Unknown column 'Array' in 'order clause' SQL=SELECT DISTINCT b.* FROM a04i_hikashop_product_category AS a LEFT JOIN a04i_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (12) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY Array DESC LIMIT 0, 18

Hi
I've been trying to set up as single drop down filter to allow filtering on name and price.

I've set it up on the top level category allowing all sub categories, to apply on sort and to sort on price and product name as per the example in the documentation.

The filter drop down appears per the image attached.

When selecting an option I get the following error:

Oh, dear, we have a 1054
Unknown column 'Array' in 'order clause' SQL=SELECT DISTINCT b.* FROM a04i_hikashop_product_category AS a LEFT JOIN a04i_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (16) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY Array ASC LIMIT 0, 18

Any help would be greatly appreciated.

Thanks in advance

KH

Hi Nicolas

I've downloaded and installed the updated package but still have the same issue.

Which were the files that have been updated - I could ftp them in to place to ensure that they are the ones being used.

Or do you have any other suggestions?

Thanks

KH

Hi

That's fixed it.

Thank you.
KH

Hi Nicolas,

I have nearly the same error, after updating with the full 2.3.5 package and the patch file in message #190607, without debug mode:

1054 - Unknown column 'Array' in 'order clause' SQL=SELECT DISTINCT b.* FROM bcn_hikashop_product_category AS a LEFT JOIN (SELECT * FROM bcn_hikashop_product AS product1 LEFT JOIN bcn_hikashop_price AS price1 ON product1.product_id=price1.price_product_id WHERE (price1.price_access = 'all' OR price1.price_access LIKE '%,1,%' OR ISNULL(price1.price_access)) AND product1.product_type='main' GROUP BY product1.product_id ORDER BY price1.price_min_quantity ASC) AS b ON a.product_id=b.product_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 '%,1,%') ORDER BY Array ASC LIMIT 0, 20

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4

Sorting on price and product name, single dropdown; configured like youtr example on www.hikashop.com/images/filters/filters_example2.jpg :

Yes, as mentioned in my message.

Let me know if you can not reproduce this problem. Than I can make you an admin account for troubleshooting.

TIA
Best regards,
Joris

Did you delete the filters that are currently set up and create new ones? I found that this was needed in addition to uploading the updated file.

KH

Thanks for this hint.
I tried everything with cache etc., but this was the solution.

Have a nice day,
Joris

Hello,

The updated "filter.php" solved a problem I had with a sort filter.

But, it introduced a strange new div when I add a cursor filter.
The div has no name so it mess up my css code.
Can you correct it ?

Best regards

Please find a small capture of the code.
In red : a cursor filter after changing filter.php
In blue : a cursor filter made before changing filter.php

Do you need the full html page ?

Hello,

Not directly related but I also got small errors in the code for the Sort filter (<label> missing ?)

Hello,

The last update solved many things.
I think the cursor filter on lenght is slightly different then cursor filter on custom fields on purpose. I could probably CSS the differences.

Thanks

I'm running currently the latest essential version.
trying to search bring the following error:

Unknown column 'a.product_descriptio' in 'where clause' SQL=SELECT DISTINCT a.product_id AS id, a.product_name, a.product_alias, a.product_canonical, a.product_created AS created , a.product_description, "1" AS browsernav, b.category_id as - 1054 category_id FROM ig52r_hikashop_product AS a INNER JOIN ig52r_hikashop_product_category AS b ON a.product_id=b.product_id WHERE a.product_published=1 AND a.product_type='main' AND b.category_id IN (2,12,85,78,79,80,76,77,70,71,72,16,83,84,17,51,52,53,54,55,56,57,58,59,60,61,62,63,50,64,47,48,49,24,81,82,25,74,75,68,69,65,66,67,73,30,31,32,34,35,36,37,38,39,40,41,42,43,44,45,46,86,87,88,89,90,91,92) AND ((((a.product_name LIKE '%lego%'))) OR (((a.product_descriptio LIKE '%lego%'))) OR (((a.PRODUCT_SKUn LIKE '%lego%')))) GROUP BY (a.product_id) ORDER BY a.product_modified DESC LIMIT 0, 50

please advise.

Thank you.