Filter doesn't show any product on Brand pages

-- url of the page with the problem -- : mainili.com
-- HikaShop version -- : bussiness 2.3.0
-- Joomla version -- : 2.5.17
-- PHP version -- : 5.2.17
-- Browser(s) name and version -- : Firefox, Chrome, Explorer
-- Error-message(debug-mod must be tuned on) -- : Hata: 500 - JDatabaseMySQL::query: 1054 - Unknown column 'a.product_id' in 'on clause' SQL=SELECT DISTINCT b.* FROM ll6dp_hikashop_product AS b INNER JOIN ll6dp_hikashop_product_category AS Filter_by_Design1 ON Filter_by_Design1.product_id=a.product_id AND Filter_by_Design1.category_id IN (20) WHERE b.product_published=1 AND b.product_type = 'main' AND b.product_manufacturer_id IN (52) AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') ORDER BY b.product_name ASC LIMIT 0, 100

I created two filters, one for product categories and one for brands. When I use "filter by brands" on product categories, it filters but when I use "filter by product" on brands it doesn't show any products.

Could you please help me ?

Do I have to upload new version via extension manager or is there any way to update ? Because even I use Bussiness edition, Extension manager -> Update shows Hikashop Essential.

Hello,
You'll just have to download the last Hikashop version through our website, and install it through your extension manager.

I have the same issue. Brands were working on 3.2.0 but filters were not working in Chrome. I have upgraded to 2.3.2 and the Chrome issue is resolved but brands are now not coming up in filters and manufacturer name no longer exists in the list of fields we can filter on. Manufacturer ID is there but not name.

Hello,
Do you also have the " 500 - JDatabaseMySQL::query: 1054 .." error ? Can you show me some screeshots of how did you configured your filters ?

There is no error message, just empty search results. I will pm you the access as it is a development site and still offline

EDIT: Ok I think I have found the problem. The filter appears to start at the current page and search only that page and its subcategories. It appears to be ignoring the category specified in the filter parameters.

Whether I have no category, or the top level product category the result is the same. The filter only shows results from the currently viewed page so the category selected doesn't appear to do anything.

What I was trying to achieve was a sitewide search that would display product as thumbnails. Is this not possible?

Sorry, I thought you were done. Its reactivated now.

I've PM'd the access details again. I've made that change in the php but no change.