Reward Points Module for ZC v13x

[akai0231]

Hi hem,

Thank you sooooo much!

BUT

I have done what you said again and again. But it still doesn't work.

( zen-cart1.3.8+MySQL 4.0.27-log+PHP4.4.7 )

I installed the 'new.sql' and got this:

17 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 10 statements ignored. See "upgrade_exceptions" table for additional details.

I clicked "Layout Box Controller" and got :

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(`reward_points`) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET `pending_points`=`pending_points`-IFNULL((SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE ph.`customers_id`=rc.`customers_id` AND ph.`status`=0 AND ph.`orders_id` NOT IN (SELECT `orders_id` FROM orders)),0);]
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.

Hello Hem,
I have the same problem.
Any suggestion to solve it?

TX in advanced.

[hem]

Hello Hem,
I have the same problem.
Any suggestion to solve it?

TX in advanced.

From the readme.txt:

!!!WARNING!!! YOU NEED AT LEAST MySQL VERSION 4.2.0 TO RUN THIS MOD