Hello,
It would be best to activate your Joomla debug mode so you can provide us the full SQL query or at least the call-stack so we can know what it is exactly.
Unfortunately, with the current details we are not able to know from where the error is coming from with precision.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.