Reward Points Module for ZC v13x

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

Code:

---

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

Quote:

---

Originally Posted by Asgoroth

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.

Quote:

---

Originally Posted by hem

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.

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:

Code:

---

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?

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

Quote:

---

Originally Posted by christon26

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:

Code:

---

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

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

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

Quote:

---

Originally Posted by 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...

Code:

---

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

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