Post by kyuss » Tue Jan 22, 2013 4:02 am

Reports > Customers > Customer Rewards > enter a date range:

Code: Select all

Notice: 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) >= '2012-11-01'DATE(cr.date_added) <= '2013-01-21' 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) >= '2012-11-01'DATE(cr.date_added) <= '2013-01-21' GROUP BY cr.customer_id ORDER BY points DESC LIMIT 0,200 in /home/public_html/system/database/mysql.php on line 49

New member

Posts

Joined
Sat Dec 01, 2012 2:32 am

Post by i2Paq » Tue Jan 22, 2013 1:39 pm

WHAT VERSION?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by kyuss » Wed Jan 23, 2013 2:35 am

Sorry, v1.5.4.1

New member

Posts

Joined
Sat Dec 01, 2012 2:32 am

Post by Daniel » Wed Jan 23, 2013 1:04 pm

go to admin > model > report > customer.php

download the latest version from opencart and replace that file with the one from the latest version.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by kyuss » Fri Jan 25, 2013 1:57 am

Thank you, I wasn't expecting a quick fix!
Much appreciated!

New member

Posts

Joined
Sat Dec 01, 2012 2:32 am
Who is online

Users browsing this forum: No registered users and 11 guests