Hello Sebastian,
I restored, updated my Blogmodule which was probably outdated and tried executing TurboDNN again. I still got a catastrophic error- the site is down and I will have to restore: This is the error i got before the crash.
System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Feedback_Modules". The conflict occurred in database "dotnetnuke2", table "dbo.Modules", column 'ModuleID'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:cebbb77a-6405-449b-a0c6-9d128113da46 Error Number:547,State:0,Class:16 -- drop AF foregn keys with known issues: IF EXISTS (SELECT * FROM Sys.Foreign_Keys WHERE Parent_Object_id = OBJECT_ID(N'dbo.[activeforums_ForumTopics]') AND name = N'FK_activeforums_ForumTopics_activeforums_Replies') ALTER TABLE dbo.[activeforums_ForumTopics] DROP CONSTRAINT [FK_activeforums_ForumTopics_activeforums_Replies] -- make sure, all constraints are enabled IF (ServerProperty(N'EngineEdition') != 5) --Check for not running on SQL Azure EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all" System.Data.SqlClient.SqlException (0x80131904): Cannot find either column "dbo" or the user-defined function or aggregate "dbo.HasChildTab", or the name is ambiguous. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:b3d708b3-5513-4232-8537-b71bc1103895 Error Number:4121,State:1,Class:16 IF dbo.[sys_currentDNNVersion]() < 70400 Exec (N' CREATE VIEW dbo.[vw_Tabs] AS SELECT T.TabID, T.TabOrder, T.PortalID, T.TabName, T.ParentId, T.[Level], T.TabPath, T.UniqueId, T.VersionGuid, T.DefaultLanguageGuid, T.LocalizedVersionGuid, T.IsVisible, dbo.FilePath(T.IconFile) AS IconFile, dbo.FilePath(T.IconFileLarge) AS IconFileLarge, T.DisableLink, T.Title, T.Description, T.KeyWords, T.IsDeleted, T.SkinSrc, T.ContainerSrc, T.StartDate, T.EndDate, T.Url, CASE WHEN dbo.HasChildTab(T.TabID) = 1 THEN N''true'' ELSE N''false'' END AS HasChildren, -- I would prefer returning a Bit value T.RefreshInterval, T.PageHeadText, T.IsSecure, T.PermanentRedirect, T.SiteMapPriority, CI.ContentItemID, CI.[Content], CI.ContentTypeID, CI.ModuleID, CI.ContentKey, CI.Indexed, CI.StateID, T.CultureCode, T.CreatedByUserID, T.CreatedOnDate, T.LastModifiedByUserID, T.LastModifiedOnDate FROM dbo.Tabs AS T LEFT JOIN dbo.ContentItems AS CI ON T.ContentItemID = CI.ContentItemID ') ELSE Exec(N' CREATE VIEW dbo.[vw_Tabs] AS SELECT T.TabID, T.TabOrder, T.PortalID, T.TabName, T.ParentId, T.[Level], T.TabPath, T.UniqueId, T.VersionGuid, T.DefaultLanguageGuid, T.LocalizedVersionGuid, T.IsVisible, T.HasBeenPublished, dbo.FilePath(T.IconFile) AS IconFile, dbo.FilePath(T.IconFileLarge) AS IconFileLarge, T.DisableLink, T.Title, T.Description, T.KeyWords, T.IsDeleted, T.SkinSrc, T.ContainerSrc, T.StartDate, T.EndDate, T.Url, CASE WHEN dbo.HasChildTab(T.TabID) = 1 THEN N''true'' ELSE N''false'' END AS HasChildren, -- I would prefer returning a Bit value T.RefreshInterval, T.PageHeadText, T.IsSecure, T.IsSystem, T.PermanentRedirect, T.SiteMapPriority, CI.ContentItemID, CI.[Content], CI.ContentTypeID, CI.ModuleID, CI.ContentKey, CI.Indexed, CI.StateID, T.CultureCode, T.CreatedByUserID, T.CreatedOnDate, T.LastModifiedByUserID, T.LastModifiedOnDate FROM dbo.Tabs AS T LEFT JOIN dbo.ContentItems AS CI ON T.ContentItemID = CI.ContentItemID ') System.Data.SqlClient.SqlException (0x80131904): Cannot find either column "dbo" or the user-defined function or aggregate "dbo.SuperuserTabID", or the name is ambiguous. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:aac96bb8-dc03-4682-ab4b-7f9817530b58 Error Number:4121,State:1,Class:16 IF dbo.[sys_currentDNNVersion]() < 70202 Exec(N' CREATE VIEW dbo.[vw_Portals] AS SELECT P.PortalID, P.PortalGroupID, P.PortalName, dbo.[FilePath](P.LogoFile) AS LogoFile, P.FooterText, P.ExpiryDate, P.UserRegistration, P.BannerAdvertising, P.AdministratorId, P.Currency, P.HostFee, P.HostSpace, P.PageQuota, P.UserQuota, P.AdministratorRoleId, P.RegisteredRoleId, P.Description, P.KeyWords, dbo.[FilePath](P.BackgroundFile) AS BackgroundFile, P.GUID, P.PaymentProcessor, P.ProcessorUserId, P.ProcessorPassword, P.SiteLogHistory, U.Email, P.DefaultLanguage, P.TimezoneOffset, P.AdminTabId, P.HomeDirectory, P.SplashTabId, P.HomeTabId, P.LoginTabId, P.RegisterTabId, P.UserTabId, P.SearchTabId, dbo.SuperuserTabID() AS SuperTabId, P.CreatedByUserID, P.CreatedOnDate, P.LastModifiedByUserID, P.LastModifiedOnDate, P.CultureCode FROM dbo.[vw_PortalBase] P LEFT JOIN dbo.[Users] U ON P.AdministratorId = U.UserId ') ELSE Exec (N' CREATE VIEW dbo.[vw_Portals] AS SELECT P.PortalID, P.PortalGroupID, P.PortalName, dbo.FilePath(P.LogoFile) AS LogoFile, P.FooterText, P.ExpiryDate, P.UserRegistration, P.BannerAdvertising, P.AdministratorId, P.Currency, P.HostFee, P.HostSpace, P.PageQuota, P.UserQuota, P.AdministratorRoleId, P.RegisteredRoleId, P.Description, P.KeyWords, dbo.FilePath(P.BackgroundFile) AS BackgroundFile, P.GUID, P.PaymentProcessor, P.ProcessorUserId, P.ProcessorPassword, P.SiteLogHistory, U.Email, P.DefaultLanguage, P.TimezoneOffset, P.AdminTabId, P.HomeDirectory, P.SplashTabId, P.HomeTabId, P.LoginTabId, P.RegisterTabId, P.UserTabId, P.SearchTabId, P.Custom404TabId, P.Custom500TabId, dbo.SuperUserTabID() AS SuperTabId, P.CreatedByUserID, P.CreatedOnDate, P.LastModifiedByUserID, P.LastModifiedOnDate, P.CultureCode FROM dbo.[vw_PortalBase] AS P LEFT JOIN dbo.[Users] AS U ON P.AdministratorId = U.UserID ') System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.vw_Portals'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d36e2fdc-6ba2-499b-97da-d6743d9cf07b Error Number:208,State:1,Class:16 -- DNN-4610: Use new helper function IF dbo.[sys_currentDNNVersion]() < 70202 Exec(N' CREATE VIEW dbo.[vw_PortalsDefaultLanguage] AS SELECT PortalID, PortalGroupID, PortalName, LogoFile, FooterText, ExpiryDate, UserRegistration, BannerAdvertising, AdministratorId, Currency, HostFee, HostSpace, PageQuota, UserQuota, AdministratorRoleId, RegisteredRoleId, Description, KeyWords, BackgroundFile, GUID, PaymentProcessor, ProcessorUserId, ProcessorPassword, SiteLogHistory, Email, DefaultLanguage, TimezoneOffset, AdminTabId, HomeDirectory, SplashTabId, HomeTabId, LoginTabId, RegisterTabId, UserTabId, SearchTabId, SuperTabId, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate, CultureCode FROM dbo.[vw_Portals] WHERE CultureCode = DefaultLanguage ') ELSE EXEC (N' CREATE VIEW dbo.[vw_PortalsDefaultLanguage] AS SELECT PortalID, PortalGroupID, PortalName, LogoFile, FooterText, ExpiryDate, UserRegistration, BannerAdvertising, AdministratorId, Currency, HostFee, HostSpace, PageQuota, UserQuota, AdministratorRoleId, RegisteredRoleId, Description, KeyWords, BackgroundFile, GUID, PaymentProcessor, ProcessorUserId, ProcessorPassword, SiteLogHistory, Email, DefaultLanguage, TimezoneOffset, AdminTabId, HomeDirectory, SplashTabId, HomeTabId, LoginTabId, RegisterTabId, UserTabId, SearchTabId, Custom404TabId, Custom500TabId, SuperTabId, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate, CultureCode FROM dbo.[vw_Portals] WHERE CultureCode = DefaultLanguage ')