[Skip to main content](#vessel-content) # 1054 error on filters ## - **[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")** - [![vividfish's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/18346-vividfish "View vividfish's Profile") Topic Author - [ Offline](/forum/user/18346-vividfish) Less More - Posts: 46 - Thank you received: 1 - - 11 years 8 months ago - 11 years 8 months ago [\#190512](#190512) by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#190512 "-- 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")* was created by *[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")* -- 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 - [ ![filter.jpg](/forum/attachment/22344) ](/forum/attachment/22344 "filter.jpg") [ ](/forum/attachment/22344?download=1 "filter.jpg") Last edit: 11 years 8 months ago by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 11 years 8 months ago [\#190555](#190555) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#190555 "-- 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, We've fixed the issue on our end. Please download again the install package of HikaShop via the menu My account>My subscriptions on our website and install it on yours and it will add the patch to fix the issue. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")** - [![vividfish's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/18346-vividfish "View vividfish's Profile") Topic Author - [ Offline](/forum/user/18346-vividfish) Less More - Posts: 46 - Thank you received: 1 - - 11 years 8 months ago [\#190587](#190587) by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") Replied by *[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#190587 "-- 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 11 years 8 months ago [\#190607](#190607) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#190607 "-- 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, Replace the file administrator/components/com_hikashop/classes/filter.php with the one in this archive and that will do it: *This attachment is hidden for guests. Please log in or register to see it.* The following user(s) said Thank You: [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")** - [![vividfish's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/18346-vividfish "View vividfish's Profile") Topic Author - [ Offline](/forum/user/18346-vividfish) Less More - Posts: 46 - Thank you received: 1 - - 11 years 8 months ago [\#190610](#190610) by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") Replied by *[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#190610 "-- 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 That's fixed it. Thank you. ![:)](/media/kunena/emoticons/8.png ":)") KH Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Joris](/forum/user/29711-joris "View Joris's Profile")** - [![Joris's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/fish.gif)](/forum/user/29711-joris "View Joris's Profile") - [ Offline](/forum/user/29711-joris) Less More - Posts: 16 - Thank you received: 1 - - - 11 years 8 months ago [\#190655](#190655) by [Joris](/forum/user/29711-joris "View Joris's Profile") Replied by *[Joris](/forum/user/29711-joris "View Joris's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#190655 "-- 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 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](http://www.hikashop.com/images/filters/filters_example2.jpg): [ ![[img](http://www.hikashop.com/images/filters/filters_example2.jpg) ](http://www.hikashop.com/images/filters/filters_example2.jpg "[img") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 8 months ago [\#190656](#190656) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#190656 "-- 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, Did you try with the file provided by Nicolas ? ( [ www.hikashop.com/forum/filters-search/87...-filters.html#190607](http://www.hikashop.com/forum/filters-search/874944-1054-error-on-filters.html#190607) ) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Joris](/forum/user/29711-joris "View Joris's Profile")** - [![Joris's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/fish.gif)](/forum/user/29711-joris "View Joris's Profile") - [ Offline](/forum/user/29711-joris) Less More - Posts: 16 - Thank you received: 1 - - - 11 years 8 months ago [\#190693](#190693) by [Joris](/forum/user/29711-joris "View Joris's Profile") Replied by *[Joris](/forum/user/29711-joris "View Joris's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#190693 "-- 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")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")** - [![vividfish's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/18346-vividfish "View vividfish's Profile") Topic Author - [ Offline](/forum/user/18346-vividfish) Less More - Posts: 46 - Thank you received: 1 - - 11 years 8 months ago - 11 years 8 months ago [\#190695](#190695) by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") Replied by *[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#190695 "-- 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")* 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 Last edit: 11 years 8 months ago by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Joris](/forum/user/29711-joris "View Joris's Profile")** - [![Joris's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/fish.gif)](/forum/user/29711-joris "View Joris's Profile") - [ Offline](/forum/user/29711-joris) Less More - Posts: 16 - Thank you received: 1 - - - 11 years 8 months ago [\#190697](#190697) by [Joris](/forum/user/29711-joris "View Joris's Profile") Replied by *[Joris](/forum/user/29711-joris "View Joris's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#190697 "-- 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")* Thanks for this hint. I tried everything with cache etc., but this was the solution. Have a nice day, Joris Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dezajn](/forum/user/36157-dezajn "View dezajn's Profile")** - [![dezajn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36157-dezajn "View dezajn's Profile") - [ Offline](/forum/user/36157-dezajn) Less More - Posts: 24 - Thank you received: 0 - - - 11 years 8 months ago [\#191656](#191656) by [dezajn](/forum/user/36157-dezajn "View dezajn's Profile") Replied by *[dezajn](/forum/user/36157-dezajn "View dezajn's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#191656 "-- 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")* 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 - [ ![Filter_-_strange_div.jpg](/forum/attachment/22564) ](/forum/attachment/22564 "...trange_div.jpg") [ ](/forum/attachment/22564?download=1 "...trange_div.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 8 months ago [\#191663](#191663) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#191663 "-- 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, It will be interesting to have the raw content (from the source code and not the inspector). The inspector can "alter" the content in order to let him feet to the HTML specifications. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dezajn](/forum/user/36157-dezajn "View dezajn's Profile")** - [![dezajn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36157-dezajn "View dezajn's Profile") - [ Offline](/forum/user/36157-dezajn) Less More - Posts: 24 - Thank you received: 0 - - - 11 years 8 months ago [\#191683](#191683) by [dezajn](/forum/user/36157-dezajn "View dezajn's Profile") Replied by *[dezajn](/forum/user/36157-dezajn "View dezajn's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#191683 "-- 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")* 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 ? - [ ![Filter_-_strange_div_2.jpg](/forum/attachment/22573) ](/forum/attachment/22573 "...ange_div_2.jpg") [ ](/forum/attachment/22573?download=1 "...ange_div_2.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dezajn](/forum/user/36157-dezajn "View dezajn's Profile")** - [![dezajn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36157-dezajn "View dezajn's Profile") - [ Offline](/forum/user/36157-dezajn) Less More - Posts: 24 - Thank you received: 0 - - - 11 years 8 months ago - 11 years 8 months ago [\#191711](#191711) by [dezajn](/forum/user/36157-dezajn "View dezajn's Profile") Replied by *[dezajn](/forum/user/36157-dezajn "View dezajn's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#191711 "-- 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")* Hello, Not directly related but I also got small errors in the code for the Sort filter (<label> missing ?) - [ ![Filter_sort_1.jpg](/forum/attachment/22581) ](/forum/attachment/22581 "Filter_sort_1.jpg") [ ](/forum/attachment/22581?download=1 "Filter_sort_1.jpg") Last edit: 11 years 8 months ago by [dezajn](/forum/user/36157-dezajn "View dezajn's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 11 years 8 months ago [\#191745](#191745) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#191745 "-- 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, Here is the latest version of the filter.php file with a class added to that div so that you can still it like you want. *This attachment is hidden for guests. Please log in or register to see it.* The following user(s) said Thank You: [dezajn](/forum/user/36157-dezajn "View dezajn's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dezajn](/forum/user/36157-dezajn "View dezajn's Profile")** - [![dezajn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36157-dezajn "View dezajn's Profile") - [ Offline](/forum/user/36157-dezajn) Less More - Posts: 24 - Thank you received: 0 - - - 11 years 8 months ago [\#191851](#191851) by [dezajn](/forum/user/36157-dezajn "View dezajn's Profile") Replied by *[dezajn](/forum/user/36157-dezajn "View dezajn's Profile")* on topic *[1054 error on filters](/forum/45-filters-search/874944-1054-error-on-filters#191851 "-- 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")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[shoppist](/forum/user/31108-shoppist "View shoppist's Profile")** - [![shoppist's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31108-shoppist "View shoppist's Profile") - [ Offline](/forum/user/31108-shoppist) Less More - Posts: 108 - Thank you received: 1 - - 11 years 7 months ago [\#192583](#192583) by [shoppist](/forum/user/31108-shoppist "View shoppist's Profile") Replied by *[shoppist](/forum/user/31108-shoppist "View shoppist's Profile")* on topic *[1054 error on normal search](/forum/45-filters-search/874944-1054-error-on-filters#192583 "-- 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")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 11 years 7 months ago [\#192589](#192589) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 error on normal search](/forum/45-filters-search/874944-1054-error-on-filters#192589 "-- 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, There are no filters in the Essential edition so your question is not related to this thread. You must be using the normal search system of Joomla and you must have enabled the HikaShop products search plugin. The issue here is that in the columns option of the plugin, you selected a product_descriptio column which doesn't exist. I believe that you deleted the n at the end of the word and that you wanted to write product_description. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NDk0NC0xMDU0LWVycm9yLW9uLWZpbHRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.495 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)