Hi There,
I hope someone there can answer me this... I'm installing the new release Feedback module beta 5. I encountered this error while trying to install it... Please check below:
SQL Execution resulted in following Exceptions:
System.Data.SqlClient.SqlException: 'PK_DNN_Feedback' is not a constraint. Could
not drop constraint. See previous errors. 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) ALTER TABLE dbo.Feedback DROP CONSTRAINT PK_DNN_Feedback
System.Data.SqlClient.SqlException: Table 'Feedback' already has a primary key
defined on it. Could not create constraint. See previous errors. 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) ALTER TABLE dbo.Feedback ADD CONSTRAINT PK_DNN_Feedback PRIMARY
KEY CLUSTERED ( FeedbackID ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY
= OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
System.Data.SqlClient.SqlException: There is already an object named
'FK_Feedback_Modules' in the database. Could not create constraint. See previous
errors. 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) ALTER TABLE dbo.Feedback WITH NOCHECK ADD CONSTRAINT
FK_Feedback_Modules FOREIGN KEY ( ModuleID ) REFERENCES dbo.Modules ( ModuleID )
ON UPDATE NO ACTION ON DELETE CASCADE NOT FOR REPLICATION
System.Data.SqlClient.SqlException: Cannot find the object "dbo.DNN_Feedback"
because it does not exist or you do not have permissions. 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) ALTER TABLE dbo.DNN_Feedback SET (LOCK_ESCALATION = TABLE)
System.Data.SqlClient.SqlException: Error: The new name 'SenderName' is already
in use as a COLUMN name and would cause a duplicate that is not permitted. 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) /* Modify the Feedback Table to rename the field CreatedByName
and CreatedByEmail to SenderName and SenderEmail */ if
col_length('dbo.[Feedback]','CreatedByName') is not NULL BEGIN EXEC sp_rename
'dbo.[Feedback].CreatedByName', 'SenderName', 'COLUMN' END
Need some answers here. Thank you...
Cheers,
Truewarpit
|