Error 1064 at checkout

Hi,

Please do that change in order to get the MySQL query for that error message:
www.hikashop.com/support/forum/2-general...ror-1054.html#287524
That will help us better understand what is going on.

Regarding the quantity issue, could you provide a screenshot of the settings of that product ?
Could you also provide a screenshot of the System>Order statuses menu and of the "order" section of the HikaShop configuration so that we can get a better understanding of the situation ?

Hi,

So what about the MySQL query for your first problem ?

Also, could you tell us how you configured the "Update the product stock on confirmed status" setting of the HikaShop configuration ?
And for the products, do they ave characteristics ? did you set the quantity in the main product or the variants ?

Hello,

So what about the MySQL query for your first problem ?

Please understand that we need that query in order to understand the situation.
And having that query means that you turn the Joomla debug mode so you can have more details about the error, including the full query and the call stack.

Regards,

Hi,

In order to get the MySQL query, there is a change that needs to be done in one of the files of Joomla. This can only be done via FTP :
www.hikashop.com/support/forum/2-general...ror-1054.html#287524
A backend access won't allow us to do it so please do it and the look at the error message again, it should provide the MySQL query causing the issue which is crutial in understanding the problem you have.

Hi,

I've searched in HikaShop, HikaMarket and Hikserial and I can't find such MySQL query.
So this must come from a plugin, either third party, or custom.
I would recommend to disable the plugins of the group "hikashop" and "system" via the Joomla plugins manager one by one and test each time in order to find the culprit. If you've developed your own plugins or added 3rd party plugins, I would start with them.