I've performed a number of upgrades to 455 with pleasurable success. Now for the most risky - on the DNN install that is the most complex and most to lose. But I followed all the correct steps - I think.
When I navigated to /install/install.aspx?mode=upgrade I got first the install/Underconstruction. I tried again and twice I got a download dialog box for install/install.aspx! Then all I saw was a blank page.
Not quite panic but certainly dread. Prepared to roll back but not looking forward to trying.
Then on an off chance, I just went to the default portal home page. Loaded fine. Cached somewhere, I was sure ... to prove it, I tried to log in, knowing that I'd get issues immediately. To my surprise, I logged in. "What portal could this be?" I thought, certain that no upgrade had taken place, and that the old one ... didn't really exist anymore.
I logged in ... there was the new 455 control panel (I was coming from 4.3.6).
Now I'm really puzzled. I look around. It looks a whole lot like a successful upgrade. I am skeptical.
I look at all the sql upgrade logs starting at 04.03.07, and they are all empty save this one for 04.05.02. It's long. I'm wondering, looking at it, if it might have something to do with the fact that I banged against the upgrade url a couple times when it was in process (but I didn't know ... didn't get my usual report. I'm not used to blank pages during an upgrade.).
Can someone tell me if I should be worrying, if I have some work to do, or if all is probably ok:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'ModuleControls'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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)
insert into dbo.ModuleControls ( ModuleDefID, ControlKey, ControlTitle, ControlSrc, IconFile, ControlType, ViewOrder, HelpUrl, SupportsPartialRendering )
values ( NULL, 'Adsense', 'Google Adsense', 'Admin/Vendors/Adsense.ascx', NULL, 2, NULL, NULL, 0 )
System.Data.SqlClient.SqlException: There is already an index on table 'ModulePermission' named 'IX_ModulePermission'.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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 unique constraint */
ALTER TABLE dbo.ModulePermission ADD CONSTRAINT
IX_ModulePermission UNIQUE NONCLUSTERED
(
ModuleID,
PermissionID,
RoleID,
UserID
) ON [PRIMARY]
System.Data.SqlClient.SqlException: There is already an index on table 'TabPermission' named 'IX_TabPermission'.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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 unique constraint */
ALTER TABLE dbo.TabPermission ADD CONSTRAINT
IX_TabPermission UNIQUE NONCLUSTERED
(
TabID,
PermissionID,
RoleID,
UserID
) ON [PRIMARY]
System.Data.SqlClient.SqlException: There is already an index on table 'FolderPermission' named 'IX_FolderPermission'.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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 unique constraint */
ALTER TABLE dbo.FolderPermission ADD CONSTRAINT
IX_FolderPermission UNIQUE NONCLUSTERED
(
FolderID,
PermissionID,
RoleID,
UserID
) ON [PRIMARY]
System.Data.SqlClient.SqlException: There is already an index on table 'Permission' named 'IX_Permission'.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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 unique constraint */
ALTER TABLE dbo.Permission ADD CONSTRAINT
IX_Permission UNIQUE NONCLUSTERED
(
PermissionCode,
ModuleDefID,
PermissionKey
) ON [PRIMARY]
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'DesktopModules'.
Cannot insert the value NULL into column 'DesktopModuleID', table 'chautauquaportal_dnn.dbo.ModuleDefinitions'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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)
declare @DesktopModuleID int
insert into dbo.DesktopModules (
FriendlyName,
Description,
Version,
IsPremium,
IsAdmin,
FolderName,
ModuleName
)
values (
'Google Adsense',
'Allows you to serve Google Adsense ads in your site',
'01.00.00',
0,
0,
'Adsense',
'Adsense'
)
SET @DesktopModuleID = @@IDENTITY
DECLARE @ModuleDefID int
insert into dbo.ModuleDefinitions (
FriendlyName,
DesktopModuleId,
DefaultCacheTime
)
values (
'Adsense',
@DesktopModuleID,
1200
)
SET @ModuleDefID = @@IDENTITY
insert into dbo.ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
null,
null,
@ModuleDefID ,
'Admin/Vendors/Adsense.ascx',
null,
0,
null
)
insert into dbo.ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
'Edit',
'Edit Adsense',
@ModuleDefID ,
'Admin/Vendors/EditAdsense.ascx',
null,
1,
null
)
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'ModuleControls'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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)
insert into dbo.ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
'Adsense',
'Google Adsense',
null,
'Admin/Vendors/EditAdsense.ascx',
null,
2,
null
)
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'DesktopModules'.
Cannot insert the value NULL into column 'DesktopModuleID', table 'chautauquaportal_dnn.dbo.ModuleDefinitions'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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)
declare @DesktopModuleID int
insert into dbo.DesktopModules (
FriendlyName,
Description,
Version,
IsPremium,
IsAdmin,
FolderName,
ModuleName
)
values (
'Feed Explorer',
'Allows users to browse RSS feeds using a tabbed user interface',
'01.00.00',
0,
0,
'FeedExplorer',
'FeedExplorer'
)
SET @DesktopModuleID = @@IDENTITY
DECLARE @ModuleDefID int
insert into dbo.ModuleDefinitions (
FriendlyName,
DesktopModuleId,
DefaultCacheTime
)
values (
'Feed Explorer',
@DesktopModuleID,
-1
)
SET @ModuleDefID = @@IDENTITY
insert into dbo.ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
null,
null,
@ModuleDefID ,
'Admin/Syndication/FeedExplorer.ascx',
null,
0,
null
)
insert into dbo.ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
'Settings',
'Feed Explorer Settings',
@ModuleDefID ,
'Admin/Syndication/FeedExplorerSettings.ascx',
null,
1,
null
)
a