Hello,
I have a 3.2.2 dotnetnuke install (upgraded from 2.1.2)
I recently tried to install The Media Mudule and got the following errors:
Please Advise.
StartJob Starting Installation
StartJob Reading files
Info Loading EditMedia.ascx
Info File EditMedia.ascx read successfully
Info Loading MediaModule.ascx
Info File MediaModule.ascx read successfully
Info Loading EditMedia.ascx.resx
Info File EditMedia.ascx.resx read successfully
Info Loading MediaModule.ascx.resx
Info File MediaModule.ascx.resx read successfully
Info Loading DotNetNuke.Modules.Media.SqlDataProvider.dll
Info File DotNetNuke.Modules.Media.SqlDataProvider.dll read successfully
Info Loading DotNetNuke.Modules.Media.dll
Info File DotNetNuke.Modules.Media.dll read successfully
Info Loading DNN_Media.dnn
Info File DNN_Media.dnn read successfully
Info Loading 03.02.00.SqlDataProvider
Info File 03.02.00.SqlDataProvider read successfully
Info Loading Uninstall.SqlDataProvider
Info File Uninstall.SqlDataProvider read successfully
EndJob Reading files done.
StartJob Reading DNN file
Info DNN file is in valid 3.0 format.
Info ...
Info Loading files info
Info Found valid path (App_LocalResources) for MediaModule.ascx.resx.
Info Found valid path (App_LocalResources) for EditMedia.ascx.resx.
Info Loading Modules info
Info Loading Control info for 'Media' module
EndJob Dnn load finished successfully
StartJob Begin Sql execution
Info Executing 03.02.00.SqlDataProvider
StartJob Start Sql execution: 03.02.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'src'. Invalid column name 'src'. Invalid column name 'alt'. Invalid column name 'Width'. Invalid column name 'height'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /** Create Table and process Media Information**/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[Media]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE dbo.[Media] ( [ModuleID] [int] NOT NULL, [Src] nvarchar(250) NOT NULL, [alt] nvarchar(100) NULL, [width] [int] NULL, [height] [int] NULL, [NavigateUrl] NVARCHAR(250) ) ALTER TABLE dbo.[Media] ADD CONSTRAINT [PK_Media] PRIMARY KEY NONCLUSTERED ([ModuleID]) ALTER TABLE dbo.[Media] WITH NOCHECK ADD CONSTRAINT [FK_Media_Modules] FOREIGN KEY ([ModuleID]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION /** Move existing data from the Module Settings table to the new Table **/ DECLARE @Setting varchar(50) DECLARE @Value varchar(2000) DECLARE @ModuleID int DECLARE @tempID int DECLARE cur CURSOR FOR SELECT dbo.ModuleSettings.ModuleID, dbo.ModuleSettings.SettingName, dbo.ModuleSettings.SettingValue FROM dbo.ModuleSettings INNER JOIN dbo.Modules ON dbo.ModuleSettings.ModuleID = dbo.Modules.ModuleID INNER JOIN dbo.ModuleDefinitions ON dbo.Modules.ModuleDefID = dbo.ModuleDefinitions.ModuleDefID INNER JOIN dbo.DesktopModules ON dbo.ModuleDefinitions.DesktopModuleID = dbo.DesktopModules.DesktopModuleID WHERE dbo.DesktopModules.ModuleName = N'DNN_Image' ORDER BY dbo.ModuleSettings.ModuleID SET @TempID = 0 OPEN cur FETCH NEXT FROM cur INTO @ModuleID, @Setting, @Value WHILE @@fetch_Status = 0 BEGIN IF @tempID <> @ModuleID BEGIN INSERT into dbo.Media (ModuleID,src) VALUES (@ModuleID,'') SET @tempID = @ModuleID END IF @Setting = 'src' UPDATE Media SET src = @Value WHERE ModuleID = @ModuleID IF @Setting = 'alt' UPDATE Media SET alt = CASE WHEN @Value ='' THEN NULL ELSE @value END WHERE ModuleID = @ModuleID IF @Setting = 'width' UPDATE Media SET Width = CASE WHEN @Value ='' THEN NULL ELSE @value END WHERE ModuleID = @ModuleID IF @Setting = 'height' UPDATE Media SET height = CASE WHEN @Value ='' THEN NULL ELSE @value END WHERE ModuleID = @ModuleID FETCH NEXT FROM cur INTO @ModuleID, @Setting, @Value END CLOSE cur DEALLOCATE cur /** delete Records from Settings **/ DELETE dbo.ModuleSettings FROM dbo.ModuleSettings INNER JOIN dbo.Modules ON dbo.ModuleSettings.ModuleID = dbo.Modules.ModuleID INNER JOIN dbo.ModuleDefinitions ON dbo.Modules.ModuleDefID = dbo.ModuleDefinitions.ModuleDefID INNER JOIN dbo.DesktopModules ON dbo.ModuleDefinitions.DesktopModuleID = dbo.DesktopModules.DesktopModuleID WHERE dbo.DesktopModules.ModuleName = N'DNN_Image' END System.Data.SqlClient.SqlException: Invalid column name 'Src'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Stored Procedures **/ CREATE PROCEDURE dbo.AddMedia @ModuleID INT, @Src NVARCHAR(250), @Alt NVARCHAR(100), @Width INT, @Height INT, @NavigateUrl NVARCHAR(250) AS INSERT INTO Media (ModuleID, Src, Alt, Width, Height, NavigateUrl) VALUES (@ModuleId, @Src, @Alt, @Width, @Height, @NavigateUrl) System.Data.SqlClient.SqlException: Invalid column name 'Src'. Invalid column name 'NavigateUrl'. Invalid column name 'NavigateUrl'. Invalid column name 'Src'. Invalid column name 'Alt'. Invalid column name 'Width'. Invalid column name 'Height'. Invalid column name 'NavigateUrl'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.GetMedia @ModuleId INT AS SELECT m.ModuleID, 'Src' = CASE WHEN srcf.FileName IS NULL THEN m.Src ELSE srcf.Folder + srcf.FileName END, m.Alt, m.Width, m.Height, 'NavigateUrl' = CASE WHEN navf.FileName IS NULL THEN m.NavigateUrl ELSE navf.Folder + navf.FileName END, UrlTracking.NewWindow, UrlTracking.TrackClicks FROM Media AS m LEFT OUTER JOIN Files AS srcf ON m.Src = 'fileid=' + CONVERT(VARCHAR, srcf.FileID) LEFT OUTER JOIN Files AS navf ON m.NavigateUrl = 'fileid=' + CONVERT(VARCHAR, navf.FileID) LEFT OUTER JOIN UrlTracking ON m.NavigateUrl = UrlTracking.Url and UrlTracking.ModuleId = @ModuleID WHERE m.ModuleId = @ModuleId System.Data.SqlClient.SqlException: Invalid column name 'Src'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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) AS UPDATE Media SET Src = @Src, Alt = @Alt, Width = @Width, Height = @Height, NavigateUrl = @NavigateUrl WHERE ModuleID = @ModuleID
EndJob End Sql execution: 03.02.00.SqlDataProvider file
EndJob Finished Sql execution
StartJob Creating files
Info Created E:\Inetpub\wwwroot\BentAngle\bin\DotNetNuke.Modules.Media.dll
Info Created E:\Inetpub\wwwroot\BentAngle\DesktopModules\Media\EditMedia.ascx
Info Created E:\Inetpub\wwwroot\BentAngle\DesktopModules\Media\MediaModule.ascx
Info Created E:\Inetpub\wwwroot\BentAngle\DesktopModules\Media\App_LocalResources\MediaModule.ascx.resx
Info Created E:\Inetpub\wwwroot\BentAngle\DesktopModules\Media\App_LocalResources\EditMedia.ascx.resx
Info Created E:\Inetpub\wwwroot\BentAngle\bin\DotNetNuke.Modules.Media.SqlDataProvider.dll
Info Created E:\Inetpub\wwwroot\BentAngle\DesktopModules\Media\Uninstall.SqlDataProvider
Info Created E:\Inetpub\wwwroot\BentAngle\DesktopModules\Media\Providers\DataProviders\SqlDataProvider\03.02.00.SqlDataProvider
Info Created E:\Inetpub\wwwroot\BentAngle\DesktopModules\Media\DNN_Media.dnn
EndJob Files created
StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished
Info
EndJob Installation successful.