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.