Reward Points Module for ZC v13x

[buzzmonkey]

Hi guys i'm new to this site and have just installed tis module v1.21a - everythings great in admin and the store but the moment you login (cutomer) the screen goes white... i know this happens a lot in php because of '.... but i don't know where to start looking i tried to unintall the MYSQL File but this error came up...

1146 Table 'mysexy_zc1.configuration' doesn't exist
in:
[DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_id;]
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.

hope someone can help... thanks

[hem]

That is a good start. However, that appears to simply not display if they are not greater then 0. The problem looks to be much deeper, as a purchase made on an item with a negative reward displayed post negative points to the customer.

The new version will not return any reward points less than zero. The issue is with rounding down of values that have 0 reward points.

[Asgoroth]

The new version will not return any reward points less than zero. The issue is with rounding down of values that have 0 reward points.

Outstanding. I await the release. Thank you for your efforts.

[LissaE]

Hey Andrew....I just came across a problem because it is the first time I have tried to do this LOL

I am running a contest where each entry is to be awarded some reward points, and when I do a search of the customer (that bit's fine lol) and click the Edit button from the search results I get this:

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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
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 tried installing the update.sql and nada, still get the error....any ideas?

[LissaE]

Just a not that I have made a temporary workaround by increasing the list limit to 150 to enable me to get to the customer I needed for now LOL

[hem]

Hey Andrew....I just came across a problem because it is the first time I have tried to do this LOL

I am running a contest where each entry is to be awarded some reward points, and when I do a search of the customer (that bit's fine lol) and click the Edit button from the search results I get this:

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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
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 tried installing the update.sql and nada, still get the error....any ideas?

That's fixed in v1.21a

[LissaE]

Oops....guess I should upgrade then eh? LOL

[LissaE]

Ok, upgraded LOL and WOW, love the alphabetical listing options! Thanx for all your hard work on this awesome mod =D

[hem]

Hi guys i'm new to this site and have just installed tis module v1.21a - everythings great in admin and the store but the moment you login (cutomer) the screen goes white... i know this happens a lot in php because of '.... but i don't know where to start looking i tried to unintall the MYSQL File but this error came up...

1146 Table 'mysexy_zc1.configuration' doesn't exist
in:
[DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_id;]
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.

hope someone can help... thanks

Did you try the diagnostic? It's here:

http://www.omnicia.com/rpd.zip

[DJMagicCards]

How do coupons affect reward points?

Coupons don't seem to affect the amount reward points issued. That doesn't seem right. For example, a customer just bought $5 of products, used a $5 coupon to reduce the cost to zero. That customer still earned reward points for the free products.

I want reward points reduced by the coupon amount. Can that be done?

Thanks,
David Bal
www.DJMagicCards.com