Reward Points Module for ZC v13x

I did as you instructed - replaced the sqlpatch.php and re-loaded all again. Still getting an error and then can not get back into my admin section - the store still works though.
This is the error that I am getting --

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 'SELECT `orders_id` FROM zen_orders) LIMIT 1' at line 1
in:
[SELECT * FROM zen_reward_status_track rs WHERE rs.`orders_id` NOT IN (SELECT `orders_id` FROM zen_orders) LIMIT 1;]
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

Thanks in advance for your help

i have the module installed but...

where is the rewards point order total which i can set each point = 1 cent ?

i have 3 module in order total, but non of them has this setting.

Quote:

---

Originally Posted by tvsupport

Just in case I caused confusion, ideally I would like to credit:

10 points for every pound if sub-total less than £25
20 points for every pound if sub-total is £25 or more

All points redeemed worth 0.01 pound.

(Idea being customers enticed to spend above £25 to gain double points per pound.)

:lookaroun

---

You would need to change the process function in includes/modules/order_total/ot_reward_points.php

Quote:

---

Originally Posted by 2004g35

I did as you instructed - replaced the sqlpatch.php and re-loaded all again. Still getting an error and then can not get back into my admin section - the store still works though.
This is the error that I am getting --

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 'SELECT `orders_id` FROM zen_orders) LIMIT 1' at line 1
in:
[SELECT * FROM zen_reward_status_track rs WHERE rs.`orders_id` NOT IN (SELECT `orders_id` FROM zen_orders) LIMIT 1;]
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

Thanks in advance for your help

---

What version of MySQL are you running?

Quote:

---

Originally Posted by weber

i have the module installed but...

where is the rewards point order total which i can set each point = 1 cent ?

i have 3 module in order total, but non of them has this setting.

---

Under Customer->Group Reward Points. Just enter 0.03 for the Global Redeem.

my php is version 5.2.11 and mysql is ver 4.0.27
Thanks for looking at this for me

Hi everyone,

I was wondering if it was possible to make a purchase with Reward Points only and not by credit card/paypal?

I have installed ZC v1.3.8 and the Rewards Points FS v1.2.6
and everything seems fine so far in terms of configruation.

Im testing at the moment and I made the reward points worth one dollar and gave 200 points to one of the test users to purchase an item worth 70 points.

I have input !00% as the maximum points allowed to redeem, too.

On checkout it asked me for credit card details to proceed, is there something I have missed?

Cheers
Adam

Quote:

---

Originally Posted by 2004g35

my php is version 5.2.11 and mysql is ver 4.0.27
Thanks for looking at this for me

---

Your problem is that this mod requires v4.2 of MySQL minimum. You will need to get your host to upgrade it.

Quote:

---

Originally Posted by kellan4459

I have upgraded to version 1.26 but when I install and try to modify the Discount Table I can't add or delete the entries. I am searching the thread and I don't see anything on this yet so again I apologize if this has been discussed before.

---

I'm also having this issue where I can't delete/add the various percentages in the Discount Table.

Any assistance appreciated.

I'm running Zen Cart 1.3.8a.

Mick

Hi I installed this but when i went to Admin->Tools->Layout Box Controller nothing shows up for it any help would be awesome
Thanks