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