I currently have my DNN site hosted on Godaddy, and I have run into a snag with my upgrade. I have managed to restore the site back to the original 7.0.6 version however there seems to be some issues with the data I restored.

I am presented with the following error:

ModuleId: 327

ModuleDefId: 72

FriendlyName: Host Settings

ModuleControlSource: DesktopModules/Admin/HostSettings/HostSettings.ascx

AssemblyVersion: 7.0.6

PortalID: 0

PortalName: Alabama Technology Network

UserID: 1

UserName: dblackmon

ActiveTabID: 16

ActiveTabName: Host Settings

RawURL: /Host/HostSettings/tabid/16/portalid/0/Default.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://www.atn.org/Home.aspx

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

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID: e72c8d7b-ba81-4b88-be10-09d1c769369f

InnerException: Invalid object name 'DotNetNuke.vw_Lists'.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlConnection.

StackTrace:

Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'DotNetNuke.vw_Lists'. ---> System.Data.SqlClient.SqlException: Invalid object name 'DotNetNuke.vw_Lists'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteReader(String connectionString, CommandType type, String sql, Int32 timeout, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteReader(String connectionString, CommandType type, String sql, Object[] args) at DotNetNuke.Data.SqlDataProvider.ExecuteReader(String procedureName, Object[] commandParameters) at DotNetNuke.Data.DataProvider.GetListEntriesByListName(String ListName, String ParentKey, Int32 PortalID) at DotNetNuke.Common.Lists.ListController.GetListEntryInfoItems(String listName, String parentKey, Int32 portalId) at DotNetNuke.Common.Lists.ListController.GetListEntryInfoItems(String listName, String parentKey) at DotNetNuke.Modules.Admin.Host.HostSettings.BindPaymentProcessor() at DotNetNuke.Modules.Admin.Host.HostSettings.BindData() at DotNetNuke.Modules.Admin.Host.HostSettings. (EventArgs e) --- End of inner exception stack trace ---

Basically if I try to go into the Host Setting, Admin Setting, Manage Users, or even try to register I am told "Invalid object name 'DotNetNuke.vw_List" with the above information. I thought the issue was due to the fact that view was missing from my backup. So I connect to a earlier version of the database that does indeed have that view and I am still presented with the issues above.

If anyone could help shed some light on how I can get my site back to normal I would be very thankful.

Thank you,

Doug

I see plenty of files in that directory on the hosting server however not sure what I am actually looking for when you say proper definition. 

Well please note that the snapshot of the database I am currently using has the vw.List in it. Are you saying I need to try and have it recreate it? Also I looked in the 07.00.06 file and there is no reference to the vw.List contained in it.