Quote Originally Posted by dre View Post
HELP I have the following error on page .

Customer Reward Points Admin Sort by:


Search:

ID Last Name First Name Pending Earned Pricing Group Redeem Ratio Action
2 Smit Andrew 270 0 Client 10.0000 Edit Delete

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 reward_status_track WHERE customers_id=2 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.

If somebody can help me thank you very much
Installed version and mods
Zen Cart 1.3.8a
Database Patch Level: 1.3.8
v1.3.8 [2008-06-07 10:38:03] (Fresh Installation)
v1.3.8 [2008-06-07 10:38:03] (Fresh Installation)
Database: MySQL 5.0.22
PHP Version: 5.1.6 (Zend: 2.1.0)

And the following Mods:
Easy populate
Admin Profiles
Dual Pricing