Page 1 of 1

Reward point query

Posted: Wed Jan 16, 2013 9:07 pm
by ashwini
Error: 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 'DATE(cr.date_added) >= '2013-01-16'DATE(cr.date_added) <= '2013-01-16' GROUP BY ' at line 1
Error No: 1064
SELECT cr.customer_id, CONCAT(c.firstname, ' ', c.lastname) AS customer, c.email, cgd.name AS customer_group, c.status, SUM(cr.points) AS points, COUNT(o.order_id) AS orders, SUM(o.total) AS total FROM customer_reward cr LEFT JOIN `customer` c ON (cr.customer_id = c.customer_id) LEFT JOIN customer_group_description cgd ON (c.customer_group_id = cgd.customer_group_id) LEFT JOIN `order` o ON (cr.order_id = o.order_id) WHERE cgd.language_id = '1'DATE(cr.date_added) >= '2013-01-16'DATE(cr.date_added) <= '2013-01-16' GROUP BY cr.customer_id ORDER BY points DESC LIMIT 0,20 in /home/sbitinfo/public_html/ecommarce/system/database/mysql.php on line 49


in opencart while im searching reward point for customer its giving me this error no.1064.


so please give me solution.

Thank You in advance.

Re: Reward point query

Posted: Mon Aug 12, 2013 9:30 pm
by jfn99
I'm getting the same issue, anyone found a fix for this?

Re: Reward point query

Posted: Mon Aug 12, 2013 9:34 pm
by jfn99