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 ForumsRepositoryRepositoryRepository 3.01.14 Release Candidate posted for testingRepository 3.01.14 Release Candidate posted for testing
Previous
 
Next
New Post
11/20/2007 2:54 PM
 

Steve Fabian wrote

no, I really am not sure why you are getting errors, I tested upgrades on a number of 3.01.13 sites and upgrades on previous dev builds. The sql script is written so that it could be run over and over without throwing exceptions.  Have you made any modifications to the database regarding the repository module? added any indexes? changed any tables. The error thrown refers to an index. maybe you can delete that index manually first, then try to rerun the sql script in the Host->SQL page?

As far as the page layout is concerned, I also am not sure why you are seeing that. The changes I've made should not affect the physical display in any way. the code changes are logic changes behind the scenes. Are you using a custom template? do you have the same layout issues with the default templates?

Ok, thanks for answering. Here is what I plan to do, because I need to upgrade (for enhance features like download from dashboard) :

- Creating a copy of my live DNN to local (to be able to do faster migration and tests)
- Trying to upgrade from the next dev build, one after the other one, to see where is the problem

To answer your question:
1/ no modification done to the database (I do not have so much knowledge except select * from xxxx)
2/ How could I delete the index, what is the command, and which one should I delete without affecting the repository tables ??
3/ For the layout, that is very change (similar to problems I had in the past with compression). Yes, it is a customise template, I will check later on with default template, good idea.

DV

 
New Post
11/21/2007 3:21 AM
 

Hello Steve,

The old dev build are not on your website anymore
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:


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

 
New Post
11/21/2007 5:41 AM
 

On a 4.7.0, if I run the sql it also creates the same errors (I know that it is not necessary if no previous dev build have been applied, but I tested it by curiosity).

Consequently, results of my tests, as explained above:
- with DNN 4.5.5 and latest dev build + sql query ==> ERRORS
- with DNN 4.5.5 upgraded to latest 4.7.0 and latest dev build + sql query ==> ERRORS
- with fresh DNN 4.5.5 and latest dev build ==> OK (without running the sql query)
- with fresh DNN 4.7.0 and latest dev build ==> OK (without running the sql query)

Remains the problem of all people who like me installed a dev build and are now stuck with these errors... Could I revert to an old version ???

DV

 
New Post
11/25/2007 4:38 AM
 

Steve, do you experiment the same behavior ??
The questions are maybe the following:

- are you sure that this SQL script runs well twice ?
- is it necessary to run it with a version 13179 (one of your dev build) ?

DV

 
New Post
11/28/2007 3:08 PM
 

Friendly bump...
Have you tried to install a DNN 4.5.5 and installing it ???
Should we run the SQL script ??

DV FX

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsRepositoryRepositoryRepository 3.01.14 Release Candidate posted for testingRepository 3.01.14 Release Candidate posted for testing


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