Reward Points Module for ZC v13x

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

[hem]

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.

[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

[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

[dre]

I have also a blank page in configuration > Reward Points



Thanx for any help,

ANdre

[hem]

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.

[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

[hem]

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.

[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

[hem]

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.