SQL error after order search?

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
10 years 6 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: 82868
  • Thank you received: 13377
  • MODERATOR
10 years 6 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.

File Attachment:

File Name: h3e5dec2.zip
File Size:9 KB

Attachments:

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

Time to create page: 0.055 seconds
Powered by Kunena Forum