Ok, thanks for this answer.
Concerning the latest Repository 3.01.14 RC4 Build 26327 (.NET 1.1/2.0/3.0) 11/16/2007, I tried to install it on 3.01.14 Install Build 13179 (.NET 1.1/2.0/3.0) 09/02/2007 (DNN 4.3.5).
For me, there are lots of problems (hopefully I had a backup of my website and I have been obliged to revert to the old version).
It's the first time I encounter problem while updating your module. Generally, everything is fine, here I have some problems.
Here is how I proceed:
1/ I downloaded the zip file
2/ Login as host on my portal
3/ Selection of "Install Additionnal modules"
4/ Browse - Selection of zip file - Install new module
5/ I have a listing of what have been done (no error, see below the resource upload logs)
6/ Then, as it is written on your website, I have executed the sql provider file manually (opened the 03.01.14.SqlDataProvider file in notepad and copy the entire contents. Go to the HOST->SQL page and paste the script into the text box. CHECK the 'Run as script' option and Execute the script.)
I had plenty of errors, see below.
Finally, when seeing my pages where I had the repository links, I have lots of problems for the way it is displayed. See below:
Error when running the SQL :
System.Data.SqlClient.SqlException: The operation failed because an index or statistics with name 'IX_grmRepositoryAttributes' already exists on table 'dbo.grmRepositoryAttributes'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* =====================================================================*/ /***** Initialization Script 03.01.14 *****/ /* =====================================================================*/ /* =====================================================================*/ if exists (select * from dbo.sysobjects where id = object_id(N'[FK_grmRepositoryAttributeValues_grmRepositoryAttributes]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE dbo.[grmRepositoryAttributeValues] DROP CONSTRAINT [FK_grmRepositoryAttributeValues_grmRepositoryAttributes] if exists (select * from dbo.sysobjects where id = object_id(N'[PK_grmRepositoryAttributes]') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE dbo.[grmRepositoryAttributes] DROP CONSTRAINT [PK_grmRepositoryAttributes] if exists (select * from dbo.sysobjects where id = object_id(N'[PK_grmRepositoryCategories]') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE dbo.[grmRepositoryCategories] DROP CONSTRAINT [PK_grmRepositoryCategories] if exists (select * from dbo.sysobjects where id = object_id(N'[PK_grmRepositoryComments]') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE dbo.[grmRepositoryComments] DROP CONSTRAINT [PK_grmRepositoryComments] if exists (select * from dbo.sysobjects where id = object_id(N'[PK_grmRepositoryObjectValues]') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE dbo.[grmRepositoryObjectValues] DROP CONSTRAINT [PK_grmRepositoryObjectValues] if exists (select * from dbo.sysobjects where id = object_id(N'[PK_grmRepositoryObjects]') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE dbo.[grmRepositoryObjects] DROP CONSTRAINT [PK_grmRepositoryObjects] if exists (select * from dbo.sysobjects where id = object_id(N'[PK_grmRepositoryAttributeValues]') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE dbo.[grmRepositoryAttributeValues] DROP CONSTRAINT [PK_grmRepositoryAttributeValues] if exists (select * from dbo.sysobjects where id = object_id(N'[IX_grmRepositoryAttributes]') and OBJECTPROPERTY(id, N'IsIndex') = 1) DROP INDEX dbo.[grmRepositoryAttributes].[IX_grmRepositoryAttributes] if exists (select * from dbo.sysobjects where id = object_id(N'[DF_grmRepositoryCategories_Parent]') and OBJECTPROPERTY(id, N'IsConstraint') = 1) ALTER TABLE dbo.[grmRepositoryCategories] DROP CONSTRAINT [DF_grmRepositoryCategories_Parent] if exists (select * from dbo.sysobjects where id = object_id(N'[IX_grmRepositoryCategories]') and OBJECTPROPERTY(id, N'IsIndex') = 1) DROP INDEX dbo.[grmRepositoryCategories].[IX_grmRepositoryCategories] if exists (select * from dbo.sysobjects where id = object_id(N'[IX_grmRepositoryComments]') and OBJECTPROPERTY(id, N'IsIndex') = 1) DROP INDEX dbo.[grmRepositoryComments].[IX_grmRepositoryComments] if exists (select * from dbo.sysobjects where id = object_id(N'[IX_grmRepositoryObjectValues]') and OBJECTPROPERTY(id, N'IsIndex') = 1) DROP INDEX dbo.[grmRepositoryObjectValues].[IX_grmRepositoryObjectValues] if exists (select * from dbo.sysobjects where id = object_id(N'[IX_grmRepositoryObjects]') and OBJECTPROPERTY(id, N'IsIndex') = 1) DROP INDEX dbo.[grmRepositoryObjects].[IX_grmRepositoryObjects] if exists (select * from dbo.sysobjects where id = object_id(N'[IX_grmRepositoryAttributeValues]') and OBJECTPROPERTY(id, N'IsIndex') = 1) DROP INDEX dbo.[grmRepositoryAttributeValues].[IX_grmRepositoryAttributeValues] /* =====================================================================*/ ALTER TABLE dbo.[grmRepositoryAttributes] ADD CONSTRAINT [PK_grmRepositoryAttributes] PRIMARY KEY CLUSTERED ([ItemID]) ALTER TABLE dbo.[grmRepositoryCategories] ADD CONSTRAINT [PK_grmRepositoryCategories] PRIMARY KEY CLUSTERED ([ItemId]) ALTER TABLE dbo.[grmRepositoryComments] ADD CONSTRAINT [PK_grmRepositoryComments] PRIMARY KEY CLUSTERED ([ItemID]) ALTER TABLE dbo.[grmRepositoryObjectValues] ADD CONSTRAINT [PK_grmRepositoryObjectValues] PRIMARY KEY CLUSTERED ([ItemID]) ALTER TABLE dbo.[grmRepositoryObjects] ADD CONSTRAINT [PK_grmRepositoryObjects] PRIMARY KEY CLUSTERED ([ItemID]) ALTER TABLE dbo.[grmRepositoryAttributeValues] ADD CONSTRAINT [PK_grmRepositoryAttributeValues] PRIMARY KEY CLUSTERED ([ItemID]) /* =====================================================================*/ CREATE INDEX [IX_grmRepositoryAttributes] ON dbo.[grmRepositoryAttributes]([ModuleID]) ALTER TABLE dbo.[grmRepositoryCategories] ADD CONSTRAINT [DF_grmRepositoryCategories_Parent] DEFAULT ((-1)) FOR [Parent] CREATE INDEX [IX_grmRepositoryCategories] ON dbo.[grmRepositoryCategories]([ModuleId]) CREATE INDEX [IX_grmRepositoryComments] ON dbo.[grmRepositoryComments]([ObjectID]) CREATE INDEX [IX_grmRepositoryObjectValues] ON dbo.[grmRepositoryObjectValues]([ObjectID]) CREATE INDEX [IX_grmRepositoryObjects] ON dbo.[grmRepositoryObjects]([ModuleID]) CREATE INDEX [IX_grmRepositoryAttributeValues] ON dbo.[grmRepositoryAttributeValues]([AttributeID]) /* =====================================================================*/ ALTER TABLE dbo.[grmRepositoryAttributeValues] ADD CONSTRAINT [FK_grmRepositoryAttributeValues_grmRepositoryAttributes] FOREIGN KEY ([AttributeID]) REFERENCES dbo.[grmRepositoryAttributes] ([ItemID]) /* =====================================================================*/ if exists (select * from dbo.sysobjects where id = object_id(N'dbo.grmGetSingleRepositoryObject') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.grmGetSingleRepositoryObject System.Data.SqlClient.SqlException: There is already an object named 'grmGetSingleRepositoryObject' in the database. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* =====================================================================*/ CREATE procedure dbo.grmGetSingleRepositoryObject @ItemID int AS SELECT a.*, ( SELECT COUNT(dbo.grmRepositoryComments.ItemID) FROM dbo.grmRepositoryComments WHERE dbo.grmRepositoryComments.ObjectID=a.ItemID ) AS CommentCount FROM dbo.grmRepositoryObjects a where a.ItemID = @ItemID
And concerning the Resource Upload Logs
StartJob Starting Installation
StartJob Reading files
Info Loading 03.00.00.SqlDataProvider
Info File 03.00.00.SqlDataProvider read successfully
Info Loading 03.00.01.SqlDataProvider
Info File 03.00.01.SqlDataProvider read successfully
Info Loading 03.00.02.SqlDataProvider
Info File 03.00.02.SqlDataProvider read successfully
Info Loading 03.00.03.SqlDataProvider
Info File 03.00.03.SqlDataProvider read successfully
Info Loading 03.00.04.SqlDataProvider
Info File 03.00.04.SqlDataProvider read successfully
Info Loading 03.00.05.SqlDataProvider
Info File 03.00.05.SqlDataProvider read successfully
Info Loading 03.00.06.SqlDataProvider
Info File 03.00.06.SqlDataProvider read successfully
Info Loading 03.00.07.SqlDataProvider
Info File 03.00.07.SqlDataProvider read successfully
Info Loading 03.00.08.SqlDataProvider
Info File 03.00.08.SqlDataProvider read successfully
Info Loading 03.00.09.SqlDataProvider
Info File 03.00.09.SqlDataProvider read successfully
Info Loading 03.00.10.SqlDataProvider
Info File 03.00.10.SqlDataProvider read successfully
Info Loading 03.00.11.SqlDataProvider
Info File 03.00.11.SqlDataProvider read successfully
Info Loading 03.00.12.SqlDataProvider
Info File 03.00.12.SqlDataProvider read successfully
Info Loading 03.00.13.SqlDataProvider
Info File 03.00.13.SqlDataProvider read successfully
Info Loading 03.00.14.SqlDataProvider
Info File 03.00.14.SqlDataProvider read successfully
Info Loading 03.00.15.SqlDataProvider
Info File 03.00.15.SqlDataProvider read successfully
Info Loading 03.00.16.SqlDataProvider
Info File 03.00.16.SqlDataProvider read successfully
Info Loading 03.01.00.SqlDataProvider
Info File 03.01.00.SqlDataProvider read successfully
Info Loading 03.01.01.SqlDataProvider
Info File 03.01.01.SqlDataProvider read successfully
Info Loading 03.01.02.SqlDataProvider
Info File 03.01.02.SqlDataProvider read successfully
Info Loading 03.01.03.SqlDataProvider
Info File 03.01.03.SqlDataProvider read successfully
Info Loading 03.01.04.SqlDataProvider
Info File 03.01.04.SqlDataProvider read successfully
Info Loading 03.01.05.SqlDataProvider
Info File 03.01.05.SqlDataProvider read successfully
Info Loading 03.01.06.SqlDataProvider
Info File 03.01.06.SqlDataProvider read successfully
Info Loading 03.01.07.SqlDataProvider
Info File 03.01.07.SqlDataProvider read successfully
Info Loading 03.01.08.SqlDataProvider
Info File 03.01.08.SqlDataProvider read successfully
Info Loading 03.01.09.SqlDataProvider
Info File 03.01.09.SqlDataProvider read successfully
Info Loading 03.01.10.SqlDataProvider
Info File 03.01.10.SqlDataProvider read successfully
Info Loading 03.01.11.SqlDataProvider
Info File 03.01.11.SqlDataProvider read successfully
Info Loading 03.01.12.SqlDataProvider
Info File 03.01.12.SqlDataProvider read successfully
Info Loading 03.01.12.txt
Info File 03.01.12.txt read successfully
Info Loading 03.01.13.SqlDataProvider
Info File 03.01.13.SqlDataProvider read successfully
Info Loading 03.01.13.txt
Info File 03.01.13.txt read successfully
Info Loading 03.01.14.SqlDataProvider
Info File 03.01.14.SqlDataProvider read successfully
Info Loading 03.01.14.txt
Info File 03.01.14.txt read successfully
Info Loading About.ascx
Info File About.ascx read successfully
Info Loading BulkUpload.ascx
Info File BulkUpload.ascx read successfully
Info Loading DashboardSettings.ascx
Info File DashboardSettings.ascx read successfully
Info Loading DashboardSettings.ascx.resx
Info File DashboardSettings.ascx.resx read successfully
Info Loading DotNetNuke.Modules.Repository.dll
Info File DotNetNuke.Modules.Repository.dll read successfully
Info Loading DotNetNuke.Modules.Repository.SqlDataProvider.dll
Info File DotNetNuke.Modules.Repository.SqlDataProvider.dll read successfully
Info Loading EditComment.ascx
Info File EditComment.ascx read successfully
Info Loading Form.ascx
Info File Form.ascx read successfully
Info Loading gooddogslogo.gif
Info File gooddogslogo.gif read successfully
Info Loading icon_repository_32px.gif
Info File icon_repository_32px.gif read successfully
Info Loading MakeThumbnail.aspx
Info File MakeThumbnail.aspx read successfully
Info Loading ModerateUploads.ascx
Info File ModerateUploads.ascx read successfully
Info Loading Repository.ascx
Info File Repository.ascx read successfully
Info Loading Repository.dnn
Info File Repository.dnn read successfully
Info Loading RepositoryDashboard.ascx
Info File RepositoryDashboard.ascx read successfully
Info Loading RepositoryDashboard.ascx.resx
Info File RepositoryDashboard.ascx.resx read successfully
Info Loading Resources.zip
Info File Resources.zip read successfully
Info Loading Settings.ascx
Info File Settings.ascx 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 xml loaded.
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'Repository' module
Info Loading files info
Info Found valid path (App_LocalResources) for RepositoryDashboard.ascx.resx.
Info Found valid path (App_LocalResources) for DashboardSettings.ascx.resx.
Info Loading Modules info
Info Loading Control info for 'Repository Dashboard' module
EndJob Dnn load finished successfully
StartJob Begin Sql execution
Info Executing 03.01.14.SqlDataProvider
StartJob Start Sql execution: 03.01.14.SqlDataProvider file
EndJob End Sql execution: 03.01.14.SqlDataProvider file
EndJob Finished Sql execution
StartJob Creating files
StartJob Expanding Resource file
EndJob Resource Files created
Info Created d:\hosting\bin\DotNetNuke.Modules.Repository.dll
Info Created d:\hosting\bin\DotNetNuke.Modules.Repository.SqlDataProvider.dll
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.00.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.01.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.02.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.03.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.04.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.05.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.06.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.07.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.08.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.09.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.10.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.11.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.12.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.13.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.14.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.15.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.00.16.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.01.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.02.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.03.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.04.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.05.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.06.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.07.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.08.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.09.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.10.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.11.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.12.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.13.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Providers\DataProviders\SqlDataProvider\03.01.14.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\Uninstall.SqlDataProvider
Info Created d:\hosting\DesktopModules\Repository\About.ascx
Info Created d:\hosting\DesktopModules\Repository\EditComment.ascx
Info Created d:\hosting\DesktopModules\Repository\MakeThumbnail.aspx
Info Created d:\hosting\DesktopModules\Repository\ModerateUploads.ascx
Info Created d:\hosting\DesktopModules\Repository\Form.ascx
Info Created d:\hosting\DesktopModules\Repository\Repository.ascx
Info Created d:\hosting\DesktopModules\Repository\Settings.ascx
Info Created d:\hosting\DesktopModules\Repository\icon_repository_32px.gif
Info Created d:\hosting\DesktopModules\Repository\03.01.14.txt
Info Created d:\hosting\DesktopModules\Repository\Repository.dnn.config
EndJob Files created
StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished
StartJob Begin Sql execution
EndJob Finished Sql execution
StartJob Creating files
Info Created d:\hosting\DesktopModules\Dashboard\DashboardSettings.ascx
Info Created d:\hosting\DesktopModules\Dashboard\RepositoryDashboard.ascx
Info Created d:\hosting\DesktopModules\Dashboard\icon_repository_32px.gif
Info Created d:\hosting\DesktopModules\Dashboard\App_LocalResources\RepositoryDashboard.ascx.resx
Info Created d:\hosting\DesktopModules\Dashboard\App_LocalResources\DashboardSettings.ascx.resx
Info Created d:\hosting\DesktopModules\Dashboard\Repository.dnn.config
EndJob Files created
StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished
EndJob Installation successful.