Filters Error after upgrade to 2.2.0

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?...

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
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.

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

Regards,

Hi,

My pull request (for mysqli) has been integrated into Joomla 3.1.0
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

Regards,

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...

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 ?

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.

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.

Hi Nikolas,

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

Regards,

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.

Hi Eliot,

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

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.

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:

to these:

Hi Eliot,

The fix works!!
Thank you!

Regards