Quote Originally Posted by burgundy View Post
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.

Anyone have any ideas for me on what the problem can be? My install was a brand new installation of the contribution, I'm not updating from a previous version. I've checked the tables and they are there. Thanks