registered users who have no orders thru HS menu get an SQL error

-- HikaShop version -- : 3.2.1
-- Joomla version -- : 3.8.3
-- PHP version -- : 5.6.32
-- Error-message(debug-mod must be tuned on) -- : SQL ERROR 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (hk_order.order_user_id = 687) AND (hk_order.order_status IN ('confirmed'' at line 1

Possible Hikashop issue. Registered Joomla users who have no orders on Hikashop (yet) get an SQL error when they try to access the Hikashop Customer Orders menu. Pretty sure this is a regression.

Thx

Conrad

Also in HS 3.2.2

Hello,

The problem is, I cannot find any SQL query matching the one you're mentioning.
Please provide the full call stack via the Joomla debug mode.

Regards,

here you go

try again

Hello,

Please update HikaSerial to the latest version.

Regards,

Fixed - thanks !!!