Guys, I have exactly the same problem. I have upgraded from DNN version 5.6.2 but this has previously been upgraded a number of times from an original install version of 5.0.1. the current media module version I have installed is 3.3.0. this is what I get when I try to upload version 4.0.0.

View Source Package Installer Package Installation Report See below for the results of the package installation Error loading files from temporary folder - see below StartJob Starting Installation Info Starting Installation - DNN_Media Info Starting Installation - Script Info Begin Sql execution Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\04.00.00.SqlDataProvider Info Created - Providers\DataProviders\SqlDataProvider\04.00.00.SqlDataProvider Info Executing 04.00.00.SqlDataProvider Info Start Sql execution: 04.00.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'MediaType'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.[Media] ALTER COLUMN [Src] NVARCHAR(1000) NOT NULL; /* UPDATE TABLE TO REFLECT THE NEW DEFAULT VALUES */ UPDATE dbo.[Media] SET [NewWindow] = 0, [TrackClicks] = 0, [MediaType] = 0; System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'MediaType'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.[AddMedia] @ModuleID INT, @Src NVARCHAR(250), @Alt NVARCHAR(100), @Width INT, @Height INT, @NavigateUrl NVARCHAR(250), @MediaAlignment INT, @AutoStart BIT, @MediaLoop BIT, @NewWindow BIT, @TrackClicks BIT, @MediaType INT AS BEGIN SET NOCOUNT ON; INSERT INTO dbo.[Media] ([ModuleID],[Src],[Alt],[Width],[Height],[NavigateUrl],[MediaAlignment],[AutoStart],[MediaLoop],[NewWindow],[TrackClicks],[MediaType]) VALUES (@ModuleId, @Src, @Alt, @Width, @Height, @NavigateUrl, @MediaAlignment, @AutoStart, @MediaLoop, @NewWindow, @TrackClicks, @MediaType); END System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'MediaType'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.[UpdateMedia] @ModuleID INT, @Src NVARCHAR(250), @Alt NVARCHAR(100), @Width INT, @Height INT, @NavigateUrl NVARCHAR(250), @MediaAlignment INT, @AutoStart BIT, @MediaLoop BIT, @NewWindow BIT, @TrackClicks BIT, @MediaType INT AS BEGIN SET NOCOUNT ON UPDATE dbo.[Media] SET [Src] = @Src, [Alt] = @Alt, [Width] = @Width, [Height] = @Height, [NavigateUrl] = @NavigateUrl, [MediaAlignment] = @MediaAlignment, [AutoStart] = @AutoStart, [MediaLoop] = @MediaLoop, [NewWindow] = @NewWindow, [TrackClicks] = @TrackClicks, [MediaType] = @MediaType WHERE [ModuleID] = @ModuleID; END System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'MediaType'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.[GetMedia] @ModuleID INT AS BEGIN SET NOCOUNT ON SELECT m.[ModuleID],m.[Alt],m.[Width],m.[Height], 'Src' = CASE WHEN srcf.[FileName] IS NULL THEN m.[Src] ELSE srcf.[Folder] + srcf.[FileName] END, 'NavigateUrl' = CASE WHEN navf.[FileName] IS NULL THEN m.[NavigateUrl] ELSE navf.[Folder] + navf.[FileName] END, ut.[NewWindow],ut.[TrackClicks],m.[MediaAlignment],m.[AutoStart],m.[MediaLoop],m.[NewWindow],m.[TrackClicks], m.[MediaType] FROM dbo.[Media] AS m LEFT OUTER JOIN dbo.[Files] AS srcf ON m.Src = 'fileid=' + CONVERT(VARCHAR, srcf.FileID) LEFT OUTER JOIN dbo.[Files] AS navf ON m.NavigateUrl = 'fileid=' + CONVERT(VARCHAR, navf.FileID) LEFT OUTER JOIN dbo.[UrlTracking] ut ON m.[NavigateUrl] = ut.[Url] and ut.[ModuleId] = @ModuleID WHERE m.[ModuleId] = @ModuleId; END Info End Sql execution: 04.00.00.SqlDataProvider file Info Finished Sql execution Failure Installation Failed - Script Info Installation Failed - DNN_Media Info Deleted temporary install folder EndJob Installation Failed

I am currently unable to duplicate this upgrade error on any of my demo sites.  I know where the error would occur, but the condition is not apparent in my demo sites.

This line of SQL should execute:

IF NOT EXISTS (SELECT 1 FROM [dbo].[syscolumns] c JOIN [dbo].[sysobjects] o ON c.[id] = o.[id] WHERE c.[name] = N'MediaType' AND o.[name] LIKE N'%{objectQualifier}Media')
    ALTER TABLE {databaseOwner}[{objectQualifier}Media] 
    ADD [MediaType] INT NOT NULL CONSTRAINT [DF_{objectQualifier}Media_MediaType] DEFAULT ((0));
GO

Resulting in this line of SQL not throwing an error like it is with your sites:

UPDATE {databaseOwner}[{objectQualifier}Media] 
SET [NewWindow] = 0, [TrackClicks] = 0, [MediaType] = 0;
GO

Though, for some reason, that is exactly what's happening.  Are there any other issues or conditions that are unique to your sites that you can think that I might not be reproducing?

---

Will Strohl

Upendo Ventures DNN experts since 2003 Official provider of the Hotcakes Commerce Cloud and SLA support

Sorry, some module install caused my site to crash yesterday, just recovered, trying to get more details from my service provider. Anyway, on the media module, I had just upgraded to DNN 05.06.03, and the media module, which I'm trying to upgrade now, is version 3.3.0.