Reward Points Module for ZC v13x

[hem]

I don't see it. I can see a series of SimpleScript backups, is it one of those?

Nevermind, found it. Okay, all the Reward Point tables have been restored to the last backup.

[lauriesscraps]

OH MY GOSH!!! Thank you! I just have to add a few that look like got overrided from orders over the last couple weeks but that is much better than having 3 pages of reward points to add! THANK YOU! You, once again, rock my world. I promise I will try to leave you alone now. Hahaha, thank you!

[lauriesscraps]

Nevermind, found it. Okay, all the Reward Point tables have been restored to the last backup.

I am now getting an error message at the bottom of the customers>reward points screen.

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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
If 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.

Do you know what this is about?

[lauriesscraps]

Actually, I fixed it by running the update SQL again. I hope that didn't screw anything up! I am also having an issue with reward points not going straight to earned. I have the sunrise period set to zero, so not sure what else I need to fix. Also, still rewarding points for free gifts even though I have it set to earn points depending on order total. Any ideas?

[hem]

Actually, I fixed it by running the update SQL again. I hope that didn't screw anything up! I am also having an issue with reward points not going straight to earned. I have the sunrise period set to zero, so not sure what else I need to fix. Also, still rewarding points for free gifts even though I have it set to earn points depending on order total. Any ideas?

Set Reward Point Mode to 1 .

Also either set your payments initial order status to something other than Pending or go to Admin->Reward Points and set Reward Point Status Track to Advanced and change all the statuses to Earned