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.

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

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

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

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/showpost.php?p=587686&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

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.

hem:

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

Yes I have . I even have 2 now (-:

But both given me emty pages .

greetz, Andre

Awesome module!! I have installed it with no problems, but I also have one page checkout installed. everything looks fine until the customer has earned rewards and they get to the checkout page, it throws the whole page off. How can I change the size of the rewards section on the checkout page?
Thanks!

helpme:

Awesome module!! I have installed it with no problems, but I also have one page checkout installed. everything looks fine until the customer has earned rewards and they get to the checkout page, it throws the whole page off. How can I change the size of the rewards section on the checkout page?
Thanks!
Fixed: css file was throwing it

hem:

That shows that at least three of the mod files have not been copied to your site- includes/modules/sideboxes/custom/reward_points.php and shopping_cart_with_reward_points.php and includes/languages/english/extra_definitions/custom/reward_points.php

I would hazard a guess that you have not copied the files correctly into your custom folders.

I have went through and made sure each and every file has been copied correctly, and it still displays in the side boxes and next to the product.
"5 PRODUCT_REWARD_POINT_TAG".

How do I stop this.

themadhattermd:

I have went through and made sure each and every file has been copied correctly, and it still displays in the side boxes and next to the product.
"5 PRODUCT_REWARD_POINT_TAG".

How do I stop this.

Do you use a custom template and what is its name?

Yes, I use a custom template and the name is "altertimes"

dre:

Yes I have . I even have 2 now (-:

But both given me emty pages .

greetz, Andre

And I still have the error wich I started with.

Please could somebody help to fix it or tell me how to undo everything in a good way.

I have already put in more then 3500 products in the database and dont want to lose them

Thanx , Andre

themadhattermd:

Yes, I use a custom template and the name is "altertimes"

Then the files should go to:

includes/modules/sideboxes/altertimes/reward_points.php
includes/modules/sideboxes/altertimes/shopping_cart_with_reward_points.php
includes/languages/english/extra_definitions/altertimes/reward_points.php

they still post in big red letter
"10 PRODUCT_REWARD_POINT_TAG" beside the product and in the side boxes

Great module, thankyou. I do have one issue with it though, if reward points are enough to completely pay for the order in other words a $0 amount then the zero amount is still passed to paypal and not the freecharger module, thus not allowing the completion of checkout. Is there any work around for this (perhaps moving the deduction to before the point freecharge is called so it can see a zero amount ??) ?

Thanks for any help on this issue.