Error on login

-- HikaShop version -- : 6.3.0
-- Joomla version -- : 5
-- Error-message(debug-mod must be tuned on) -- : 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 ')' at line 1

Hello Nicolas,

I am experiencing a SQL syntax error when a registered user logs into the frontend while having items in their cart.

The error message: 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 ')' at line 1

Steps to reproduce:
Log in as a user and add products to the cart.
Log out (the cart is saved in the database).
Attempt to log back in.

The error appears immediately after the login action, and the user is blocked by the error page.

Observations:

If I manually delete the cart entries for that user via the Joomla administrator, the user can log in again without issues.

The error seems to be caused by an empty IN() clause in a SQL query, likely where HikaShop tries to retrieve or merge cart data, resulting in syntax like WHERE something IN ().


Could you please investigate this?

Best regards,
Jeroen

I disabled the Hikashop GA4 plugin and this seems to work:

#
#<?php die('Forbidden.'); ?>
#Date: 2026-02-10 09:04:54 UTC
#Software: Joomla! 5.4.2 Stable [ Kutegemea ] 6-January-2026 16:00 GMT

#Fields: datetime priority clientip category message
2026-02-10T09:04:54+00:00 CRITICAL 83.86.253.48 error Uncaught Throwable of type mysqli_sql_exception thrown with message "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 ')' at line 1". Stack trace: #0 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php(138): mysqli->prepare()
#1 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(972): Joomla\Database\Mysqli\MysqliStatement->__construct()
#2 [ROOT]/libraries/vendor/joomla/database/src/DatabaseDriver.php(1780): Joomla\Database\Mysqli\MysqliDriver->prepareStatement()
#3 [ROOT]/plugins/system/hikashop_ga4/hikashop_ga4.php(856): Joomla\Database\DatabaseDriver->setQuery()
#4 [ROOT]/plugins/system/hikashop_ga4/hikashop_ga4.php(869): plgSystemHikashop_ga4->_isCartPage()
#5 [ROOT]/plugins/system/hikashop_ga4/hikashop_ga4.php(75): plgSystemHikashop_ga4->getCartJS()
#6 [ROOT]/administrator/components/com_hikashop/pluginCompatJ4.php(68): plgSystemHikashop_ga4->onBeforeCompileHead()
#7 [ROOT]/libraries/vendor/joomla/event/src/Dispatcher.php(454): hikashopJoomlaPlugin->__call()
#8 [ROOT]/libraries/src/Document/Renderer/Html/MetasRenderer.php(62): Joomla\Event\Dispatcher->dispatch()
#9 [ROOT]/libraries/src/Document/HtmlDocument.php(578): Joomla\CMS\Document\Renderer\Html\MetasRenderer->render()
#10 [ROOT]/libraries/src/Document/HtmlDocument.php(897): Joomla\CMS\Document\HtmlDocument->getBuffer()
#11 [ROOT]/libraries/src/Document/HtmlDocument.php(650): Joomla\CMS\Document\HtmlDocument->_renderTemplate()
#12 [ROOT]/libraries/src/Application/CMSApplication.php(1120): Joomla\CMS\Document\HtmlDocument->render()
#13 [ROOT]/libraries/src/Application/SiteApplication.php(745): Joomla\CMS\Application\CMSApplication->render()
#14 [ROOT]/libraries/src/Application/CMSApplication.php(309): Joomla\CMS\Application\SiteApplication->render()
#15 [ROOT]/includes/app.php(58): Joomla\CMS\Application\CMSApplication->execute()
#16 [ROOT]/index.php(51): require_once('...')
#17 {main}