Error installing DNNMasters Multi Portal User Sharing xTreme 3.8

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

Home

Using DNN Platf...

Using Modules a...

Error installing DNNMasters Multi Portal User Sharing xTreme 3.8 on DNN 7.2

3/2/2014 10:15 AM

Luke Sanderlin

Joined: 11/16/2005

Posts: 6

Error installing DNNMasters Multi Portal User Sharing xTreme 3.8 on DNN 7.2

When I add a purchased copy of DNNMaster Multi Portal User Sharing xTreme 3.8 it gives me the following error? Any suggestions or ideas?

Please see the sql error also.

Luke

[start error]

See below for the results of the package installation

Error loading files from temporary folder - see below

StartJob	Starting Installation
Info	Starting Installation - DNNMasters.MPUS.Xtreme
Info	Starting Installation - Script
Info	Begin Sql execution
Info	Creating backup of previous version - 00.00.01.SqlDataProvider
Info	Created - 00.00.01.SqlDataProvider
Info	Executing 00.00.01.SqlDataProvider
Info	Start Sql execution: 00.00.01.SqlDataProvider file
Info	End Sql execution: 00.00.01.SqlDataProvider file
Info	Creating backup of previous version - 00.00.02.SqlDataProvider
Info	Created - 00.00.02.SqlDataProvider
Info	Executing 00.00.02.SqlDataProvider
Info	Start Sql execution: 00.00.02.SqlDataProvider file
Info	End Sql execution: 00.00.02.SqlDataProvider file
Info	Creating backup of previous version - 00.00.04.SqlDataProvider
Info	Created - 00.00.04.SqlDataProvider
Info	Executing 00.00.04.SqlDataProvider
Info	Start Sql execution: 00.00.04.SqlDataProvider file
Info	End Sql execution: 00.00.04.SqlDataProvider file
Info	Creating backup of previous version - 00.00.11.SqlDataProvider
Info	Created - 00.00.11.SqlDataProvider
Info	Executing 00.00.11.SqlDataProvider
Info	Start Sql execution: 00.00.11.SqlDataProvider file
Info	End Sql execution: 00.00.11.SqlDataProvider file
Info	Creating backup of previous version - 01.00.02.SqlDataProvider
Info	Created - 01.00.02.SqlDataProvider
Info	Executing 01.00.02.SqlDataProvider
Info	Start Sql execution: 01.00.02.SqlDataProvider file
Info	End Sql execution: 01.00.02.SqlDataProvider file
Info	Creating backup of previous version - 01.00.04.SqlDataProvider
Info	Created - 01.00.04.SqlDataProvider
Info	Executing 01.00.04.SqlDataProvider
Info	Start Sql execution: 01.00.04.SqlDataProvider file
Info	End Sql execution: 01.00.04.SqlDataProvider file
Info	Creating backup of previous version - 01.00.11.SqlDataProvider
Info	Created - 01.00.11.SqlDataProvider
Info	Executing 01.00.11.SqlDataProvider
Info	Start Sql execution: 01.00.11.SqlDataProvider file
Info	End Sql execution: 01.00.11.SqlDataProvider file
Info	Creating backup of previous version - 01.00.14.SqlDataProvider
Info	Created - 01.00.14.SqlDataProvider
Info	Executing 01.00.14.SqlDataProvider
Info	Start Sql execution: 01.00.14.SqlDataProvider file
Info	End Sql execution: 01.00.14.SqlDataProvider file
Info	Creating backup of previous version - 01.00.16.SqlDataProvider
Info	Created - 01.00.16.SqlDataProvider
Info	Executing 01.00.16.SqlDataProvider
Info	Start Sql execution: 01.00.16.SqlDataProvider file
Info	End Sql execution: 01.00.16.SqlDataProvider file
Info	Creating backup of previous version - 01.00.17.SqlDataProvider
Info	Created - 01.00.17.SqlDataProvider
Info	Executing 01.00.17.SqlDataProvider
Info	Start Sql execution: 01.00.17.SqlDataProvider file
Info	End Sql execution: 01.00.17.SqlDataProvider file
Info	Creating backup of previous version - 01.00.18.SqlDataProvider
Info	Created - 01.00.18.SqlDataProvider
Info	Executing 01.00.18.SqlDataProvider
Info	Start Sql execution: 01.00.18.SqlDataProvider file
Info	End Sql execution: 01.00.18.SqlDataProvider file
Info	Creating backup of previous version - 01.00.35.SqlDataProvider
Info	Created - 01.00.35.SqlDataProvider
Info	Executing 01.00.35.SqlDataProvider
Info	Start Sql execution: 01.00.35.SqlDataProvider file
Info	End Sql execution: 01.00.35.SqlDataProvider file
Info	Creating backup of previous version - 02.00.00.SqlDataProvider
Info	Created - 02.00.00.SqlDataProvider
Info	Executing 02.00.00.SqlDataProvider
Info	Start Sql execution: 02.00.00.SqlDataProvider file
Info	End Sql execution: 02.00.00.SqlDataProvider file
Info	Creating backup of previous version - 02.00.01.SqlDataProvider
Info	Created - 02.00.01.SqlDataProvider
Info	Executing 02.00.01.SqlDataProvider
Info	Start Sql execution: 02.00.01.SqlDataProvider file
Info	End Sql execution: 02.00.01.SqlDataProvider file
Info	Creating backup of previous version - 02.00.07.SqlDataProvider
Info	Created - 02.00.07.SqlDataProvider
Info	Executing 02.00.07.SqlDataProvider
Info	Start Sql execution: 02.00.07.SqlDataProvider file
Info	End Sql execution: 02.00.07.SqlDataProvider file
Info	Creating backup of previous version - 02.00.14.SqlDataProvider
Info	Created - 02.00.14.SqlDataProvider
Info	Executing 02.00.14.SqlDataProvider
Info	Start Sql execution: 02.00.14.SqlDataProvider file
Info	End Sql execution: 02.00.14.SqlDataProvider file
Info	Creating backup of previous version - 02.00.15.SqlDataProvider
Info	Created - 02.00.15.SqlDataProvider
Info	Executing 02.00.15.SqlDataProvider
Info	Start Sql execution: 02.00.15.SqlDataProvider file
Info	End Sql execution: 02.00.15.SqlDataProvider file
Info	Creating backup of previous version - 02.00.17.SqlDataProvider
Info	Created - 02.00.17.SqlDataProvider
Info	Executing 02.00.17.SqlDataProvider
Info	Start Sql execution: 02.00.17.SqlDataProvider file
Info	End Sql execution: 02.00.17.SqlDataProvider file
Info	Creating backup of previous version - 02.00.19.SqlDataProvider
Info	Created - 02.00.19.SqlDataProvider
Info	Executing 02.00.19.SqlDataProvider
Info	Start Sql execution: 02.00.19.SqlDataProvider file
Info	End Sql execution: 02.00.19.SqlDataProvider file
Info	Creating backup of previous version - 02.00.28.SqlDataProvider
Info	Created - 02.00.28.SqlDataProvider
Info	Executing 02.00.28.SqlDataProvider
Info	Start Sql execution: 02.00.28.SqlDataProvider file
Info	End Sql execution: 02.00.28.SqlDataProvider file
Info	Creating backup of previous version - 02.00.38.SqlDataProvider
Info	Created - 02.00.38.SqlDataProvider
Info	Executing 02.00.38.SqlDataProvider
Info	Start Sql execution: 02.00.38.SqlDataProvider file
Info	End Sql execution: 02.00.38.SqlDataProvider file
Info	Creating backup of previous version - 02.01.01.SqlDataProvider
Info	Created - 02.01.01.SqlDataProvider
Info	Executing 02.01.01.SqlDataProvider
Info	Start Sql execution: 02.01.01.SqlDataProvider file
Info	End Sql execution: 02.01.01.SqlDataProvider file
Info	Creating backup of previous version - 02.01.02.SqlDataProvider
Info	Created - 02.01.02.SqlDataProvider
Info	Executing 02.01.02.SqlDataProvider
Info	Start Sql execution: 02.01.02.SqlDataProvider file
Info	End Sql execution: 02.01.02.SqlDataProvider file
Info	Creating backup of previous version - 02.01.03.SqlDataProvider
Info	Created - 02.01.03.SqlDataProvider
Info	Executing 02.01.03.SqlDataProvider
Info	Start Sql execution: 02.01.03.SqlDataProvider file
Failure	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:8d8a27d8-388d-4501-9097-0c7c036220d3 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsUpdate') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsUpdate @SharedGroupId int, @PortalId int, @GroupId int, @SharedAreaId int AS SET NOCOUNT ON UPDATE DotNetNuke_32.DNNMasters_MPUS_X_SharedGroups SET PortalId=@PortalId, GroupId=@GroupId, SharedAreaId=@SharedAreaId WHERE SharedGroupId=@SharedGroupId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:c83fa45e-a90a-4300-9c25-2ed0caa8bf01 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsGetAll') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsGetAll AS SET NOCOUNT ON SELECT SharedGroupId,PortalId,GroupId,SharedAreaId FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedGroups ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:8c50703b-fbc8-4d6a-ad6c-5108f53b271b IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsGet_BySA') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N'CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsGet_BySA @SharedAreaId int AS SET NOCOUNT ON SELECT SharedGroupId,PortalId,GroupId,SharedAreaId FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedGroups WHERE SharedAreaId=@SharedAreaId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:db9155de-9e2d-40b1-b602-013b240b2345 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsGet') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsGet @SharedGroupId int AS SET NOCOUNT ON SELECT SharedGroupId,PortalId,GroupId,SharedAreaId FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedGroups WHERE SharedGroupId=@SharedGroupId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:dd196ca1-95ae-4d73-9d1e-99d19da82774 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsDeleteAll') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsDeleteAll AS SET NOCOUNT ON DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedGroups ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:57ef0fbc-24fa-44a7-9c25-d3788a124228 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsDelete_BySAAndPortal') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N'CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsDelete_BySAAndPortal @PortalId int, @SharedAreaId int AS SET NOCOUNT ON DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedGroups WHERE PortalId=@PortalId and SharedAreaId = @SharedAreaId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:aaa0fa77-704b-44b8-96e2-bacb4c0e5f9d IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsDelete') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsDelete @SharedGroupId int AS SET NOCOUNT ON DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedGroups WHERE SharedGroupId=@SharedGroupId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:3acbf28e-56e3-4304-a15b-3cee4021400a IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsCountAll') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsCountAll AS SET NOCOUNT ON SELECT count() FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedGroups ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:f7bea3c3-a2fa-4bea-996f-8d618f6fc68a IF NOT EXISTS (SELECT FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsAdd') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' -- ************* Create relations (foreign keys) ************** -- *********** Create stored procedures ************** -- * Create stored procedures for table DNNMasters_MPUS_X_SharedGroups *** CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedGroupsAdd @PortalId int, @GroupId int, @SharedAreaId int AS SET NOCOUNT ON INSERT INTO DotNetNuke_32.DNNMasters_MPUS_X_SharedGroups (PortalId,GroupId,SharedAreaId) VALUES (@PortalId,@GroupId,@SharedAreaId) SELECT SCOPE_IDENTITY() ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:406705f1-0d28-4b2c-9d44-d2134418072c IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedAreaUpdate') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedAreaUpdate @RoleName NVARCHAR(100), @PortalId INT, @SharedRole INT, @RoleId INT, @SharedUsersRole INT AS DECLARE @Cnt INT SELECT @Cnt = COUNT() FROM DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedArea WHERE RoleName = @RoleName IF ( @Cnt > 0 ) BEGIN UPDATE DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedArea SET RoleName=@RoleName,PortalId=@PortalId,SharedRole=@SharedRole,RoleId=@RoleId,SharedUsersRole=@SharedUsersRole WHERE RoleId=@RoleId END ELSE BEGIN INSERT INTO DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedArea (RoleName, PortalId, SharedRole, RoleId, SharedUsersRole ) VALUES (@RoleName, @PortalId, @SharedRole, @RoleId, @SharedUsersRole) END ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:a1938edc-f225-42bc-a7e9-830b4de3fca5 IF NOT EXISTS (SELECT FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedAreaSet') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedAreaSet @RoleName NVARCHAR(100), @PortalId INT, @SharedRole INT, @RoleId INT, @SharedUsersRole INT AS INSERT INTO DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedArea (RoleName, PortalId, SharedRole, RoleId, SharedUsersRole ) VALUES (@RoleName, @PortalId, @SharedRole, @RoleId, @SharedUsersRole) ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:8c10f706-bda8-491c-bc6f-da1fd058b7a4 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_RoleInAllSharedAreaGet') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_RoleInAllSharedAreaGet AS SELECT MPUS_RoleId, RoleName, PortalId, SharedRole, RoleId, SharedUsersRole FROM DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedArea ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:50ea9468-a07b-45dd-9cff-d78883f52cfd IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_CheckDuplicates') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_CheckDuplicates AS SELECT UserName ,COUNT() FROM Users GROUP BY UserName HAVING COUNT() > 1 ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:aff0cc9b-2b5a-430a-af90-4a7f8eea99f7 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalAssignedSet') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalAssignedSet @SharedAreaID INT, @PortalID INT, @SharePortalUser INT, @ShareSAUser INT AS INSERT INTO DotNetNuke_32.DNNMasters_MPUS_X_PortalAssigned (SharedAreaID ,PortalID ,SharePortalUser ,ShareSAUser) VALUES (@SharedAreaID, @PortalID, @SharePortalUser, @ShareSAUser) RETURN SCOPE_IDENTITY() ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:1819227e-87f5-4265-82dd-338ec1f1c802 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalAssignedRemove') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalAssignedRemove @PortalID INT, @SharedAreaID INT AS DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_PortalAssigned WHERE PortalID = @PortalID AND SharedAreaID = @SharedAreaID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:5f7aae35-0e58-434f-bdf1-ad03670de622 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalAssignedGet') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalAssignedGet @PortalID INT AS SELECT PortalID, P.SharedAreaID, SharePortalUser, ShareSAUser, Name, Comment FROM DotNetNuke_32.DNNMasters_MPUS_X_SA as S, DotNetNuke_32.DNNMasters_MPUS_X_PortalAssigned as P WHERE P.SharedAreaID = S.SharedAreaID AND PortalID = @PortalID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d2ad60ed-31d3-4074-a88f-aa9b61b533b4 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalAssignedCheck') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalAssignedCheck @PortalID INT, @SharedAreaID INT AS SELECT SharedID, PortalID, P.SharedAreaID, SharePortalUser, ShareSAUser, Name, Comment FROM DotNetNuke_32.DNNMasters_MPUS_X_SA as S, DotNetNuke_32.DNNMasters_MPUS_X_PortalAssigned as P WHERE P.SharedAreaID = S.SharedAreaID AND PortalID = @PortalID AND P.SharedAreaID = @SharedAreaID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:7fa50867-b823-412e-9075-783235672063 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_Set') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_Set @GroupName nvarchar(200), @PortalId int, @GroupId int, @SharedGroup int AS UPDATE DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea SET GroupName=@GroupName,PortalId=@PortalId,SharedGroup=@SharedGroup WHERE GroupId=@GroupId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:46b3f107-585d-4c2e-b651-67c54a25aacb IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_GetByGroup') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_GetByGroup @GroupId INT AS SELECT MPUS_GroupId, GroupName, PortalId, GroupId, SharedGroup FROM DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea WHERE GroupId = @GroupId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:ae743e8c-7af9-4150-a186-6b3f91a69b99 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_Get') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_Get @PortalID INT AS SELECT MPUS_GroupId, GroupName, PortalId, GroupId, SharedGroup FROM DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea WHERE PortalID = @PortalID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:bb6e6d40-57ec-4c3a-8c1a-6b6a56b6eae3 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_DeleteByGroup') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_DeleteByGroup @GroupId INT AS DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea WHERE GroupId = @GroupId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:182bee5e-a445-495f-9368-a598ea74b8db IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_Delete') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_Delete @PortalID INT AS DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea WHERE PortalID = @PortalID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:871ffc8d-31a9-4188-91df-adb5bc4296ef IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_Add') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea_Add @GroupName nvarchar(200), @PortalId int, @GroupId int, @SharedGroup int AS INSERT INTO DotNetNuke_32.DNNMasters_MPUS_X_GroupInSharedArea ( GroupName, PortalId, GroupId, SharedGroup ) VALUES ( @GroupName, @PortalId, @GroupId, @SharedGroup ) RETURN SCOPE_IDENTITY() ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:3ca19464-bc77-4bb8-9248-4d56c70baa0d IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalsInSharedArea_WithSA') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalsInSharedArea_WithSA @SharedAreaId INT AS SELECT SharedId, PortalId, P.SharedAreaId, SharePortalUser, ShareSAUser, Name, Comment FROM DotNetNuke_32.DNNMasters_MPUS_X_SA as S, DotNetNuke_32.DNNMasters_MPUS_X_PortalAssigned as P WHERE P.SharedAreaId = S.SharedAreaId AND P.SharedAreaId = @SharedAreaId AND ShareSAUser=''1'' ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:f62546ea-080f-4687-bcc6-75194257a925 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalsInSharedArea_WithPortal') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalsInSharedArea_WithPortal @SharedAreaId INT AS SELECT SharedId, PortalId, P.SharedAreaId, SharePortalUser, ShareSAUser, Name, Comment FROM DotNetNuke_32.DNNMasters_MPUS_X_SA as S, DotNetNuke_32.DNNMasters_MPUS_X_PortalAssigned as P WHERE P.SharedAreaId = S.SharedAreaId AND P.SharedAreaId = @SharedAreaId --AND SharePortalUser=''1'' ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:be27b880-136e-4690-b365-d12483a0c95e IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalsInSharedArea') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalsInSharedArea @SharedAreaId INT AS SELECT SharedId, PortalId, P.SharedAreaId, SharePortalUser, ShareSAUser, Name, Comment FROM DotNetNuke_32.DNNMasters_MPUS_X_SA as S, DotNetNuke_32.DNNMasters_MPUS_X_PortalAssigned as P WHERE P.SharedAreaId = S.SharedAreaId AND P.SharedAreaId = @SharedAreaId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:afc07f8f-935b-4b22-9629-3b3e56a31593 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalSettingsUpdate') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalSettingsUpdate @PortalID INT, @ShareRole INT, @ShareGroup INT, @ShareUserInRole INT AS DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_PortalSettings WHERE PortalID=@PortalID UPDATE DotNetNuke_32.DNNMasters_MPUS_X_PortalSettings SET PortalID=@PortalID,ShareRole=@ShareRole,ShareGroup=@ShareGroup,ShareUserInRole=@ShareUserInRole WHERE PortalID=@PortalID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:60bd5324-f313-4686-af87-3caf2c0fa192 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalSettingsSet') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalSettingsSet @PortalID INT, @ShareRole INT, @ShareGroup INT, @ShareUserInRole INT AS DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_PortalSettings WHERE PortalID=@PortalID INSERT INTO DotNetNuke_32.DNNMasters_MPUS_X_PortalSettings (PortalID, ShareRole, ShareGroup, ShareUserInRole ) VALUES (@PortalID, @ShareRole, @ShareGroup, @ShareUserInRole) ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:46abbb51-5ae8-495d-a748-c44c7be1c52c IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalSettingsRemove') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalSettingsRemove @PortalID INT AS DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_PortalSettings WHERE PortalID=@PortalID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:7fed8446-55e0-4506-829b-1fd9e394ff7c IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalSettingsGet') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalSettingsGet @PortalID INT AS SELECT PortalID, ShareRole, ShareGroup, ShareUserInRole FROM DotNetNuke_32.DNNMasters_MPUS_X_PortalSettings WHERE PortalID = @PortalID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:be29b01c-7fa6-471a-9789-1ad29d51eb89 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalListInSAByPortalID') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalListInSAByPortalID @PortalId INT AS begin declare @l_said int select @l_said = ( select top 1 SharedAreaID from DotNetNuke_32.DNNMasters_MPUS_X_PortalAssigned where PortalId = @PortalId ) select PortalID from DotNetNuke_32.DNNMasters_MPUS_X_PortalAssigned where SharedAreaID = @l_said end ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:949b2ee4-a568-4483-bddc-e51a45a4fcd9 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesUpdate') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesUpdate @SharedRoleId int, @PortalId int, @RoleId int, @SharedAreaId int AS SET NOCOUNT ON UPDATE DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles SET PortalId=@PortalId, RoleId=@RoleId, SharedAreaId=@SharedAreaId WHERE SharedRoleId=@SharedRoleId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:ada12618-268a-4d5c-99f5-cbc441eb6d5d IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesGetAll') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesGetAll AS SET NOCOUNT ON SELECT SharedRoleId,PortalId,RoleId,SharedAreaId FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:c426c60d-d642-4110-8164-84bdd7643dd9 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesGet_BySharedArea') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N'create PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesGet_BySharedArea @SharedAreaId int AS SET NOCOUNT ON SELECT SharedRoleId,PortalId,RoleId,SharedAreaId FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles WHERE SharedAreaId=@SharedAreaId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:fb4a4b3f-a351-42b0-9d59-bcefbf29c076 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesGet') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesGet @SharedRoleId int AS SET NOCOUNT ON SELECT SharedRoleId,PortalId,RoleId,SharedAreaId FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles WHERE SharedRoleId=@SharedRoleId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:60c885b7-b8ee-46e0-becf-a6bac7aa61dd IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesDeleteBySaAndPortal') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesDeleteBySaAndPortal @SharedAreaId int, @PortalId int AS begin SET NOCOUNT ON DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles where SharedAreaId = @SharedAreaId and PortalId = @PortalId end ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:b1d47c52-fdd1-4090-a834-820e18baa013 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesDeleteAll') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesDeleteAll AS SET NOCOUNT ON DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:1a66bc90-816b-448c-88af-7fc0e11d44fb IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesDelete') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesDelete @SharedRoleId int AS SET NOCOUNT ON DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles WHERE SharedRoleId=@SharedRoleId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:bcfce4a1-4850-48a9-bce8-5dfdf4bfb468 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesCountAll') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesCountAll AS SET NOCOUNT ON SELECT count() FROM DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:5a4d46f2-7433-40a2-8523-d281bb9fdbfb IF NOT EXISTS (SELECT FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesAdd') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' -- ************* Create relations (foreign keys) ************** -- *********** Create stored procedures ************** -- * Create stored procedures for table DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles *** CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SharedRolesAdd @PortalId int, @RoleId int, @SharedAreaId int AS SET NOCOUNT ON INSERT INTO DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles (PortalId,RoleId,SharedAreaId) VALUES (@PortalId,@RoleId,@SharedAreaId) SELECT SCOPE_IDENTITY() ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:bd42b382-a81f-4038-8473-e50274eb2ddf IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SAList') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SAList AS SELECT SharedAreaId, Name, Comment FROM DotNetNuke_32.DNNMasters_MPUS_X_SA ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:fcd4d8bf-9c43-4e88-bc90-22e07fe81145 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SAEdit') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SAEdit @SharedAreaId INT, @SharedAreaName NVARCHAR(256), @SharedAreaDescription NVARCHAR(256) AS UPDATE DotNetNuke_32.DNNMasters_MPUS_X_SA SET Name = @SharedAreaName, Comment = @SharedAreaDescription WHERE SharedAreaId = @SharedAreaId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:259a452a-5868-4cb7-b2f0-b8a51aee2e58 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SADelete') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SADelete @SharedAreaId INT AS DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_SA WHERE SharedAreaId = @SharedAreaId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:db376aa8-e68b-4363-b399-6c234d423ef9 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_SAAdd') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_SAAdd @Name NVARCHAR(100), @Comment NVARCHAR(200) AS INSERT INTO DotNetNuke_32.DNNMasters_MPUS_X_SA ( Name, Comment ) VALUES ( @Name, @Comment ) RETURN SCOPE_IDENTITY() ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:9ae9a40b-3f94-41a0-8130-c0d4185e3ebd IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedAreaGetByID') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedAreaGetByID @RoleId INT AS SELECT MPUS_RoleId, RoleName, PortalId, SharedRole, RoleId, SharedUsersRole FROM DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedArea WHERE RoleId = @RoleId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:ca76ec4d-f4cd-48d7-8041-9d6d67c87c12 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedAreaGet') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedAreaGet @PortalId INT AS SELECT MPUS_RoleId, RoleName, PortalId, SharedRole, RoleId, SharedUsersRole FROM DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedArea WHERE PortalID = @PortalID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:02f4aedf-180f-4a50-b9a1-0a8cf148416c IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaBulkRemove') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaBulkRemove @PortalId INT AS begin DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea WHERE PortalId = @PortalId end ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:8085270c-1f39-4834-b314-edbdd2a7d7be IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaRemove') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaRemove @UserName nvarchar (100), @UserID INT, @PortalId INT AS DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea WHERE UserID = @UserID AND UserName = @UserName AND PortalId = @PortalId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:39854cb6-465e-4b11-928c-5f3342562cf9 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaGet_ByUserName') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaGet_ByUserName @UserName nvarchar (100) AS SELECT SharedUserID, UserID, UserName, PortalId FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea WHERE UserName = @UserName ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:e3fc4279-eee7-436d-b9d3-680d75fbe202 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaGet_ByUserID') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaGet_ByUserID @UserID INT AS SELECT SharedUserID, UserID, UserName, PortalId FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea WHERE UserID = @UserID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d2c3fbbd-e55a-45cb-868f-d90ca29bedb8 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaGet_ByPortalID') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaGet_ByPortalID @PortalId INT AS SELECT SharedUserID, UserID, UserName, PortalId FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea WHERE PortalId = @PortalId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:3e6f83af-2d39-498b-a470-41393dfcf06d IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaAdd') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaAdd @UserID INT, @UserName nvarchar (100), @PortalId INT AS INSERT INTO DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea (UserID, UserName, PortalId) VALUES (@UserID, @UserName, @PortalId) RETURN SCOPE_IDENTITY() ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:012c4eb7-fabf-4092-8f46-dea19ab08c77 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserToPortalAdd') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserToPortalAdd @UserId INT, @PortalId INT AS DECLARE @Cnt INT SELECT @Cnt = COUNT() FROM UserPortals WHERE UserId= @UserId AND PortalId = @PortalId IF ( @Cnt = 0 ) BEGIN INSERT INTO UserPortals (UserId, PortalId, CreatedDate, Authorised ) VALUES (@UserId, @PortalId, GETDATE(), ''1'') RETURN SCOPE_IDENTITY() END ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:8f758b64-eaae-4773-a8c9-fcd0ff5c8f6e IF NOT EXISTS (SELECT FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaClear') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaClear @UserId INT, @PortalId INT AS DELETE FROM UserPortals WHERE UserId = @UserId AND PortalId = @PortalId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:07507a7f-5b23-4f41-a316-169e423dac66 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserToPortalRemove') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserToPortalRemove @UserId INT, @PortalId INT AS DELETE FROM UserPortals WHERE UserId=@UserId AND PortalId=@PortalId ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:b9c8a70f-cd05-4590-9c54-32302aa8e80c IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalListByUserID') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalListByUserID @UserID INT AS SELECT PortalID FROM UserPortals WHERE UserID = @UserID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:59ccb935-b5ff-4e65-8aae-bdcb78bcd2aa IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_PortalAliasList') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_PortalAliasList @PortalID INT AS SELECT PortalAliasID ,PortalID ,HTTPAlias FROM PortalAlias WHERE PortalID = @PortalID ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:78e1caea-f1df-4e02-8474-ce4b6e64e16a IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_RoleAdd') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_RoleAdd @PortalId int, @RoleGroupId int, @RoleName nvarchar(50), @Description nvarchar(1000), @ServiceFee money, @BillingPeriod int, @BillingFrequency char(1), @TrialFee money, @TrialPeriod int, @TrialFrequency char(1), @IsPublic bit, @AutoAssignment bit, @RSVPCode nvarchar(50), @IconFile nvarchar(100) AS INSERT INTO Roles ( PortalId, RoleGroupId, RoleName, Description, ServiceFee, BillingPeriod, BillingFrequency, TrialFee, TrialPeriod, TrialFrequency, IsPublic, AutoAssignment, RSVPCode, IconFile ) VALUES ( @PortalId, Null, @RoleName, @Description, @ServiceFee, @BillingPeriod, @BillingFrequency, @TrialFee, @TrialPeriod, @TrialFrequency, @IsPublic, @AutoAssignment, @RSVPCode, @IconFile ) SELECT SCOPE_IDENTITY() ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d72d3af5-3112-46f3-a1d3-2c97b92d453c IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserRoleToPortalBulkAdd') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserRoleToPortalBulkAdd @SourcePortalId INT, @DestinationPortalId INT, @CreatedByUserID int AS BEGIN INSERT INTO DotNetNuke_32.UserRoles ( UserId, RoleId, EffectiveDate, ExpiryDate, IsTrialUsed ) select up.UserID, r.RoleId, null, null, 1 from DotNetNuke_32.UserPortals usprt join DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea up on up.UserID = usprt.UserId join ( select rs.* from DotNetNuke_32.Roles rs join DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedArea rsa on rsa.RoleName = rs.RoleName and rsa.PortalId = @SourcePortalId where rs.PortalID = @DestinationPortalId union select rs.* from DotNetNuke_32.Roles rs where rs.PortalID = @DestinationPortalId and rs.AutoAssignment = 1 ) as r on r.PortalID = usprt.PortalId -- join DotNetNuke_32.UserRoles ur_dest on ur_dest.UserID = up.UserId join DotNetNuke_32.Roles r_dest on r_dest.RoleID = ur_dest.RoleID and r_dest.PortalID = @DestinationPortalId and r.RoleName =r_dest.RoleName -- left join DotNetNuke_32.UserRoles ur on ur.RoleID = r.RoleID and ur.UserID = up.UserID where up.PortalId = @SourcePortalId and ur.UserID is null -- END ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:ef07cc3b-1154-445c-b785-c1acc61c7b81 IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserToPortalBulkAdd') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N'CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserToPortalBulkAdd @SourcePortalId INT, @DestinationPortalId INT, @SharedAreaId int AS DECLARE @L_ROLES_EXISTS BIT BEGIN SET @L_ROLES_EXISTS = 0 IF EXISTS(select TOP 1 1 from DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles where PortalId = @SourcePortalId and SharedAreaId = @SharedAreaId ) BEGIN SET @L_ROLES_EXISTS = 1 END -- IF (@L_ROLES_EXISTS = 0) BEGIN INSERT INTO DotNetNuke_32.UserPortals (UserId, PortalId, CreatedDate, Authorised ) SELECT up.UserId, PortalId = @DestinationPortalId, CreatedDate = GETDATE(), Authorised = 1 from DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea up left join ( select updest.UserId from DotNetNuke_32.UserPortals updest where updest.PortalId = @DestinationPortalId ) as x on x.UserId = up.UserId where up.PortalId = @SourcePortalId and x.UserId is null END ELSE IF (@L_ROLES_EXISTS = 1) BEGIN INSERT INTO DotNetNuke_32.UserPortals (UserId, PortalId, CreatedDate, Authorised ) SELECT up.UserId, PortalId = @DestinationPortalId, CreatedDate = GETDATE(), Authorised = 1 from DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea up join DotNetNuke_32.UserRoles ur on ur.UserId = up.UserId join DotNetNuke_32.Roles r on r.RoleID = ur.RoleID join DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles sr on sr.RoleId = r.RoleID and sr.SharedAreaId = @SharedAreaId left join ( select updest.UserId from DotNetNuke_32.UserPortals updest where updest.PortalId = @DestinationPortalId ) as x on x.UserId = up.UserId where up.PortalId = @SourcePortalId and x.UserId is null and r.PortalId = @SourcePortalId and Sr.PortalId = @SourcePortalId END -- END /* begin tran a exec DotNetNuke_32.DNNMasters_MPUS_X_UserToPortalBulkAdd_new 0, 2, 2 rollback tran a / ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:49367892-6ced-4094-9625-4c8f403ee07d IF NOT EXISTS (SELECT FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaBulkAdd') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N'CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaBulkAdd @PortalId INT, @SharedAreaId int AS DECLARE @L_ROLES_EXISTS BIT BEGIN SET @L_ROLES_EXISTS = 0 IF EXISTS(select TOP 1 1 from DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles where PortalId = @PortalId and SharedAreaId = @SharedAreaId ) BEGIN SET @L_ROLES_EXISTS = 1 END -- IF (@L_ROLES_EXISTS = 0) BEGIN insert into DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea (UserID, UserName, PortalId) select u.UserID, u.Username, up.PortalId from DotNetNuke_32.Users u join DotNetNuke_32.UserPortals up on up.UserId = u.UserID where up.PortalId = @PortalId END ELSE IF (@L_ROLES_EXISTS = 1) BEGIN insert into DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea (UserID, UserName, PortalId) select distinct u.UserID, u.Username, up.PortalId from DotNetNuke_32.Users u join DotNetNuke_32.UserPortals up on up.UserId = u.UserID join DotNetNuke_32.UserRoles ur on ur.UserId = up.UserId join DotNetNuke_32.Roles r on r.RoleID = ur.RoleID join DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles sr on sr.RoleId = r.RoleID and sr.SharedAreaId = @SharedAreaId where up.PortalId = @PortalId and r.PortalId = @PortalId and Sr.PortalId = @PortalId END -- end /* BEGIN TRAN A insert into DotNetNuke_32.DNNMasters_MPUS_X_SharedRoles (PortalId, RoleId, SharedAreaId) values(0, 18,2) EXEC DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaBulkAdd_NEW 0, 2 ROLLBACK TRAN A /' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:03786c25-ef2d-4872-9254-ef535a2e2003 IF NOT EXISTS (SELECT FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_UserInRolesInSharedAreaBulkRemove') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N'CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_UserInRolesInSharedAreaBulkRemove @PortalId INT, @RoleId int, @MainPortalId INT AS begin --select ''wywalić'', * from UserRoles where UserID = 3 --select ''wywalić'', * from DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea --select ''wywalić'', * -- FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea up -- join DotNetNuke_32.UserRoles ur on ur.UserID = up.UserID -- join DotNetNuke_32.Roles r on r.RoleID = ur.RoleID -- WHERE up.PortalId = @MainPortalId -- and ur.RoleId = @RoleId -- and r.PortalId = @PortalId --if (@MainPortalId = -1) --begin --select ''wywalić'', * -- FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea up -- join DotNetNuke_32.UserRoles ur on ur.UserID = up.UserID -- join DotNetNuke_32.Roles r on r.RoleID = ur.RoleID -- WHERE up.PortalId <> @PortalId -- and ur.RoleId = @RoleId -- and r.PortalId = @PortalId --end -- 1. delete all users frm portal and role if (@MainPortalId <> -1) begin DELETE ur FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea up join DotNetNuke_32.UserRoles ur on ur.UserID = up.UserID join DotNetNuke_32.Roles r on r.RoleID = ur.RoleID WHERE up.PortalId = @MainPortalId and ur.RoleId = @RoleId and r.PortalId = @PortalId end else begin DELETE ur FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea up join DotNetNuke_32.UserRoles ur on ur.UserID = up.UserID join DotNetNuke_32.Roles r on r.RoleID = ur.RoleID WHERE up.PortalId <> @PortalId and ur.RoleId = @RoleId and r.PortalId = @PortalId end --DELETE ur -- FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea up -- join DotNetNuke_32.UserRoles ur on ur.UserID = up.UserID -- WHERE up.PortalId = @PortalId -- and ur.RoleId = @RoleId -- 2. delete users from portal which has no roles assigned DELETE up FROM DotNetNuke_32.UserPortals up join DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea us on us.PortalId = up.PortalId and us.UserID = up.UserID and up.PortalId=@PortalId left join DotNetNuke_32.UserRoles ur on ur.UserID = us.UserID WHERE ur.UserID is null -- end /* BEGIN TRAN A EXEC DotNetNuke_32.DNNMasters_MPUS_X_UserInRolesInSharedAreaBulkRemove 1, 4, -1 --EXEC DotNetNuke_32.DNNMasters_MPUS_X_UserInRolesInSharedAreaBulkRemove 0, 0, 1 ROLLBACK TRAN A /' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:f6e34d3d-932b-485c-bb95-ffb3a545d006 IF NOT EXISTS (SELECT FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_ShareUserInSelectedRole_Bulk') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' create procedure DotNetNuke_32.DNNMasters_MPUS_X_ShareUserInSelectedRole_Bulk @RoleName nvarchar(50), @RoleID int, @MainPortalID int, @TempPortalID int as begin --1. DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedAreaGet_ByPortalID DECLARE @L_T_USERS TABLE ( SharedUserID int, UserID int, UserName nvarchar(100), PortalId int ) -- INSERT INTO @L_T_USERS ( SharedUserID, UserID, UserName, PortalId ) SELECT SharedUserID, UserID, UserName, PortalId FROM DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea WHERE PortalId = @MainPortalID -- -- 2. GET roles for users from @MainPortalID DECLARE @L_T_USERROLES_MAINPORTA TABLE ( UserID int, RoleName nvarchar(50), PortalId int ) -- INSERT INTO @L_T_USERROLES_MAINPORTA ( UserID, RoleName, PortalId ) select ur.UserID, r.RoleName, r.PortalID from DotNetNuke_32.UserRoles ur join @L_T_USERS ut on ut.UserID = ur.UserID join DotNetNuke_32.Roles r on ur.RoleID = r.RoleID where r.PortalID = @MainPortalID -- --------------------- -- UserToPortalAdd (DotNetNuke_32.DNNMasters_MPUS_X_UserToPortalAdd) --------------------- INSERT INTO DotNetNuke_32.UserPortals (UserId, PortalId, CreatedDate, Authorised ) select up.UserID, @TempPortalID, getdate(), 1 from @L_T_USERROLES_MAINPORTA up left join DotNetNuke_32.UserPortals uu on up.UserID = uu.UserId and uu.PortalId = @TempPortalID where up.RoleName = @RoleName and uu.UserId is null -- --------------------- -- AddUserRole --------------------- INSERT INTO DotNetNuke_32.UserRoles ( UserId, RoleId, EffectiveDate, ExpiryDate, IsTrialUsed ) select up.UserID, @RoleID, null, null, 1 from @L_T_USERROLES_MAINPORTA up where up.RoleName = @RoleName -- end ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:771d8475-dd13-4de7-8c80-fd55734fc7ab IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedAreaRemove') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedAreaRemove @RoleId INT AS BEGIN DELETE FROM DotNetNuke_32.DNNMasters_MPUS_X_RoleInSharedArea WHERE RoleId=@RoleId DECLARE @PortalId INT SELECT @PortalId = ( SELECT PortalId FROM Roles WHERE RoleID = @RoleId ) IF (@PortalId IS NOT NULL) BEGIN DELETE ur FROM DotNetNuke_32.UserRoles ur WHERE ur.RoleId = @RoleId and ur.UserID not in ( select UserID from UserPortals where PortalId = @PortalId ) END END ' END System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'DotNetNuke_32.sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:0a025fcc-6ed9-4d72-846d-0dadfcfd6d2b IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'DotNetNuke_32.DNNMasters_MPUS_X_AutoAssignmentRole') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN EXEC DotNetNuke_32.sp_executesql @statement = N' CREATE PROCEDURE DotNetNuke_32.DNNMasters_MPUS_X_AutoAssignmentRole @SourcePortalId INT, @DestinationPortalId INT, @CreatedByUserID int AS BEGIN -- 1. get roles based on oryginal portal roles with autossignment = true DECLARE @L_T_ROLES TABLE ( ROLEID INT, PORTALID INT ) -- INSERT INTO @L_T_ROLES ( ROLEID, PORTALID ) select r_des.RoleID,r_des.PortalID from DotNetNuke_32.Roles r_org join DotNetNuke_32.Roles r_des on r_org.RoleName = r_des.RoleName where r_org.PortalID = @SourcePortalId and r_des.PortalID = @DestinationPortalId and r_des.AutoAssignment = 1 -- INSERT INTO DotNetNuke_32.UserRoles ( UserId, RoleId, EffectiveDate, ExpiryDate, IsTrialUsed ) select up.UserID, r.RoleId, null, null, 1 from DotNetNuke_32.UserPortals usprt JOIN DotNetNuke_32.DNNMasters_MPUS_X_UserInSharedArea up ON up.UserID = usprt.UserId JOIN @L_T_ROLES R ON r.PortalID = usprt.PortalId left join DotNetNuke_32.UserRoles ur on ur.RoleID = r.RoleID and ur.UserID = up.UserID where up.PortalId = @SourcePortalId and ur.UserID is null -- END ' END
Info	End Sql execution: 02.01.03.SqlDataProvider file
Info	Finished Sql execution
Failure	Installation Failed - Script
Info	Installation Failed - DNNMasters.MPUS.Xtreme
Info	Starting Installation - DNNMasters.Shared
Info	Starting Installation - Assembly
Info	Assembly already registered - bin\DnnMasters.Fusion.LS.Client.dll
Info	Creating backup of previous version - bin\DnnMasters.Fusion.LS.Client.dll
Info	Created - bin\DnnMasters.Fusion.LS.Client.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - DNNMasters.Shared
Info	Deleted temporary install folder
EndJob	Installation Failed

[end Error]

3/2/2014 6:06 PM

cathal connolly

www.cathal.co.uk
Joined: 4/9/2003

Posts: 9676

Re: Error installing DNNMasters Multi Portal User Sharing xTreme 3.8 on DNN 7.2

I'd recommend checking your database collation as if it's case sensitive then sp_executesql would fail (as sql servers looking for sp_ExecuteSQL) -see http://blogs.lessthandot.com/index.ph... for an example. To resolve this you would use a case-insensitive collation (which I would recommend as that's the sql default so you're likely to have future issues in platform/3rd party extensions if you stick with case-sensitive collations). Alternatively you could raise it with the vendor and request they use the correct casing in their database script

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US

Page 1 of 1

Home

Using DNN Platf...

Using Modules a...

Error installing DNNMasters Multi Portal User Sharing xTreme 3.8 on DNN 7.2

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)