[Skip to main content](#vessel-content)

#   1054 - Unknown column...

##

- **[korzo](/forum/user/34428-korzo "View korzo's Profile")**
- [![korzo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34428.png)](/forum/user/34428-korzo "View korzo's Profile")
- [ Offline](/forum/user/34428-korzo)

Less More

- Posts: 193
- Thank you received: 76
-
-

12 years 1 month ago [\#174445](#174445) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column?start=20#174445 "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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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 can confirm this code from pastebin fix SQL error in Hikashop 2.3.2 and 2.3.3.
Any chance to include it in official release?

Please can you take a look at line 1117: Code:

if($list &amp;&amp; $filter-&gt;filter_options['title_position']='inside'){

I think there should be comparison instead of assignment.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

12 years 1 month ago [\#174486](#174486) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column?start=20#174486 "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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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,

Thanks for this correction, I just edited the code on our end and this will be corrected for next releases of HikaShop.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Valerio](/forum/user/34985-valerio "View Valerio's Profile")**
- [![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)

Less More

- Posts: 4
- Thank you received: 0
-
-
-
- [](http://www.sitomaestro.it)
-

11 years 11 months ago -  11 years 11 months ago [\#183555](#183555) by [Valerio](/forum/user/34985-valerio "View Valerio's Profile")  Replied by *[Valerio](/forum/user/34985-valerio "View Valerio's Profile")* on topic *[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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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.")*

Hello, same problems here... ![:(](/media/kunena/emoticons/22.png ":(")
I've have tried everything (I believe) in this forum. Here the issues...

Error 1054 it says:
Unknown column 'b.b.product_average_score' in 'where clause' SQL=SELECT DISTINCT b.* FROM p76f8_hikashop_product_category AS a LEFT JOIN p76f8_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN p76f8_hikamarket_vendor AS hikam_vendor ON b.product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (31) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') AND b.b.product_average_score BETWEEN 2 AND 5 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 18

And I don't know why but the copy/paste of the pastebin file it's not working either.

I keep looking...

Thanks in advanced!
Regards,

---

Thanks in advance!
Regards,
Valerio

Last edit: 11 years 11 months ago by [Valerio](/forum/user/34985-valerio "View Valerio's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Valerio](/forum/user/34985-valerio "View Valerio's Profile")**
- [![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)

Less More

- Posts: 4
- Thank you received: 0
-
-
-
- [](http://www.sitomaestro.it)
-

11 years 11 months ago [\#183560](#183560) by [Valerio](/forum/user/34985-valerio "View Valerio's Profile")  Replied by *[Valerio](/forum/user/34985-valerio "View Valerio's Profile")* on topic *[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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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 also have found this topic about updating Hika...
Here it's the url [ www.hikashop.com/support/support/documen...lity-issues.html#SQL](http://www.hikashop.com/support/support/documentation/61-hikashop-compatibility-issues.html#SQL)

My hosting provider has confirmed me that my MySQL user has the ALTER privilege. I also have tried to delete and create new filters but the issue it's still there.

Regards

---

Thanks in advance!
Regards,
Valerio

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

11 years 11 months ago [\#183587](#183587) 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?start=20#183587 "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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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,

Please give us the full 1054 error message.
The previous issue has been fixed in HikaShop 2.3.4.

Do you have HikaShop 2.3.4 ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Valerio](/forum/user/34985-valerio "View Valerio's Profile")**
- [![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)

Less More

- Posts: 4
- Thank you received: 0
-
-
-
- [](http://www.sitomaestro.it)
-

11 years 10 months ago -  11 years 10 months ago [\#183736](#183736) by [Valerio](/forum/user/34985-valerio "View Valerio's Profile")  Replied by *[Valerio](/forum/user/34985-valerio "View Valerio's Profile")* on topic *[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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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!

Yes I have: HikaShop Business: 2.3.4 and HikaMarket Multivendor: 1.5.1. Template Gavick Storefront updated.

With the "full error report" do you mean this?

Unknown column 'b.b.product_average_score' in 'where clause' SQL=SELECT DISTINCT b.* FROM p76f8_hikashop_product_category AS a LEFT JOIN p76f8_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN p76f8_hikamarket_vendor AS hikam_vendor ON b.product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (31) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') AND b.b.product_average_score BETWEEN 5 AND 5 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 18

Regards

---

Thanks in advance!
Regards,
Valerio

Last edit: 11 years 10 months ago by [Valerio](/forum/user/34985-valerio "View Valerio's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) 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: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

11 years 10 months ago [\#183737](#183737) 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?start=20#183737 "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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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,

Where have you this error ? Front end ? Back end ?
If it is in the front-endn are you using a filter or something like that ?

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Valerio](/forum/user/34985-valerio "View Valerio's Profile")**
- [![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)

Less More

- Posts: 4
- Thank you received: 0
-
-
-
- [](http://www.sitomaestro.it)
-

11 years 10 months ago [\#184067](#184067) by [Valerio](/forum/user/34985-valerio "View Valerio's Profile")  Replied by *[Valerio](/forum/user/34985-valerio "View Valerio's Profile")* on topic *[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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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 Yes it is the filter at the front end, here is the page
[ www.italianheart.it/index.php?option=com...t=listing&amp;Itemid=979](http://www.italianheart.it/index.php?option=com_hikashop&view=category&layout=listing&Itemid=979)
Thanks a lot!

---

Thanks in advance!
Regards,
Valerio

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

11 years 10 months ago [\#184119](#184119) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column?start=20#184119 "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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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.")*

Hello,
I just tested it and fixed it, can you edit the "administrator\components\com_hikashop\classes\filter.php" file, and change that line : Code:

$limit=' b.'.$filter-&gt;filter_data.' BETWEEN '.(float)$values[0].' AND '.(float)$values[1].' ';

By : Code:

if(strpos($filter-&gt;filter_data,'b.')!==0) $filter-&gt;filter_data = 'b.'.$filter-&gt;filter_data; $limit=' '.$filter-&gt;filter_data.' BETWEEN '.(float)$values[0].' AND '.(float)$values[1].' ';

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nnnn](/forum/user/31721-nnnn "View nnnn's Profile")**
- [![nnnn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31721-nnnn "View nnnn's Profile")
- [ Offline](/forum/user/31721-nnnn)

Less More

- Posts: 10
- Thank you received: 0
-
-

11 years 9 months ago [\#187790](#187790) by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile")  Replied by *[nnnn](/forum/user/31721-nnnn "View nnnn's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column?start=20#187790 "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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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.")*

Hello!
Hikashop 2.3.5 Bisness vertion
Problem in front end :
1054 - Unknown column 'a.ordering' in 'order clause' SQL=SELECT a.* FROM fbj2u_hikashop_category AS a WHERE a.category_parent_id = 46 AND a.category_published=1 AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%') ORDER BY a.ordering ASC LIMIT 0, 15

The problem of the choice of the filter value on the category page.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) 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: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

11 years 9 months ago [\#187792](#187792) 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?start=20#187792 "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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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,

Please see : [ www.hikashop.com/forum/install-update/87...to-2-3-5.html#187297](http://www.hikashop.com/forum/install-update/874337-error-in-category-view-after-upgrading-to-2-3-5.html#187297)

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nnnn](/forum/user/31721-nnnn "View nnnn's Profile")**
- [![nnnn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31721-nnnn "View nnnn's Profile")
- [ Offline](/forum/user/31721-nnnn)

Less More

- Posts: 10
- Thank you received: 0
-
-

11 years 9 months ago -  11 years 9 months ago [\#187944](#187944) by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile")  Replied by *[nnnn](/forum/user/31721-nnnn "View nnnn's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column?start=20#187944 "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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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.")*

did not help. The error persists. Deleted if you delete cookies, but if you select an error again in 1054.
The bug had appeared after upgrade.
Work on Hikashop version 2.3.1

Last edit: 11 years 9 months ago by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

11 years 9 months ago [\#187993](#187993) 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?start=20#187993 "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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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,

On which page do you have the problem ? Could you provide a link ? Do you need to do something to reproduce the issue ? What exactly ?
How did you configure the products listing menu/module options (menu Display&gt;Content menus) ? Could you provide a screenshot ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nnnn](/forum/user/31721-nnnn "View nnnn's Profile")**
- [![nnnn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31721-nnnn "View nnnn's Profile")
- [ Offline](/forum/user/31721-nnnn)

Less More

- Posts: 10
- Thank you received: 0
-
-

11 years 9 months ago [\#188028](#188028) by [nnnn](/forum/user/31721-nnnn "View nnnn's Profile")  Replied by *[nnnn](/forum/user/31721-nnnn "View nnnn's Profile")* on topic *[1054 - Unknown column...](/forum/45-filters-search/870210-1054-unknown-column?start=20#188028 "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&#95;id' in 'on clause' SQL=SELECT DISTINCT b.&#42; FROM zudjf&#95;hikashop&#95;product AS b INNER JOIN zudjf&#95;hikashop&#95;product&#95;category AS Brand&#95;Colour2 ON Brand&#95;Colour2.product&#95;id=a.product&#95;id AND Brand&#95;Colour2.category&#95;id IN (73) WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND b.product&#95;manufacturer&#95;id IN (22) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;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.")*

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.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MDIxMC0xMDU0LXVua25vd24tY29sdW1uP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.106 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
