I just moved a site from a Server 2008x64 with SQL 2008 to a Server 2008x64 with SQL 2005.

I had an issue where the 2008 db wouldn't attach to 2005 so instead exported the database contents from 2008 to a 2005 then dropped and moved.

When I try to update anything ont he Admin or Host Settings page I get :

Error: Host Settings is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'SkinID', table 'dnnACN.dbo.Skins'; column does not allow nulls.

However if I go to the Page Settings and set the skin, it takes. I am guessing that the export did not go well. I have checked all the sprocs, views, table to make sure it all matches but am still at a loss what would cause Admin and Host Settings changes from being written to the db.

Thansk, Ron

Thanks Scott for the quick reply.

One of the servers is not mine so I can't install much, however I did go ahead and download SQL toolbelt and was able to compare against my database and a backup that I ftp'd from the orig server.

Two things that stand out are the missing aspnet_* roles and schemas from the database that is having issues. Would that cause the errors I am experiancing you think, or is this a difference between SQL Server 2005 and 2008? Not up to speed on 2008 but leanign fast!

Hope all is well with you!

-Ron