[Skip to main content](#vessel-content) # SQL error after altering characteristics in product, error disappears with shipp ## - **[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")** - [![ianspeed's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1602-ianspeed "View ianspeed's Profile") Topic Author - [ Offline](/forum/user/1602-ianspeed) Less More - Posts: 173 - Thank you received: 8 - - 6 years 5 months ago [\#319906](#319906) by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") *[SQL error after altering characteristics in product, error disappears with shipp](/forum/28-shipping-methods/900014-sql-error-after-altering-characteristics-in-product-error-disappears-with-shipp#319906 "-- 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")* was created by *[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")* -- 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 - [ ![error.jpg](/forum/attachment/49537) ](/forum/attachment/49537 "error.jpg") [ ](/forum/attachment/49537?download=1 "error.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTAwMDE0LXNxbC1lcnJvci1hZnRlci1hbHRlcmluZy1jaGFyYWN0ZXJpc3RpY3MtaW4tcHJvZHVjdC1lcnJvci1kaXNhcHBlYXJzLXdpdGgtc2hpcHA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 652 - - 6 years 5 months ago - 6 years 5 months ago [\#319909](#319909) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[SQL error after altering characteristics in product, error disappears with shipp](/forum/28-shipping-methods/900014-sql-error-after-altering-characteristics-in-product-error-disappears-with-shipp#319909 "-- 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")* Hello, We have just add **some fix** on this plugin, that may solve your issue. And so can you try to reinstall the plugin from the zip in attachment. Hope this will solve your issue. Regards *This attachment is hidden for guests. Please log in or register to see it.* Last edit: 6 years 5 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). The following user(s) said Thank You: [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTAwMDE0LXNxbC1lcnJvci1hZnRlci1hbHRlcmluZy1jaGFyYWN0ZXJpc3RpY3MtaW4tcHJvZHVjdC1lcnJvci1kaXNhcHBlYXJzLXdpdGgtc2hpcHA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")** - [![ianspeed's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1602-ianspeed "View ianspeed's Profile") Topic Author - [ Offline](/forum/user/1602-ianspeed) Less More - Posts: 173 - Thank you received: 8 - - 6 years 5 months ago [\#319957](#319957) by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") Replied by *[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")* on topic *[SQL error after altering characteristics in product, error disappears with shipp](/forum/28-shipping-methods/900014-sql-error-after-altering-characteristics-in-product-error-disappears-with-shipp#319957 "-- 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTAwMDE0LXNxbC1lcnJvci1hZnRlci1hbHRlcmluZy1jaGFyYWN0ZXJpc3RpY3MtaW4tcHJvZHVjdC1lcnJvci1kaXNhcHBlYXJzLXdpdGgtc2hpcHA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")** - [![ianspeed's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1602-ianspeed "View ianspeed's Profile") Topic Author - [ Offline](/forum/user/1602-ianspeed) Less More - Posts: 173 - Thank you received: 8 - - 6 years 5 months ago [\#319966](#319966) by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") Replied by *[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")* on topic *[SQL error after altering characteristics in product, error disappears with shipp](/forum/28-shipping-methods/900014-sql-error-after-altering-characteristics-in-product-error-disappears-with-shipp#319966 "-- 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")* Hi Philip, Happened again after uploading the new plugin. ![:-(](/media/kunena/emoticons/22.png ":-(") 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTAwMDE0LXNxbC1lcnJvci1hZnRlci1hbHRlcmluZy1jaGFyYWN0ZXJpc3RpY3MtaW4tcHJvZHVjdC1lcnJvci1kaXNhcHBlYXJzLXdpdGgtc2hpcHA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86556 - Thank you received: 14304 - - 6 years 5 months ago [\#319968](#319968) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[SQL error after altering characteristics in product, error disappears with shipp](/forum/28-shipping-methods/900014-sql-error-after-altering-characteristics-in-product-error-disappears-with-shipp#319968 "-- 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")* Hi, Could you please do this modification in order to get the MySQL query generating that error ? [ www.hikashop.com/support/forum/product-c...eld-list.html#304882](https://www.hikashop.com/support/forum/product-category-display/897111-1054-unknown-column-b-product-volume-in-field-list.html#304882) Then, also activate the "error reporting" and "debug mode" settings of the Joomla configuration and reproduce the error. The, please provide a screenshot of that page. It will contain the MySQL query and the call stack debug information which will help us understand where the problem is coming from. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTAwMDE0LXNxbC1lcnJvci1hZnRlci1hbHRlcmluZy1jaGFyYWN0ZXJpc3RpY3MtaW4tcHJvZHVjdC1lcnJvci1kaXNhcHBlYXJzLXdpdGgtc2hpcHA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")** - [![ianspeed's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1602-ianspeed "View ianspeed's Profile") Topic Author - [ Offline](/forum/user/1602-ianspeed) Less More - Posts: 173 - Thank you received: 8 - - 6 years 4 months ago [\#320831](#320831) by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") Replied by *[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")* on topic *[SQL error after altering characteristics in product, error disappears with shipp](/forum/28-shipping-methods/900014-sql-error-after-altering-characteristics-in-product-error-disappears-with-shipp#320831 "-- 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")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTAwMDE0LXNxbC1lcnJvci1hZnRlci1hbHRlcmluZy1jaGFyYWN0ZXJpc3RpY3MtaW4tcHJvZHVjdC1lcnJvci1kaXNhcHBlYXJzLXdpdGgtc2hpcHA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")** - [![ianspeed's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1602-ianspeed "View ianspeed's Profile") Topic Author - [ Offline](/forum/user/1602-ianspeed) Less More - Posts: 173 - Thank you received: 8 - - 6 years 4 months ago [\#320834](#320834) by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") Replied by *[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")* on topic *[SQL error after altering characteristics in product, error disappears with shipp](/forum/28-shipping-methods/900014-sql-error-after-altering-characteristics-in-product-error-disappears-with-shipp#320834 "-- 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")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTAwMDE0LXNxbC1lcnJvci1hZnRlci1hbHRlcmluZy1jaGFyYWN0ZXJpc3RpY3MtaW4tcHJvZHVjdC1lcnJvci1kaXNhcHBlYXJzLXdpdGgtc2hpcHA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 652 - - 6 years 4 months ago - 6 years 4 months ago [\#320900](#320900) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[SQL error after altering characteristics in product, error disappears with shipp](/forum/28-shipping-methods/900014-sql-error-after-altering-characteristics-in-product-error-disappears-with-shipp#320900 "-- 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")* Hello, Thanks for your return, we have updated our plugin code, can you try with this version ? There is good chance that this will solve your issue, see the zip in attachment. And returns will be appreciated. Regards Last edit: 6 years 4 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTAwMDE0LXNxbC1lcnJvci1hZnRlci1hbHRlcmluZy1jaGFyYWN0ZXJpc3RpY3MtaW4tcHJvZHVjdC1lcnJvci1kaXNhcHBlYXJzLXdpdGgtc2hpcHA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.076 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)