Filter and Search not working as expected

-- url of the page with the problem -- : fancydresshut.com/index.php?option=com_c...cle&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

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!

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.

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

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,

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!