Reward Points Module for ZC v13x

[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!

[DivaVocals]

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..

[saltsandsuch]

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.

[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: 1062uplicate 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?

[DivaVocals]

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?

It's actually not that mysterious.. 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..

[saltsandsuch]

It's actually not that mysterious.. 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!!!!

[DivaVocals]

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..

[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?

[DivaVocals]

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???

[saltsandsuch]

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