Reward Points Module for ZC v13x

Quote:

---

Originally Posted by GG01

I am getting an error:

1146 Table 'mycustom_zc1.zen_reward_master' doesn't exist
in: [SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute FROM zen_reward_master prp, zen_products p, zen_products_to_categories p2c WHERE p.products_id='20' AND p2c.products_id='20' AND ((prp.scope_id=p.products_id AND prp.scope='2') OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1') OR (prp.scope='0')) ORDER BY prp.scope DESC LIMIT 1;]

Also Admin, Configuration, Reward Points does not exist in Zen Cart Admin screen.

Where did I go wrong?? Can anyone please help me?? :cry:

---

What version did you upgrade from??? Plus did you follow the instructions in the readme.txt regarding the rename???

Quote:

---

Originally Posted by Asgoroth

OK, additional info..

1) The address bar shows the following after clicking on a name that has been displayed from a search.

Code:

---

http://www.site.org/cart/admin/customers_reward_points.php?id=1&action=edit

---

2) I have removed the mod and reinstalled
a) Manual removal of all files
b) SQL patch uninstall.sql
c) install

3) Also, when a listing is displayed, there are only 40 names being listed.

4) I have reverted to a 1.13a install and it is working.

---

Strange- Nothing has changed in that file between the two versions. Also the code you posted shows the customer_id being passed.

Hi
Ive installed the latest version, using a credit card, no points are added to the customer accounts or set as pending.

When it go into customers>reward points> search on my test user, and try to edit to allow points to be added manually i get this sql error

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 status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
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.


any idea's why this is happening, the first version worked fine

thanks

Andy

sorry to post agin, but cant edit the above post.

When i ran the db update.sql, i got errors, so i then ran the uninstall.sql and removed all the tables and then installed the new.sql with no errors, not sure if this has anything to do with the problem.

thanks

Andy

Hello Andy,

I have upgraded to the latest version, and I get this on the shopping cart page, in the Reward Points shopping cart and also on the product page where it used to show reward points value:-

Quote:

---

Warning: Missing argument 2 for zen_round() in /home/gemtree/public_html/includes/functions/functions_general.php on line 176

---

I noticed nobody else reported it, so is it a clash with another module? I have turned it off for now.

Quote:

---

Originally Posted by HeathenMagic

Hello Andy,

I have upgraded to the latest version, and I get this on the shopping cart page, in the Reward Points shopping cart and also on the product page where it used to show reward points value:-



I noticed nobody else reported it, so is it a clash with another module? I have turned it off for now.

---

What version of Zencart are you running?

Hi Andy
zencart version is 3.17

ive unistalled the lastest version, installed version 1-13a again and its working fine

I installed it to see if paypal was working, but never got that far

thanks

Andy

I just reinstalled the old version and the problem goes. It is definitely a file from the includes/ folder that does (new version) it. I have tried debugging tools, but nothing comes through.

I am using zencart 1.38a (sorry should have put that)

I love the module, and would also like to know if you accept donations at all?

Regards,

James :smile:

Hello Andy,

It is this file that does it:-

includes/functions/extra_functions/reward_points_functions.php

It yields those error messages. I have quite a few mods, would it be a clash? But the 1.13a is fine, so not sure.

James

Quote:

---

Originally Posted by HeathenMagic

Hello Andy,

It is this file that does it:-

includes/functions/extra_functions/reward_points_functions.php

It yields those error messages. I have quite a few mods, would it be a clash? But the 1.13a is fine, so not sure.

James

---

Thanks for the heads up James- I'm going to do a compare between the two versions and try and get a handle on what's wrong.