
Originally Posted by
burgundy
Hello!
I am getting the same error message when I try to go to Customers --> Reward Points in admin:
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 'SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=r' at line 1
in:
[UPDATE reward_customer_points cp, reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status='0' AND rp.dateIf you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I am using mysql 5.0 and Zen Cart 1.3.8a. I have a fresh install of Reward Points Module. Everything else appears to be working fine.
Bookmarks