Since 7.2.2 whenever I make a change to any setting on a host, an event is registered and the change is lost. There are some other problems, but this one is the clearest.

Event viewer:

ModuleId:327

ModuleDefId:72

FriendlyName:Host Settings

ModuleControlSource:DesktopModules/Admin/HostSettings/HostSettings.ascx

AssemblyVersion:7.2.2

PortalID:0

PortalName:obfuscated

UserID:1

UserName:root

ActiveTabID:16

ActiveTabName:Host Settings

RawURL:/host/host-settings/portalid/0

AbsoluteURL:/Default.aspx

AbsoluteURLReferrer:http://www.obfuscated.com/host/host-settings/portalid/0

UserAgent:Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:3efe161e-92de-4696-98f9-4d17d144e01d

InnerException:Object reference not set to an instance of an object.

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:DotNetNuke.Modules.Admin.Host.HostSettings.UpdateSettings

StackTrace:

Message:

DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object.
   at DotNetNuke.Modules.Admin.Host.HostSettings.UpdateSettings(Object sender, EventArgs e)
   --- End of inner exception stack trace ---

 

Source:

Server Name: obfuscated

 

It seemed similar to http://www.dnnsoftware.com/forums/forumid/200/threadid/498717/scope/posts, but the error stack is different.

 

What is a good analysis approach?

Hi Sebastian, thanks for the tip. I have the following:

select count(*)
from hostsettings
where settingvalue is null

Result: 0 (so no rows with null)

select settingname, count(*)
from hostsettings
group
by settingname
having count(*) > 1

No rows.

The settingnames and settingvalues seem ok.

Found that for instance HostPortalID in HostSettings is empty string. Should have been 0. Found more strange things. The problems have probably been caused by the upgrade from iFinity URL Master to Advanced URLs using 2.8.0 of iFinity URL Master and then damage caused by that. Restored backup and switched back to ifinity url master, no longer using advanced urls.

All problems seem to have gone when using iFinity URL Master instead of AUM.