I am running the 5.1.0 community beta and all was well with 4.9. I am using a Windows Server 2008 R2 operating system with SQL Server 2008 Enterprise. Once I upgraded to 5.1 i get this error in the update log:
System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_DNN_DesktopModules_DNN_Packages". The conflict occurred in database "Website", table "dbo.DNN_Packages", column 'PackageID'.
at System.Data.SqlClient.SqlConnection.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 Foreign Key to PAckages/DesktopModules */
/**********************************************/
ALTER TABLE dbo.DNN_DesktopModules
ADD CONSTRAINT FK_DNN_DesktopModules_DNN_Packages FOREIGN KEY ( PackageID ) REFERENCES dbo.DNN_Packages ( PackageID ) ON UPDATE CASCADE ON DELETE CASCADE
Now all my sites are blank with the containers there and i can not log in any more? At a little bit of a loss here:(
I am using Server 2008 R2 for the enhanced support for PHP. I will note that the Active directory authentication is much smoother on server 2k8 R2, and the over all performance is better. But now i have to reload the whole thing.
Please tell me someone has seen this on 5.1 and knows where the upgrade went wrong?
Thank you,
Dino D