Not certain if it's the install or the particular cart I'm working on but I thought I would share... Zen Cart 1.55f, Reward Point Full Suite 2.5f
After installing the newest rewards module 2.5f, running the SQL for a new install this particular sql update created a mismatch between the configuration menu and the actual configuration_group_id
The menu was posting gID=36 while the actual entry was set for **configuration_group_id = 63 **
This prevented the entire admin -> configuration menu -> Reward Point Configuration from loading. No errors, no sign of what or why until I hovered over the menu link and noticed the ID error.
I sourced it back to this line of the SQL file:
/*
zencart 1.5 mods
*/
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);
Which also relates to this:
SELECT @groupid:=configuration_group_id FROM configuration_group
WHERE configuration_group_title= 'Reward Points';
DELETE FROM configuration WHERE configuration_group_id = @groupid AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @groupid AND configuration_group_id != 0;
INSERT INTO configuration_group VALUES (NULL , 'Reward Points', 'Reward Point Module Configuration', '50' , '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SELECT @cgi:=configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Reward Points';
The problem:
It seems @cgi picked up the wrong ID then rolled with it.
The fix:
I changed the db entry in admin_pages -> page_key -> configRewardPoints -> page_params -> **gID=36 **to gID=63
All is well now!
Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian