Cannot access customer carts?

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
9 years 7 months ago #196269

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4.1
-- Error-message(debug-mod must be tuned on) -- : 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 '14,)' at line 1 SQL=SELECT category_left,category_right FROM jos_hikashop_category WHERE category_id IN (,14,)

Hi, Updated to Joomla 3.4.1 and now cannot access the customer carts? have tried repairing the database and that has not worked, can you advise where the problem mat be please.

error message;

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 '14,)' at line 1 SQL=SELECT category_left,category_right FROM jos_hikashop_category WHERE category_id IN (,14,)

rgds

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 7 months ago #196293

Hi,

We've already fixed that with a patch on our end. Please download the install package of the latest version via the menu My account>My subscriptions and install it on your website and it will add the patch and you should not have the error anymore.

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

  • Posts: 332
  • Thank you received: 6
9 years 7 months ago #197962

Nicholas,

I encountered a similar error message but the shopping cart version was already updated to the current 2.4.0 version. I downloaded and installed it again which fixed the problem.

My concern is what caused this to begin with and can I trust that it won't happen again since the cart was already on the most recent version. Can you elaborate on why this error message appeared?

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

  • Posts: 13201
  • Thank you received: 2322
9 years 7 months ago #197975

Hi,

This won't happen again, you had the latest version so the 2.4.0 but we added some fixes in that same version after its release date.
Small fixes, which can't do the object of a new package but which needed to be added in the release.

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

  • Posts: 332
  • Thank you received: 6
9 years 7 months ago #198078

Xavier,

I would recommend that, even if they are minor, that the revision # be incremented, ie: 2.4.1, so that people will know there have been some changes made. Just my two cents. :)

Luke

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

Time to create page: 0.083 seconds
Powered by Kunena Forum