Page Comparison

...

To restore the Settings link, complete the following procedure:

1. Locate the PACE_MASTERDBO database.
   The portal_sys_setting_info table in the PACE_MASTERDBO database stores each setting, its description, data type category, and key id. The Settings Link has a key id value of 49.  

2. Go to the portal_sys_setting_detail table and locate key id 49.

3. Select * from portal_sys_setting_detail where key_id = '49'.
   The values for each setting based on their key_id are stored in this table’s Value column.  Boolean values such as show settings/not show settings are stored as 0 for false, 1 for true.

4. Run the update statement to change the value in Value column back to 1:
   update pace_masterdbo.portal_sys_setting_detail set value = 1 where key_id = 49

5. Recycle all PACE Appserver instances and the Portal website.

6. Log out and back into Eagle Portal to view the restored Settings link.