Hi,
When you create a new topic, please provide the information we ask in the first form.
Like the HikaShop version number you are using, the Joomla version number and a link to your website (which can stay private).
Without such kind of information ; when you got an SQL error like that, we can't help you because we do not have any useful context.
Also, do not duplicate your messages in the forum for the same exact problem ; you won't have a faster reply but it could have the opposite effect.
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.