Bad start with beta testing: Install gave an error:
00:02:03.610 - Upgrading to Version: 05.06.00
00:02:03.640 - Executing Script: 05.06.00.SqlDataProvider Error! (see 05.06.00.log.resources for more information)
00:02:05.579 - Executing Application Upgrades: 05.06.00 Success
05.06.00.log.resources has this to say:
System.Data.SqlClient.SqlException: The constraint 'PK_Roles' is being referenced by table 'Forum_PrivateForums',
foreign key constraint 'FK_Forum_PrivateForums_Roles'.
Could not drop 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)
/* DNN-13278 - Clustered Primary Key for Roles */
/*************************************************/
if not exists (select * from dbo.sysobjects where id = object_id(N'PK_Roles') and OBJECTPROPERTY(id, N'CnstIsClustKey') = 1)
begin
alter table dbo.[UserRoles]
drop constraint FK_UserRoles_Roles
alter table dbo.[Roles]
drop constraint PK_Roles
alter table dbo.[Roles]
add constraint PK_Roles
primary key clustered ( RoleID ) on [PRIMARY]
alter table dbo.[UserRoles]
add constraint FK_UserRoles_Roles
foreign key ( RoleID ) references dbo.[Roles] ( RoleID )
on update no action
on delete cascade
end
The installation completed nevertheless. I will have a peek preview anyway.