i did s test server upgrade and it work fine..now i upgraded another server and got this:
System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'FolderMappingID' in table 'dbo.Folders' is specified more than once. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* Add FolderMappingID column to Folders table and fill it with right values */ /*****************************************************************************/ ALTER TABLE dbo.[Folders] ADD [FolderMappingID] int NULL System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'GetEventLog' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[GetEventLog] @PortalID int, @LogTypeKey nvarchar(35), @PageSize int, @PageIndex int AS begin -- Set the page bounds DECLARE @PageLowerBound INT , @PageUpperBound INT , @RowsToReturn int , @TotalRecords int exec dbo.CalculatePagingInformation @PageIndex, @PageSize, @RowsToReturn output, @PageLowerBound output, @PageUpperBound output begin with [eLog] as ( select row_number() over (order by E.LogCreateDate desc) as rowid, e.* from dbo.EventLog e where (e.LogPortalID = @PortalID or @PortalID IS NULL) AND (e.LogTypeKey Like @LogTypeKey or @LogTypeKey IS NULL) ) select * from [eLog] where rowid > @PageLowerBound and rowid < @PageUpperBound order by rowid end select count(*) AS TotalRecords from dbo.EventLog e where (e.LogPortalID = @PortalID or @PortalID IS NULL) AND (e.LogTypeKey Like @LogTypeKey or @LogTypeKey IS NULL) END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'GetAllFiles' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[GetAllFiles] AS BEGIN SELECT F.FileId, FO.PortalId, F.[FileName], F.Extension, F.Size, F.Width, F.Height, F.ContentType, F.FolderID, 'Folder' = FolderPath, FO.StorageLocation, FO.IsCached, F.UniqueId, F.VersionGuid, F.SHA1Hash, FO.FolderMappingID FROM dbo.[Files] F INNER JOIN dbo.[Folders] FO on F.FolderID = FO.FolderID END System.Data.SqlClient.SqlException (0x80131904): Table 'PortalLocalization' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[PortalLocalization] ADD CONSTRAINT [PK_PortalLocalization] PRIMARY KEY CLUSTERED ([PortalID], [CultureCode]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'vw_PortalsDefaultLanguage' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE VIEW dbo.[vw_PortalsDefaultLanguage] AS SELECT DISTINCT P.PortalID, PL.PortalName as PortalName, PL.LogoFile, PL.FooterText as 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 as Description, PL.KeyWords as KeyWords, PL.BackgroundFile, P.GUID, P.PaymentProcessor, P.ProcessorUserId, P.ProcessorPassword, P.SiteLogHistory, U.Email, P.DefaultLanguage, P.TimezoneOffset, PL.AdminTabId as AdminTabId, P.HomeDirectory, PL.SplashTabId as SplashTabId, PL.HomeTabId as HomeTabId, PL.LoginTabId as LoginTabId, PL.RegisterTabId as RegisterTabId, PL.UserTabId as UserTabId, PL.SearchTabId as 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.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.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): Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'dbo.ModuleControls'. The duplicate key value is (94, Download, DesktopModules/Admin/Extensions/Download.ascx). The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* Add new Download host ModuleControl */ /***************************************/ IF (SELECT COUNT(*) FROM dbo.ModuleControls WHERE ModuleDefID IS NULL AND ControlKey = 'Download') = 0 BEGIN DECLARE @ModuleDefID int SET @ModuleDefID = (SELECT ModuleDefID FROM dbo.ModuleDefinitions WHERE FriendlyName = 'Extensions') INSERT INTO dbo.ModuleControls ( ModuleDefID, ControlKey, ControlTitle, ControlSrc, ControlType ) VALUES ( @ModuleDefID, 'Download', 'Downloader', 'DesktopModules/Admin/Extensions/Download.ascx', 3) END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'vw_TabModules' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE VIEW dbo.vw_TabModules AS SELECT M.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.Files WHERE 'fileid=' + CONVERT(varchar, dbo.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, MD.DesktopModuleID, MD.DefaultCacheTime, MC.ModuleControlID, DM.BusinessControllerClass, DM.IsAdmin, DM.SupportedFeatures, CI.ContentItemID, CI.Content, CI.ContentTypeID, CI.ContentKey, CI.Indexed, 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 WHERE (MC.ControlKey IS NULL) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'vw_Modules' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE VIEW dbo.vw_Modules AS SELECT M.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.Files WHERE 'fileid=' + CONVERT(varchar, dbo.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, MD.DesktopModuleID, MD.DefaultCacheTime, MC.ModuleControlID, DM.BusinessControllerClass, DM.IsAdmin, DM.SupportedFeatures, CI.ContentItemID, CI.Content, CI.ContentTypeID, CI.ContentKey, CI.Indexed, 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 WHERE (MC.ControlKey IS NULL) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'GetContentItems' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[GetContentItems] @ContentTypeId int, @TabId int, @ModuleId int AS SELECT * FROM dbo.ContentItems WHERE (ContentTypeId = @ContentTypeId OR @ContentTypeId IS NULL) AND (TabId = @TabId OR @TabId IS NULL) AND (ModuleId = @ModuleId OR @ModuleId IS NULL)
|