1064 on Checkout

  • Posts: 206
  • Thank you received: 10
  • Hikashop Multisite
8 years 1 month ago #251376

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6

Hi i have a user who's get a 1064 error in the checkout.
I can't find whats going wrong,
Can you help me?

This is the error:
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 category_right >= ) OR (category_left <= 2 AND category_right >= 121) OR (ca' at line 1 SQL=SELECT * FROM #__hikashop_category WHERE category_type='product' AND (category_left <= 115 AND category_right >= 116) OR (category_left <= 883 AND category_right >= 884) OR (category_left <= 699 AND category_right >= 700) OR (category_left <= 853 AND category_right >= 854) OR (category_left <= 61 AND category_right >= 72) OR (category_left <= 80 AND category_right >= 81) OR (category_left <= 66 AND category_right >= 67) OR (category_left <= 115 AND category_right >= 116) OR (category_left <= 897 AND category_right >= 898) OR (category_left <= 175 AND category_right >= 176) OR (category_left <= 94 AND category_right >= 95) OR (category_left <= 80 AND category_right >= 81) OR (category_left <= 86 AND category_right >= 87) OR (category_left <= 19 AND category_right >= 22) OR (category_left <= 88 AND category_right >= 89) OR (category_left <= 20 AND category_right >= 21) OR (category_left <= 811 AND category_right >= 812) OR (category_left <= 115 AND category_right >= 116) OR (category_left <= 897 AND category_right >= 898) OR (category_left <= 811 AND category_right >= 812) OR (category_left <= 175 AND category_right >= 176) OR (category_left <= 94 AND category_right >= 95) OR (category_left <= 80 AND category_right >= 81) OR (category_left <= 76 AND category_right >= 77) OR (category_left <= 86 AND category_right >= 87) OR (category_left <= 19 AND category_right >= 22) OR (category_left <= 20 AND category_right >= 21) OR (category_left <= 115 AND category_right >= 116) OR (category_left <= 897 AND category_right >= 898) OR (category_left <= 94 AND category_right >= 95) OR (category_left <= 80 AND category_right >= 81) OR (category_left <= 86 AND category_right >= 87) OR (category_left <= 19 AND category_right >= 22) OR (category_left <= 175 AND category_right >= 176) OR (category_left <= 811 AND category_right >= 812) OR (category_left <= 115 AND category_right >= 116) OR (category_left <= 895 AND category_right >= 896) OR (category_left <= 98 AND category_right >= 99) OR (category_left <= 88 AND category_right >= 89) OR (category_left <= 66 AND category_right >= 67) OR (category_left <= AND category_right >= ) OR (category_left <= 2 AND category_right >= 121) OR (category_left <= 897 AND category_right >= 898) OR (category_left <= 115 AND category_right >= 116) OR (category_left <= 825 AND category_right >= 826) OR (category_left <= 535 AND category_right >= 536) OR (category_left <= 80 AND category_right >= 81) OR (category_left <= 19 AND category_right >= 22) OR (category_left <= 20 AND category_right >= 21) OR (category_left <= 115 AND category_right >= 116) OR (category_left <= 897 AND category_right >= 898) OR (category_left <= 259 AND category_right >= 260) OR (category_left <= 811 AND category_right >= 812) OR (category_left <= 86 AND category_right >= 87) OR (category_left <= 19 AND category_right >= 22) OR (category_left <= 20 AND category_right >= 21) OR (category_left <= 80 AND category_right >= 81) OR (category_left <= 115 AND category_right >= 116) OR (category_left <= 897 AND category_right >= 898) OR (category_left <= 877 AND category_right >= 878) OR (category_left <= 707 AND category_right >= 708) OR (category_left <= 86 AND category_right >= 87) OR (category_left <= 19 AND category_right >= 22) OR (category_left <= 88 AND category_right >= 89) OR (category_left <= 20 AND category_right >= 21) OR (category_left <= 2 AND category_right >= 121) OR (category_left <= 897 AND category_right >= 898) OR (category_left <= 20 AND category_right >= 21) OR (category_left <= 19 AND category_right >= 22) OR (category_left <= 115 AND category_right >= 116) OR (category_left <= 2 AND category_right >= 121) OR (category_left <= 1 AND category_right >= 910) OR (category_left <= 54 AND category_right >= 55) OR (category_left <= 853 AND category_right >= 854) OR (category_left <= 88 AND category_right >= 89) OR (category_left <= 883 AND category_right >= 884) OR (category_left <= 115 AND category_right >= 116) OR (category_left <= 61 AND category_right >= 72) OR (category_left <= 66 AND category_right >= 67) OR (category_left <= 699 AND category_right >= 700) OR (category_left <= 2 AND category_right >= 121)

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

  • Posts: 82868
  • Thank you received: 13378
  • MODERATOR
8 years 1 month ago #251384

Hi,

It seems that there is a problem with the data of your categories.
Go in the categories listing and click on the "rebuild" button there.
That should fix the problem.

The following user(s) said Thank You: Joomill

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

Time to create page: 0.054 seconds
Powered by Kunena Forum