[Skip to main content](#vessel-content) # Profile for Valerio ## [![Valerio's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34985-valerio "View Valerio's Profile") **[ Offline](/forum/user/34985-valerio)** - **User Type:** User - **Register Date:** 14 Nov 2014 - **Last login:** 8 years 5 months ago - **Time Zone:** UTC +1:00 - **Local Time:** 17:40 - **Posts:** 4 - **Profile views:** 58 - **Location:** [Italy](https://maps.google.com?q=Italy) - **Gender:** Male - **Birthdate:** Unknown [ SitoMaestro - Web-Development and Marketing around](http://www.sitomaestro.it) > Thanks in advance! > Regards, > Valerio - Posts # Valerio's recent posts (4 messages ) All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year | [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) | |---|---|---|---|---| | [](/forum/45-filters-search/870210-1054-unknown-column?start=20#184067) | [1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column?start=20#184067 "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.") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 2 months ago, by [Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile") [Last Post](/forum/45-filters-search/870210-1054-unknown-column?start=20#188028 "Hello. I updated again version 2,3,5 and filter the quantity of goods in the category started working. Probably the first time update was unsuccessful Thank you for taking the time to help.") 11 years 9 months ago by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile") - [1](/forum/45-filters-search/870210-1054-unknown-column?start=0 "Page:1") - [2](/forum/45-filters-search/870210-1054-unknown-column?start=20 "Page:2") | Replies:33 Views:4733 | [Last Post](/forum/45-filters-search/870210-1054-unknown-column?start=20#188028 "Hello. I updated again version 2,3,5 and filter the quantity of goods in the category started working. Probably the first time update was unsuccessful Thank you for taking the time to help.") by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile") 11 years 9 months ago | | [](/forum/45-filters-search/870210-1054-unknown-column?start=20#183736) | [1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column?start=20#183736 "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.") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 2 months ago, by [Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile") [Last Post](/forum/45-filters-search/870210-1054-unknown-column?start=20#188028 "Hello. I updated again version 2,3,5 and filter the quantity of goods in the category started working. Probably the first time update was unsuccessful Thank you for taking the time to help.") 11 years 9 months ago by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile") - [1](/forum/45-filters-search/870210-1054-unknown-column?start=0 "Page:1") - [2](/forum/45-filters-search/870210-1054-unknown-column?start=20 "Page:2") | Replies:33 Views:4733 | [Last Post](/forum/45-filters-search/870210-1054-unknown-column?start=20#188028 "Hello. I updated again version 2,3,5 and filter the quantity of goods in the category started working. Probably the first time update was unsuccessful Thank you for taking the time to help.") by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile") 11 years 9 months ago | | [](/forum/45-filters-search/870210-1054-unknown-column?start=20#183560) | [1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column?start=20#183560 "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.") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 2 months ago, by [Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile") [Last Post](/forum/45-filters-search/870210-1054-unknown-column?start=20#188028 "Hello. I updated again version 2,3,5 and filter the quantity of goods in the category started working. Probably the first time update was unsuccessful Thank you for taking the time to help.") 11 years 9 months ago by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile") - [1](/forum/45-filters-search/870210-1054-unknown-column?start=0 "Page:1") - [2](/forum/45-filters-search/870210-1054-unknown-column?start=20 "Page:2") | Replies:33 Views:4733 | [Last Post](/forum/45-filters-search/870210-1054-unknown-column?start=20#188028 "Hello. I updated again version 2,3,5 and filter the quantity of goods in the category started working. Probably the first time update was unsuccessful Thank you for taking the time to help.") by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile") 11 years 9 months ago | | [](/forum/45-filters-search/870210-1054-unknown-column?start=20#183555) | [1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column?start=20#183555 "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.") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 2 months ago, by [Lexnia](/forum/user/28370-lexnia "View Lexnia's Profile") [Last Post](/forum/45-filters-search/870210-1054-unknown-column?start=20#188028 "Hello. I updated again version 2,3,5 and filter the quantity of goods in the category started working. Probably the first time update was unsuccessful Thank you for taking the time to help.") 11 years 9 months ago by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile") - [1](/forum/45-filters-search/870210-1054-unknown-column?start=0 "Page:1") - [2](/forum/45-filters-search/870210-1054-unknown-column?start=20 "Page:2") | Replies:33 Views:4733 | [Last Post](/forum/45-filters-search/870210-1054-unknown-column?start=20#188028 "Hello. I updated again version 2,3,5 and filter the quantity of goods in the category started working. Probably the first time update was unsuccessful Thank you for taking the time to help.") by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile") 11 years 9 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.152 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)