Reward Points Module for ZC v13x

[Beyond Dreams]

yes i ran it and it says error. i placed all the files in the directories they are supposed to be in by hand. My upload folder doesnt seem to work on my hosting site. I have the rewards box, I changed the rewards name, it adds 1 point per dollar when i put the items in the shopping cart, but I am still missing the menu options that will help me set these options.

I even tried cutting and pasting the sql patch into the tools sqlpatch and still got an error but no info to tell me what the error is. I have the main admin file where i put the files, I have no custom admin file. The only customized items i have are from using the an_upscale_boutique template, and i put the appropriate files in those folders. This is the latest version of zencart and the latest version of reward points and a fresh install. What else can I do to fix this?

I cant launch my store until i fix this. Any help would be greatly appreciated.
my site is www.beyonddreams.co

[DivaVocals]

yes i ran it and it says error. i placed all the files in the directories they are supposed to be in by hand. My upload folder doesnt seem to work on my hosting site. I have the rewards box, I changed the rewards name, it adds 1 point per dollar when i put the items in the shopping cart, but I am still missing the menu options that will help me set these options.

I even tried cutting and pasting the sql patch into the tools sqlpatch and still got an error but no info to tell me what the error is. I have the main admin file where i put the files, I have no custom admin file. The only customized items i have are from using the an_upscale_boutique template, and i put the appropriate files in those folders. This is the latest version of zencart and the latest version of reward points and a fresh install. What else can I do to fix this?

I cant launch my store until i fix this. Any help would be greatly appreciated.
my site is www.beyonddreams.co

You say you got an error when you ran the SQL.. well that's the start of your issue.. No SQL, no admin menu..

Errors = ERROR LOG file created.. Look at your error log and post that here.. It will tell you what happened.. without this information folks can only GUESS what happened, but clearly it's an installation issue..

[Beyond Dreams]

where can i find the error log? sorry this is all new to me

[DivaVocals]

where can i find the error log?

See if these help..
http://www.zen-cart.com/content.php?...-and-try-again
http://www.zen-cart.com/content.php?124-blank-page

sorry this is all new to me

Great! As a new Zenner you will want to spend some time getting to know Zen Cart.. the FAQ section is an excellent place to start. You should start with this FAQ SECTION:
http://www.zen-cart.com/content.php?25-troubleshooting

[Beyond Dreams]

ok there is no log file created. so what does that tell me? The last log created was from 2/19/13 when i first started setting this site up.

[Beyond Dreams]

here are the logs i have

[27-Mar-2013 12:25:09 America/Phoenix] 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 '<?php /** * @package admin * @copyright Copyright 2003-2006 Zen Cart Development' at line 1 :: <?php /** * @package admin * @copyright Copyright 2003-2006 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: sqlpatch.php 7166 2007-10-03 23:01:46Z drbyte $ */ require('includes/application_top.php'); in /home/content/16/10425116/html/includes/classes/db/mysql/query_factory.php on line 120

[28-Mar-2013 14:35:38 America/Phoenix] PHP Fatal error: 1062uplicate entry '0b1fbde067958a59fbe3acbb08d49cfe' for key 1 :: insert into zen_sessions
values ('0b1fbde067958a59fbe3acbb08d49cfe', '1364507438', 'c2VjdXJpdHlUb2tlbnxzOjMyOiI0ZmVkYjJiMmExN2U2Y2FjZGNiN2VhNjQ4OGMyMjU5NSI7bGFuZ3V hZ2V8czo3OiJlbmdsaXNoIjtsYW5ndWFnZXNfaWR8czoxOiIxIjtsYW5ndWFnZXNfY29kZXxzOjI6ImV uIjtzZWxlY3RlZF9ib3h8czoxMzoiY29uZmlndXJhdGlvbiI7') in /home/content/16/10425116/html/includes/classes/db/mysql/query_factory.php on line 120


[27-Mar-2013 12:55:53 America/Phoenix] 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/16/10425116/html/includes/classes/db/mysql/query_factory.php on line 120



thank you for your help

[Beyond Dreams]

I also tried to do the sql patch command by command to see what ones produced an error and here is what I got

#1 already exists

#2 dup entry

#3 already exists

#4 already exists

#5 processed

#6 processed

#7 - 23 (the insert commands gave all the save errors)

INSERT 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 , 'Reward Point Mode', 'REWARD_POINT_MODE', '0', 'Select the Reward Point Mode<br />0= Reward Points are fixed to the product prices and are calculated individually.<br />1= Reward Points are calculated on the Order Total or Subtotal (depending on the setting of the <strong>Allow Redeem of Reward Points on Order Total or Subtotal</strong> configuration).', @cgi, '0', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

result:

[29-Mar-2013 08:50:48 America/Phoenix] PHP Fatal error: 1048:Column 'configuration_group_id' cannot be null :: INSERT INTO zen_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 , 'Reward Point Mode', 'REWARD_POINT_MODE', '0', 'Select the Reward Point Mode<br />0= Reward Points are fixed to the product prices and are calculated individually.<br />1= Reward Points are calculated on the Order Total or Subtotal (depending on the setting of the <strong>Allow Redeem of Reward Points on Order Total or Subtotal</strong> configuration).', @cgi, '0', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), '); in /home/content/16/10425116/html/includes/classes/db/mysql/query_factory.php on line 120

#24

DELETE FROM admin_pages WHERE page_key='configRewardPoints';
DELETE FROM admin_pages WHERE page_key='GroupRewardRedeem';
DELETE FROM admin_pages WHERE page_key='RewardPoints';
DELETE FROM admin_pages WHERE page_key='CustomerRewardPoints';

results

processed

#25

INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order ) VALUES ('configRewardPoints','BOX_CONFIGURATION_REWARD_POINTS','FILENAME_CONFIGURATION' ,CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('GroupRewardRedeem', 'BOX_GROUP_REWARD_POINTS_REDEEM', 'FILENAME_ADMIN_GROUP_REWARD_POINTS_REDEEM', '', 'customers', 'Y', 35);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('RewardPoints', 'BOX_REWARD_POINTS', 'FILENAME_ADMIN_REWARD_POINTS', '', 'catalog', 'Y', 36);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('CustomerRewardPoints', 'BOX_CUSTOMER_REWARD_POINTS', 'FILENAME_ADMIN_CUSTOMER_REWARD_POINTS', '', 'customers', 'Y', 37);

results

[29-Mar-2013 09:21:06 America/Phoenix] PHP Fatal error: 1048:Column 'page_params' cannot be null :: INSERT INTO zen_admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order ) VALUES ('configRewardPoints','BOX_CONFIGURATION_REWARD_POINTS','FILENAME_CONFIGURATION' ,CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi); in /home/content/16/10425116/html/includes/classes/db/mysql/query_factory.php on line 120

I hope this helps a bit. I just want to understand what is happening and how I can fix this.

Thank you so much for all your help.

[Beyond Dreams]

ok, i uninstalled the new.sql and reinstalled it by opening it in notepad and pasting the file contents into the admin-tools-sqlpatch. I still do not have the menu items in my admin to set the point amounts and to control this module. missing...

I don't have the following on my admin page
admin-catalog-reward points is not in my menu
admin-configuration-reward points is not in my menu
admin-customer-group reward redeem is not in my list


This is the error I got from redoing the above...

[29-Mar-2013 14:01:35 America/Phoenix] PHP Fatal error: 1048:Column 'configuration_group_id' cannot be null :: INSERT INTO zen_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.', @cgi, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), '); in /home/content/16/10425116/html/includes/classes/db/mysql/query_factory.php on line 120

I don't know what else to do I have been trying to fix this for a month and my store launch has been on hold due to it. I see there are others with this issue and they too uninstalled and reinstalled to only get the same result. However they responded they are fixed but no details how they fixed it. Any help at this point would be greatly appreciated.

[Beyond Dreams]

Stevesh and Country Charm Thank you... Thank you.... Thank you!!!!

Stevesh you were right! When I installed zen cart somehow it created an admin folder named adminurrhtcqq, I also had an admin folder. I moved all the files from the admin folder to the adminurrhtcqq folder and wala I now have menu items!!! I am sooo happy I don't know how to thank you guys! You are the best!! Now I just need to test it. I will keep my finger crossed! I need to try to figure out why I wasn't given the option to rename my own admin folder so this wouldn't have happened.

I am forever grateful to you both, and you are greatly appreciated!

[randrew]

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.