Reward Points Module for ZC v13x

Quote:

---

Originally Posted by walkerhxg

Hi hem,

Thank you sooooo much!

BUT

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

( 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.

---

You can ignore the errors- they just mean that you've already installed the mod. Have you downloaded the latest version of the mod??? It has code that by-passes the error you are seeing.

Yes,I have installed "Reward Point Full Suite1.10C" and did what you said again and again. But it still doesn't work.

Maybe "reward_points_functions.php" has bug?

I would be crazy :frusty:

Quote:

---

Originally Posted by walkerhxg

Yes,I have installed "Reward Point Full Suite1.10C" and did what you said again and again. But it still doesn't work.

Maybe "reward_points_functions.php" has bug?

I would be crazy :frusty:

---

Can you confirm that you have a MySQL table called YOURPREFIX_reward_status_track on your ZenCart database.

Quote:

---

Originally Posted by hem

Can you confirm that you have a MySQL table called YOURPREFIX_reward_status_track on your ZenCart database.

---

Ah- just copped it- you need at least MySQL v4.2 to run this mod.

Quote:

---

Originally Posted by hem

It's already done automatically by the syncing code.

Are you using simple or advanced Reward Point Status Track???

---

Advanced ..

I followed all the installation instructions to the letter but in admin > configuration > reward points I only have the heading. None of the configuration options are there.

Any thoughts?

Quote:

---

Originally Posted by sutikah1

I followed all the installation instructions to the letter but in admin > configuration > reward points I only have the heading. None of the configuration options are there.

Any thoughts?

---

Something went amiss with the sql file then. You are missing the entries that were supposed to be placed in the Configuration Group table.

Thanks for this incredible add-on!

I can't quite tell from previous posts and the Readme: Once installed is this module globally on for everyone or can I add customers individually? If it is possible, I would prefer it be a program that a customer signs up for.

Thanks!

Hi again - What is the purpose of the Group Reward Points Redeem?

Quote:

---

Originally Posted by MeltDown

Thanks for this incredible add-on!

I can't quite tell from previous posts and the Readme: Once installed is this module globally on for everyone or can I add customers individually? If it is possible, I would prefer it be a program that a customer signs up for.

Thanks!

---

Looks like you found your own answer to the question.

If you go to the Group Rewards Redeem, you can set a Redeem ratio for the entire store (i.e. you can set it to zero.

You can also set the redeem ration for special groups as well.

I don't think that there is any way to turn off the award of points to everybody, but you can set it so that they cannot redeem them for anything unless they are part of a group.