I have a DNN site that is incredibly ancient, the current version being DNN 6.2.1, but the site itself has been around since DNN 3 was around. Pretty much every time we go to upgrade it, there's been some sort of error, and when I went to upgrade to DNN 7, there was no exception, so I decided to just do a completely fresh install, and then move over all our user data, along with any modules still in use. The install went off without a hitch, but once I started migrating user data, I ran into problems.
I took down the site in IIS, temporarily disabled foreign keys, and then migrated over the aspnet tables, User tables, and Role tables using SQL server's import data wizard (enabling insert identity). The new install had only one portal, so I pointed the portal ID's for all relevant entries, and re-enabled foreign keys. No errors, so I figured everything was good, copied the previous host password to the new host account, changed the machine key in the web.config file, and brought the site back up. Logged in and everything seemed to work, logged in with the host no problem, and started testing out other user accounts. The first thing I noticed was that the admin accounts didn't seem to have the proper permissions, they couldn't edit or see admin only pages. I figured maybe I just needed to set the admin role in site settings, but when I went to the page, I got this error: A critical error has occurred. Object reference not set to an instance of an object.
I haven't installed any custom modules yet, so the only possible cause could be the data migration, that maybe I didn't transfer all the tables that I needed to, or I forget to tweak a setting somewhere in the database and it's causing the site settings not to load. Does anyone know all of the tables that need to be moved when migrating users, or have any idea where the issue might be? Any help would be much appreciated, been banging my head against the wall on this issue for a while.
Also, this is the full error from the event viewer:
AssemblyVersion: 7.0.3
PortalID: 0
PortalName: DNN7 Test site
UserID: 1
UserName: host
ActiveTabID: 67
ActiveTabName: Site Settings
RawURL: /Admin/SiteSettings.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://localhost/Home.aspx
UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.152 Safari/537.22
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID: a3fb51fb-3803-47ff-86f6-5f6a81102592
InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: DotNetNuke.Web.UI.WebControls.DnnFilePickerUploader.LoadFiles
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Web.UI.WebControls.DnnFilePickerUploader.LoadFiles() at DotNetNuke.Web.UI.WebControls.DnnFilePickerUploader.LoadFolders() at DotNetNuke.Web.UI.WebControls.DnnFilePickerUploader.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---