Re: Reward Points Module- Live Release now available.
Quote:
Originally Posted by
hem
I looked at this file and there are no extra lines.
If anyone that has set this up prior, I would be willing to pay to have my set up completed. The errors I'm receiving are all listed above. Please, PM me if you're willing.
Re: Reward Points Module- Live Release now available.
Quote:
Originally Posted by
jb2233
Hi Andrew,
I am new and quite rookie regarding SQL. I have a new -- and working -- installation of zen cart. What is the exact script that I need to type into the "Install SQL Patches" window in order to run the 'new.sql' file?
Thank you much
Jay
Where it says "Upload file" click on the browse button and select the file from there.
Re: Reward Points Module- Live Release now available.
Hi Andrew
In Customers/Reward Points
I only can see my first 40 customers to edit it and give them manually their points.
If I make a search, for example, looking the customer 41, I can edit it, I obtain this 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 zen_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.
can you please help me?
thanks
Re: Reward Points Module- Live Release now available.
Quote:
Originally Posted by
mipavluk
Hi Andrew
In Customers/Reward Points
I only can see my first 40 customers to edit it and give them manually their points.
If I make a search, for example, looking the customer 41, I can edit it, I obtain this 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 zen_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.
can you please help me?
thanks
That issue was sorted out in v1.22- http://www.omnicia.com/Zencart%20Rew...s%20Module.zip
Re: Reward Points Module- Live Release now available.
I need execute the update.sql
and update all the files?
Re: Reward Points Module- Live Release now available.
Quote:
Originally Posted by
mipavluk
I need execute the update.sql
and update all the files?
Look for the previous post here that just shows the update and execute that.
Re: Reward Points Module- Live Release now available.
Hi Hem.
I am new to zencart and i really like this module of yours. However i seems to be unable to install this module into my zencart. So i was wondering is there any specific steps to install this module successfully? Help would be greatly appreciated. Thank you
Re: Reward Points Module- Live Release now available.
Hi,
I have checked every where - the php files have the correct wording, I have copied all the files over again and I still get this.
Reward Points You may click to redeem any collected Reward Points. Your redeemed points will be applied to the total and reflected in your cart after to click continue.
Current Reward Points:
90 CUSTOMER_EARNED_POINT_TAG
Minimum required to redeem:
1000 MINIMUM_POINT_LEVEL_TAG
Value of Redeemed Reward Points:
AU$0.90
Redeem Reward Points:
Not enough points to redeem.
This is from the reward_points.php file:
<?php
define('BOX_REWARD_POINTS', 'Reward Points');
define('PRODUCT_REWARD_POINT_TAG', 'reward points');
define('REWARD_POINTS_IN_CART_TAG', 'reward points in cart');
define('CUSTOMER_EARNED_POINT_TAG', 'points earned');
define('CUSTOMER_PENDING_POINT_TAG', 'points pending');
define('MINIMUM_POINT_LEVEL_TAG', 'points minimum');
define('MAXIMUM_POINT_LEVEL_TAG', 'points maximum');
define('CUSTOMER_TOTAL_POINT_TAG', 'points total');
define('NO_REWARD_POINTS_IN_CART_TAG','No points earned yet on current order.');
define('CUSTOMER_NOT_LOGGED_IN_TAG','Log in to see how many reward points you have already earned');
define('REWARD_POINT_TITLE','Reward Points');
define('REWARD_POINT_PROMPT','Total Reward Points: ');
?>
Re: Reward Points Module- Live Release now available.
Quote:
Originally Posted by
djjase
Hi,
I have checked every where - the php files have the correct wording, I have copied all the files over again and I still get this.
Reward Points You may click to redeem any collected Reward Points. Your redeemed points will be applied to the total and reflected in your cart after to click continue.
Current Reward Points:
90 CUSTOMER_EARNED_POINT_TAG
Minimum required to redeem:
1000 MINIMUM_POINT_LEVEL_TAG
Value of Redeemed Reward Points:
AU$0.90
Redeem Reward Points:
Not enough points to redeem.
This is from the reward_points.php file:
<?php
define('BOX_REWARD_POINTS', 'Reward Points');
define('PRODUCT_REWARD_POINT_TAG', 'reward points');
define('REWARD_POINTS_IN_CART_TAG', 'reward points in cart');
define('CUSTOMER_EARNED_POINT_TAG', 'points earned');
define('CUSTOMER_PENDING_POINT_TAG', 'points pending');
define('MINIMUM_POINT_LEVEL_TAG', 'points minimum');
define('MAXIMUM_POINT_LEVEL_TAG', 'points maximum');
define('CUSTOMER_TOTAL_POINT_TAG', 'points total');
define('NO_REWARD_POINTS_IN_CART_TAG','No points earned yet on current order.');
define('CUSTOMER_NOT_LOGGED_IN_TAG','Log in to see how many reward points you have already earned');
define('REWARD_POINT_TITLE','Reward Points');
define('REWARD_POINT_PROMPT','Total Reward Points: ');
?>
Did you try the Reward Point Diagnostic? It would appear that the file is in the wrong location.
Re: Reward Points Module- Live Release now available.
Quote:
Originally Posted by
zhengda
Hi Hem.
I am new to zencart and i really like this module of yours. However i seems to be unable to install this module into my zencart. So i was wondering is there any specific steps to install this module successfully? Help would be greatly appreciated. Thank you
Just follow the steps in the readme.txt file- It's in the root of the zip file.