I have set up two Media modules on one page, each using a Flash swf file.   They work great.

I put a link to a URL on each, and neither works, so I tried to change to a page on the site.  Won't change, won't delete.

I am using 4.0 DNN and wound up with all sorts of SQL errors during install of 03.02.02.  But, other then this problem, the module seems to work fine.

I have the error text below:

Thank you.

David

StartJob Start Sql execution: 03.02.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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 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 
EndJob End Sql execution: 03.02.00.SqlDataProvider file