Hello :)

I was editing some modules, just making routine changes, then this error came up several times:

Error: Host Settings is currently unavailable.
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.HostSettingsModule.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

Any ideas as to what I did wrong, and how to fix?

thanks

I removed httpcompression (commented out in web.config, and set to zero via database query in HostSettings table) as well as set Whitespace to 'N' in that table.

Gave it an hour, came back, and all seems fine. Not the performance I would like in terms of speed, but working and slow-ish is better than not working fast.

An update on my experience - even after removing compression and whitespace the same problem has recurred. It seems not to be quite as often or consistent but is still giving me fits. There is a gemini support issue regarding this:

http://support.dotnetnuke.com/issue/ViewIssue.aspx?ID=5030

as far as updating the settings via direct update to the database table, I did so from MS SQL client tools, not the SQL window in the HOST menu. I suppose you could do it there as well. I would caution you first to back up your database before doing anything of this nature.

The database table in question is HostSettings, and what you want to do is something like this:

I'm assuming you are running this from within the HOST SQL window.

First, select the data out to see that you are looking at the correct info:

select * from hostsettings

If you have set the object qualifier in web.config then prefix that to the table name as

select * from objq_hostsettings (if for example your object qualifier were "objq")

Now you will see the current host settings.

you want to change the httpcompression to be zero and the whitespace filter to be 'N'

update hostsettings set settingvalue = '0' where settingname = 'HttpCompression'

update hostsettings set settingvalue = 'N' where settingname = 'WhitespaceFilter'

Of course, if using an object qualifier, it must be prepended to the table name here as well.

run each separately, and in between each run the select query above to see that your changes were effective.

I suggest great caution when updating such settings manually - back up the database first, make sure you have the entire query correctly written (if you just put in part of it such as "update hostsettings set settingvalue = '0'" you will change every value for every column ... very bad!)

It's not difficult to do it correctly and if done correctly will be reflected the next time you view Host Settings as superuser. But please take every precaution and don't hole me responsible for any ensuing problems ... got enough of my own!

Perhaps someone from core could respond as to the advisability and accuracy of the above.