1. Download and install the latest version.
2. Check http://www.zen-cart.com/forum/showpo...7&postcount=19
1. Download and install the latest version.
2. Check http://www.zen-cart.com/forum/showpo...7&postcount=19
Ok.. I clearly have a gremiln.. I have not touched or installed anything and now I have this issue again. (Rapidly removing hair..!!!)
I checked the ot_rewards_points and nothing seems to be amiss.
I even copied the original across and no change..
Where do I set (re-set) the ratio ?
Right- new version has been sent off to the contribs:
v1.11a
Added an uninstall.sql script to remove Reward Point sql items.
Added Configuration item to set minimum order value to redeem points against.
Added Configuration item to allow redeem of RP against Subtotal or Total (inc. shipping)
Added Reward Points on Attribute Price for products that are Priced By Attribute
Hi hem,
Thank you sooooo much!
BUT
I have done what you said again and again. But it still doesn't work.
( zen-cart1.3.8+MySQL 4.0.27-log+PHP4.4.7 )
I installed the 'new.sql' and got this:
17 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 10 statements ignored. See "upgrade_exceptions" table for additional details.
I clicked "Layout Box Controller" and got :
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(`reward_points`) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET `pending_points`=`pending_points`-IFNULL((SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE ph.`customers_id`=rc.`customers_id` AND ph.`status`=0 AND ph.`orders_id` NOT IN (SELECT `orders_id` FROM orders)),0);]
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.
Bookmarks