Reward Points Module for ZC v13x

hem:

What version of MySQL are you using???

Database: MySQL 5.0.45-community-log

I was trying to set up the Standard IPN first, but after discovering the Paypal problem with the IPN i switched to Express Checkout.

And im afraid that maybe the Reward Points Module is causing this SQL-error when clicking the button without being logged in.

So i just want to make sure, is this mod working when using Paypal Express Checkout?

user2345:

Database: MySQL 5.0.45-community-log

I was trying to set up the Standard IPN first, but after discovering the Paypal problem with the IPN i switched to Express Checkout.

And im afraid that maybe the Reward Points Module is causing this SQL-error when clicking the button without being logged in.

So i just want to make sure, is this mod working when using Paypal Express Checkout?

Strange- it should work fine- let me have a look at it in the morning and I'll get back to you then.

hem:

Strange- it should work fine- let me have a look at it in the morning and I'll get back to you then.

Actuallly- now I've had a good look at your original message I can see where the problem is- I'll code in an adjustment and add it to the mod.

Hi there -
First of all thanks for this mod! It sounds awesome and I can't wait to dig in.
That being said... after I installed the mod and went to the Admin>Customer>Group rewards redeem, I get the following error:

Warning: require(../../includes/application_top.php) [function.require]: failed to open stream: No such file or directory in /home/eurocoop/public_html/botanikanaturals/admin/group_reward_points.php on line 23

Fatal error: require() [function.require]: Failed opening required '../../includes/application_top.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/eurocoop/public_html/botanikanaturals/admin/group_reward_points.php on line 23

Now, I don't know that much about PHP at all, so I'm kinda lost here. Can anyone give me a hint what could be causing this or how to fix it? I would be eternally in your debt and will add you to my list of ZC Heroes :D

crashley1784:

Hi there -
First of all thanks for this mod! It sounds awesome and I can't wait to dig in.
That being said... after I installed the mod and went to the Admin>Customer>Group rewards redeem, I get the following error:

Warning: require(../../includes/application_top.php) [function.require]: failed to open stream: No such file or directory in /home/eurocoop/public_html/botanikanaturals/admin/group_reward_points.php on line 23

Fatal error: require() [function.require]: Failed opening required '../../includes/application_top.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/eurocoop/public_html/botanikanaturals/admin/group_reward_points.php on line 23

Now, I don't know that much about PHP at all, so I'm kinda lost here. Can anyone give me a hint what could be causing this or how to fix it? I would be eternally in your debt and will add you to my list of ZC Heroes :D

It looks like you haven't copied the files across correctly- You need to make sure that they go into the corresponding folders on your website.

OK, I'll double check that. I thought I was relentless in making sure I did everything correctly, but maybe I made a mistake. Any hint what application_top.php is though? I searched the reward point module folder and did not find that file...

Ok, I checked and all my files are in the correct places. Any other ideas?

Question about the mod -
Is it possible to only offer reward points to a specific group? I don't want every customer to be able to earn points, only my club members - earning points is one of the perks of membership.
Thanks :)

crashley1784:

OK, I'll double check that. I thought I was relentless in making sure I did everything correctly, but maybe I made a mistake. Any hint what application_top.php is though? I searched the reward point module folder and did not find that file...

It's a ZenCart core file. Your error message is telling you that application_top.php could not find one of the reward point modules.

crashley1784:

Question about the mod -
Is it possible to only offer reward points to a specific group? I don't want every customer to be able to earn points, only my club members - earning points is one of the perks of membership.
Thanks :)

Yes- just set your global redeem to 0 and set up a Group Redeem Points for your club members.

hem:

Yes- just set your global redeem to 0 and set up a Group Redeem Points for your club members.

If global redeem is set to zero will non-club members still be able to see the reward points listed per item or no?

Hello,

Hem, I seem to be experiencing problems redeeming points when using Maestro.

I have Fast and Easy Checkout installed and One Page checkout enabled. No problems when using Visa, Solo, MasterCard as the points are deducted correctly.

For some reason, it won't deduct when using Maestro? Have you tried it with this card? Do you think the 3D Secure is causing it?

Thx

MeltDown:

If global redeem is set to zero will non-club members still be able to see the reward points listed per item or no?

No- they will just see 0 reward points per product

Berserker:

Hello,

Hem, I seem to be experiencing problems redeeming points when using Maestro.

I have Fast and Easy Checkout installed and One Page checkout enabled. No problems when using Visa, Solo, MasterCard as the points are deducted correctly.

For some reason, it won't deduct when using Maestro? Have you tried it with this card? Do you think the 3D Secure is causing it?

Thx

It should return via the same path as the rest of the cards so there should not be any problems.

hem:

It should return via the same path as the rest of the cards so there should not be any problems.

Unfortunately, that wasn't the case for Maestro. Had a customer buy something and then used their reward points. The rewards points was used but did not deduct on the total value of purchase.

Hi Hem
When I go to redeem the reward points earned they have no value and cannot be redeemed how do I fix this?
Thanks

Hello

I installed Store Credits and Rewards Points Module

IN the admin , customer, store credit , the following error appear:

1146 Table 'pillownp_zc1.zen_sc_customers' doesn't exist
in:
[select count(*) as total from zen_customers c left join zen_sc_customers sc on c.customers_id= sc.customers_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.

And on checkout a similiar error:

1146 Table 'pillownp_zc1.zen_sc_customers' doesn't exist
in:
[select amount from zen_sc_customers where customers_id = 5]

Please advise

thank you

Hello , this is update on above

After installed Reward point Full suit, got following error on checkout:

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 ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_prici' at line 5
in:
[SELECT redeem_ratio FROM zen_reward_master prp, zen_customers as c LEFT JOIN(zen_group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) WHERE c.customers_id= AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;]

Please advise

thank you

hem:

It's a ZenCart core file. Your error message is telling you that application_top.php could not find one of the reward point modules.

Any idea which module it's not able to find? I've quadruple checked that all my files are in the correct places (at least according to the file structure included with the rewards suite download). If I knew which module it was looking for I could probably solve the problem.
Thanks!

Rasyr:

Here is the post that I was referring to finding -- http://www.zen-cart.com/forum/showpost.php?p=543257&postcount=19

Hi,
I've tried this procedure and I still get the same error when I try to uninstall this (even my backup files aren't overriding this). How can I get rid of it?

Thanks!