No results on filtering

-- HikaShop version -- : 2.3.1
-- Joomla version -- : 3.2.3
-- Browser(s) name and version -- : chrome

I created multiple costum fields and a filter on frontend, but if I choose any of them, no results where found. I search around the forum, but didn't found the solution. I also don't get any error messages.

What am I doing wrong?

Jerome wrote: Hi,

Your website is currently offline ; so we can't take a look.

Regards,

I've send you a PM with the userdata, thank you!

Hi,

How are you displaying the filters ? In the category listing or via the filter module ?
If it is the module, in the "menu" parameter, you have to set the id of a product listing menu which is listing all the available products on your website.

Else are you sure that the entered data are valid ?

I display it in the category listing.

What you define as valid? I didn't found anywhere rules for validation.

I changed from maintenance mode to htaccess and tested the login data I've send you and it works for me to login in both. htaccess and website.

Hello,
Your issue is coming from the fact that you have added all of your products through the "Rosen" category, and that you don't have any product through the sub-categories of the "Rosen" category.
The solution will just be to add your product through the "Rosen" sub-categories.

No I don't have all products in the Rosen category. Some subcategories are empty, but all plant products are in sub categories of the Rosen category. For example product category / Rosen / Historische Rosen

If you use in the backend the filter "Direct subelements" in the product view of "Rosen" category, the list is empty. So all products are in the subcategories.

I changed the code and turned the debug mode on.

I found the issue. You check for if $field=' ' to determine if you want to search for it or not. This results in this query.

SELECT DISTINCT b.* 
  FROM #__hikashop_product_category AS a 
  LEFT JOIN #__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 (20) 
  AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') 
  AND (b.untergruppe LIKE '%none%') 
  AND (b.farbgruppe LIKE '%none%') 
  AND (b.bluetenmerkmale LIKE '%none%') 
  AND (b.duft LIKE '%none%') 
  AND (b.einmalmehrmalsbluehend LIKE '%none%') 
  AND (b.gesundheit LIKE '%none%') 
  AND (b.winterhaerte LIKE '%none%') 
  AND (b.hoehe LIKE '%none%') 
  AND (b.besondereeignung LIKE '%Schnittblume%') 
  AND (b.wuchsform LIKE '%none%') 
  AND (b.stammrosenverfuegbarkeit LIKE '%none%') 
  AND (b.pflanzabstand LIKE '%none%') 
  ORDER BY a.ordering ASC 
  LIMIT 0, 21

&& $field!='none')

SELECT DISTINCT b.* 
  FROM #__hikashop_product_category AS a 
  LEFT JOIN #__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 (20) 
  AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') 
  AND (b.besondereeignung LIKE '%Schnittblume%') 
  ORDER BY a.ordering ASC 
  LIMIT 0, 21

foreach($infoGet as $field){
    if($field!=$filter->filter_namekey && $field!=' ' && $field!='none'){
	//$fieldsList.=' b.'.$filter->filter_options['custom_field'].' =  '.$database->Quote($field).' OR';
	$fieldsList[]='b.'.$filter->filter_options['custom_field'].' LIKE \'%'.hikashop_getEscaped($field,true).'%\'';
    }
}

No further response?

Will this be fixed or am I wrong?