Hi all!

My upgrade from Media 04.00.00 to Media 04.01.00 errors  out as below:
--------------------------------------------------------------------------------------------------
Start jobb Starter Installering 

Info Starter Installering - DNN_Media 

Info Starter Installering - Script 

Info Start Sql-kjøringen 

Info Opprettet  

Info Utfører04.01.00.SqlDataProvider 

Info Start Sql-kjøringen: 04.01.00.SqlDataProvider filen 

Feil Sql-kjøringen årsaket følgende unntak: System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_dnn_Media_LastUpdatedBy". The conflict occurred in database "SwcWeb", table "dbo.dnn_Users", column 'UserID'. ved System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) ved System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) ved System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) ved System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) ved System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) ved System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) ved System.Data.SqlClient.SqlCommand.ExecuteNonQuery() ved DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) ved DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM [dbo].[sysobjects] WHERE [id] = OBJECT_ID(N'FK_dnn_Media_LastUpdatedBy') AND OBJECTPROPERTY([id], N'IsConstraint') = 1) ALTER TABLE dbo.[dnn_Media] ADD CONSTRAINT [FK_dnn_Media_LastUpdatedBy] FOREIGN KEY ([LastUpdatedBy]) REFERENCES dbo.[dnn_Users] ([UserId]);  

Info Avslutt Sql-kjøringen: 04.01.00.SqlDataProvider filen 

Info Fullført Sql-kjøringen 

Feil Installasjonen feilet - Script 

Info Installasjonen feilet - DNN_Media 

Info Slettet midlertidig instalasjonsmappe 

Avslutt jobb Installasjonen  
--------------------------------------------------------------------------------------------

Please help ASAP
Thank you

---

Arnt O. Kvannefoss Software Consult AS Microsoft Certified Partner www.SwcWeb.net www.pamelding.net www.softwareconsult.no

Sebastian,

Your are absolute correct, as usual. :)

Thank you!

---

Arnt O. Kvannefoss Software Consult AS Microsoft Certified Partner www.SwcWeb.net www.pamelding.net www.softwareconsult.no

I've had the same problem, and I noted a way to hot-fix the issue as well. See my comments on the Issue Tracker in the CodePlex site for this module: http://dnnmedia.codeplex.com/workitem/22139

My post(s) on the Issue Tracker include a recommended fix for the 04.01.00.SqlDataProvider script.

I've also have some thoughts on the whole idea of the Foreign Key constraint for the LastUpdatedBy column. In my view, this constraint should be dropped, and the default constraint for the LastUpdatedBy column should have a value of -1. My rationale is as follows:

Having the constraint between the tables can cause an adverse effect on the ability to delete a user who has been the last to update a media module. This "locks in" the user, causing administrative problems for the site (you can't permanently delete the user). Yet, at the same time, there is a desire to track who has last modified the module, and display meaningful information (name, etc.), and this information would be required.