Does anybody have an informational page they put together about this Reward Points Program?
I'd like to put one up on my site to explain to people how it works...
Printable View
Does anybody have an informational page they put together about this Reward Points Program?
I'd like to put one up on my site to explain to people how it works...
Is there a way to display to the customer which products they can earn reward points on,
eg on the product listing it say earn 3 reward points on this product?
Thanks
Do you mean on each individual product? This is built in already. You have to follow the edits made to the template files for product_info.php.Quote:
Originally Posted by nigelt74
where does it tell me to make these edits for the product_info.php file, its not in the readme and there is no product_info.php file in the reward points zip fileQuote:
Originally Posted by retched
I have the reward points mod working great. I love it.
Just one comment.... when it first installed it it changed my order total mods, it included some COD fees for countries I dont even ship to.
So if you instal it, go ahead and check your OT mods.
Thanks author, other than that it works great.
Is there any way to limit the use of reward points, and coupon together.
I do not want my customers to use reward points if they are using a coupon code?
Thanks in advance.
Sorry guys- I'm not ignoring you- I'm on holiday at the moment (in Spain) and I'm on a tech-detox. Give me a couple of days and I'll be back to normal.
Have a look at the first couple of pages of this thread, there are a couple of examples thereQuote:
Originally Posted by swamyg1
Ok well i have got it working i have copied the reward points section from tpl_document_product_info_display.php to tpl_product_info_display.php, is this correct? or have i missed something, because i can't find instructions on it and no-one else seems to have had the problemQuote:
Originally Posted by nigelt74
Doing a file compare would have been better but yeah, you were generally told to copy the file into your template directory to override the template_default one.Quote:
Originally Posted by nigelt74
And thats exactly what i did and it wasn't displaying, unless I am misunderstanding something? nowhere does it say that the file "tpl_document_product_info_display.php" will overwrite "tpl_product_info_display.php" note the different names,Quote:
Originally Posted by retched
the "tpl_product_info_display.php" included in the reward points module doesn't contain any reward point code, infact its identical to the stock zencart one, I did use winmerge to check, the only way i could get it to work was to copy the relevant code from "tpl_document_product_info_display.php" these were all done in the override directories.
Is it possible to have the store reward points regardless of status?
Customer orders and points are given regardless of status, even if order is refunded.
Is that the sunrise period?
no you want to edit ........ Reward Point Status Track, and just mark them all as Earned if that is what you are wanting. The sunrise period is how many days they have to wait before the points move from pending to earned.
Unfortunately, until you hit the checkout, none of the other Order Total mods are in play, so there is no way for the sidebox to know what they are and whether or not they will affect the final total.Quote:
Originally Posted by swamyg1
I'm having a look at this at the moment. Other than a really nasty kludge the only way I can think of doing it is by extending the Advanced Rules configuration.Quote:
Originally Posted by mask2011
There were a couple of good ones but I see the sites are no longer available unfortunately.Quote:
Originally Posted by swamyg1
Should do that "right out of the box" if you have have copied the templates/YOUR CUSTOM FOLDER/templates/tpl_product_info_display.php file correctly.Quote:
Originally Posted by nigelt74
Which countries? This is strange as this mod has absolutely nothing to do with the COD mod.Quote:
Originally Posted by marcelarr
No- just set Reward Point Status Track to Advanced and then set all the status's to Earned. Warning though- this could leave your site open to fraud. Someone could make a very large purchase, receive the points, then make a purchase using these points and once that is accepted, cancel the original purchase.Quote:
Originally Posted by DigitalShadow
Installed RP version 133a. Same problem as all earlier versions. ZC Version 1.38a
Configuration is complete. Running rpd.php shows NO errors or missing files. All sideboxes configured correctly. When an item is selected, points show in sidebox and all during checkout. Order confirmation and archived order show correct reward point total. I can award a customer points in the Admin, and they are displayed and can be redeemed as normal.
But with a regular order, no points are written into the database. No pending, no earned. Changing status settings make no difference. Tables for storing pending or earned points in DB are empty. Only "awarded" points are there.
I think it may be that we don't use any payment method that can be confirmed at time of order. The only payment options are Purchase Orders and Off-Line Credit Cards. No Paypal or anything like that.
Got any ideas where to look?
I had that exact problem and this answer by retched fixed it for meQuote:
Originally Posted by Sailman
Quote:
Is the order total modules installed and set to "True" in admin?
What other mods do you have installed? Specifically any order mods (Super Orders for instance)Quote:
Originally Posted by Sailman
Yes. In the Admin/Order Total Modules, Reward Points (ot_reward_points) is turned on and True. Reward Points Tiered Discount is OFF and Reward Points Earned is ON.
Hem, yes. I do have Super Orders enabled. The only other Order Total mod is Quantity Discounts (ot_big_chooser).
There is no Shipping, no taxes. We do have a single Group Discount and a Discount Coupon that will probably go away if I can get the Reward Points mod running.
It seems to work everywhere, with no error messages anywhere, but it just does not write the points in any status to the DB. Does that help?
The most obvious culprit is one of the mods which is using a version of orders.php that is v.1.3.7 or earlier- None of these used the observer/notifier system that was introduced in v1.3.8- Without this the Reward Points are never posted. Best thing to do would be to check your version of orders.php against the current version using WinMerge or something similar.Quote:
Originally Posted by Sailman
Had the same issue but made changes in a "Setting" and issue resolved itself. BUT, I can't remember which setting(s) that I changed since RP is currently installed in my sandbox and am still in the familiarization & setup mode. It may have been related to the "Sunrise" settings but I had changed several settings and am unable to reproduce the issue again.Quote:
Originally Posted by Sailman
Issue:
Expected effect is to award double points for this product category
- Points Ratio set to 2.0 for one product category.
- Product description does show double points to be rewarded.
- When product is added to cart, sidebox only shows 1x points to be rewarded.
- After checkout, only 1x points show pending in sidebox.
- Admin change order status to delivered and only 1x points show awarded when customer checkout confirmation page is refreshed.
Expected effect is to award ZERO points for products in this category.
- Points Ratio set to 0.0 for a different product category
- Product description shows 1x points to be rewarded.
- Product added to cart shows 1x points to be rewarded.
- After checkout, 1x points show pending
- After Admin status change, 1x point are actually awarded.
Did I have a brainfart and miss something?
1.3.9f
Rick- you need to check the Reward Point Mode setting in your Reward Points config. This needs to be set to 0 for the rewards ratio to work. If you base the RP on subtotal or total the the individual ratios get ignored.Quote:
Originally Posted by RixStix
I did a search on this thread, but couldn't find the answer and there are too many pages to read through :)
It looks like there was a feature on the wishlist to have customers automatically receive reward points for referring a friend, was this feature ever implemented?
Thank you!
TNX Andrew,
My brainfart. All seems OK now.
wishlist: Point redeemable only for certain category items or categories instead of entire catalog. (don't tell me I've had another brainfart)
It's not in the mod right now but there is something in development. Watch this space.Quote:
Originally Posted by Danielle
No, that one is at the top of the wishlist. Fancy being a beta-tester? I should have something ready in the next week or so.Quote:
Originally Posted by RixStix
I'm using 1.3.9f
When I tried installing by applying the new.sql patch, I get this error:
I already tried applying uninstall.sql and remove_multiple_config_items.sql but it keeps returning that error.Quote:
Success 24 statements processed.
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 17 statements ignored. See "upgrade_exceptions" table for additional details.
The reward point config in admin panel doesn't show any options (just blank).
Any clue?
This is my server info
Quote:
Apache/1.3.41 (Unix) mod_ssl/2.8.31 OpenSSL/0.9.8e PHP/5.2.10
MySQL client version: 5.0.83
PHP extension: mysqli
MySQL server version 5.0.77 protocol version 10
Have you checked your MySQL DB for the configuration items?Quote:
Originally Posted by Justapeddler
Hi,
Is there any news on support for Paypal IPN? It's taking me so long each day updating the points manually for paypal orders...
Thanks.
Don't mind testing it at all. That's what this is all about.Quote:
Originally Posted by hem
Yes, I tried to search for %REWARD% in the configuration table but there's no entry like that. The sql patcher failed to input the reward addon configuration entries. Do I need to somehow enter those manually?Quote:
Originally Posted by retched
I'd say try it using phpmyadmin BUT remember this caveat, you have to rename the CREATE and INSERT INTO table references to match your databases name. That is if you have a prefix you have to change:Quote:
Originally Posted by Justapeddler
CREATE TABLE `reward_status_track` (
to
CREATE TABLE `thisismyprefix_reward_status_track` (
Finally I resolved my issue thanks to this post: http://www.zen-cart.com/forum/showpo...postcount=1807
Followed it and finally I can try this reward point addon!
Now I have a question: Is it possible to set a level in the reward point? e.g. 0-$100 orders are given 5% reward points, $100-$300 orders are given 8% and $300+ are given 10%.
No that isn't currently possible. The module will only take the entire portion of the order and either line by line calculate the reward points total OR the entire total of the order against the discount.Quote:
Originally Posted by Justapeddler
Or run RPD?Quote:
Originally Posted by retched
Have you tried using Paypal Express instead- It works fine with that.Quote:
Originally Posted by emtecmedia
Yes- Just the Tiered Discount's Order Total instead.Quote:
Originally Posted by Justapeddler
I have just installed this module and everything seems to work well but I don't have the click to redeem button at checkout.
I am testing this module and I gave a user 100 points.
I have also ran the diagnostic tool and all files are there, nothing shows up in red.
Do I need to wait for some sort of period before the points can be used, or is earned ready to use.
As you can see I have 10$ earned, but no button to click to redeem.
I am using paypal IPN but i'm only at the checkout point before I even select a payment option.
You may click to redeem any collected Reward Points. Your redeemed points will be applied to the total and reflected in your cart after you click continue.
Current Reward Points:100 points earned ($10.00)
Value of Redeemed Reward Points:$10.00 (100)
Hi gj91
There isn't a button right now, but a box where the customer types in the number of reward points he/she wishes to redeem in step 2 of the checkout process.
So, from my site...
You can see how much money in Reward Points you have avaiable. One point = 1p, so in this example, the screen tells us that we have 3099 point = £30.99.
http://www.hills-breeder-association...ointsStep1.jpg
You then type in the number of points you want to redeem. You can redeem none, or any number between 1 point (1p) and the full value of your bill (assuming you have enough points). If you choose not to redeem any, you will be able to keep building them up for 6 months from the date of issue.
In this order, we redeemed all our points. (Note, you are typing in 'points', not 'money', so don't use a decimal point.
http://www.hills-breeder-association...ointsStep2.jpg
I guess there was a problem with the previous 'tick box to redeem your reward points' system, so Hem changed it.
Paul
There was a change? Is it posted?Quote:
Originally Posted by ardhill
Have you installed ot_reward_points under Admin->Modules->Order Total. Once you do this you can set the Redeem Method to Manual (customer enters number of points) or Automatic (user ticks a checkbox to use available points).
Yes this is definitely installed, but I do not see that box at all.Quote:
Originally Posted by hem
when I run the rdp.php to check the install, this is the only error I get.
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in configuration!!!
I do not see the box area at all, but the layout looks like it is making room for the box, just nothing there.Quote:
Originally Posted by ardhill
This is all I see
https://www.gigavelocity.com/images/Untitled-1.gif
Maybe your settings do not allow that low amount to be redeemed?Quote:
Originally Posted by gj91
Is there a way to automatically include the total of the reward points and NOT to give a checkbox for it?
That is when the customer comes to step 2 of 3, they already see the cart with the discount calculated?
Okay- go to Admin->Tools->Install SQL Patch and paste in the following:Quote:
Originally Posted by gj91
Quote:
SET @group_id = '';
SELECT (@group_id := `configuration_group_id`) FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Reward Points';
REPLACE INTO `configuration`
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Allow Redeem of Reward Points on Order Total or Subtotal', 'REWARD_POINTS_ALLOW_TOTAL', '0', 'Allow points to be redeemed against the full order (including shipping) or only against the subtotal.<br />0= Against the subtotal.<br />1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');
I don't understand the point of that- then you are just talking about a regular discount rather than a Reward/Loyalty scheme.Quote:
Originally Posted by retched
This sort of helped, but I think I have an install issue where there are more then one installs of rewards points.Quote:
Originally Posted by hem
If I go to admin I see 4 rewards points not 1.
Should I go delete everything or is this a database issue.
This is the error I get when I go to install rewards points again.
1062 Duplicate entry 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO' for key 2
in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Redeem Ratio', 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO', '0.01', 'Amount given per Reward Point.', '6', '3', now())]
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.
There's an SQL script called remove_multiple_config_items in the RP zip file. Run this in the same Install SQL Patches and that should solve your problem.Quote:
Originally Posted by gj91
This got rid of the multiple items in configuration but I still get the duplicate entry when I go to install ot_rewards.Quote:
Originally Posted by hem
1062 Duplicate entry 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO' for key 2
That's correct. You've already installed it once, it does not need installing again.Quote:
Originally Posted by gj91
Consider the discount scheme:Quote:
Originally Posted by hem
400 = 4%
500 = 5%
600 = 7%
Instead of a redeem and spend, have an accruing balance of points. The more points you earn, the higher the discount on the order.
Ah, got you. So in that scheme the reward points earned would never drop but continue accumulating...Quote:
Originally Posted by retched
It would need another Order Total mod but I could probably build it out of the Tiered Reward Point mod that already exists...
Oh I didn't know this mod already existed? I had mangled this mod to get it to work like that one :mellow:Quote:
Originally Posted by hem
Just out of interest, what would you call that function?Quote:
Originally Posted by retched
The function which I changed?Quote:
Originally Posted by hem
Well, what snappy name would you give it? Perpetual Rewards? Longtime Customer Benefit? Loyalty Accruement?Quote:
Originally Posted by retched
Lifetime Customer Rewards would be something I'd name it.Quote:
Originally Posted by hem
Hello,
First, thank you for your wonderful contribution!
I want to encourage customers to write reviews or testimonials in my site. Is it possible to reward customers, say 10 reward points, for them to do so?
Lina
You can manually add in points on your own after you moderate them.Quote:
Originally Posted by lina0962
If you want to automatically add them on a posted review... I think this can be done by adding a few lines to the review poster.
Version 1.40a now available for testing.
The major change for this version is a new stub written especially to handle missing PayPal IPN orders. It is available for download from my website (http://www.omnicia.com).
Make sure you backup your database first (just to be safe).
IMPORTANT. If you use PayPal IPN and you have been manually adding Reward Points to customers, you must run the following SQL patch BEFORE installing this version. Failure to do so will result in doubled up points.
This patch is also available in the root folder of the zip and is called prep_IPN_RP_orders.sql.PHP Code:INSERT IGNORE INTO reward_status_track
(customers_id,orders_id,date,reward_points,status)
SELECT o.customers_id,o.orders_id,NOW(),ot.text,IF(o.orders_status=1,0,1)
FROM orders o,orders_total ot
WHERE ot.orders_id=o.orders_id AND
ot.class='ot_reward_points_display';
Further to this, if you are upgrading from the latest version (1.33a) then all you need to do is copy /admin/includes/functions/extra_functions/reward_points_functions.php to the corresponding folder in your admin folder. No need to install updates.sql either as there have been no changes to the MySQL tables.
Well, this is still not showing up right. Not sure what the problem is.Quote:
Originally Posted by hem
I may take a snapshot of the current site and start over.
I am eager to give the new version a try and will do so shortly. One question, I am using the rewards points and an order editor (sorry don't recall which one off hand) but when I edit orders, it does very strange things to the rewards points. It will change the total to 0 on the order page. Now it does not seem to make a difference to the ACTUAL points as they are still added to the account when the order is completed but it has been tough with my paypal orders as you know, it has not been adding the reward points for paypal orders so each time I had to manually enter reward points for an order I had edited, I had to also calculate the reward points myself as well. Also if you add an item to an order, the reward points don't seem to change for the edited order.Quote:
Originally Posted by hem
I understand that both of these modules are from different people. Does there need to be a collaboration on the module creator's part to see if there is a fix to these issues? I am amazingly happy with my rewards points module and very happy with my order editor as well.
If you would like more information or would like to view the site I am talking about you can go to www.urbansamuraihobbies.com.
Thanks.
Spencer.
I'm having similar problems between Super Orders and Edit Orders what generally happens is that any number entered where total points are are converted to a $0.00 like entry (example, I enter 400, the number is converted to $400).Quote:
Originally Posted by urbansamurai
The only way for this to be fixed is to take apart the edit order mod and determine how it gets values then add in custom coding so that when you modify the value of the points, it doesn't change on you.
Another, less practical, way of fixing this would be to go into your MySQL DB with a tool like phpMyAdmin and have it at that way. But again, this is NOT ideal for beginner's.
Hi,
Thanks for a great module. This thread is 168 pages long!.
I have had a look through and found a similar issue to mine (page 99) but could not see an answer, I may have missed it.
I have this set to 1 in admin - configuration - rewards points
"How to calculate Reward Points
0= Always use the base price.
1= Use price less Discounts and Specials."
But the rewards are granted on based price (i.e. item for 60, special / sale price 45, 60 points awarded) , I have tried switching the options.
ZenCart 1.3.9d
PHP Version: 5.2.6 (Zend: 2.2.0)
Database: MySQL 5.0.51a
Any ideas before I start to dig into the code?
Alan
This option should be what you're looking for:Quote:
Originally Posted by sailsport
Adjust Reward Points for Sales/Specials
How to calculate Reward Points
0= Always use the base price.
1= Use price less Discounts and Specials.
If you're still noticing this on the item info page, then a bit of coding needs to be changed indeed.
What version are you using? The latest version is 1.40a and is available off of my website.Quote:
Originally Posted by sailsport
Thank I'll try 1.40, the version I got from the zen site 11 Oct was 1.32a
I am getting an access error on www.omnicia.com
"You don't have permission to access / on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."
I'm able to access it fine?Quote:
Originally Posted by sailsport
Where are you trying to access from? Specifically your IP address (www.myipaddress.com)Quote:
Originally Posted by sailsport
Yes I can access you from my phone, (not much use!) so definitely my ip being blocked.
188-222-128-186.zone13.bethere.co.uk
188.222.128.186
It shouldn't be in any block lists for any reason I know of, let me know if you find out something I don't.
Alan
Okay, try now.Quote:
Originally Posted by sailsport
If you're struggling with edit orders corrupting order reward points, I've made some changes to my edit_orders.php and attached it for download.
Be aware that I have removed the add comment/notify customer section from my edit orders and made some other small style changes so don't just overwrite your current one with this new one!
If you just want to apply my changes to your version, scan the source for ot_reward_points_display and you'll see what I've done.
The change I have made also allows you to manually amend the reward points stored against the order.
Changing the reward points here does not effect the number of points the customer has earned. It only effects the number stored against the order in the order_totals table.
You'll still have to manually change the rewards the customer has earned if that's what you want to do.
Oops! It seems I've been a little hasty :blush:
I forgot to deal with redeemed reward points.....it's fixed in this version......
I've just debugged a site that was having problems with the edit_orders mod. It appears that edit_orders does not update the last_modified field in the order table when changes are made to an order- This is the trigger that my mod uses to see if points move from pending to awarded. I'll have a chat with the developer and see if we can get this sorted.
I have this mod installed, and have the New Account Rewards Points set to award 100 points to pending. So according to the instructions, those 100 points should be released after the customer has placed their first order, correct? I have tested it, and when I update the order status to delivered, the points from that specific order are released, but the 100 points that were put in pending for the new account just stay in pending. Shouldn't those be automatically released once the first order is set to delivered?
Thanks!
Are you using Edit Orders by any chance?Quote:
Originally Posted by Danielle
No, but I am using Super Orders. Would that make a difference?
Possibly- I think Super Orders uses some of the Edit Order codebase (I might be wrong). I've found an issue with Edit Orders that makes it incompatible with the RP mod. I'm currently working on a new version of Edit Orders to solve this.Quote:
Originally Posted by Danielle
any news on the edit orders front?Quote:
Originally Posted by hem
Things have got very busy over the last couple of weeks. Hopefully I'll get to it at the weekend.Quote:
Originally Posted by Kezza
Hi how can I see the log of all points transactions for each customer?
Is there a table or something to set my rewards?
I want to allow 1 point per ever dollar spent
I want each point to be worth ten cents ($.10)
Where do I set this up? Or what settings to I need to find to set them up.
As LisaVB. I too want to reward point per dollar. 1dollar=1point. I want to generate a gift card for 500points. Once gift card is generated, points should be deducted and customer has to come in person to store to collect the gift. He/She brings his GiftCardId or printed gift card. So that admin can logs into admin panel and checks the gift card Id and give customer a gift.:frusty:
PHP People - I need some help. I have Reward Points 140 installed. On the checkout_payment page, it displays in a DIV:
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 you click continue.
Current Reward Points:582 points earned ($582.00)
Value of Redeemed Reward Points:$194.00 (194)
Redeem Reward Points:
I need to remove the display of the value of the points ($582.00) in the top line, and the "Value of Redeemed Reward Points:$194.00 " line completely as well as the "Redeem Reward Points:" line with either the checkbox or the field completely.
All redeeming of points will be done a different way. I don't care about the math of points valuing, as long as it is hidden. I need to either remove ALL the lines except Current Reward Points (without the value) or remove this DIV entirely from the Checkout_payment page. When I try to comment out parts of ot_reward_points.php, it crashes the checkout process.
Any guidance would be appreciated.
Go to your Zen Cart Admin thenQuote:
Originally Posted by LisaVB
Catalog menu
Reward Points
and set the "Global Reward Point Ratio" to 10.0000
That should give you 10% of every dollar spent as Reward Points and 1 point = 1 cent. So for every dollar spent, the customer should get 10 Reward Points / 10 cents in value.
This should give the same same value you want, and is the way I use it.
If you really want each point to equal 10c then someone else may be able to help.
Paul
Not sure if this mod can do that.Quote:
Originally Posted by sai1983
Personally I would probably look at using Zen Cart's own Gift Voucher mod that comes with the cart.
I need all Reward Points to be posted automatically as Earned, without having order status changes, etc.
We will redeem the points off-line in a different manner. Using the Advanced/Order Status in the Admin doesn't change anything. All points still go to Pending and I must manually change them to Earned in Admin/Customers/Reward Points.
I have messed with some of the functions, but only succeeded in crashing it. Is there a place where a few lines of code will put all points in the cart automatically to Earned?
any word on the edit orders working with rewards points?
First of all... MERRY CHRISTMAS EVERYONE!! :cheers:
this is the first time I have posted. I think I have the right forum... I apologise if it is not.
I am using Reward Point full suite 1.33a
:frusty: :wacko: :frusty: :wacko:
All database tables have prefix zen_<tablename>
I have a number of other mods installed - but this is the first one to generated the level of issues I have encountered.
Modifications I made to the Original install readme instructions:
- modified CUSTOM folder name to "tvzen_jellyfish" in line with the template I am using.
- Changed table creation and table referances in new.sql to have "zen_" prefix "zen_configuration", "zen_configuration_group" and the three reward tables, master, customer points & status track eg "zen_reward_master"
- Modified 2 files "reward_points_filenames.php" located in "zc_admin\includes\extra_datafiles" and "includes\extra_datafiles" - Lines 6-9 added "zen_" to the table names after "DB_PREFIX ." eg "define('TABLE_REWARD_MASTER', DB_PREFIX . 'zen_reward_master');"
Outcome:
- Configuration -> Reward Points works!
- Customers -> Reward Points throws an error
1142 SELECT command denied to user 'admin_zc1'@'localhost' for table 'reward_customer_points'
in:
[UPDATE zen_zen.reward_customer_points cp, zen_zen.reward_status_track rp SET cp.pending_points=cp.pending_points-IFNULL((SELECT SUM(rp.reward_points) FROM zen_zen.reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status='0' AND rp.dateIf 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.- Customers -> Group Reward Redeem throws an error
1142 SELECT command denied to user 'admin_zc1'@'localhost' for table 'reward_master'The Group reward redeem error occurs within the ZEN Cart Admin construct, while the Reward Point error is a completely formless whitescreen within the browser.
in:
[SELECT * FROM zen_zen.reward_master WHERE scope='0' AND scope_id='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.
The thing I find strange about the errors is the reference to zen_zen.reward_master.
The database name is not zen_zen, it is similar to database_zc and I don't know where it is getting this from. Plus... it is not referring to to the prefix => zen_reward_master... I think this may be from DB_PREFIX (but I don't know where this is defined.)
If anyone can offer some words of assistance... I would be most apprecaitive!!:hug::hug:
Oh my!!
I found it!!
Developers ToolKit showed me where DB_PREFIX was defined!! yay!
Then I realised that the files "reward_points_filenames.php" should not have been edited at all!!
My frustration is over! :) yay!
It works with the latest version but I don't know if that has been released yet.Quote:
Originally Posted by Kezza