Error updating to 3.2.0. Error in SQL Syntax Limit1

-- url of the page with the problem -- : staging1.restorationuk.com/
-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.7.5
-- PHP version -- : 5.6.31
-- Browser(s) name and version -- : Chrome

Hello,
My Hikashop version is currently on 2.6.4 and I am trying to update to 3.2.0 by installing the latest version via Joomla Install but I keep receiving a component error.

I also I receive an error saying:
"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 'LIMIT 1' at line 1"

How can I resolve this?

Thanks

www.hikashop.com/forum/install-update/89...ikashop-version.html

Thanks but non of that helps me. Turning on debug can't see any difference in the error message. In debug the Database Queries says it has found 6 duplicates. Not sure if this means anything.

Adding this :parent::__construct($message."\r\n".$query, $code, $previous);" to the executing.php file just creates a white blank page.

Hello,

Adding this :parent::__construct($message."\r\n".$query, $code, $previous);" to the executing.php file just creates a white blank page.

So I suppose that you did not put the patch correctly since "neo191987" was able to apply it and get the full error message.

Please follow the instructions in the latest post of the thread :
www.hikashop.com/forum/install-update/89...-version.html#278203

Regards,

I am not sure what you mean by the patch but I have re downloaded the 3.2.0 version and it has installed fine.

Thanks for your help