Trying to load 2.0 on zc1.5.0 fresh install. I DID bring over order history from a previous install, as I don't want to lose all those comments and tracking numbers. All the functions of tracking seem to be working, but I can't get the Ty config page to show.
This statement works fine:
SELECT @tyid:=configuration_group_id FROM zen_configuration_group
WHERE configuration_group_title= 'Ty Package Tracker';
DELETE FROM zen_configuration WHERE configuration_group_id = @tyid;
DELETE FROM zen_configuration_group WHERE configuration_group_id = @tyid;
This statement works fine:
INSERT INTO zen_configuration_group VALUES (NULL, 'Ty Package Tracker', 'Settings for Ty Package Tracker features', '0', '1');
UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SELECT @cgi:=configuration_group_id FROM zen_configuration_group WHERE configuration_group_title = 'Ty Package Tracker';
This statement gives an error:
/*
Register Admin Page
*/
SELECT @typackageadmin:=page_key
FROM zen_admin_pages WHERE language_key='BOX_CONFIGURATION_TY_PACKAGE_SETTINGS';
DELETE FROM zen_admin_pages WHERE page_key=@typackageadmin;
INSERT INTO zen_admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order)
VALUES ('configTyPackageTracker','BOX_CONFIGURATION_TY_PACKAGE_SETTINGS','FILENAME_CONFIGURATION',CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);
The error is:
SQL query:
INSERT INTO zen_admin_pages( page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order )
VALUES (
'configTyPackageTracker', 'BOX_CONFIGURATION_TY_PACKAGE_SETTINGS', 'FILENAME_CONFIGURATION', CONCAT( 'gID=', @cgi ) , 'configuration', 'Y', @cgi
);
MySQL said: Documentation
#1048 - Column 'page_params' cannot be null
Any help would be very appreciated!
