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

  • Posts: 98
  • Thank you received: 2
  • Hikashop Essential
1 month 6 days ago #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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 2568
  • Thank you received: 339
  • MODERATOR
1 month 5 days ago #319909

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

File Attachment:

File Name: shippingpr...ices.zip
File Size:11 KB

Attachments:
Last edit: 1 month 6 days ago by Philip.
The following user(s) said Thank You: ianspeed

Please Log in or Create an account to join the conversation.

  • Posts: 98
  • Thank you received: 2
  • Hikashop Essential
1 month 5 days ago #319957

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 or Create an account to join the conversation.

  • Posts: 98
  • Thank you received: 2
  • Hikashop Essential
1 month 5 days ago #319966

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

Please Log in or Create an account to join the conversation.

  • Posts: 69940
  • Thank you received: 10476
  • MODERATOR
1 month 5 days ago #319968

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
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 or Create an account to join the conversation.

  • Posts: 98
  • Thank you received: 2
  • Hikashop Essential
2 weeks 3 days ago #320831

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 or Create an account to join the conversation.

  • Posts: 98
  • Thank you received: 2
  • Hikashop Essential
2 weeks 3 days ago #320834

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 or Create an account to join the conversation.

  • Posts: 2568
  • Thank you received: 339
  • MODERATOR
2 weeks 3 days ago #320900

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

Attachments:
Last edit: 2 weeks 3 days ago by Philip.

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum