I removed Ealo modules and tried again the upgrade, and now the upgrade started and gives the following errors:
26% 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, 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:edf72b7d-8cd7-473a-9cd3-7e703cd8e357
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, 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:dbc0bb2e-0a6b-4be2-a0ca-63975fb1591cUPDATE 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, 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:6e09aef8-12b9-4279-bfac-a878eb263f80ALTER 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, 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:80b46892-9bdb-4e33-8449-352aa9ebf7f4
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, 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:1d345f84-4a78-406e-8a97-174506751b55
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, 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:e61179bb-5fb6-4518-9792-99d328a3fbab
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, 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:154eba84-7f27-4f60-85f7-653b82621403
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 intASBEGIN 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 @FileIDEND
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, 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:5c88b9d2-7747-46d9-84d0-53ad8dfe83ed
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 intAS 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, 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:a048344c-3783-4a9d-84be-5b85f907b379
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, 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:bc1f936e-23d5-4f45-acc8-13598a84122f
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, 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:f17b9b7d-d627-4d8c-b6c5-9479cf653b89
CREATE VIEW dbo.vw_TabModulesAS 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, 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:d4edf83b-5b27-49e0-b769-f620c997a5f5
CREATE VIEW dbo.vw_ModulesAS 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, 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:04405562-e822-4727-9a6a-fef0347f9706CREATE 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, 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:f10cb728-3b03-41f4-86bb-7afd3975d284
CREATE PROCEDURE dbo.[UpdateFileLastModificationTime]@FileId int,
@LastModificationTime dateAS UPDATE dbo.Files
SET [LastModificationTime] = @LastModificationTime WHERE [FileId] = @FileId
|