registered users who have no orders thru HS menu get an SQL error

  • Posts: 98
  • Thank you received: 3
6 years 3 months ago #285520

-- HikaShop version -- : 3.2.1
-- Joomla version -- : 3.8.3
-- PHP version -- : 5.6.32
-- Error-message(debug-mod must be tuned on) -- : SQL ERROR 1064 - 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 ')) AND (hk_order.order_user_id = 687) AND (hk_order.order_status IN ('confirmed'' at line 1

Possible Hikashop issue. Registered Joomla users who have no orders on Hikashop (yet) get an SQL error when they try to access the Hikashop Customer Orders menu. Pretty sure this is a regression.

Thx

Conrad

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

  • Posts: 98
  • Thank you received: 3
6 years 3 months ago #285521

Also in HS 3.2.2

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

  • Posts: 26000
  • Thank you received: 4004
  • MODERATOR
6 years 3 months ago #285530

Hello,

The problem is, I cannot find any SQL query matching the one you're mentioning.
Please provide the full call stack via the Joomla debug mode.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 98
  • Thank you received: 3
6 years 3 months ago #285587

here you go

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

  • Posts: 98
  • Thank you received: 3
6 years 3 months ago #285588

try again

Attachments:

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

  • Posts: 26000
  • Thank you received: 4004
  • MODERATOR
6 years 3 months ago #285593

Hello,

Please update HikaSerial to the latest version.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 98
  • Thank you received: 3
6 years 3 months ago #285643

Fixed - thanks !!!

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

Time to create page: 0.076 seconds
Powered by Kunena Forum