SQL error after order search?

  • Posts: 572
  • Thank you received: 11
  • Hikashop Business
11 years 10 months ago #155261

Hi, I was trying to do a search by order date in Hikashop business and now have an error so I cannot access any orders at all?

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 ') ORDER BY b.order_id desc LIMIT 0, 100' at line 1 SQL=SELECT a.*,b.*,c.* FROM jos_hikashop_order AS b LEFT JOIN jos_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN jos_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') AND (b.order_created > ) ORDER BY b.order_id desc LIMIT 0, 100

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

  • Posts: 85425
  • Thank you received: 13964
  • MODERATOR
11 years 10 months ago #155310

Hi,


I'm not able to reproduce the problem.

Replace the file administrator/components/com_hikashop/views/order/view.html.php with the one in this archive and that should avoid the problem.

This attachment is hidden for guests.
Please log in or register to see it.

This message has an attachment file.
Please log in or register to see it.

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

Time to create page: 0.047 seconds
Powered by Kunena Forum