Hello Steve,
The old dev build are not on your website anymore ![](/Providers/HtmlEditorProviders/Fck/FCKeditor/editor/images/smiley/msn/sad_smile.gif)
Is it possible to let them few days so I can download them and make tests ???
Otherwise, I have found a possibility to reproduce the problem which seems to be common to DNN 4.5.5 installation and upgrade (at least).
I have a friend who installed a new fresh 4.5.5 and installed the repository (Install Build 26327) and he has exactly the same error messages than me.
==> This is general to all DNN 4.5x version
We have both upgraded this local clean DNN 4.5.5 install (without anything else than the standard DNN install + Repository) to latest 4.7.0 version and the problem persists (see below errors). We will try now on a clean DNN 4.7.0 install.
The problem of display is also present, see below:
![](http://img150.imageshack.us/img150/1264/testlatestsm2.gif)
But as soon as you edit the module and "update it" (even without any modification), the display problem disappear. This is also true on my DNN 4.5.5 live.
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
I will test on a new 4.7.0 version to see...
DV FX