 |
|
|
Joined: 3/26/2006
Posts: 22
|
|
|
On a fresh 4.5.1 portal I get the folloing error during module installation (its a long one!!)
Its weird - its looking for an object with the name of the db user...
| StartJob |
Start Sql execution: 01.00.01.sqldataprovider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_SettingsAdd') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_SettingsAdd System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_SettingsUpdate') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_SettingsUpdate System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_SettingsDelete') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_SettingsDelete System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_SettingsGet') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_SettingsGet System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_SettingsGetByModuleID') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_SettingsGetByModuleID System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicAdd') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicAdd System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicUpdate') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicUpdate System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicDelete') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicDelete System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicGet') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicGet System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicGetAll') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicGetAll System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicGetAllByModuleID') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicGetAllByModuleID System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicGetByNameForModule') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicGetByNameForModule System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicGetAllByModuleChangedWhen') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicGetAllByModuleChangedWhen System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicSearchWiki') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicSearchWiki System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicHistoryAdd') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicHistoryAdd System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicHistoryUpdate') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicHistoryUpdate System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicHistoryDelete') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicHistoryDelete System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicHistoryGet') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicHistoryGet System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicHistoryGetHistoryForTopic') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE cosnet_DNNPortalUser.Wiki_TopicHistoryGetHistoryForTopic System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) -- Creating tables if not exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_Settings') and OBJECTPROPERTY(id, N'IsTable') = 1) CREATE TABLE cosnet_DNNPortalUser.Wiki_Settings ( [SettingID] int IDENTITY (1, 1) NOT NULL, [ModuleID] int NOT NULL, [ContentEditorRoles] nvarchar(255) NOT NULL ) ON [PRIMARY] System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if not exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'PK_Wiki_Settings') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE cosnet_DNNPortalUser.Wiki_Settings ADD CONSTRAINT PK_Wiki_Settings PRIMARY KEY CLUSTERED (SettingID) ON [PRIMARY] System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if not exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_Topic') and OBJECTPROPERTY(id, N'IsTable') = 1) CREATE TABLE cosnet_DNNPortalUser.Wiki_Topic ( [TopicID] int IDENTITY (1, 1) NOT NULL, [ModuleID] int NOT NULL, [Content] ntext NULL, [Name] nvarchar(50) NULL, [UpdateDate] datetime NOT NULL, [UpdatedBy] nvarchar(101) NOT NULL ) ON [PRIMARY] System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if not exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'PK_Wiki_Topic') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE cosnet_DNNPortalUser.Wiki_Topic ADD CONSTRAINT PK_Wiki_Topic PRIMARY KEY CLUSTERED (TopicID) ON [PRIMARY] System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if not exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'cosnet_DNNPortalUser.Wiki_TopicHistory') and OBJECTPROPERTY(id, N'IsTable') = 1) CREATE TABLE cosnet_DNNPortalUser.Wiki_TopicHistory ( [TopicHistoryID] int IDENTITY (1, 1) NOT NULL, [TopicID] int NOT NULL, [Content] ntext NULL, [Name] nvarchar(50) NULL, [UpdateDate] datetime NOT NULL, [UpdatedBy] nvarchar(101) NOT NULL ) ON [PRIMARY] System.Data.SqlClient.SqlException: Invalid object name 'cosnet_DNNPortalUser.sysobjects'. 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) if not exists (select * from cosnet_DNNPortalUser.sysobjects where id = object_id(N'PK_Wiki_TopicHistory') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE cosnet_DNNPortalUser.Wiki_TopicHistory ADD CONSTRAINT PK_Wiki_TopicHistory PRIMARY KEY CLUSTERED (TopicHistoryID) ON [PRIMARY] System.Data.SqlClient.SqlException: There is already an object named 'Wiki_SettingsAdd' 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) -- Creating table relations -- Creating stored procedures CREATE PROCEDURE cosnet_DNNPortalUser.Wiki_SettingsAdd @moduleID int, @contentEditorRoles nvarchar(255) AS SET NOCOUNT ON INSERT INTO cosnet_DNNPortalUser.Wiki_Settings (ModuleID, ContentEditorRoles) VALUES (@ModuleID, @ContentEditorRoles) SELECT SCOPE_IDENTITY() System.Data.SqlClient.SqlException: There is already an object named 'Wiki_SettingsUpdate' 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 cosnet_DNNPortalUser.Wiki_SettingsUpdate @settingID int, @moduleID int, @contentEditorRoles nvarchar(255) AS SET NOCOUNT ON UPDATE cosnet_DNNPortalUser.Wiki_Settings SET ModuleID = @moduleID, ContentEditorRoles = @contentEditorRoles WHERE SettingID = @settingID System.Data.SqlClient.SqlException: There is already an object named 'Wiki_SettingsDelete' 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 cosnet_DNNPortalUser.Wiki_SettingsDelete @settingID int AS SET NOCOUNT ON DELETE FROM cosnet_DNNPortalUser.Wiki_Settings WHERE SettingID = @settingID System.Data.SqlClient.SqlException: There is already an object named 'Wiki_SettingsGet' 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 cosnet_DNNPortalUser.Wiki_SettingsGet @settingID int AS SET NOCOUNT ON SELECT SettingID, ModuleID, ContentEditorRoles FROM cosnet_DNNPortalUser.Wiki_Settings WHERE SettingID = @settingID System.Data.SqlClient.SqlException: There is already an object named 'Wiki_SettingsGetByModuleID' 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 cosnet_DNNPortalUser.Wiki_SettingsGetByModuleID @ModuleID int AS SET NOCOUNT ON SELECT SettingID, ModuleID, ContentEditorRoles FROM cosnet_DNNPortalUser.Wiki_Settings WHERE ModuleID = @ModuleID System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicAdd' 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 cosnet_DNNPortalUser.Wiki_TopicAdd @moduleID int, @content ntext, @name nvarchar(50), @updateDate datetime, @updatedBy nvarchar(101) AS SET NOCOUNT ON INSERT INTO cosnet_DNNPortalUser.Wiki_Topic (ModuleID, Content, [Name], [UpdateDate], UpdatedBy) VALUES (@ModuleID, @Content, @Name, @UpdateDate, @UpdatedBy) SELECT SCOPE_IDENTITY() System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicUpdate' 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 cosnet_DNNPortalUser.Wiki_TopicUpdate @moduleID int, @topicID int, @content ntext, @name nvarchar(50), @updateDate datetime, @updatedBy nvarchar(101) AS SET NOCOUNT ON UPDATE cosnet_DNNPortalUser.Wiki_Topic SET ModuleID = @moduleID, Content = @content, [Name] = @name, UpdateDate = @updateDate, UpdatedBy = @updatedBy WHERE TopicID = @topicID System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicDelete' 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 cosnet_DNNPortalUser.Wiki_TopicDelete @topicID int AS SET NOCOUNT ON DELETE FROM cosnet_DNNPortalUser.Wiki_Topic WHERE TopicID = @topicID System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicGet' 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 cosnet_DNNPortalUser.Wiki_TopicGet @topicID int AS SET NOCOUNT ON SELECT * FROM cosnet_DNNPortalUser.Wiki_Topic WHERE TopicID = @topicID ORDER BY Name System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicGetAll' 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 cosnet_DNNPortalUser.Wiki_TopicGetAll AS SET NOCOUNT ON SELECT * FROM cosnet_DNNPortalUser.Wiki_Topic ORDER BY Name System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicGetAllByModuleID' 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 cosnet_DNNPortalUser.Wiki_TopicGetAllByModuleID @ModuleID int AS SET NOCOUNT ON SELECT * FROM cosnet_DNNPortalUser.Wiki_Topic Where cosnet_DNNPortalUser.Wiki_topic.ModuleID = @ModuleID ORDER BY Name System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicGetByNameForModule' 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 cosnet_DNNPortalUser.Wiki_TopicGetByNameForModule @ModuleID int, @name nvarchar(200) AS SET NOCOUNT ON SELECT * FROM cosnet_DNNPortalUser.Wiki_Topic WHERE cosnet_DNNPortalUser.Wiki_topic.ModuleID = @ModuleID and cosnet_DNNPortalUser.Wiki_topic.name = @name System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicSearchWiki' 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 cosnet_DNNPortalUser.Wiki_TopicSearchWiki @Search ntext, @ModuleID int AS SET NOCOUNT ON SELECT * FROM cosnet_DNNPortalUser.Wiki_Topic WHERE ( name like @Search or content like @Search ) AND ModuleID = @ModuleID Order By Name System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicHistoryAdd' 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 cosnet_DNNPortalUser.Wiki_TopicHistoryAdd @topicID int, @content ntext, @name nvarchar(50), @updateDate datetime, @updatedBy nvarchar(101) AS SET NOCOUNT ON INSERT INTO cosnet_DNNPortalUser.Wiki_TopicHistory (TopicID, Content, Name, UpdateDate, UpdatedBy) VALUES (@TopicID, @Content, @Name, @UpdateDate, @UpdatedBy) SELECT SCOPE_IDENTITY() System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicHistoryUpdate' 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 cosnet_DNNPortalUser.Wiki_TopicHistoryUpdate @topicHistoryID int, @topicID int, @content ntext, @name nvarchar(50), @updateDate datetime, @updatedBy nvarchar(101) AS SET NOCOUNT ON UPDATE cosnet_DNNPortalUser.Wiki_TopicHistory SET TopicID = @topicID, Content = @content, Name = @name, UpdateDate = @updateDate, UpdatedBy = @updatedBy WHERE TopicHistoryID = @topicHistoryID System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicHistoryDelete' 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 cosnet_DNNPortalUser.Wiki_TopicHistoryDelete @topicHistoryID int AS SET NOCOUNT ON DELETE FROM cosnet_DNNPortalUser.Wiki_TopicHistory WHERE TopicHistoryID = @topicHistoryID System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicHistoryGet' 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 cosnet_DNNPortalUser.Wiki_TopicHistoryGet @topicHistoryID int AS SET NOCOUNT ON SELECT * FROM cosnet_DNNPortalUser.Wiki_TopicHistory WHERE TopicHistoryID = @topicHistoryID System.Data.SqlClient.SqlException: There is already an object named 'Wiki_TopicHistoryGetHistoryForTopic' 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 cosnet_DNNPortalUser.Wiki_TopicHistoryGetHistoryForTopic @topicID int AS SET NOCOUNT ON SELECT * FROM cosnet_DNNPortalUser.Wiki_TopicHistory WHERE cosnet_DNNPortalUser.Wiki_topichistory.topicID = @topicID ORDER BY UpdateDate |
| EndJob |
End Sql execution: 01.00.01.sqldataprovider file |
|
| |
|
|
 | |
|
|
|
Thanks for the post Matt. As a temporary fix here's what I'd suggest.
Open the sqldataprovider files in the ZIP file for the Wiki module and replace the
{databaseOwner}sysobjects
with
dbo.sysobjects
I'll have that corrected in the next release of the module, but you can do that for now with your scripts to be able to install the module.
|
| |
|
|
| |
|
|
Joined: 3/26/2006
Posts: 22
|
|
|
Got it installed with that modification - but adding the module to a page still comes up with a similar error
| |
A critical error has occurred.
Invalid object name 'cosnet_DNNPortalUser.Wiki_Settings'. |
I guess its the same problem as before... (its looking for the dbo.wiki_settings ....)
|
| |
|
|
| |
|
|
|
I'm assuming the DBO defined in your web.config file is cosnet_DNNPortalUser?
Do you have a table in your DB called Wiki_settings? Who is the owner on it?
|
| |
|
|
| |
|
|
Joined: 3/26/2006
Posts: 22
|
|
|
Hi, sorrry for such a long reply time - work takes priority unfortunately!
Anyway: DBO is set in web.config in the entry as follows:
<add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SiteSqlServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifier="" databaseOwner="cosnet_DNNPortalUser" />
Also, I have 4 tables with a Wiki prefix, but no Wiki_settings
Wiki_CommentParents, Wiki_Comments, Wiki_Topic, Wiki_TopicHistory
|
| |
|
|
| |