Hi Xavier,
1)my HikaShop Business version is 2.1.2
2)Screenshot No.1:
3)
Screenshot No.2:
4)
The corresponding lines in "filter.php" are the following. (The second from top is line 981, mentioned in the error message):
if($filter->filter_data=='category'){
if(!($infoGet[0]==$filter->filter_namekey && count($infoGet)==1)){
$categoriesList='';
foreach($infoGet as $cat){
if($cat!=$filter->filter_namekey){
$categoriesList.=(int)$cat.',';
}
}
$categoriesList=substr($categoriesList,0,-1);
$table = 'a';
if(preg_match('#hikashop_product AS ([a-z0-9_]+)#i',$a,$matches)){
$table = $matches[1];
}
$on.=' INNER JOIN '.hikashop_table('product_category').' AS '.$filter->filter_namekey.$i.' ON '.$filter->filter_namekey.$i.'.product_id='.$table.'.product_id AND '.$filter->filter_namekey.$i.'.category_id IN ('.$categoriesList.')';
}
}
I hope you can help me...