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

Quote:

---

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

Quote:

---

<?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']).'&nbsp;'.PRODUCT_REWARD_POINT_TAG;
?>

---

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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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_

Quote:

---

Originally Posted by 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.