Installation in 05.05.00 (653) failed

Nov 26, 2010 at 8:41 PM

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Could not drop object 'dbo.Findy_XsltDb_Configs' because it is referenced by a FOREIGN KEY constraint. at System.Data.SqlClient.SqlConnection.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) if OBJECT_ID('dbo.[Findy_XsltDb_Configs]') is not null drop table dbo.[Findy_XsltDb_Configs]; System.Data.SqlClient.SqlException: There is already an object named 'Findy_XsltDb_Configs' in the database. at System.Data.SqlClient.SqlConnection.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 table dbo.[Findy_XsltDb_Configs] ( ConfigID uniqueidentifier primary key default newid(), IsSuper bit default 0, XSLT nvarchar(max) ); System.Data.SqlClient.SqlException: There is already an object named 'Findy_XsltDb_GetModulesWithSameConfig' in the database. at System.Data.SqlClient.SqlConnection.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.[Findy_XsltDb_GetModulesWithSameConfig] @ModuleID int as begin select c.ModuleID from dbo.[Findy_XsltDb_Modules] m join dbo.[Findy_XsltDb_Modules] c on c.ConfigID = m.ConfigID where m.ModuleID = @ModuleID end;

Developer
Nov 29, 2010 at 11:24 AM

ingekr,

are you trying to upgrade a previous installation? I upgraded XsltDb several times, but never got this error...

If you're trying a clean install, you'd better cleanup db tables (delete findy_xsltdb_* objects) and try a new install.

 

Nov 29, 2010 at 11:26 AM
No, first time installation.

I just installed dnn 5.6.0 and I will try there. So, we will see.

2010/11/29 trapias <notifications@codeplex.com>

From: trapias

ingekr,

.are you trying to upgrade a previous installation? I upgraded XsltDb several times, but never got this error...

If you're trying a clean install, you'd better cleanup db tables (delete findy_xsltdb_* objects) and try a new install.

Read the full discussion online.

To add a post to this discussion, reply to this email (xsltdb@discussions.codeplex.com@discussions.codeplex.com)

To start a new discussion for this project, email xsltdb@discussions.codeplex.com@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com




--
//Inge
Nov 30, 2010 at 8:55 PM

It installed perfectly on 5.6.0, so I am very happy.

I need to list some image files from a DNN gallery and create a link for my users

to use the image.

Any samples around?

Regds

Inge

Developer
Dec 1, 2010 at 9:09 AM

ingekr,

I developed a Slideshow module on XsltDb which you might find useful, take a look at http://albe.ihnet.it/Software/XsltDb/XSLideShow.

Documentation is not up-to-date, if you need help leave a comment on my site / here / on Twitter.

Regards,

al.