1
Vote

Invalid object name 'Users'

description

I keep getting the following error [ 'Wishlist' is what I called the Roadmap module] .....
 
 
ModuleId: 416
ModuleDefId: 110
FriendlyName: Wish List
ModuleControlSource: DesktopModules/Roadmap/View.ascx
AssemblyVersion: 5.2.2
PortalID: 0
PortalName: MyCourts
UserID: 2
UserName: admin
ActiveTabID: 72
ActiveTabName: Wish List
RawURL: /Features/WishList.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.mycourts.com.au/Features/WishList/tabid/72/ctl/Module/ModuleId/416/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.8) Gecko/20100202 Firefox/3.5.8
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 262824d6-4aa4-4361-adb1-0ac4c87b7cf5
InnerException: Invalid object name 'Users'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'Users'. ---> System.Data.SqlClient.SqlException: Invalid object name 'Users'. 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.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.NextResult() at DotNetNuke.Modules.Roadmap.EnhancementController.GetEnhancements(Int32 ModuleId, Boolean IsAdmin, Int32 PageSize, Int32 PageIndex, Int32 Filter, Int32& TotalRecords) at DotNetNuke.Modules.Roadmap.View.BindData() at DotNetNuke.Modules.Roadmap.View.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

comments

glenharvy wrote Feb 24, 2010 at 9:02 AM

OK - so I thought I would remove the extension and start again. On trying the install wizard I now get the following error: Package Installation Report See below for the results of the package installation Error loading files from temporary folder - see below StartJob Starting Installation Info Starting Installation - DotNetNuke Roadmap Info Starting Installation - Script Info Begin Sql execution Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider Info Created - Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider Info Executing 01.00.00.SqlDataProvider Info Start Sql execution: 01.00.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'dnn_Enhancements' 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 TABLE dbo.dnn_Enhancements ( [EnhancementID] [int] IDENTITY (1, 1) NOT NULL , [ModuleID] [int] NOT NULL , [Title] [nvarchar] (100) NOT NULL , [URL] [nvarchar] (250) NOT NULL , [Description] [nvarchar] (2000) NULL , [Problem] [ntext] NULL , [Rationale] [ntext] NULL , [Solution] [ntext] NULL , [Impact] [ntext] NULL , [Risk] [ntext] NULL , [Authorized] bit NOT NULL, [UserID] [int] NOT NULL , [CreatedDate] [datetime] NOT NULL, [Votes] [int] NOT NULL, [Comments] [int] NOT NULL ) ON [PRIMARY] System.Data.SqlClient.SqlException: Table 'dnn_Enhancements' 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.dnn_Enhancements ADD CONSTRAINT PK_dnn_Enhancements PRIMARY KEY CLUSTERED ( EnhancementID ) ON [PRIMARY] System.Data.SqlClient.SqlException: There is already an object named 'FK_dnn_Enhancements_dnn_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.dnn_Enhancements ADD CONSTRAINT FK_dnn_Enhancements_dnn_Modules FOREIGN KEY ( ModuleID ) REFERENCES dbo.dnn_Modules ( ModuleID ) ON DELETE CASCADE NOT FOR REPLICATION System.Data.SqlClient.SqlException: There is already an object named 'dnn_GetEnhancements' 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.dnn_GetEnhancements @ModuleID int, @IsAdmin bit, @PageSize int, @PageIndex int as DECLARE @PageLowerBound int DECLARE @PageUpperBound int -- Set the page bounds SET @PageLowerBound = @PageSize * @PageIndex SET @PageUpperBound = @PageLowerBound + @PageSize + 1 CREATE TABLE #PageIndex ( IndexID int IDENTITY (1, 1) NOT NULL, EnhancementID int ) INSERT INTO #PageIndex (EnhancementID) SELECT EnhancementID from dnn_Enhancements where ModuleID = @ModuleID and (Authorized = 1 or @IsAdmin = 1) order by Votes desc, CreatedDate asc SELECT COUNT(*) as TotalRecords FROM #PageIndex SELECT * FROM dnn_Enhancements INNER JOIN #PageIndex PageIndex ON dnn_Enhancements.EnhancementID = PageIndex.EnhancementID INNER JOIN dnn_Users ON dnn_Enhancements.UserID = dnn_Users.UserID WHERE ( (PageIndex.IndexID > @PageLowerBound) OR @PageLowerBound is null ) AND ( (PageIndex.IndexID < @PageUpperBound) OR @PageUpperBound is null ) ORDER BY PageIndex.IndexID System.Data.SqlClient.SqlException: There is already an object named 'dnn_GetEnhancementsByUser' 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.dnn_GetEnhancementsByUser @ModuleID int, @UserID int as select * from dnn_Enhancements where ModuleID = @ModuleID and UserID = @UserID System.Data.SqlClient.SqlException: There is already an object named 'dnn_GetEnhancement' 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.dnn_GetEnhancement @EnhancementID int, @ModuleID int as select * from dnn_Enhancements inner join dnn_Users on dnn_Enhancements.UserID = dnn_Users.UserID where EnhancementID = @EnhancementID and ModuleID = @ModuleID System.Data.SqlClient.SqlException: There is already an object named 'dnn_DeleteEnhancement' 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.dnn_DeleteEnhancement @EnhancementID int, @ModuleID int as delete from dnn_Enhancements where EnhancementID = @EnhancementID and ModuleID = @ModuleID System.Data.SqlClient.SqlException: There is already an object named 'dnn_AddEnhancement' 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.dnn_AddEnhancement @ModuleID int, @Title nvarchar(100), @URL nvarchar(250), @Description nvarchar(2000), @Problem ntext, @Rationale ntext, @Solution ntext, @Impact ntext, @Risk ntext, @Authorized bit, @UserID int as insert into dnn_Enhancements ( ModuleID, Title, URL, Description, Problem, Rationale, Solution, Impact, Risk, Authorized, UserID, CreatedDate, Votes, Comments ) values ( @ModuleID, @Title, @URL, @Description, @Problem, @Rationale, @Solution, @Impact, @Risk, @Authorized, @UserID, getdate(), 0, 0 ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException: There is already an object named 'dnn_UpdateEnhancement' 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.dnn_UpdateEnhancement @EnhancementID int, @ModuleID int, @Title nvarchar(100), @URL nvarchar(250), @Description nvarchar(2000), @Problem ntext, @Rationale ntext, @Solution ntext, @Impact ntext, @Risk ntext, @Authorized bit as update dnn_Enhancements set Title = @Title, URL = @URL, Description = @Description, Problem = @Problem, Rationale = @Rationale, Solution = @Solution, Impact = @Impact, Risk = @Risk, Authorized = @Authorized where EnhancementID = @EnhancementID and ModuleID = @ModuleID System.Data.SqlClient.SqlException: There is already an object named 'dnn_EnhancementVotes' 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 TABLE dbo.dnn_EnhancementVotes ( [EnhancementVoteID] [int] IDENTITY (1, 1) NOT NULL , [EnhancementID] [int] NOT NULL , [UserID] [int] NOT NULL , [CreatedDate] [datetime] NOT NULL ) ON [PRIMARY] System.Data.SqlClient.SqlException: Table 'dnn_EnhancementVotes' 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.dnn_EnhancementVotes ADD CONSTRAINT PK_dnn_EnhancementVotes PRIMARY KEY CLUSTERED ( EnhancementVoteID ) ON [PRIMARY] System.Data.SqlClient.SqlException: There is already an object named 'FK_dnn_EnhancementVotes_dnn_Enhancements' 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.dnn_EnhancementVotes ADD CONSTRAINT FK_dnn_EnhancementVotes_dnn_Enhancements FOREIGN KEY ( EnhancementID ) REFERENCES dbo.dnn_Enhancements ( EnhancementID ) ON DELETE CASCADE NOT FOR REPLICATION System.Data.SqlClient.SqlException: There is already an object named 'dnn_GetEnhancementVote' 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.dnn_GetEnhancementVote @EnhancementID int, @UserID int as select * from dnn_EnhancementVotes where EnhancementID = @EnhancementID and UserID = @UserID System.Data.SqlClient.SqlException: There is already an object named 'dnn_AddEnhancementVote' 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.dnn_AddEnhancementVote @EnhancementID int, @UserID int as insert into dnn_EnhancementVotes ( EnhancementID, UserID, CreatedDate ) values ( @EnhancementID, @UserID, getdate() ) update dnn_Enhancements set Votes = (select count(*) from dnn_EnhancementVotes where EnhancementID = @EnhancementID ) where EnhancementID = @EnhancementID System.Data.SqlClient.SqlException: There is already an object named 'dnn_EnhancementComments' 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 TABLE dbo.dnn_EnhancementComments ( [EnhancementCommentID] [int] IDENTITY (1, 1) NOT NULL , [EnhancementID] [int] NOT NULL , [Comment] [ntext] NOT NULL , [UserID] [int] NOT NULL , [CreatedDate] [datetime] NOT NULL ) ON [PRIMARY] System.Data.SqlClient.SqlException: Table 'dnn_EnhancementComments' 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.dnn_EnhancementComments ADD CONSTRAINT PK_dnn_EnhancementComments PRIMARY KEY CLUSTERED ( EnhancementCommentID ) ON [PRIMARY] System.Data.SqlClient.SqlException: There is already an object named 'FK_dnn_EnhancementComments_dnn_Enhancements' 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.dnn_EnhancementComments ADD CONSTRAINT FK_dnn_EnhancementComments_dnn_Enhancements FOREIGN KEY ( EnhancementID ) REFERENCES dbo.dnn_Enhancements ( EnhancementID ) ON DELETE CASCADE NOT FOR REPLICATION System.Data.SqlClient.SqlException: There is already an object named 'dnn_GetEnhancementComments' 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.dnn_GetEnhancementComments @EnhancementID int as select * from dnn_EnhancementComments inner join dnn_Users on dnn_EnhancementComments.UserID = dnn_Users.UserID where EnhancementID = @EnhancementID order by CreatedDate desc System.Data.SqlClient.SqlException: There is already an object named 'dnn_GetEnhancementComment' 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.dnn_GetEnhancementComment @EnhancementCommentID int, @EnhancementID int as select * from dnn_EnhancementComments inner join dnn_Users on dnn_EnhancementComments.UserID = dnn_Users.UserID where EnhancementCommentID = @EnhancementCommentID and EnhancementID = @EnhancementID System.Data.SqlClient.SqlException: There is already an object named 'dnn_DeleteEnhancementComment' 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.dnn_DeleteEnhancementComment @EnhancementCommentID int, @EnhancementID int as delete from dnn_EnhancementComments where EnhancementCommentID = @EnhancementCommentID update dnn_Enhancements set Comments = (select count(*) from dnn_EnhancementComments where EnhancementID = @EnhancementID ) where EnhancementID = @EnhancementID System.Data.SqlClient.SqlException: There is already an object named 'dnn_AddEnhancementComment' 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.dnn_AddEnhancementComment @EnhancementID int, @Comment ntext, @UserID int as insert into dnn_EnhancementComments ( EnhancementID, Comment, UserID, CreatedDate ) values ( @EnhancementID, @Comment, @UserID, getdate() ) update dnn_Enhancements set Comments = (select count(*) from dnn_EnhancementComments where EnhancementID = @EnhancementID ) where EnhancementID = @EnhancementID System.Data.SqlClient.SqlException: There is already an object named 'dnn_UpdateEnhancementComment' 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.dnn_UpdateEnhancementComment @EnhancementCommentID int, @EnhancementID int, @Comment ntext as update dnn_EnhancementComments set Comment = @Comment where EnhancementCommentID = @EnhancementCommentID and EnhancementID = @EnhancementID Info End Sql execution: 01.00.00.SqlDataProvider file Info Finished Sql execution Failure Installation Failed - Script Info Installation Failed - DotNetNuke Roadmap Info Deleted temporary install folder EndJob Installation Failed

glenharvy wrote Feb 24, 2010 at 9:03 AM

So how do I get this module installed and working?

Thanks.....

glenharvy wrote Feb 24, 2010 at 12:59 PM

OK - I'm making progress.

My DNN database has all tables prepended with 'dnn_' so I think that's why Roadmap can't locate the 'Users' table because it's 'dnn_Users'.

I've just downloaded the code but I'm a C# person and I have no idea on how to create, let alone edit a module.

I would like to get this fixed asap so I am hoping a fix can be released early please.

Thanks.

glenharvy wrote Feb 26, 2010 at 12:06 AM

SQLDataProvider
  • 01.00.03SqlDataprovider
    -- Line 334
    --- Should read: INNER JOIN {databaseOwner}{objectQualifier}Users u
It has taken me days to get this far.

Now I need to discover how to amend the sp.

wrote Feb 12, 2013 at 8:29 PM