Hi,

An issue with Hikashop appeared a while ago. I explained the issue through the Hikashop forum. You can find out full details over there.

Basically: while trying to confirm an order of a client in the order listing of the backend we get a SQL error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 SQL=SELECT * FROM #__hikashop_address WHERE address_id =

The Hikashop support figures it is related to the IM Hikashop plugin and suggested to inform you with the debug data:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 SQL=SELECT * FROM vit_hikashop_address WHERE address_id =

Call stack

#	Function	Location

1	JApplicationCms->execute()	/volume1/web/justlovepaint/administrator/index.php:51

2	JApplicationAdministrator->doExecute()	/volume1/web/justlovepaint/libraries/cms/application/cms.php:257

3	JApplicationAdministrator->dispatch()	/volume1/web/justlovepaint/libraries/cms/application/administrator.php:152

4	JComponentHelper::renderComponent()	/volume1/web/justlovepaint/libraries/cms/application/administrator.php:98

5	JComponentHelper::executeComponent()	/volume1/web/justlovepaint/libraries/cms/component/helper.php:380

6	require_once()	/volume1/web/justlovepaint/libraries/cms/component/helper.php:405

7	hikashopController->execute()	/volume1/web/justlovepaint/administrator/components/com_hikashop/hikashop.php:54

8	JControllerLegacy->execute()	/volume1/web/justlovepaint/administrator/components/com_hikashop/helpers/helper.php:1630

9	OrderController->savechangestatus()	/volume1/web/justlovepaint/libraries/legacy/controller/legacy.php:728

10	OrderController->_save()	/volume1/web/justlovepaint/administrator/components/com_hikashop/controllers/order.php:432

11	hikashopOrderClass->save()	/volume1/web/justlovepaint/administrator/components/com_hikashop/controllers/order.php:491

12	JEventDispatcher->trigger()	/volume1/web/justlovepaint/administrator/components/com_hikashop/classes/order.php:416

13	JEvent->update()	/volume1/web/justlovepaint/libraries/joomla/event/dispatcher.php:160

14	call_user_func_array()	/volume1/web/justlovepaint/libraries/joomla/event/event.php:69

15	plgHikashopInvoicemanager->onAfterOrderUpdate()	 

16	plgHikashopInvoicemanager->create_invoice()	/volume1/web/justlovepaint/plugins/hikashop/invoicemanager/invoicemanager.php:34

17	JDatabaseDriver->loadObject()	/volume1/web/justlovepaint/plugins/hikashop/invoicemanager/invoicemanager.php:78

18	JDatabaseDriverMysqli->execute()	/volume1/web/justlovepaint/libraries/joomla/database/driver.php:1653

If needed I could provide you with a login for a copy of the site installed on my LAN-server.