DotNetNuke ® Portal and Module Development - www.schelian.com

 Search



Forum

 Forum update Minimize
      

Today: 09/12/2005 we have setup our new dedicated English forum.

From today on, please use this forum instead of the English forums on DNNPortal.DE.

I will lock the English forums on DNNPortal.DE.


 Forum Minimize
Forum Home  Search       
SearchForum Home
     
  DNNPortal-Download  Using the DNNPortal-Download  Installing DNNP...
 Installing DNNPortal_Download
 
imgOfflineCarlito
1 posts
www.guinney.com
Joined
9/28/2005
Installing DNNPortal_Download
Posted: 28 Sep 05 3:11 PM (N/A) Modified By Carlito on 9/28/2005 11:13:33 PM)
When installing the DNNPortal-Download. Everything seems to load fine until it begins SQL execution and then failures appear. Does anyone know why this is happening?

Thanks (see below)

Begin Sql execution
Executing 01.00.00.SqlDataProvider
Start Sql execution: 01.00.00.SqlDataProvider file
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Could not drop object 'dbo.HPS_DNNPortal_Downloads' because it is referenced by a FOREIGN KEY constraint. 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) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.HPS_DNNPortal_Downloads') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table dbo.HPS_DNNPortal_Downloads System.Data.SqlClient.SqlException: There is already an object named 'HPS_DNNPortal_Downloads' in the database. 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 TABLE dbo.HPS_DNNPortal_Downloads ( [ItemID] [int] IDENTITY (1, 1) NOT NULL , [ModuleID] [int] NULL , [CreatedByUser] [nvarchar] (150) , [CreatedDate] [datetime] NULL , [UpdatedByUser] [nvarchar] (150) , [UpdatedDate] [datetime] NULL , [Name] [nvarchar] (50) , [Description] [ntext] , [Author] [nvarchar] (150) , [AuthorEmail] [nvarchar] (150) , [FileSize] [nvarchar] (12) , [Downloads] [int] NULL , [PreviewImage] [nvarchar] (150) , [Image] [nvarchar] (150) , [FileName] [nvarchar] (150) , [Clicks] [int] NULL , [RatingVotes] [bigint] NULL , [RatingTotal] [bigint] NULL , [RatingAverage] [float] NULL , [Approved] [int] NULL , [ShowEMail] [int] NULL , [DownloadRoles] [nvarchar] (150) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] System.Data.SqlClient.SqlException: Table 'HPS_DNNPortal_Downloads' already has a primary key defined on it. Could not create constraint. See previous errors. 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) ALTER TABLE dbo.HPS_DNNPortal_Downloads WITH NOCHECK ADD CONSTRAINT [PK_HPS_DNNPortal_DownloadObjects] PRIMARY KEY CLUSTERED ( [ItemID] ) ON [PRIMARY] System.Data.SqlClient.SqlException: There is already an object named 'FK_HPS_DNNPortal_Downloads_Modules' in the database. Could not create constraint. See previous errors. 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) ALTER TABLE dbo.HPS_DNNPortal_Downloads ADD CONSTRAINT [FK_HPS_DNNPortal_Downloads_Modules] FOREIGN KEY ( [ModuleID] ) REFERENCES dbo.Modules ( [ModuleID] ), CONSTRAINT [FK_HPS_DNNPortal_DownloadsObjects_Modules] FOREIGN KEY ( [ModuleID] ) REFERENCES dbo.Modules ( [ModuleID] ) ON DELETE CASCADE NOT FOR REPLICATION System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) -- Insert a new List DownloadMimeType INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'text/plain', 'txt', 1) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'text/html', 'htm', 2) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'text/html', 'html', 3) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'text/richtext', 'rtf', 4) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'image/jpeg', 'jpg', 5) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'image/jpeg', 'jpeg', 6) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'image/gif', 'gif', 7) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'image/bmp', 'bmp', 8) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'video/mpeg', 'mpg', 9) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'video/mpeg', 'mpeg', 10) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'video/avi', 'avi', 11) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'application/pdf', 'pdf', 12) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'application/msword', 'doc', 13) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'application/msword', 'dot', 14) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'application/x-msexcel', 'csv', 15) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'application/x-msexcel', 'xls', 16) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadMimeType', 'application/x-msexcel', 'xlt', 17)
End Sql execution: 01.00.00.SqlDataProvider file

Executing 01.00.02.SqlDataProvider
Start Sql execution: 01.00.02.SqlDataProvider file
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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 *****/ /***** DNNPortal.Download.SqlDataProvider *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ -- Insert a new List DownloadValidImageTypes INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadValidImageTypes', 'gif', '1', 1) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadValidImageTypes', 'jpg', '2', 1) System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Lists'. Cannot insert duplicate key in object 'Lists'. The statement has been terminated. 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) INSERT INTO dbo.Lists ([ListName], [Value], [Text], [SortOrder]) VALUES ('DownloadValidImageTypes', 'png', '3', 1)
End Sql execution: 01.00.02.SqlDataProvider file

Executing 01.00.03.SqlDataProvider
Start Sql execution: 01.00.03.SqlDataProvider file
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'ExpireDate' in table 'dbo.HPS_DNNPortal_Downloads' is specified more than once. 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) ALTER TABLE dbo.HPS_DNNPortal_Downloads ADD ExpireDate DateTime NULL System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'PublishDate' in table 'dbo.HPS_DNNPortal_Downloads' is specified more than once. 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) ALTER TABLE dbo.HPS_DNNPortal_Downloads ADD PublishDate DateTime NULL
End Sql execution: 01.00.03.SqlDataProvider file

Executing 01.00.06.SqlDataProvider
Start Sql execution: 01.00.06.SqlDataProvider file
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'LogDownloads' in table 'dbo.HPS_DNNPortal_Downloads' is specified more than once. 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) ALTER TABLE dbo.HPS_DNNPortal_Downloads ADD LogDownloads int NULL
End Sql execution: 01.00.06.SqlDataProvider file

Executing 01.00.07.SqlDataProvider
Start Sql execution: 01.00.07.SqlDataProvider file
End Sql execution: 01.00.07.SqlDataProvider file

Finished Sql execution

Creating files
Expanding Resource file
ExceptionSystem.Security.SecurityException: Request for the permission of type System.Security.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed. at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet grantedSet, PermissionSet deniedSet, CodeAccessPermission demand, PermissionToken permToken) at System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames, Int32 unrestrictedOverride) at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, StackCrawlMark& stackMark) at System.Security.CodeAccessPermission.Demand() at System.IO.Directory.GetCurrentDirectory() at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateResourceFile(PaFile ResourceFile, String RootFolder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateModuleFile(PaFile File, PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()





imgOfflineSchelianHP
118 posts
5th
Joined
12/3/2004




Re: Installing DNNPortal_Download
Posted: 30 Sep 05 6:25 AM (Germany)
What DNN version do you have installed ?
Best regards
Hans-Peter Schelian
www.schelian.com (English)
www.schelian.de (Deutsch)
German DotNetNuke Community
 Page 1 of 1
NextPreviousNo Rating
  DNNPortal-Download  Using the DNNPortal-Download  Installing DNNP...


Page generated in 0.34375 seconds.