Reward Points Module for ZC v13x

Hey guys, I would really appreciate some help on this. I just installed the points module for my store running Zen Cart version 1.3.9. and after copying the custom folders over and then running the new.sql from the back of the site in admin>tools>sql patch the module is not running correctly.

It's not completely messed up as the points module option shows up in the configuration menu but when I go to it these three errors come up at the top of the screen...

Warning: call_user_func() expects parameter 1 to be a valid callback, function 'UseRewardPointStateFunction' not found or invalid function name in /chroot/home/nulifesu/nulifesupplements.com/html/storeconsole/includes/functions/general.php on line 1749

Warning: call_user_func() expects parameter 1 to be a valid callback, function 'UseRewardPointNewAccountAwardFunction' not found or invalid function name in /chroot/home/nulifesu/nulifesupplements.com/html/storeconsole/includes/functions/general.php on line 1749

Warning: call_user_func() expects parameter 1 to be a valid callback, function 'UseRewardPointAdvancedCalculateTableFunction' not found or invalid function name in /chroot/home/nulifesu/nulifesupplements.com/html/storeconsole/includes/functions/general.php on line 1749

Also, in admin>tools>sideboxes there are no options for the points module sideboxes.

Any help on this would be much appreciated.

Hi Everyone,

Forgive me, I am a noob and am slowly getting I am having an issue getting this fully installed. My issue seems to be similar to Beyond Dreams' issue above. I moved everything to the custom folders and I moved everything from the admin folder to my custom admin folder.

The shopping_cart_with_rewards and rewards_points box shows up in my layout boxes controller. There is nothing showing up in the Order Total module for me to configure.

I have tried running the new.sql patch, but I got an error 500 page. I tried it a couple times actually. After figuring out to check my error logs, I found the following errors:

PHP Fatal error: Call to undefined function GetRewardPoints() in /home/content/94/10567094/html/includes/templates/piccadilly_posh/sideboxes/tpl_reward_points.php on line 11

PHP Fatal error: Call to undefined function GetProductRewardPoints() in /home/content/94/10567094/html/includes/templates/piccadilly_posh/templates/tpl_product_reward_points.php on line 16

PHP Fatal error: Class 'RewardPoints' not found in /home/content/94/10567094/html/includes/autoload_func.php on line 79

PHP Fatal error: 1062: Duplicate entry '0-0' for key 2 :: INSERT INTO zen_reward_master (rewards_products_id ,scope ,scope_id ,point_ratio ,bonus_points, redeem_ratio, redeem_points) VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL); in /home/content/94/10567094/html/includes/classes/db/mysql/query_factory.php on line 120

PHP Fatal 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 ''new.sql patch'' at line 1 :: 'new.sql patch'; in /home/content/94/10567094/html/includes/classes/db/mysql/query_factory.php on line 120

Being such a noob, I have absolutely no clue where to go from here. I am running version 1.5.1 and I have the piccadilly_posh template. This is a brand new website, waiting to launch.

TIA for any help you can offer!

saltsandsuch:

Hi Everyone,

Forgive me, I am a noob and am slowly getting I am having an issue getting this fully installed. My issue seems to be similar to Beyond Dreams' issue above. I moved everything to the custom folders and I moved everything from the admin folder to my custom admin folder.

The shopping_cart_with_rewards and rewards_points box shows up in my layout boxes controller. There is nothing showing up in the Order Total module for me to configure.

I have tried running the new.sql patch, but I got an error 500 page. I tried it a couple times actually. After figuring out to check my error logs, I found the following errors:

PHP Fatal error: Call to undefined function GetRewardPoints() in /home/content/94/10567094/html/includes/templates/piccadilly_posh/sideboxes/tpl_reward_points.php on line 11

PHP Fatal error: Call to undefined function GetProductRewardPoints() in /home/content/94/10567094/html/includes/templates/piccadilly_posh/templates/tpl_product_reward_points.php on line 16

PHP Fatal error: Class 'RewardPoints' not found in /home/content/94/10567094/html/includes/autoload_func.php on line 79

PHP Fatal error: 1062: Duplicate entry '0-0' for key 2 :: INSERT INTO zen_reward_master (rewards_products_id ,scope ,scope_id ,point_ratio ,bonus_points, redeem_ratio, redeem_points) VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL); in /home/content/94/10567094/html/includes/classes/db/mysql/query_factory.php on line 120

PHP Fatal 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 ''new.sql patch'' at line 1 :: 'new.sql patch'; in /home/content/94/10567094/html/includes/classes/db/mysql/query_factory.php on line 120

Being such a noob, I have absolutely no clue where to go from here. I am running version 1.5.1 and I have the piccadilly_posh template. This is a brand new website, waiting to launch.

TIA for any help you can offer!Ultimately at the end of the day Beyond Dreams issue was an installation issue (the most common problems with module installations.. I suggest rolling back your site the state it was before you installed this module (you DID back up before you installed it right????), and start your install over and carefully make sure you have all the files in the right folders and run the installation SQL file.. BTW, when I say rollback it means not only the files, but the database..

Yes, thankfully I have learned to always make a backup before a big change or install.

I suppose I'll restore and try again. I know it has to be an operator error, but I can't seem to figure out where my error is. Third time is a charm, maybe.

I tried it again, and it looks like both the sideboxes and the order total modules are there.
I am getting one error now when running the sql patch:

PHP Fatal error: 1062:Duplicate entry '0-0' for key 2 :: INSERT INTO zen_reward_master (rewards_products_id ,scope ,scope_id ,point_ratio ,bonus_points, redeem_ratio, redeem_points) VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL); in /home/content/94/10567094/html/includes/classes/db/mysql/query_factory.php on line 120

I am not sure what this means. Any help?

saltsandsuch:

I tried it again, and it looks like both the sideboxes and the order total modules are there.
I am getting one error now when running the sql patch:

PHP Fatal error: 1062[B] Duplicate entry [/B]'0-0' for key 2 :: INSERT INTO zen_reward_master (rewards_products_id ,scope ,scope_id ,point_ratio ,bonus_points, redeem_ratio, redeem_points) VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL); in /home/content/94/10567094/html/includes/classes/db/mysql/query_factory.php on line 120

FYI..Use the forum code functions to post code otherwise the forum software will parse things and add smilies to things where they shouldn't be..

DivaVocals:

It's actually not that mysterious..:smile: It says that you tried to create a DB record which already exists.. To me it indicated that when you restored your site to a pre-install state, you may not have rolled back your DB too.. Suggest running the uninstall SQL and then re-run the installation SQL..

FYI..Use the forum code functions to post code otherwise the forum software will parse things and add smilies to things where they shouldn't be..

I saw the duplicate entry part, and I figured something got added twice but I couldn't figure out where. I did as you suggested, ran the uninstall and then the new.sql again, and no errors.

Now to test. Crossing my fingers it works! Thanks for your help!!!!

saltsandsuch:

I saw the duplicate entry part, and I figured something got added twice but I couldn't figure out where. I did as you suggested, ran the uninstall and then the new.sql again, and no errors.

Now to test. Crossing my fingers it works! Thanks for your help!!!!
Can't add twice.. hence the error message.. Hope things work out for you..

Well, now I get 404 error when I try to go to Customers>Group Reward Redeem or Customers>Reward Points.

Would this have something to do with table prefixes?

saltsandsuch:

Well, now I get 404 error when I try to go to Customers>Group Reward Redeem or Customers>Reward Points.

Would this have something to do with table prefixes?
404 indicates a page not found.. are you sure you have ALL the files uploaded to the proper places???

DivaVocals:

404 indicates a page not found.. are you sure you have ALL the files uploaded to the proper places???

I think I just found it. Somehow I missed a couple files. smh

Hi,

I have this module up and running and I love it!!! Thank you thank you thank you!

I have one more question. On the product page the red text really stands out on my page, does anyone know where to modify the color of this text? The size is too large also, compared to the text of the price. I want to make it a bit smaller as well....

Thanks in advance for your help.

Hi, I installed via the upload from my computer and chose the new.sql
it seemed to install most of it.. I can see the following
Admin>Configuration>Reward Point Configuratioin
Admin>Catalog>Reward Points
Admin>Customers>Group Reward Redeem
Admin>Customers>Reward Points

What I dont see is the Admin>Tools>Layout Boxes Controller (Shopping Cart with Rewards' sidebox ) or the ("Reward Points" sidebox)
nor do they seem to work when I make a sale.. there is no indication in the shopping cart that reward points are being earned.
then after the sale I checked the customers/reward points and there are no pending points.

not sure what to do
any help would be appreciated

oh ok I found where I have to install the module and the reward points are showing up now... sorry for the post....

but The Layout boxes are still not there .....

Hello I have installed it on 1.3.9 zencart shop but now doesn't work the new sql patch
i get a vaule message what can i do now ?
i get this message

1062 Duplicate entry '0-0' for key 'unique_id'
in:
[INSERT INTO reward_master (rewards_products_id ,scope ,scope_id ,point_ratio ,bonus_points, redeem_ratio, redeem_points) VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL);]
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.

hey,

i installed the Reward Points Module for zen-cart 1.5.0.
The test costumer buy something and it will be count right.

Now I have 3 questions:

How can i offer my costumers the discount?
I can see nothing in "Step 1 of 2 - Payment Information"

If the points are used, they stay or disappear?
Can not test it now.

Can I add a small refID system?

And one Problem:

When I open "Customer Reward Points Admin"
i see index: ...
WARNING: An Error occurred, please refresh the page and try again.

ID Last Name ...

but no costumers only the error.

i hope somebody can help.

Check your debug logs in /logs and see what is showing when you get that error, they are date stamped ...

In my logs i can see:

[29-Apr-2013 10:17:34] PHP Fatal 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 'REWARD_POINTS_CUSTOMER_LIMIT' at line 1 :: select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_group_pricing, r.pending_points, r.reward_points, gp.group_name, rm.redeem_ratio from customers as c LEFT JOIN (reward_customer_points as r) ON (r.customers_id=c.customers_id) LEFT JOIN(group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) LEFT JOIN(reward_master as rm) ON ((c.customers_group_pricing!=0 AND rm.scope=3 AND rm.scope_id=c.customers_group_pricing) OR (c.customers_group_pricing=0 AND rm.scope=0 AND rm.scope_id=0)) WHERE c.customers_lastname LIKE 'A%' ORDER BY c.customers_id, c.customers_lastname LIMIT REWARD_POINTS_CUSTOMER_LIMIT; in /home/..../db/mysql/query_factory.php on line 101

Does anyone knows how to fix this annoying error for my 1.3.9h zen cart

Warning: Invalid argument supplied for foreach() in /home/cdsfds/public_html/includes/functions/extra_functions/reward_points_functions.php on line 314

I keep seeing after i installed reward points - everything seems to work properly but i keep seeing it during checkout procedure and in the error logs

I know others also have this problem but i have not found somewhere a solution for it

Please anyone help :shocking:

Hi

I have moved the login links to the head wrapper section in tpl_header.php. I'm trying to include the reward points in there too. I have been examining the code in tpl_header.php as examples to accomplish this without any luck. I tried adding the sidebox code in there which didn't work either. Is it possible to get the reward points to display in the head wrapper? Any help much appreciated.

thanks

zen cart 1.3.9b
Reward Points Full Suite