SQL error after altering characteristics in product, error disappears with shipp

-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.18
-- PHP version -- : 7.2.31
-- Browser(s) name and version -- : All browsers
-- Error-message(debug-mod must be tuned on) -- : 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 '18) AND a.shipping_price_ref_type = 'product' ORDER BY a.shipping_id, a.shippin' at line 1
You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.
Please try one of the following pages:

Home Page
If difficulties persist, please contact the System Administrator of this site and report the error below.

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 '18) AND a.shipping_price_ref_type = 'product' ORDER BY a.shipping_id, a.shippin' at line 1


Developing a new site:
Everything was going fine until I changed the characteristics in a product then I got an SQL error after altering characteristics in product, error disappears with price per shipping disabled.

Have even removed all of the characteristics...

Still happening

Thanks

Ian

Thanks Philip,
I'll install and try it out. Although I seemed to get rid of the error, not sure how, but it's good to know that this may stop it re-occurring .

Thanks
Ian

Hi Philip,
Happened again after uploading the new plugin.

Just deleted the characteristics again of a product and I'm getting the same error message! Again turning off the shipping per product gets rid of the error.

Thanks

Ian

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 ') AND a.shipping_price_ref_type = 'product' ORDER BY a.shipping_id, a.shippi...' at line 1
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/libraries/joomla/database/driver/mysqli.php:665

Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:665
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/helpers/shippingplugin.php:146
4 hikashopShippingPlugin->onShippingDisplay() JROOT/libraries/joomla/event/event.php:70
5 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
7 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_hikashop/classes/shipping.php:397
8 hikashopShippingClass->getShippings() JROOT/administrator/components/com_hikashop/classes/cart.php:1278
9 hikashopCartClass->getFullCart() JROOT/components/com_hikashop/views/product/view.html.php:1972
10 ProductViewProduct->cart() JROOT/components/com_hikashop/views/product/view.html.php:28
11 ProductViewProduct->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:844
12 hikashop_getLayout() JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
13 include() JROOT/libraries/src/Helper/ModuleHelper.php:200
14 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
16 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501
17 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793
18 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567
19 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
20 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
21 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202
22 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

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 ') AND a.shipping_price_ref_type = 'product' ORDER BY a.shipping_id, a.shippi...' at line 1 SELECT a.shipping_id, a.shipping_price_ref_id as `ref_id`, a.shipping_price_min_quantity as `min_quantity`, a.shipping_price_value as `price`, a.shipping_fee_value as `fee`, a.shipping_blocked as `blocked` FROM jos_hikashop_shipping_price AS a WHERE a.shipping_id IN (2) AND a.shipping_price_ref_id IN () AND a.shipping_price_ref_type = 'product' ORDER BY a.shipping_id, a.shipping_price_ref_id, a.shipping_price_min_quantity