Issue

When accessing the site settings within a DNN instance, customers have reported receiving the following error:

Error: Site Settings is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Input string was not in a correct format. ---> System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt32(String value) at DotNetNuke.Entities.Users.UserController.GetUserSettings(Int32 portalId) at DesktopModules.Admin.Portals.SiteSettings.BindUserAccountSettings(PortalInfo portal, String activeLanguage) at DesktopModules.Admin.Portals.SiteSettings.BindPortal(Int32 portalId, String activeLanguage) at DesktopModules.Admin.Portals.SiteSettings.OnLoad(EventArgs e) 

Root Cause

The source of this error is a malformed or corrupt setting in the PortalSettings table within the DNN database. 

Resolution

We have created a SQL script that will restore the PortalSettings table back to its original settings which will fix the issue. 

Requirements: SQL access to the DNN database, access to the DNN web.config file

NOTE: Please take a database backup before executing the script in the following instructions.

The following fix will only work for versions 7.0 - 9.1.1

1. Download the AdjustDNNPortalSettings911.sql file attached here. 

2. Log in to SQL Server Management Studio.

3. In the left side Object Explorer, Double click on your server name and then Databases to expand. 

4. Find your DNN database and right-click to select New Query. 

5. Open the AdjustDNNPortalSettings911.sql file and Paste the script into the middle query box.

6. Per the script instructions, you will need to get the {databaseOwner} and
{objectQualifier} values from your web.config file which should be in the root DNN installation folder. Replace those placeholders with the values taken from the config file. 

7. Press F5 to execute the script. 

8. Clear your cache.

9. Validate the fix by navigating to the site settings in your DNN portal. If successful, the error message will not show and you should be able to proceed as needed.