Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsMediaMediaModule Installation FailureModule Installation Failure
Previous
 
Next
New Post
12/1/2006 1:10 PM
 

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.

 
New Post
12/15/2006 2:46 PM
 

The Solution was:

Upgrade to dotnetnuke 3.3.7

Uninstalled Image Module, Uninstalled Media Module.

Installed media 3.2.3 (installation went perfect) and module now works.

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsMediaMediaModule Installation FailureModule Installation Failure


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out