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 ?

Hi,

Please update to the latest version of HikaShop and it should fix the problem.

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.

Hi,

I guess that you want to remove the category that you selected in the category option of your filter so that the filter applies regardless of the category.

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?

Yes, it is definitely possible.

Please provide a backend access and we can check your settings.
The access that you had provided previously doesn't work anymore.

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

Hi,

Warning
Username and password do not match or you do not have an account yet.

Sorry, the credentials we got are not working.

In your filters, do you have filter on characteristics ?
If so, please edit the file "administrator/components/com_hikashop/classes/filter.php" and replace the line By
Regards,

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

Hi,

You don't have the same error as the other person who started this thread.
There is no error on your pages when you use the filters.

However, the display of the results are done based on the products already displayed because the "force redirect" option of your filter module is not turned on. I've turned it on for you (also the products listing menu item used for it was not configured properly so I've fixed its options).
I think that it's working like you want now.