Error: 1064 - You have an error in your SQL syntax; check the manual

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.8.2.
-- PHP version -- : 721
-- Error-message(debug-mod must be tuned on) -- : 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND a.category_published=1 ORDER BY a.category_ordering ASC' at line 1

Hi,

I updated a new domain to PHP 7.1

After that, I migrated a website from an old domain to the new domein.

After using Akeeba to extract, i receive this error in the hikashop front-end:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND a.category_published=1 ORDER BY a.category_ordering ASC' at line 1

I know i'm using an older version of Hikashop. I'm willing to upgrade (just waiting for the order to be confirmed), but will upgrading solve the problem?
Is it just a PHP problem?



Tnx for your incoming feedback

Ah, i discovered this topic:

www.hikashop.com/forum/filters-search/88...ategories-error.html

After turning filters off, de website works fine.

So im gonna install update and hope for the best!

i believe in miracles

After updating, it works fine now!


tnx nicolas!

And version of HikaShop Business: 3.2.2 - is compatible with Joomla 3.8.4 ?
Thank you/

Thank you!

cant fint actual topic

OK Table "hikashop_email_log" checked
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.101.104' at line 1
Error Duplicate entry '8-85.117.101.104' for key 'PRIMARY'
OK Product categories checked

thank you