I'm like chadderuski I can add it manually to the configuration menu but if I add a sql statement it throws and error. This is the sql statement I'm trying to get it to add. This happen in store admin and phpMyAdmin. Any ideas why. Thank You in advance.
PHP Code:
# Register the configuration page for Admin Access Control
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=',@groupid),'configuration','Y',@groupid);
This is the error it throws
Error
SQL query:
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=', @groupid ) , 'configuration', 'Y', @groupid )
MySQL said:
#1048 - Column 'page_params' cannot be null
Bookmarks