[Skip to main content](#vessel-content) # 1054 - Unknown column... ## - **[Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile")** - [![Lexnia's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28370.jpg)](/forum/user/28370-lexnia "View Lexnia's Profile") Topic Author - [ Offline](/forum/user/28370-lexnia) Less More - Posts: 52 - Thank you received: 2 - - 12 years 2 months ago [\#166589](#166589) by [Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile") *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#166589 "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.")* was created by *[Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile")* 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. [ ![Untitled-1.jpg](/forum/attachment/18868) ](/forum/attachment/18868 "Untitled-1.jpg") - [ ![Untitled-1.jpg](/forum/attachment/18868) ](/forum/attachment/18868 "Untitled-1.jpg") [ ](/forum/attachment/18868?download=1 "Untitled-1.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 12 years 2 months ago [\#166596](#166596) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#166596 "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](http://pastebin.com/K2zMf5cW) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile")** - [![Lexnia's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28370.jpg)](/forum/user/28370-lexnia "View Lexnia's Profile") Topic Author - [ Offline](/forum/user/28370-lexnia) Less More - Posts: 52 - Thank you received: 2 - - 12 years 2 months ago [\#166700](#166700) by [Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile") Replied by *[Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#166700 "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.")* 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? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 12 years 2 months ago [\#166719](#166719) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#166719 "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.")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile")** - [![Lexnia's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28370.jpg)](/forum/user/28370-lexnia "View Lexnia's Profile") Topic Author - [ Offline](/forum/user/28370-lexnia) Less More - Posts: 52 - Thank you received: 2 - - 12 years 2 months ago [\#166801](#166801) by [Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile") Replied by *[Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#166801 "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.")* 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? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 12 years 2 months ago [\#166806](#166806) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#166806 "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.")* You should indeed replace the whole file. There is nothing particular to do. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[andreahill](/forum/user/5849-andreahill "View andreahill's Profile")** - [![andreahill's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5849-andreahill "View andreahill's Profile") - [ Offline](/forum/user/5849-andreahill) Less More - Posts: 20 - Thank you received: 1 - - 12 years 2 months ago [\#169028](#169028) by [andreahill](/forum/user/5849-andreahill "View andreahill's Profile") Replied by *[andreahill](/forum/user/5849-andreahill "View andreahill's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#169028 "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.")* I am having the same problem. I have two filters on my site [ diamondnecessities.com/index.php?option=...og&id=99&Itemid=1610](http://diamondnecessities.com/index.php?option=com_content&view=category&layout=blog&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](http://diamondnecessities.com/index.php?option=com_hikashop&ctrl=product&task=listing&Itemid=424) Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 12 years 2 months ago [\#169035](#169035) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#169035 "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.")* 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](http://pastebin.com/K2zMf5cW) and try again ? The following user(s) said Thank You: [kassil](/forum/user/34195-kassil "View kassil's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[andreahill](/forum/user/5849-andreahill "View andreahill's Profile")** - [![andreahill's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5849-andreahill "View andreahill's Profile") - [ Offline](/forum/user/5849-andreahill) Less More - Posts: 20 - Thank you received: 1 - - 12 years 1 month ago [\#169644](#169644) by [andreahill](/forum/user/5849-andreahill "View andreahill's Profile") Replied by *[andreahill](/forum/user/5849-andreahill "View andreahill's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#169644 "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.")* This doesn't fix it either ![:(](/media/kunena/emoticons/5.png ":("). Any other suggestions? This filter is really important. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 12 years 1 month ago [\#169656](#169656) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#169656 "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.")* 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](https://www.hikashop.com/support/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nossibe63](/forum/user/31216-nossibe63 "View nossibe63's Profile")** - [![nossibe63's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar31216.png)](/forum/user/31216-nossibe63 "View nossibe63's Profile") - [ Offline](/forum/user/31216-nossibe63) Less More - Posts: 163 - Thank you received: 11 - - 12 years 1 month ago - 12 years 1 month ago [\#169705](#169705) by [nossibe63](/forum/user/31216-nossibe63 "View nossibe63's Profile") Replied by *[nossibe63](/forum/user/31216-nossibe63 "View nossibe63's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#169705 "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.")* 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](https://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) Last edit: 12 years 1 month ago by [nossibe63](/forum/user/31216-nossibe63 "View nossibe63's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 12 years 1 month ago [\#169795](#169795) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#169795 "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.")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nossibe63](/forum/user/31216-nossibe63 "View nossibe63's Profile")** - [![nossibe63's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar31216.png)](/forum/user/31216-nossibe63 "View nossibe63's Profile") - [ Offline](/forum/user/31216-nossibe63) Less More - Posts: 163 - Thank you received: 11 - - 12 years 1 month ago [\#169810](#169810) by [nossibe63](/forum/user/31216-nossibe63 "View nossibe63's Profile") Replied by *[nossibe63](/forum/user/31216-nossibe63 "View nossibe63's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#169810 "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.")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[permsk](/forum/user/28179-permsk "View permsk's Profile")** - [![permsk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/28179-permsk "View permsk's Profile") - [ Offline](/forum/user/28179-permsk) Less More - Posts: 101 - Thank you received: 2 - - 12 years 1 month ago [\#170166](#170166) by [permsk](/forum/user/28179-permsk "View permsk's Profile") Replied by *[permsk](/forum/user/28179-permsk "View permsk's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#170166 "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.")* thanks helped Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[andreahill](/forum/user/5849-andreahill "View andreahill's Profile")** - [![andreahill's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5849-andreahill "View andreahill's Profile") - [ Offline](/forum/user/5849-andreahill) Less More - Posts: 20 - Thank you received: 1 - - 12 years 1 month ago [\#170288](#170288) by [andreahill](/forum/user/5849-andreahill "View andreahill's Profile") Replied by *[andreahill](/forum/user/5849-andreahill "View andreahill's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#170288 "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.")* 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? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[permsk](/forum/user/28179-permsk "View permsk's Profile")** - [![permsk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/28179-permsk "View permsk's Profile") - [ Offline](/forum/user/28179-permsk) Less More - Posts: 101 - Thank you received: 2 - - 12 years 1 month ago [\#170298](#170298) by [permsk](/forum/user/28179-permsk "View permsk's Profile") Replied by *[permsk](/forum/user/28179-permsk "View permsk's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#170298 "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.")* update hikashop Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[andreahill](/forum/user/5849-andreahill "View andreahill's Profile")** - [![andreahill's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5849-andreahill "View andreahill's Profile") - [ Offline](/forum/user/5849-andreahill) Less More - Posts: 20 - Thank you received: 1 - - 12 years 1 month ago [\#170299](#170299) by [andreahill](/forum/user/5849-andreahill "View andreahill's Profile") Replied by *[andreahill](/forum/user/5849-andreahill "View andreahill's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#170299 "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.")* I'm on the latest version. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[permsk](/forum/user/28179-permsk "View permsk's Profile")** - [![permsk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/28179-permsk "View permsk's Profile") - [ Offline](/forum/user/28179-permsk) Less More - Posts: 101 - Thank you received: 2 - - 12 years 1 month ago [\#170309](#170309) by [permsk](/forum/user/28179-permsk "View permsk's Profile") Replied by *[permsk](/forum/user/28179-permsk "View permsk's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#170309 "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.")* delete and new Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 1 month ago [\#170315](#170315) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#170315 "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.")* 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, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[andreahill](/forum/user/5849-andreahill "View andreahill's Profile")** - [![andreahill's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5849-andreahill "View andreahill's Profile") - [ Offline](/forum/user/5849-andreahill) Less More - Posts: 20 - Thank you received: 1 - - 12 years 1 month ago [\#170448](#170448) by [andreahill](/forum/user/5849-andreahill "View andreahill's Profile") Replied by *[andreahill](/forum/user/5849-andreahill "View andreahill's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column#170448 "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.")* Oh good grief. You are so right. OK, it's fixed. Sorry! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.590 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)