Hello all,
I'm getting the following exceptions when trying to upgrade DNN from 07.00.06 to 07.01.01:
0% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): Column, parameter, or variable #22: Cannot find data type date.
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)
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:1195c228-ce04-41b0-a654-7a6f42d18c19 IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'Files' AND COLUMN_NAME = 'StartDate') ALTER TABLE dbo.[Files] ADD [StartDate] date NULL DEFAULT GETDATE() System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StartDate'.
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)
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:caeb25f6-7620-41bc-9c0e-435234d16e39 UPDATE dbo.[Files] SET [StartDate] = COALESCE([CreatedOnDate], GETDATE()) System.Data.SqlClient.SqlException (0x80131904): ALTER TABLE ALTER COLUMN failed because column 'StartDate' does not exist in table 'Files'.
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)
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:ebbcfcac-1228-4fb5-a204-baf723f99a83 ALTER TABLE dbo.[Files] ALTER COLUMN [StartDate] date NOT NULL System.Data.SqlClient.SqlException (0x80131904): Column, parameter, or variable #23: Cannot find data type date.
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)
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:7fe506eb-b5f0-4395-bcde-bc67c5100dc8 IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'Files' AND COLUMN_NAME = 'EndDate') ALTER TABLE dbo.[Files] ADD [EndDate] date NULL System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StartDate'. Invalid column name 'EndDate'.
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)
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:3f63080d-fe2d-4284-abe5-245af45ea3c5 CREATE VIEW dbo.[vw_Files] AS SELECT fi.[FileId] ,fi.[PortalId] ,fi.[FileName] ,fi.[Extension] ,fi.[Size] ,fi.[Width] ,fi.[Height] ,fi.[ContentType] ,fi.[FolderID] ,fi.[Content] ,fi.[CreatedByUserID] ,fi.[CreatedOnDate] ,fi.[LastModifiedByUserID] ,fi.[LastModifiedOnDate] ,fi.[UniqueId] ,fi.[VersionGuid] ,fi.[SHA1Hash] ,fi.[LastModificationTime] ,fi.[Title] ,fi.[StartDate] ,fi.[EnablePublishPeriod] ,fi.[EndDate] ,fi.[ContentItemID] ,fi.[PublishedVersion] ,fo.FolderPath as [Folder] FROM dbo.[Files] fi INNER JOIN dbo.[Folders] fo ON fi.FolderID = fo.FolderID System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.vw_Files'.
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)
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:a17a3e65-22d0-4fe6-b23e-9cc96cd09c16 CREATE VIEW dbo.[vw_PublishedFiles] AS SELECT fi.[FileId] ,fi.[PortalId] ,fi.[FileName] ,fi.[Extension] ,fi.[Size] ,fi.[Width] ,fi.[Height] ,fi.[ContentType] ,fi.[FolderID] ,fi.[Content] ,fi.[CreatedByUserID] ,fi.[CreatedOnDate] ,fi.[LastModifiedByUserID] ,fi.[LastModifiedOnDate] ,fi.[UniqueId] ,fi.[VersionGuid] ,fi.[SHA1Hash] ,fi.[LastModificationTime] ,fi.[Title] ,fi.[StartDate] ,fi.[EnablePublishPeriod] ,fi.[EndDate] ,fi.[ContentItemID] ,fi.[PublishedVersion] ,fi.[Folder] FROM dbo.[vw_Files] fi WHERE [EnablePublishPeriod] = 0 OR ([StartDate] <= GETDATE() AND ([EndDate] IS NULL OR GETDATE() <= [EndDate])) System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StartDate'. Invalid column name 'EndDate'.
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)
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:37345e25-2bbb-4c8c-8182-c811d9cc1ccb CREATE PROCEDURE dbo.[AddFile] @PortalId int, @UniqueId uniqueidentifier, @VersionGuid uniqueidentifier, @FileName nvarchar(246), @Extension nvarchar(100), @Size int, @Width int, @Height int, @ContentType nvarchar(200), @Folder nvarchar(246), @FolderID int, @CreatedByUserID int, @Hash varchar(40), @LastModificationTime datetime, @Title nvarchar(256), @EnablePublishPeriod bit, @StartDate datetime, @EndDate datetime, @ContentItemID int AS BEGIN DECLARE @FileID int UPDATE dbo.[Files] SET /* retrieves FileId from table */ @FileID = FileId, FileName = @FileName, VersionGuid = @VersionGuid, Extension = @Extension, Size = @Size, Width = @Width, Height = @Height, ContentType = @ContentType, FolderID = @FolderID, LastModifiedByUserID = @CreatedByUserID, LastModifiedOnDate = getdate(), SHA1Hash = @Hash, LastModificationTime = @LastModificationTime, Title = @Title, EnablePublishPeriod = @EnablePublishPeriod, StartDate = @StartDate, EndDate = @EndDate, ContentItemID = @ContentItemID WHERE FolderID = @FolderID AND FileName = @FileName IF @@ROWCOUNT = 0 BEGIN INSERT INTO dbo.[Files] ( PortalId, UniqueId, VersionGuid, FileName, Extension, Size, Width, Height, ContentType, FolderID, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate, SHA1Hash, LastModificationTime, Title, EnablePublishPeriod, StartDate, EndDate, ContentItemID ) VALUES ( @PortalId, @UniqueId, @VersionGuid, @FileName, @Extension, @Size, @Width, @Height, @ContentType, @FolderID, @CreatedByUserID, getdate(), @CreatedByUserID, getdate(), @Hash, @LastModificationTime, @Title, @EnablePublishPeriod, @StartDate, @EndDate, @ContentItemID ) SELECT @FileID = SCOPE_IDENTITY() END SELECT @FileID END System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StartDate'. Invalid column name 'EndDate'.
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)
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:d6f5e657-00e1-4a0c-82cd-108258182c1e CREATE PROCEDURE dbo.[UpdateFile] @FileId int, @VersionGuid uniqueidentifier, @FileName nvarchar(246), @Extension nvarchar(100), @Size int, @Width int, @Height int, @ContentType nvarchar(200), @Folder nvarchar(246), @FolderID int, @LastModifiedByUserID int, @Hash varchar(40), @LastModificationTime datetime, @Title nvarchar(256), @EnablePublishPeriod bit, @StartDate datetime, @EndDate datetime, @ContentItemID int AS UPDATE dbo.Files SET FileName = @FileName, VersionGuid = @VersionGuid, Extension = @Extension, Size = @Size, Width = @Width, Height = @Height, ContentType = @ContentType, FolderID = @FolderID, LastModifiedByUserID = @LastModifiedByUserID, LastModifiedOnDate = getdate(), SHA1Hash = @Hash, LastModificationTime = @LastModificationTime, Title = @Title, EnablePublishPeriod = @EnablePublishPeriod, StartDate = @StartDate, EndDate = @EndDate, ContentItemID = @ContentItemID WHERE FileId = @FileId System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.vw_Files'.
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)
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:f66623c8-6a44-4e33-a95d-2232bfe1081f CREATE VIEW dbo.[vw_Portals] AS SELECT DISTINCT P.PortalID, P.PortalGroupID, PL.PortalName, CASE WHEN LEFT(LOWER(PL.LogoFile), 7) = 'fileid=' THEN (SELECT Folder + FileName FROM dbo.vw_Files WHERE fileid = CAST((RIGHT(LOWER(PL.LogoFile), Len(PL.LogoFile) - 7)) AS int)) ELSE PL.LogoFile END AS LogoFile, PL.FooterText, P.ExpiryDate, P.UserRegistration, P.BannerAdvertising, P.AdministratorId, P.Currency, P.HostFee, P.HostSpace, P.PageQuota, P.UserQuota, P.AdministratorRoleId, P.RegisteredRoleId, PL.Description, PL.KeyWords, CASE WHEN LEFT(LOWER(PL.BackgroundFile), 7) = 'fileid=' THEN (SELECT Folder + FileName FROM dbo.vw_Files WHERE fileid = CAST((RIGHT(LOWER(PL.BackgroundFile), Len(PL.BackgroundFile) - 7)) AS int)) ELSE PL.BackgroundFile END AS BackgroundFile, P.GUID, P.PaymentProcessor, P.ProcessorUserId, P.ProcessorPassword, P.SiteLogHistory, U.Email, P.DefaultLanguage, P.TimezoneOffset, PL.AdminTabId, P.HomeDirectory, PL.SplashTabId, PL.HomeTabId, PL.LoginTabId, PL.RegisterTabId, PL.UserTabId, PL.SearchTabId, (SELECT TOP (1) TabID FROM dbo.Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabId, P.CreatedByUserID, P.CreatedOnDate, P.LastModifiedByUserID, P.LastModifiedOnDate, PL.CultureCode FROM dbo.Portals AS P INNER JOIN dbo.PortalLocalization AS PL ON P.PortalID = PL.PortalID LEFT OUTER JOIN dbo.Users AS U ON P.AdministratorId = U.UserID System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.vw_Files'.
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)
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:f2e85678-3b56-41b7-8aae-4ef04dcd15e0 CREATE VIEW dbo.[vw_PortalsDefaultLanguage] AS SELECT DISTINCT P.PortalID, P.PortalGroupID, PL.PortalName, PL.LogoFile, PL.FooterText, P.ExpiryDate, P.UserRegistration, P.BannerAdvertising, P.AdministratorId, P.Currency, P.HostFee, P.HostSpace, P.PageQuota, P.UserQuota, P.AdministratorRoleId, P.RegisteredRoleId, PL.Description, PL.KeyWords, PL.BackgroundFile, P.GUID, P.PaymentProcessor, P.ProcessorUserId, P.ProcessorPassword, P.SiteLogHistory, U.Email, P.DefaultLanguage, P.TimezoneOffset, PL.AdminTabId, P.HomeDirectory, PL.SplashTabId, PL.HomeTabId, PL.LoginTabId, PL.RegisterTabId, PL.UserTabId, PL.SearchTabId, (SELECT TOP (1) TabID FROM dbo.Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabId, P.CreatedByUserID, P.CreatedOnDate, P.LastModifiedByUserID, P.LastModifiedOnDate, PL.CultureCode FROM dbo.Portals AS P INNER JOIN (SELECT PortalID, PortalName, CASE WHEN LEFT(LOWER(LogoFile), 7) = 'fileid=' THEN (SELECT Folder + FileName FROM dbo.vw_Files WHERE fileid = CAST((RIGHT(LOWER(LogoFile), LEN(LogoFile) - 7)) AS INT)) ELSE LogoFile END AS LogoFile, FooterText, Description, KeyWords, CASE WHEN LEFT(LOWER(BackgroundFile), 7) = 'fileid=' THEN (SELECT Folder + FileName FROM dbo.vw_Files WHERE fileid = CAST((RIGHT(LOWER(BackgroundFile), LEN(BackgroundFile) - 7)) AS INT)) ELSE BackgroundFile END AS BackgroundFile, AdminTabId, SplashTabId, HomeTabId, LoginTabId, RegisterTabId, UserTabId, SearchTabId, CultureCode FROM dbo.PortalLocalization) AS PL ON P.PortalID = PL.PortalID AND PL.CultureCode = P.DefaultLanguage LEFT OUTER JOIN dbo.Users AS U ON P.AdministratorId = U.UserID System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.vw_Files'.
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)
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:dc3e9489-0beb-4db5-8832-fe9f00e68e37 CREATE VIEW dbo.vw_TabModules AS SELECT M.PortalID AS [OwnerPortalID], T.PortalID, TM.TabID, TM.TabModuleID, M.ModuleID, M.ModuleDefID, TM.ModuleOrder, TM.PaneName, TM.ModuleTitle, TM.CacheTime, TM.CacheMethod, TM.Alignment, TM.Color, TM.Border, CASE WHEN LEFT(LOWER(TM.IconFile), 6) = 'fileid' THEN (SELECT Folder + FileName FROM dbo.vw_Files WHERE 'fileid=' + CONVERT(varchar, dbo.vw_Files.FileID) = TM.IconFile) ELSE TM.IconFile END AS IconFile, M.AllTabs, TM.Visibility, TM.IsDeleted, TM.Header, TM.Footer, M.StartDate, M.EndDate, TM.ContainerSrc, TM.DisplayTitle, TM.DisplayPrint, TM.DisplaySyndicate, TM.IsWebSlice, TM.WebSliceTitle, TM.WebSliceExpiryDate, TM.WebSliceTTL, M.InheritViewPermissions, M.IsShareable, M.IsShareableViewOnly, MD.DesktopModuleID, MD.DefaultCacheTime, MC.ModuleControlID, DM.BusinessControllerClass, DM.IsAdmin, DM.SupportedFeatures, CI.ContentItemID, CI.Content, CI.ContentTypeID, CI.ContentKey, CI.Indexed, CI.StateID, TM.CreatedByUserID, TM.CreatedOnDate, TM.LastModifiedByUserID, TM.LastModifiedOnDate, M.LastContentModifiedOnDate, TM.UniqueId, TM.VersionGuid, TM.DefaultLanguageGuid, TM.LocalizedVersionGuid, TM.CultureCode FROM dbo.ModuleDefinitions AS MD INNER JOIN dbo.Modules AS M ON MD.ModuleDefID = M.ModuleDefID INNER JOIN dbo.ModuleControls AS MC ON MD.ModuleDefID = MC.ModuleDefID INNER JOIN dbo.DesktopModules AS DM ON MD.DesktopModuleID = DM.DesktopModuleID LEFT OUTER JOIN dbo.ContentItems AS CI ON M.ContentItemID = CI.ContentItemID LEFT OUTER JOIN dbo.TabModules AS TM ON M.ModuleID = TM.ModuleID LEFT OUTER JOIN dbo.Tabs AS T ON TM.TabID = T.TabID WHERE (MC.ControlKey IS NULL) System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.vw_Files'.
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)
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:dbd32d25-9f87-4b35-84f1-b0af7dcb8df7 CREATE VIEW dbo.vw_Modules AS SELECT M.PortalID AS [OwnerPortalID], T.PortalID, TM.TabID, TM.TabModuleID, M.ModuleID, M.ModuleDefID, TM.ModuleOrder, TM.PaneName, TM.ModuleTitle, TM.CacheTime, TM.CacheMethod, TM.Alignment, TM.Color, TM.Border, CASE WHEN LEFT(LOWER(TM.IconFile), 6) = 'fileid' THEN (SELECT Folder + FileName FROM dbo.vw_Files WHERE 'fileid=' + CONVERT(varchar, dbo.vw_Files.FileID) = TM.IconFile) ELSE TM.IconFile END AS IconFile, M.AllTabs, TM.Visibility, TM.IsDeleted, TM.Header, TM.Footer, M.StartDate, M.EndDate, TM.ContainerSrc, TM.DisplayTitle, TM.DisplayPrint, TM.DisplaySyndicate, TM.IsWebSlice, TM.WebSliceTitle, TM.WebSliceExpiryDate, TM.WebSliceTTL, M.InheritViewPermissions, M.IsShareable, M.IsShareableViewOnly, MD.DesktopModuleID, MD.DefaultCacheTime, MC.ModuleControlID, DM.BusinessControllerClass, DM.IsAdmin, DM.SupportedFeatures, CI.ContentItemID, CI.Content, CI.ContentTypeID, CI.ContentKey, CI.Indexed, CI.StateID, M.CreatedByUserID, M.CreatedOnDate, M.LastModifiedByUserID, M.LastModifiedOnDate, M.LastContentModifiedOnDate, TM.UniqueId, TM.VersionGuid, TM.DefaultLanguageGuid, TM.LocalizedVersionGuid, TM.CultureCode FROM dbo.ModuleDefinitions AS MD INNER JOIN dbo.Modules AS M ON MD.ModuleDefID = M.ModuleDefID INNER JOIN dbo.ModuleControls AS MC ON MD.ModuleDefID = MC.ModuleDefID INNER JOIN dbo.DesktopModules AS DM ON MD.DesktopModuleID = DM.DesktopModuleID LEFT OUTER JOIN dbo.ContentItems AS CI ON M.ContentItemID = CI.ContentItemID LEFT OUTER JOIN dbo.TabModules AS TM ON M.ModuleID = TM.ModuleID LEFT OUTER JOIN dbo.Tabs AS T ON TM.TabID = T.TabID WHERE (MC.ControlKey IS NULL) System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.vw_Files'.
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)
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:e9856981-64cc-4757-8edc-aa9421fd5a19 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, CASE WHEN LEFT(LOWER(T .IconFile), 7) = 'fileid=' THEN (SELECT Folder + FileName FROM dbo.vw_Files WHERE fileid = CAST((RIGHT(LOWER(T.IconFile), Len(T.IconFile) - 7)) AS int) ) ELSE T.IconFile END AS IconFile, CASE WHEN LEFT(LOWER(T .IconFileLarge), 7) = 'fileid=' THEN (SELECT Folder + FileName FROM dbo.vw_Files WHERE fileid = CAST((RIGHT(LOWER(T.IconFileLarge), Len(T.IconFileLarge) - 7)) AS int) ) ELSE T.IconFileLarge END AS IconFileLarge, T.DisableLink, T.Title, T.Description, T.KeyWords, T.IsDeleted, T.SkinSrc, T.ContainerSrc, T.StartDate, T.EndDate, T.Url, CASE WHEN EXISTS (SELECT 1 FROM dbo.Tabs T2 WHERE T2.ParentId = T.TabId) THEN 'true' ELSE 'false' END AS HasChildren, 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 OUTER JOIN dbo.ContentItems AS CI ON T.ContentItemID = CI.ContentItemID System.Data.SqlClient.SqlException (0x80131904): Column, parameter, or variable #2: Cannot find data type date. Parameter or variable '@LastModificationTime' has an invalid data type.
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)
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:7d12c51b-a07e-4c60-bf25-e347f352a8a4 CREATE PROCEDURE dbo.[UpdateFileLastModificationTime] @FileId int, @LastModificationTime date AS UPDATE dbo.Files SET [LastModificationTime] = @LastModificationTime WHERE [FileId] = @FileId
Any ideas?
Thanks!