1054 - Unknown column...

I've been working on the filters for all product categories and they all work a treat. The only problem I'm having now is that I've created a filters for the brands pages too and they don't work.

The filter shows up fine, but when I select a search criteria and click 'Filter', it brings me to an error page with the following message:
1054 - Unknown column 'a.product_id' in 'on clause' SQL=SELECT DISTINCT b.* FROM zudjf_hikashop_product AS b INNER JOIN zudjf_hikashop_product_category AS Brand_Colour2 ON Brand_Colour2.product_id=a.product_id AND Brand_Colour2.category_id IN (73) WHERE b.product_published=1 AND b.product_type = 'main' AND b.product_manufacturer_id IN (22) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY b.product_created DESC LIMIT 0, 12

I've googled the error message, but can's find an answer.
Does anyone know what I can do to fix this?

I've unpublished the filter (except for the price filter, which seems to work) so the message does not come up in the meantime, but I've attached a screenshot.

Please replace the content of the file administrator/components/com_hikashop/classes/filter.php with this:
pastebin.com/K2zMf5cW

Hi Nicolas,

Thanks for your response.

I replaced the specific page with pastebin.com/K2zMf5cW as suggested, but this brings up an error page across the entire website:

Fatal error: Call to a member function getFilters() on a non-object in /homepages/30/d293983197/htdocs/elevateshop/components/com_hikashop/views/product/view.html.php on line 125

What should i do?

Hi,

This indicates that HikaShop didn't find the code for the filter class (the code that I told you to put in the filter.php file.
So you must not have copy/pasted the code in the filter.php properly or something.

Hi Nicolas,

I replaced the entire page with pastebin.com/K2zMf5cW, I guess this was not correct. Where exactly should I place the code in the filter.php file?

You should indeed replace the whole file. There is nothing particular to do.

I am having the same problem. I have two filters on my site diamondnecessities.com/index.php?option=...og&id=99&Itemid=1610 - Price, and Carat Size.

I uploaded the newest version of Hikashop yesterday.

Now the price filter is not working. However, I don't know for sure that the price filter was working before the update either. The carat filter is working just fine.

I tried deleting and recreating the filter. I tried the suggestions you made to the previous person with this problem. I created an entirely new filter (new name) and reset the related parameters. Nothing has worked. Here is the error I am getting:
diamondnecessities.com/index.php?option=...k=listing&Itemid=424

Thank you.

Hi,

The error that you have on your website is different than the error that the other user on this thread had.
Could you replace the content of the file administrator/components/com_hikashop/classes/filter.php with this pastebin.com/K2zMf5cW and try again ?

This doesn't fix it either . Any other suggestions? This filter is really important.

Then I don't know and it would require debugging the problem on the website.
Please provide a FTP access and a link to this thread via our contact form and we can look deeper into the problem.
www.hikashop.com/support/contact-us.html

Hi, I have the same problem, I send you FTP access to my site.

Problem on this page : www.impress-3d.com/fichiers-3d/imprimante-3d.html

I replace the content of the file administrator/components/com_hikashop/classes/filter.php with this pastebin.com/K2zMf5cW but it doesn't fix the problem.
After replace I have this message :
Parse error: syntax error, unexpected 'hikashopFilterClass' (T_STRING) in /administrator/components/com_hikashop/classes/filter.php on line 1

Thank you

(sorry for my bad english)

Hi,

@nossibe63: I've just copied the code from pastebin.com to your filter.php and it didn't create any error and just fix the problem. So I'm thinking that you didn't do your copy/paste from my pastebin.com link properly.

Hi,

I do not understand how I could copy the code wrong, yet I have done this several times with the top code and then with the bottom one ...

Thank you for your help!

Regards, Nossibe

thanks helped

I just tried it again, in case I was making a mistake. Still not fixed. One thing I noticed. You told me to replace the pastebin file into

administrator/components/com_hikashop/classes/filter.php

I don't have a /classes/ folder. My filter.php is in components/com_hikashop/fields/filter.php. Could that be part of the problem?

update hikashop

I'm on the latest version.

delete and new

Hi,

@andreahill : You do not look in the right folder.
"administrator/components/com_hikashop/classes/filter.php"

@permsk : Thanks for the help ; don't worry, we will handle it.

Regards,

Oh good grief. You are so right. OK, it's fixed. Sorry!