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:-
I noticed nobody else reported it, so is it a clash with another module? I have turned it off for now.Warning: Missing argument 2 for zen_round() in /home/gemtree/public_html/includes/functions/functions_general.php on line 176
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
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
Bookmarks