Hello

Hope you can help, I have been using this mod for months now, worked great .. but I decided now to upgrade to the latest version, as I need the "Sunrise Period"

But now I am having a problem

When I go to "Customers -> Reward Points" I get

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 use MySql 5.0.51

Can you help ?

PS - Also, in order to have the points show in the product_display_info I had to revert tpl_product_reward_points to

<?php
/**
* Module Template
*
* @package templateSystem
* @copyright Copyright 2008 Andrew Moore
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/
echo (int)GetRewardPoints($_GET['products_id']).'&nbsp;'.PRODUCT_REWARD_POINT_TAG;
?>
or it wont show it.. (on the product display)