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

#   Filters Error after upgrade to 2.2.0

##

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

Less More

- Posts: 120
- Thank you received: 1
-
-
-

13 years 3 months ago [\#114768](#114768) by [watashi](/forum/user/8585-watashi "View watashi's Profile")  *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#114768 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")* was created by *[watashi](/forum/user/8585-watashi "View watashi's Profile")*

After upgrade the following issue started to occur when I try to apply a filter at the front-end:

**Error: 0 - SQL=SELECT DISTINCT b.\* FROM xxxxx\_hikashop\_product\_category AS a LEFT JOIN xxxxx\_hikashop\_product AS b ON a.product\_id=b.product\_id WHERE b.product\_published=1 AND b.product\_type = 'main' AND a.category\_id IN (18) AND b.product\_quantity!=0 AND (b.product\_access = 'all' OR b.product\_access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter\_6 DESC LIMIT 0, 200**
I have switched on debug mode, but no errors were detected.
My provider's server logs show no errors.
However, the Developer Tool in Google Chrome shows following lines:

**Request URL:http://www.xxxxxxxx.com.ua/products/coats
Request Method:GET
Status Code:500 Internal Server Error
Request Headersview source**

Do you have any idea?...

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NTUxOC1maWx0ZXJzLWVycm9yLWFmdGVyLXVwZ3JhZGUtdG8tMi0yLTA/dG1wbD1tYXJrZG93bg==) 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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86560
- Thank you received: 14307
-
-

13 years 3 months ago [\#114772](#114772) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#114772 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Hi,

We would need to know the MySQL error message to be able to understand what's going on because this query looks fine.
That is a bug of Joomla 3.0 which doesn't display MySQL errors:
[ joomlacode.org/gf/project/joomla/tracker...racker\_item\_id=29345](http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=29345)
It has normally been fixed for Joomla 3.1 (make sure that you use the MySQLi driver in the joomla configuration in order to see the error).
So you an either update joomla or apply the patch in the bugtracker to display the error message.

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

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

Less More

- Posts: 120
- Thank you received: 1
-
-
-

13 years 3 months ago [\#114779](#114779) by [watashi](/forum/user/8585-watashi "View watashi's Profile")  Replied by *[watashi](/forum/user/8585-watashi "View watashi's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#114779 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Hi Nocolas,

Thanks for very quick support!
I am actually using the latest version of Joomla (3.1.1 Stable).
I have changed MySQL to MySQLi under Global Configuration/Server/Database Settings.
I have enabled Debug System under Global Configuration/System.

Still I can't get a error. (It actually shows many wrapped text inside, but I can't see nothing special there.

I am quite sure it was working before the upgrade...

As for the link provided, I could not find location of file mysqli.diff... Definitely I don't understand something..
[ joomlacode.org/gf/project/joomla/tracker...racker\_item\_id=29345](http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=29345)

Regards,

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NTUxOC1maWx0ZXJzLWVycm9yLWFmdGVyLXVwZ3JhZGUtdG8tMi0yLTA/dG1wbD1tYXJrZG93bg==) 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)
-

13 years 3 months ago [\#114781](#114781) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#114781 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Hi,

My pull request (for mysqli) has been integrated into Joomla 3.1.0
[ github.com/joomla/joomla-platform/pull/1554/files](https://github.com/joomla/joomla-platform/pull/1554/files)

Otherwise, you can use the "hikamysqli" driver:
[ www.hikashop.com/en/forum/2-general-talk...p-20-beta.html#72321](http://www.hikashop.com/en/forum/2-general-talk-about-hikashop/72191-hikashop-20-beta.html#72321)

Regards,

---

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

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

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

Less More

- Posts: 120
- Thank you received: 1
-
-
-

13 years 3 months ago [\#114783](#114783) by [watashi](/forum/user/8585-watashi "View watashi's Profile")  Replied by *[watashi](/forum/user/8585-watashi "View watashi's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#114783 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Another sort of error generated by filters:

**Error: 1054 - Unknown column 'filter\_6' in 'order clause' SQL=SELECT DISTINCT b.\* FROM xxxxx\_hikashop\_product\_category AS a LEFT JOIN xxxxx\_hikashop\_product AS b ON a.product\_id=b.product\_id INNER JOIN xxxxx\_hikashop\_category AS filter\_22 ON filter\_22.category\_id=a.category\_id AND b.product\_manufacturer\_id IN (17) WHERE b.product\_published=1 AND b.product\_type = 'main' AND a.category\_id IN (12) AND b.product\_quantity!=0 AND (b.product\_access = 'all' OR b.product\_access LIKE '%,9,%') ORDER BY filter\_6 DESC LIMIT 0, 200**

But this page does not generate any errors in the debug area as well (of course, Debug System is on...

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NTUxOC1maWx0ZXJzLWVycm9yLWFmdGVyLXVwZ3JhZGUtdG8tMi0yLTA/dG1wbD1tYXJrZG93bg==) 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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86560
- Thank you received: 14307
-
-

13 years 3 months ago [\#114785](#114785) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#114785 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Great ! That's what we need.

So filter_6 doesn't exist.
Could you do a screenshot of the options your filter with the problem ? Is its id 6 ?

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

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

Less More

- Posts: 120
- Thank you received: 1
-
-
-

13 years 3 months ago [\#114790](#114790) by [watashi](/forum/user/8585-watashi "View watashi's Profile")  Replied by *[watashi](/forum/user/8585-watashi "View watashi's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#114790 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Ooopph..
You are great guys there! I have localized the issue.

Whatever filter I try to select, it always shows me message **Unknown column 'filter\_6' in 'order clause'**.
Filter with ID 6 is a simple sort by price.
After I have disabled that filter, everything works just fine!
I have created another sort-by-price filter with same settings and I have started to get same errors again.

I believe it is a bug. Please see my filter settings on the screenshot attached hereto.

[ ![Untitled-3.jpg](/forum/attachment/11243) ](/forum/attachment/11243 "Untitled-3.jpg")

- [ ![Untitled-3.jpg](/forum/attachment/11243) ](/forum/attachment/11243 "Untitled-3.jpg") [ ](/forum/attachment/11243?download=1 "Untitled-3.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NTUxOC1maWx0ZXJzLWVycm9yLWFmdGVyLXVwZ3JhZGUtdG8tMi0yLTA/dG1wbD1tYXJrZG93bg==) 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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86560
- Thank you received: 14307
-
-

13 years 3 months ago [\#114791](#114791) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#114791 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

I can't reproduce the issue.
I'll need a backend and FTP access to look at that directly on the website with the problem.
For now, I recommend to simply keep it unpbulished until we can debug it during the weekend once you provide the necessary accesses.

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

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

Less More

- Posts: 120
- Thank you received: 1
-
-
-

13 years 3 months ago [\#114850](#114850) by [watashi](/forum/user/8585-watashi "View watashi's Profile")  Replied by *[watashi](/forum/user/8585-watashi "View watashi's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#114850 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Hi Nikolas,

I have sent a PM with admin credentials to you. Please, kindly check.

Regards,

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

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

Less More

- Posts: 2334
- Thank you received: 403
-
-

13 years 3 months ago [\#115033](#115033) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#115033 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Hi there,

I just took a look and it was a strange bug since there was a value in your session for this specific filter. After cleaning it, it's working fine.
Maybe you totally changed this filter after few try with another filter type (but on the same id) ending in causing this issue.
Anyway, tell us if it's fine on your end but I think it's ok now.

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

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

Less More

- Posts: 120
- Thank you received: 1
-
-
-

13 years 3 months ago [\#115143](#115143) by [watashi](/forum/user/8585-watashi "View watashi's Profile")  Replied by *[watashi](/forum/user/8585-watashi "View watashi's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#115143 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Hi Eliot,

A few clicks it was working. The next click it showed the same error again:
Code:

Error: 1054 - SQL Error Unknown column 'filter_6' in 'order clause' SELECT DISTINCT b.* FROM xxxxx_hikashop_product_category AS a LEFT JOIN xxxxx_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY filter_6 DESC LIMIT 0, 200

I don't understand what you say about a value for my session. However, I am trying same in private (incognito) mode of Google Chrome. Same issue comes out again.

![:(](/media/kunena/emoticons/22.png ":(")

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

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

Less More

- Posts: 2334
- Thank you received: 403
-
-

13 years 3 months ago [\#115208](#115208) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#115208 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Indeed, there was a real bug.
It took me a certain time but it's fixed!
For those who experience the same issue, you have to edit the file filter.php in administrator/components/com_hikashop/classes and change these lines:
Code:

if($filter-&gt;filter_options['title_position']=='inside'){ $html.='&lt;OPTION VALUE="'.$filter-&gt;filter_namekey.'"&gt;'.$filter-&gt;filter_name.'&lt;/OPTION&gt;';

to these: Code:

if($filter-&gt;filter_options['title_position']=='inside' &amp;&amp; $filter-&gt;filter_data=='sort'){ $html.='&lt;OPTION VALUE="none"&gt;'.$filter-&gt;filter_name.'&lt;/OPTION&gt;';

The following user(s) said Thank You: [watashi](/forum/user/8585-watashi "View watashi's Profile")

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

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

Less More

- Posts: 120
- Thank you received: 1
-
-
-

13 years 3 months ago [\#115343](#115343) by [watashi](/forum/user/8585-watashi "View watashi's Profile")  Replied by *[watashi](/forum/user/8585-watashi "View watashi's Profile")* on topic *[Filters Error after upgrade to 2.2.0](/forum/3-bug-report/85518-filters-error-after-upgrade-to-2-2-0#115343 "After upgrade the following issue started to occur when I try to apply a filter at the front-end:  Error: 0 - SQL=SELECT DISTINCT b.&#42; FROM xxxxx&#95;hikashop&#95;product&#95;category AS a LEFT JOIN xxxxx&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (18) AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND (b.sizedresseu LIKE '%36%') ORDER BY filter&#95;6 DESC LIMIT 0, 200  I have switched on debug mode, but no errors were detected. My provider's server logs show no errors. However, the Developer Tool in Google Chrome shows following lines:  Request URL:http://www.xxxxxxxx.com.ua/products/coats Request Method:GET Status Code:500 Internal Server Error Request Headersview source   Do you have any idea?...")*

Hi Eliot,

The fix works!!
Thank you!

Regards

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NTUxOC1maWx0ZXJzLWVycm9yLWFmdGVyLXVwZ3JhZGUtdG8tMi0yLTA/dG1wbD1tYXJrZG93bg==) 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.095 seconds

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