Reward Points Module for ZC v13x

[lauriesscraps]

OK, I think I got it fixed, as far as seeing the other things I was not in the screenshots. Now I am seeing an error message somewhere else, under Customer Reward Points Admin:

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 '' at line 1
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_group_pricing, r.pending_points, r.reward_points, gp.group_name, rm.redeem_ratio from customers as c LEFT JOIN (reward_customer_points as r) ON (r.customers_id=c.customers_id) LEFT JOIN(group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) LEFT JOIN(reward_master as rm) ON ((c.customers_group_pricing!=0 AND rm.scope=3 AND rm.scope_id=c.customers_group_pricing) OR (c.customers_group_pricing=0 AND rm.scope=0 AND rm.scope_id=0)) WHERE c.customers_lastname LIKE 'A%' ORDER BY c.customers_lastname LIMIT ;]
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.

[lauriesscraps]

I a=have been going through everything trying to figure this out on my own and just decided to uninstall the SQL patch then reinstall it, which worked ok, then I started changes some of the settings in admin and I got th error again, so I uninstalled then reinstalled again and it fixed it. Not sure if will give me the error again or not, but for now it is fixed.

The only other question I have is this..... I installed another module that gives a "free gift" of my choosing when the order is over a certain amount of money. Even though it shows up as free in the shopping cart when it is automatically added, and I have free products set to 0 points, it still gives points for the "free gift" item. Do you know if that can be changed or fixed?

Thanks again for all your help. I am slowly learning my way around all of these. Thank you for your patience.

[lauriesscraps]

I not sure- My guess would be to code into the function pre_confirmation_check() so that the order total is checked and if it is zero then don't prompt for paypal details.

Mine is doing the same thing and I did not see a fix to this problem. Is there a fix to this?

Mine will go straight to pay pal even if there is nothing owing, and I can also not choose how many points to put towards the purchase. Is this something that is in the beta version that was posted about back in October?

Thanks again!

[imagino]

Just set your ratio to 1.15.

But how to handle that, when I use two different taxes in shop?

[lauriesscraps]

I still haven't gotten any response on my questions.... does anyone have any suggestions on the pay pal problem and the points being given for free gifts problem? Thank you!

[integrity_designs]

Ran that update. It did place the items on the menu, but now I have two reward points directories on the config menu. One is blank.....one has all the options on it. I will mess with it and make sure it's figuring it correctly.

thanks

This is what has happened to me.

Kind Regards

[hem]

This is what has happened to me.

Kind Regards

there's an SQL patch included in the mod zipfile called remove_multiple_config_items.sql. Just run that under Config->Tools->SQL Patches.

[hem]

I still haven't gotten any response on my questions.... does anyone have any suggestions on the pay pal problem and the points being given for free gifts problem? Thank you!

Well the first issue is a Paypal problem so probably the best is to flag it with them. For the second I'd change the way your RP is being calculated in Config->Reward Points; From the readme.txt

From 1.20a admin can set a Mode configuration item to select whether points are rewarded by product or are
rewarded by order (sub)total.

[integrity_designs]

there's an SQL patch included in the mod zipfile called remove_multiple_config_items.sql. Just run that under Config->Tools->SQL Patches.

This is what I got when I used the remove_multiple_config_items.sql:

1146 Table 'integri2_zc1.configuration' doesn't exist
in:
[DELETE FROM zen_configuration_group WHERE configuration_group_id NOT IN ( SELECT configuration_group_id FROM configuration WHERE 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.

I did try it earlier on tonight and for some reason I had all my products etc missing so I re-installed the sql patch and now I have 3 of the Reward Points in configuration under Admin.

Kind Regards

[hem]

This is what I got when I used the remove_multiple_config_items.sql:




I did try it earlier on tonight and for some reason I had all my products etc missing so I re-installed the sql patch and now I have 3 of the Reward Points in configuration under Admin.

Kind Regards

There is an issue with an ZC corefile called sqlpatch.php which affects anyone who uses a prefix on their zencart tables. You can find an updated version in admin/sqlpatch.zip- Just extract this to admin/sqlpatch.php and the script will work.