[Skip to main content](#vessel-content)

#   Filter and Search not working as expected

##

- **[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")**
- [![grayt7's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30010.jpg)](/forum/user/30010-grayt7 "View grayt7's Profile") Topic Author
- [ Offline](/forum/user/30010-grayt7)

Less More

- Posts: 377
- Thank you received: 7
-
-
- [](http://www.identitywebdesign.com)
-

11 years 8 months ago [\#191965](#191965) by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")  *[Filter and Search not working as expected](/forum/45-filters-search/875198-filter-and-search-not-working-as-expected#191965 "-- url of the page with the problem -- :   fancydresshut.com/index.php?option=com&#95;c...cle&amp;id=52&amp;Itemid=241  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'a.content' in 'where clause' SQL=SELECT DISTINCT a.product&#95;id AS id, a.product&#95;name, a.product&#95;alias, a.product&#95;canonical, a.product&#95;created AS created , a.product&#95;description, &quot;1&quot; AS browsernav, a.product&#95;type, a.product&#95;parent&#95;id, b.category&#95;id as category&#95;id FROM wdsx9&#95;hikashop&#95;product AS a INNER JOIN wdsx9&#95;hikashop&#95;product&#95;category AS b ON a.product&#95;parent&#95;id=b.product&#95;id OR a.product&#95;id=b.product&#95;id WHERE a.product&#95;published=1 AND (a.product&#95;access = 'all' OR a.product&#95;access LIKE '%,1,%') AND b.category&#95;id IN (2,79,78,76,75,59,62,61,63,22,23,24,25,26,27,28,29,30,31,32,33,74,64,65,67,68,69,70,71,72,73,60,80,81,82,83,84,85,86,87,88,89,91,92,93,96,95,97,98) AND ((((a.product&#95;name LIKE '%morph%'))) OR (((a.product&#95;description LIKE '%morph%'))) OR (((a.product&#95;code LIKE '%morph%'))) OR (((a.content LIKE '%morph%'))) OR (((a.region LIKE '%morph%'))) OR (((a.size LIKE '%morph%')))) GROUP BY (a.product&#95;id) ORDER BY a.product&#95;modified DESC LIMIT 0, 50  Hi,  I have setup a filter, however, the search results are always the same, just seem to show categories with pagination that doesn't work? There are no products that are shown.  When using the default joomla search I get an SQL error.  Please help :)  Thanks.")* was created by *[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")*

-- url of the page with the problem -- : [ fancydresshut.com/index.php?option=com\_c...cle&amp;id=52&amp;Itemid=241](http://fancydresshut.com/index.php?option=com_content&view=article&id=52&Itemid=241)
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3
-- Browser(s) name and version -- : any
-- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'a.content' 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, a.product_type, a.product_parent_id, b.category_id as category_id FROM wdsx9_hikashop_product AS a INNER JOIN wdsx9_hikashop_product_category AS b ON a.product_parent_id=b.product_id OR a.product_id=b.product_id WHERE a.product_published=1 AND (a.product_access = 'all' OR a.product_access LIKE '%,1,%') AND b.category_id IN (2,79,78,76,75,59,62,61,63,22,23,24,25,26,27,28,29,30,31,32,33,74,64,65,67,68,69,70,71,72,73,60,80,81,82,83,84,85,86,87,88,89,91,92,93,96,95,97,98) AND ((((a.product_name LIKE '%morph%'))) OR (((a.product_description LIKE '%morph%'))) OR (((a.product_code LIKE '%morph%'))) OR (((a.content LIKE '%morph%'))) OR (((a.region LIKE '%morph%'))) OR (((a.size LIKE '%morph%')))) GROUP BY (a.product_id) ORDER BY a.product_modified DESC LIMIT 0, 50

Hi,

I have setup a filter, however, the search results are always the same, just seem to show categories with pagination that doesn't work? There are no products that are shown.

When using the default joomla search I get an SQL error.

Please help ![:)](/media/kunena/emoticons/3.png ":)")

Thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NTE5OC1maWx0ZXItYW5kLXNlYXJjaC1ub3Qtd29ya2luZy1hcy1leHBlY3RlZD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

11 years 8 months ago [\#191972](#191972) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Filter and Search not working as expected](/forum/45-filters-search/875198-filter-and-search-not-working-as-expected#191972 "-- url of the page with the problem -- :   fancydresshut.com/index.php?option=com&#95;c...cle&amp;id=52&amp;Itemid=241  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'a.content' in 'where clause' SQL=SELECT DISTINCT a.product&#95;id AS id, a.product&#95;name, a.product&#95;alias, a.product&#95;canonical, a.product&#95;created AS created , a.product&#95;description, &quot;1&quot; AS browsernav, a.product&#95;type, a.product&#95;parent&#95;id, b.category&#95;id as category&#95;id FROM wdsx9&#95;hikashop&#95;product AS a INNER JOIN wdsx9&#95;hikashop&#95;product&#95;category AS b ON a.product&#95;parent&#95;id=b.product&#95;id OR a.product&#95;id=b.product&#95;id WHERE a.product&#95;published=1 AND (a.product&#95;access = 'all' OR a.product&#95;access LIKE '%,1,%') AND b.category&#95;id IN (2,79,78,76,75,59,62,61,63,22,23,24,25,26,27,28,29,30,31,32,33,74,64,65,67,68,69,70,71,72,73,60,80,81,82,83,84,85,86,87,88,89,91,92,93,96,95,97,98) AND ((((a.product&#95;name LIKE '%morph%'))) OR (((a.product&#95;description LIKE '%morph%'))) OR (((a.product&#95;code LIKE '%morph%'))) OR (((a.content LIKE '%morph%'))) OR (((a.region LIKE '%morph%'))) OR (((a.size LIKE '%morph%')))) GROUP BY (a.product&#95;id) ORDER BY a.product&#95;modified DESC LIMIT 0, 50  Hi,  I have setup a filter, however, the search results are always the same, just seem to show categories with pagination that doesn't work? There are no products that are shown.  When using the default joomla search I get an SQL error.  Please help :)  Thanks.")*

Hi,

1. In your hikashop filter module, in the "menu" option, you entered the id of a menu item of the type "hikashop category listing" instead of entering the id of a menu item of the type "hikashop product listing". That's why you don't get any result with the filter module.

2. For the query issue, that's because in the "columns" option of the HikaShop search plugin, that you can configure via the Joomla plugins manager, you entered the name of a column "content" which doesn't exist anymore. Remove it and you wont' get the error.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NTE5OC1maWx0ZXItYW5kLXNlYXJjaC1ub3Qtd29ya2luZy1hcy1leHBlY3RlZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")**
- [![grayt7's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30010.jpg)](/forum/user/30010-grayt7 "View grayt7's Profile") Topic Author
- [ Offline](/forum/user/30010-grayt7)

Less More

- Posts: 377
- Thank you received: 7
-
-
- [](http://www.identitywebdesign.com)
-

11 years 8 months ago [\#192066](#192066) by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")  Replied by *[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")* on topic *[Filter and Search not working as expected](/forum/45-filters-search/875198-filter-and-search-not-working-as-expected#192066 "-- url of the page with the problem -- :   fancydresshut.com/index.php?option=com&#95;c...cle&amp;id=52&amp;Itemid=241  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'a.content' in 'where clause' SQL=SELECT DISTINCT a.product&#95;id AS id, a.product&#95;name, a.product&#95;alias, a.product&#95;canonical, a.product&#95;created AS created , a.product&#95;description, &quot;1&quot; AS browsernav, a.product&#95;type, a.product&#95;parent&#95;id, b.category&#95;id as category&#95;id FROM wdsx9&#95;hikashop&#95;product AS a INNER JOIN wdsx9&#95;hikashop&#95;product&#95;category AS b ON a.product&#95;parent&#95;id=b.product&#95;id OR a.product&#95;id=b.product&#95;id WHERE a.product&#95;published=1 AND (a.product&#95;access = 'all' OR a.product&#95;access LIKE '%,1,%') AND b.category&#95;id IN (2,79,78,76,75,59,62,61,63,22,23,24,25,26,27,28,29,30,31,32,33,74,64,65,67,68,69,70,71,72,73,60,80,81,82,83,84,85,86,87,88,89,91,92,93,96,95,97,98) AND ((((a.product&#95;name LIKE '%morph%'))) OR (((a.product&#95;description LIKE '%morph%'))) OR (((a.product&#95;code LIKE '%morph%'))) OR (((a.content LIKE '%morph%'))) OR (((a.region LIKE '%morph%'))) OR (((a.size LIKE '%morph%')))) GROUP BY (a.product&#95;id) ORDER BY a.product&#95;modified DESC LIMIT 0, 50  Hi,  I have setup a filter, however, the search results are always the same, just seem to show categories with pagination that doesn't work? There are no products that are shown.  When using the default joomla search I get an SQL error.  Please help :)  Thanks.")*

Hi,

thanks for the quick reply.

1. I do that the product listing menu item ID spefcified in the filter module? Anything else I may be missing?

2. Fixed THANKS!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NTE5OC1maWx0ZXItYW5kLXNlYXJjaC1ub3Qtd29ya2luZy1hcy1leHBlY3RlZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

11 years 8 months ago [\#192075](#192075) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Filter and Search not working as expected](/forum/45-filters-search/875198-filter-and-search-not-working-as-expected#192075 "-- url of the page with the problem -- :   fancydresshut.com/index.php?option=com&#95;c...cle&amp;id=52&amp;Itemid=241  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'a.content' in 'where clause' SQL=SELECT DISTINCT a.product&#95;id AS id, a.product&#95;name, a.product&#95;alias, a.product&#95;canonical, a.product&#95;created AS created , a.product&#95;description, &quot;1&quot; AS browsernav, a.product&#95;type, a.product&#95;parent&#95;id, b.category&#95;id as category&#95;id FROM wdsx9&#95;hikashop&#95;product AS a INNER JOIN wdsx9&#95;hikashop&#95;product&#95;category AS b ON a.product&#95;parent&#95;id=b.product&#95;id OR a.product&#95;id=b.product&#95;id WHERE a.product&#95;published=1 AND (a.product&#95;access = 'all' OR a.product&#95;access LIKE '%,1,%') AND b.category&#95;id IN (2,79,78,76,75,59,62,61,63,22,23,24,25,26,27,28,29,30,31,32,33,74,64,65,67,68,69,70,71,72,73,60,80,81,82,83,84,85,86,87,88,89,91,92,93,96,95,97,98) AND ((((a.product&#95;name LIKE '%morph%'))) OR (((a.product&#95;description LIKE '%morph%'))) OR (((a.product&#95;code LIKE '%morph%'))) OR (((a.content LIKE '%morph%'))) OR (((a.region LIKE '%morph%'))) OR (((a.size LIKE '%morph%')))) GROUP BY (a.product&#95;id) ORDER BY a.product&#95;modified DESC LIMIT 0, 50  Hi,  I have setup a filter, however, the search results are always the same, just seem to show categories with pagination that doesn't work? There are no products that are shown.  When using the default joomla search I get an SQL error.  Please help :)  Thanks.")*

Hi,

If you have set the item id of a product listing menu able to list all the products of the shop, so that must be working.
Please give us a link to a page with the filter in order to have mode informations.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NTE5OC1maWx0ZXItYW5kLXNlYXJjaC1ub3Qtd29ya2luZy1hcy1leHBlY3RlZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")**
- [![grayt7's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30010.jpg)](/forum/user/30010-grayt7 "View grayt7's Profile") Topic Author
- [ Offline](/forum/user/30010-grayt7)

Less More

- Posts: 377
- Thank you received: 7
-
-
- [](http://www.identitywebdesign.com)
-

11 years 7 months ago [\#196111](#196111) by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")  Replied by *[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")* on topic *[Filter and Search not working as expected](/forum/45-filters-search/875198-filter-and-search-not-working-as-expected#196111 "-- url of the page with the problem -- :   fancydresshut.com/index.php?option=com&#95;c...cle&amp;id=52&amp;Itemid=241  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'a.content' in 'where clause' SQL=SELECT DISTINCT a.product&#95;id AS id, a.product&#95;name, a.product&#95;alias, a.product&#95;canonical, a.product&#95;created AS created , a.product&#95;description, &quot;1&quot; AS browsernav, a.product&#95;type, a.product&#95;parent&#95;id, b.category&#95;id as category&#95;id FROM wdsx9&#95;hikashop&#95;product AS a INNER JOIN wdsx9&#95;hikashop&#95;product&#95;category AS b ON a.product&#95;parent&#95;id=b.product&#95;id OR a.product&#95;id=b.product&#95;id WHERE a.product&#95;published=1 AND (a.product&#95;access = 'all' OR a.product&#95;access LIKE '%,1,%') AND b.category&#95;id IN (2,79,78,76,75,59,62,61,63,22,23,24,25,26,27,28,29,30,31,32,33,74,64,65,67,68,69,70,71,72,73,60,80,81,82,83,84,85,86,87,88,89,91,92,93,96,95,97,98) AND ((((a.product&#95;name LIKE '%morph%'))) OR (((a.product&#95;description LIKE '%morph%'))) OR (((a.product&#95;code LIKE '%morph%'))) OR (((a.content LIKE '%morph%'))) OR (((a.region LIKE '%morph%'))) OR (((a.size LIKE '%morph%')))) GROUP BY (a.product&#95;id) ORDER BY a.product&#95;modified DESC LIMIT 0, 50  Hi,  I have setup a filter, however, the search results are always the same, just seem to show categories with pagination that doesn't work? There are no products that are shown.  When using the default joomla search I get an SQL error.  Please help :)  Thanks.")*

Hi,

Sorry about the late reply to this. Unfortuantely as business goes other things sometimes take priority.

I have made the filter search live on all pages: [ fancydresshut.com/index.php](http://fancydresshut.com/index.php)

I can't get it to show the results at all. Yes I have added the correct ItemID to display the results but it keeps just displaying the categories?

Thanks,

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NTE5OC1maWx0ZXItYW5kLXNlYXJjaC1ub3Qtd29ya2luZy1hcy1leHBlY3RlZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")**
- [![grayt7's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30010.jpg)](/forum/user/30010-grayt7 "View grayt7's Profile") Topic Author
- [ Offline](/forum/user/30010-grayt7)

Less More

- Posts: 377
- Thank you received: 7
-
-
- [](http://www.identitywebdesign.com)
-

11 years 7 months ago [\#196144](#196144) by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")  Replied by *[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")* on topic *[Filter and Search not working as expected](/forum/45-filters-search/875198-filter-and-search-not-working-as-expected#196144 "-- url of the page with the problem -- :   fancydresshut.com/index.php?option=com&#95;c...cle&amp;id=52&amp;Itemid=241  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'a.content' in 'where clause' SQL=SELECT DISTINCT a.product&#95;id AS id, a.product&#95;name, a.product&#95;alias, a.product&#95;canonical, a.product&#95;created AS created , a.product&#95;description, &quot;1&quot; AS browsernav, a.product&#95;type, a.product&#95;parent&#95;id, b.category&#95;id as category&#95;id FROM wdsx9&#95;hikashop&#95;product AS a INNER JOIN wdsx9&#95;hikashop&#95;product&#95;category AS b ON a.product&#95;parent&#95;id=b.product&#95;id OR a.product&#95;id=b.product&#95;id WHERE a.product&#95;published=1 AND (a.product&#95;access = 'all' OR a.product&#95;access LIKE '%,1,%') AND b.category&#95;id IN (2,79,78,76,75,59,62,61,63,22,23,24,25,26,27,28,29,30,31,32,33,74,64,65,67,68,69,70,71,72,73,60,80,81,82,83,84,85,86,87,88,89,91,92,93,96,95,97,98) AND ((((a.product&#95;name LIKE '%morph%'))) OR (((a.product&#95;description LIKE '%morph%'))) OR (((a.product&#95;code LIKE '%morph%'))) OR (((a.content LIKE '%morph%'))) OR (((a.region LIKE '%morph%'))) OR (((a.size LIKE '%morph%')))) GROUP BY (a.product&#95;id) ORDER BY a.product&#95;modified DESC LIMIT 0, 50  Hi,  I have setup a filter, however, the search results are always the same, just seem to show categories with pagination that doesn't work? There are no products that are shown.  When using the default joomla search I get an SQL error.  Please help :)  Thanks.")*

Hi,

I fixed the issue. To anyone who may be having the same problem here is my solution.

On the module setting of the filter you need to specify the ItemId of the search result page. That itemId has to be of type hikashop and the "Type of Content" will need to be what you want the results to be. So if you want the results to be categories then select Category, if product then Product. I had done all this an still couldn't get it to work. My solution was to change "Type of layout" to something other than "inherit" as that doesn't seem to work.

Many thanks!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3NTE5OC1maWx0ZXItYW5kLXNlYXJjaC1ub3Qtd29ya2luZy1hcy1leHBlY3RlZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.094 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
