Quote Originally Posted by redeemer641 View Post
I am facing an error.
The points go in pending state, but am not able to move them to earned.

Other things:
1. The Reward Point Diagnostic that "hem" gave, works perfectly. (no errors)
2. Admin > Configuration > Reward Points shows nothing...empty table
3. Admin > Customers > Reward Points, when I press "edit", it gives error 1064 as below:
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 'REWARD_POINTS_MAX_TRANSACTIONS' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM zen_reward_status_track WHERE customers_id=3 AND status=0 ORDER BY date DESC LIMIT REWARD_POINTS_MAX_TRANSACTIONS;]
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.

Can someone help ?
The empty Reward Points configuration is worrying- Re-install upgrade.sql and see if that solves the problem.