Reward Points Module for ZC v13x

Hello

Hope you can help, I have been using this mod for months now, worked great .. but I decided now to upgrade to the latest version, as I need the "Sunrise Period"

But now I am having a problem :dontgetit

When I go to "Customers -> Reward Points" I get

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(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=r' at line 1
in:
[UPDATE reward_customer_points cp, reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status='0' AND rp.dateIf 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 use MySql 5.0.51

Can you help ? :cry:

PS - Also, in order to have the points show in the product_display_info I had to revert tpl_product_reward_points to

<?php /** * Module Template * * @package templateSystem * @copyright Copyright 2008 Andrew Moore * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 */ echo (int)GetRewardPoints($_GET['products_id']).' '.PRODUCT_REWARD_POINT_TAG; ?>

or it wont show it.. (on the product display)

NullMind:

Hello

Hope you can help, I have been using this mod for months now, worked great .. but I decided now to upgrade to the latest version, as I need the "Sunrise Period"

Which version did you upgrade from??? Theres been a couple of table name changes taht might be causing your problem.

zafer:

I installed latest reward points , with updated update.sql file

still error after loading sql:

Fatal error: Call to a member function add() on a non-object in /home/pillownp/public_html/admin/sqlpatch.php on line 211

Please help

Which version of ZenCart are you running?

hem:

Which version of ZenCart are you running?

I am running 1.3.8a from the start. I upgraded from rewards 1.11a

Also my checkout is now a blank screen. When I debug the error is:

PHP Fatal error: Cannot redeclare class ot_reward_points in /home/pillownp/public_html/includes/modules/order_total/ot_reward_points.php on line 23

Thank you for your help

hem:

Which version did you upgrade from??? Theres been a couple of table name changes taht might be causing your problem.

1.10b I believe :unsure:

what do I need to do ?

Hello!

I am getting the same error message when I try to go to Customers --> Reward Points in 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 'SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=r' at line 1
in:
[UPDATE reward_customer_points cp, reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status='0' AND rp.dateIf 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 am using mysql 5.0 and Zen Cart 1.3.8a. I have a fresh install of Reward Points Module. Everything else appears to be working fine.

zafer:

I am running 1.3.8a from the start. I upgraded from rewards 1.11a

Also my checkout is now a blank screen. When I debug the error is:

PHP Fatal error: Cannot redeclare class ot_reward_points in /home/pillownp/public_html/includes/modules/order_total/ot_reward_points.php on line 23

Thank you for your help

Shall I uninstall sql? Please advise

zafer:

Shall I uninstall sql? Please advise

Something I would try if you haven't already is to go to Modules - Order Total on admin screen. Select remove for Rewards Points & Reward Points earned. Then select Install for both. If the Module changed it may need reinstalled in this fashion.

Ken

NullMind:

1.10b I believe :unsure:

what do I need to do ?

Do you have phpmyadmin???

If so check you have the following tables:

reward_customer_points
reward_master
reward_status_track

If you use a prefix then look of the same tables preceded by YOURPREFIX_

kenwahl:

I looked at that one and from what I remember.... It didn't play well with Google Checkout or items with attributes. It also was set up to only work with a global point structure by a percentage of the sale( All items get same points). It also displays in Dollars not points so if a product gets 10 points with this mod that one may display $.05 for that one depending what they are worth. I personally like it to show points rather that what they are worth on the product page. That mod has a lot less options as to how points are awarded and how they are used.

Hope this helps a little

Ken

Thanks for the clarification. I will give this a go on our test site.

hem:

Do you have phpmyadmin???

If so check you have the following tables:

reward_customer_points
reward_master
reward_status_track

If you use a prefix then look of the same tables preceded by YOURPREFIX_

I have the following

reviews_description
reward_customer_points
reward_master
reward_point_history
reward_status_track

I've just upgraded to the latest version that i read has fixed attribute handling.

however i'm still having a BIG issue.

I am using another contributions to enable users to set the price of the product.

now the shopping cart sees a total and everything works right, except 0 reward points are awarded.

http://www.diversitygifts.com.au/index.php?main_page=product_info&cPath=9_34&products_id=1
**
EDIT i changed the value of an attribute and now it gives just the base price. It may be a problem with how the other contribution works.

burgundy:

Hello!

I am getting the same error message when I try to go to Customers --> Reward Points in 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 'SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=r' at line 1
in:
[UPDATE reward_customer_points cp, reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status='0' AND rp.dateIf 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 am using mysql 5.0 and Zen Cart 1.3.8a. I have a fresh install of Reward Points Module. Everything else appears to be working fine.

Anyone have any ideas for me on what the problem can be? My install was a brand new installation of the contribution, I'm not updating from a previous version. I've checked the tables and they are there. Thanks

Does this play well with the other modules yet or is there still come problems?

Thanks!

burgundy:

Anyone have any ideas for me on what the problem can be? My install was a brand new installation of the contribution, I'm not updating from a previous version. I've checked the tables and they are there. Thanks

I had this same error show up and I got lucky because the only setting that I changed was the "sunrise period" in the configuration- I had made it 10. I changed it back to 0 and it works fine now. Of course, I don't know how to add a Sunrise period but at least I don't have the error!!

Hope this helps???
Nancy

ladyink:

I had this same error show up and I got lucky because the only setting that I changed was the "sunrise period" in the configuration- I had made it 10. I changed it back to 0 and it works fine now. Of course, I don't know how to add a Sunrise period but at least I don't have the error!!

Hope this helps???
Nancy

Hi Nancy

You are correct, just put the sunrise period back to 0 in the config and the error went away

but like you, I need the sunrise period :(

I found a problem.
If use "Super Orders" to change order status, the pending points won't add to earn point.

Thank you Ladyink and Nullmind. I set the sunrise period to 0 and that did the trick. However like you, I also need a sunrise period. And I tried setting it back to see if it worked on the off chance. It didn't.

Any of the wonderful resident coders have a fix for this? I'm just a coding noob, I wouldn't have the faintest idea what to do.

Or is there some other setting that needs to be tweaked in order for it to work? Maybe there's another switch we need to flip?

burgundy:

Thank you Ladyink and Nullmind. I set the sunrise period to 0 and that did the trick. However like you, I also need a sunrise period. And I tried setting it back to see if it worked on the off chance. It didn't.

Any of the wonderful resident coders have a fix for this? I'm just a coding noob, I wouldn't have the faintest idea what to do.

Or is there some other setting that needs to be tweaked in order for it to work? Maybe there's another switch we need to flip?

I'll have a look in the morning.

So I just installed this mod and I have a few problems, and yes...I am kind of a newbie.

I copied all the files to the folders, installed SQL, and at first when I went to turn the Order Total portion "on" there was an error....So I tried uninstalling the SQL....it didnt work

So now I receive this error :
Fatal error: Call to a member function format() on a non-object in /home/nazarhoo/public_html/includes/modules/order_total/ot_gv.php on line 49

That is under the Order Total in Admin.

What do I have to do to get this mod working smoothly???

Thank You
-Mahir