Reward Points Module for ZC v13x

walkerhxg:

Hi all,

  Whatever  I do , it always gets :

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 SUM(reward_points) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET pending_points=pending_points-IFNULL((SELECT SUM(reward_points) FROM reward_status_track ph WHERE ph.customers_id=rc.customers_id AND ph.status=0 AND ph.orders_id NOT IN (SELECT orders_id FROM orders)),0);]
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.

Please help me , thx in advance.

PS: How can I uninstall the sql completely?

1. Download and install the latest version.

2. Check http://www.zen-cart.com/forum/showpost.php?p=543257&postcount=19

Mike_Dean:

Hi Andrew,

RP was working ok, then for some reason I am now having an issue.

I have put points onto a customers account, but in Admin they show up as Reward Points Earned, but as you can seem, they don't show up in the Value of Earned section.

Value of Pending: $0.00
Reward Points Earned: 1000
Value of Earned: $0.00

When I go through the checkout process, its shows as:

Current Reward Points:1000 points earned
Value of Redeemed Reward Points:$0.00
Redeem Reward Points: (is un checked)

If I tick the checkbox, then continue to process the order, the order total amount does not get adjusted,

*Sub-Total: $175.50

AustPost (Parcel Post - 4 days Estimated Delivery Time)): $10.50

GST: $16.90

Value of Redeemed Reward Points: -$0.00

Total: $186.00

Reward Points earned: 160*

Yet, when I go back into Admin, the points have been deducted ?????

*Value of Pending: $0.00
Reward Points Earned: 160
Value of Earned: $0.00 *

I've re-installed the mod and re-tried and its the same

Your redeem ratio was set to 0- re-installing the mod just reset the ratio back to the default (0.01). And yes the points will be removed from the earned as you had ticked the box.

hem:

Ah- Now I get you. So it would mean an addition to the Reward Points configuration and some method of telling the customer that they must spend at least X amount before they can redeem their points. I suppose this should go in the reward point sidebox.

Getting back to this one.

Is this something you think you could add Andrew, and how long would it take..?

I'm thinking of hanging on until this option becomes available (if possible)

Thanks for the wonderful support and great Mod..

Mike_Dean:

Getting back to this one.

Is this something you think you could add Andrew, and how long would it take..?

I'm thinking of hanging on until this option becomes available (if possible)

Thanks for the wonderful support and great Mod..

I'm adding it at the moment (it's a lot easier than trying to track down Rasyrs PayPal issue :smile:). Should have something later this afternoon.

hem:

I'm adding it at the moment (it's a lot easier than trying to track down Rasyrs PayPal issue :smile:). Should have something later this afternoon.

Wow.... Thanks heaps... :clap:

I'm yet to try PayPal. as I have not installed the Paypal sandbox so I hope I dont have the same issues..!! :unsure::unsure:

hem:

Your redeem ratio was set to 0- re-installing the mod just reset the ratio back to the default (0.01). And yes the points will be removed from the earned as you had ticked the box.

Ok.. I clearly have a gremiln.. I have not touched or installed anything and now I have this issue again. (Rapidly removing hair..!!!)

I checked the ot_rewards_points and nothing seems to be amiss.

I even copied the original across and no change..

Where do I set (re-set) the ratio ?

Right- new version has been sent off to the contribs:

v1.11a
Added an uninstall.sql script to remove Reward Point sql items.
Added Configuration item to set minimum order value to redeem points against.
Added Configuration item to allow redeem of RP against Subtotal or Total (inc. shipping)
Added Reward Points on Attribute Price for products that are Priced By Attribute

Mike_Dean:

Ok.. I clearly have a gremiln.. I have not touched or installed anything and now I have this issue again. (Rapidly removing hair..!!!)

I checked the ot_rewards_points and nothing seems to be amiss.

I even copied the original across and no change..

Where do I set (re-set) the ratio ?

Admin->Customers->Group Reward Points. Global Redeem is on the top right hand side.

hem:

Admin->Customers->Group Reward Points. Global Redeem is on the top right hand side.

More brownie points to you..

I wonder whyt it re-set it self..?? :unsure:

Ok will wait patiently for the latest version to upload to contribs.. :smile:

Hi hem,

Thank you sooooo much!

BUT

I have done what you said again and again. But it still doesn't work. :frusty:

( zen-cart1.3.8+MySQL 4.0.27-log+PHP4.4.7 )

I installed the 'new.sql' and got this:

17 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 10 statements ignored. See "upgrade_exceptions" table for additional details.

I clicked "Layout Box Controller" and got :

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 SUM(reward_points) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET pending_points=pending_points-IFNULL((SELECT SUM(reward_points) FROM reward_status_track ph WHERE ph.customers_id=rc.customers_id AND ph.status=0 AND ph.orders_id NOT IN (SELECT orders_id FROM orders)),0);]
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.

walkerhxg:

Hi hem,

Thank you sooooo much!

BUT

I have done what you said again and again. But it still doesn't work. :frusty:

( zen-cart1.3.8+MySQL 4.0.27-log+PHP4.4.7 )

I installed the 'new.sql' and got this:

17 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 10 statements ignored. See "upgrade_exceptions" table for additional details.

I clicked "Layout Box Controller" and got :

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 SUM(reward_points) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET pending_points=pending_points-IFNULL((SELECT SUM(reward_points) FROM reward_status_track ph WHERE ph.customers_id=rc.customers_id AND ph.status=0 AND ph.orders_id NOT IN (SELECT orders_id FROM orders)),0);]
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.

You can ignore the errors- they just mean that you've already installed the mod. Have you downloaded the latest version of the mod??? It has code that by-passes the error you are seeing.

Yes,I have installed "Reward Point Full Suite1.10C" and did what you said again and again. But it still doesn't work.

Maybe "reward_points_functions.php" has bug?

I would be crazy :frusty:

walkerhxg:

Yes,I have installed "Reward Point Full Suite1.10C" and did what you said again and again. But it still doesn't work.

Maybe "reward_points_functions.php" has bug?

I would be crazy :frusty:

Can you confirm that you have a MySQL table called YOURPREFIX_reward_status_track on your ZenCart database.

hem:

Can you confirm that you have a MySQL table called YOURPREFIX_reward_status_track on your ZenCart database.

Ah- just copped it- you need at least MySQL v4.2 to run this mod.

hem:

It's already done automatically by the syncing code.

Are you using simple or advanced Reward Point Status Track???

Advanced ..

I followed all the installation instructions to the letter but in admin > configuration > reward points I only have the heading. None of the configuration options are there.

Any thoughts?

sutikah1:

I followed all the installation instructions to the letter but in admin > configuration > reward points I only have the heading. None of the configuration options are there.

Any thoughts?

Something went amiss with the sql file then. You are missing the entries that were supposed to be placed in the Configuration Group table.

Thanks for this incredible add-on!

I can't quite tell from previous posts and the Readme: Once installed is this module globally on for everyone or can I add customers individually? If it is possible, I would prefer it be a program that a customer signs up for.

Thanks!

Hi again - What is the purpose of the Group Reward Points Redeem?

MeltDown:

Thanks for this incredible add-on!

I can't quite tell from previous posts and the Readme: Once installed is this module globally on for everyone or can I add customers individually? If it is possible, I would prefer it be a program that a customer signs up for.

Thanks!

Looks like you found your own answer to the question.

If you go to the Group Rewards Redeem, you can set a Redeem ratio for the entire store (i.e. you can set it to zero.

You can also set the redeem ration for special groups as well.

I don't think that there is any way to turn off the award of points to everybody, but you can set it so that they cannot redeem them for anything unless they are part of a group.