Reward Points Module for ZC v13x

Hello, will be split pages in admin - customers - rewards points? I have about 3000 customers and this is problem. Many queries to database too.

Quote:

---

Originally Posted by ryska

Hello, will be split pages in admin - customers - rewards points? I have about 3000 customers and this is problem. Many queries to database too.

---

Yes, this is something I want to tackle. Probably using AJAX.

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

Quote:

---

Originally Posted by dre

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

I have also a blank page in configuration > Reward Points



Thanx for any help,

ANdre

Quote:

---

Originally Posted by dre

I have also a blank page in configuration > Reward Points



Thanx for any help,

ANdre

---

That's the clue there- Go back and reinstall upgrade.sql and that will sort it out.

Thanx for your reply.

I did as you told but I get this error:;

1062 Duplicate entry '0-0' for key 2
in:
[INSERT INTO reward_master (rewards_products_id ,scope ,scope_id ,point_ratio ,bonus_points, redeem_ratio, redeem_points) VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL);]
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.

I'm totally newbie to mysql so i dont know what its all about

Quote:

---

Originally Posted by dre

Thanx for your reply.

I did as you told but I get this error:;

1062 Duplicate entry '0-0' for key 2
in:
[INSERT INTO reward_master (rewards_products_id ,scope ,scope_id ,point_ratio ,bonus_points, redeem_ratio, redeem_points) VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL);]
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.

I'm totally newbie to mysql so i dont know what its all about

---

Check the following post:

http://www.zen-cart.com/forum/showpo...&postcount=350

It resolves this issue.

Hmm nothing.

Instead of 1 reward points tab in configuration I now have 2, and both are empty pages.

This is what I got after this upgrade SQL:

Success 19 statements processed.
Error ERROR: Cannot create table reward_master because it already exists
Error ERROR: Cannot create table reward_master because it already exists
Error ERROR: Cannot create table reward_customer_points because it already exists
Error ERROR: Cannot create table reward_status_track because it already exists
Error ERROR: Cannot create table reward_status_track because it already exists
Error ERROR: Cannot create table reward_status_track because it already exists
Error ERROR: Cannot create table reward_status_track because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 15 statements ignored. See "upgrade_exceptions" table for additional details.


Gr, Andre

Quote:

---

Originally Posted by dre

Hmm nothing.

Instead of 1 reward points tab in configuration I now have 2, and both are empty pages.

This is what I got after this upgrade SQL:

Success 19 statements processed.
Error ERROR: Cannot create table reward_master because it already exists
Error ERROR: Cannot create table reward_master because it already exists
Error ERROR: Cannot create table reward_customer_points because it already exists
Error ERROR: Cannot create table reward_status_track because it already exists
Error ERROR: Cannot create table reward_status_track because it already exists
Error ERROR: Cannot create table reward_status_track because it already exists
Error ERROR: Cannot create table reward_status_track because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 15 statements ignored. See "upgrade_exceptions" table for additional details.


Gr, Andre

---

That's okay. You should now have a Configuration->Reward Points now.