Reward Points Module for ZC v13x

[hem]

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??

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

[hem]

OK, additional info..

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

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.

[andy]

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

[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

[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:-

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.

[hem]

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?

[andy]

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

[HeathenMagic]

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

[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

[hem]

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.