|
Joined: 5/29/2007
Posts: 48
|
|
|
Failure to install Media 4.0.0
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: 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(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) 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: 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(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) 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: 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(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) 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: 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(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) 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 |
|
|
|
|
|