System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.UpdatePortalInfo', because it does not exist or you do not have permission.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/************************************************************/
/***** SqlDataProvider *****/
/***** *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for dbo. and *****/
/***** *****/
/************************************************************/
/***********************/
/* fix for DNN-11370 */
/***********************/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UpdatePortalInfo]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
DROP PROCEDURE dbo.UpdatePortalInfo
System.Data.SqlClient.SqlException: There is already an object named 'UpdatePortalInfo' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.UpdatePortalInfo
@PortalID int,
@PortalName nvarchar(128),
@LogoFile nvarchar(50),
@FooterText nvarchar(100),
@ExpiryDate datetime,
@UserRegistration int,
@BannerAdvertising int,
@Currency char(3),
@AdministratorId int,
@HostFee money,
@HostSpace int,
@PageQuota int,
@UserQuota int,
@PaymentProcessor nvarchar(50),
@ProcessorUserId nvarchar(50),
@ProcessorPassword nvarchar(50),
@Description nvarchar(500),
@KeyWords nvarchar(500),
@BackgroundFile nvarchar(50),
@SiteLogHistory int,
@SplashTabId int,
@HomeTabId int,
@LoginTabId int,
@UserTabId int,
@DefaultLanguage nvarchar(10),
@TimeZoneOffset int,
@HomeDirectory varchar(100),
@LastModifiedByUserID int,
@CultureCode nvarchar(50)
AS
update dbo.Portals
set
ExpiryDate = @ExpiryDate,
UserRegistration = @UserRegistration,
BannerAdvertising = @BannerAdvertising,
Currency = @Currency,
AdministratorId = @AdministratorId,
HostFee = @HostFee,
HostSpace = @HostSpace,
PageQuota = @PageQuota,
UserQuota = @UserQuota,
PaymentProcessor = @PaymentProcessor,
ProcessorUserId = @ProcessorUserId,
ProcessorPassword = @ProcessorPassword,
SiteLogHistory = @SiteLogHistory,
DefaultLanguage = @DefaultLanguage,
TimeZoneOffset = @TimeZoneOffset,
HomeDirectory = @HomeDirectory,
LastModifiedByUserID = @LastModifiedByUserID,
LastModifiedOnDate = getdate()
where PortalId = @PortalID
UPDATE dbo.PortalLocalization
SET
PortalName = @PortalName,
LogoFile = @LogoFile,
FooterText = @FooterText,
Description = @Description,
KeyWords = @KeyWords,
BackgroundFile = @BackgroundFile,
HomeTabId = @HomeTabId,
LoginTabId = @LoginTabId,
UserTabId = @UserTabId,
SplashTabId = @SplashTabId,
LastModifiedByUserID = @LastModifiedByUserID,
LastModifiedOnDate = getdate()
WHERE PortalId = @PortalID AND CultureCode = @CultureCode
System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.GetPortalDesktopModules', because it does not exist or you do not have permission.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/***********************/
/* fix for DNN-11595 */
/***********************/
/* Update GetPortalDesktopModules Stored Procedure */
/****************************************/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[GetPortalDesktopModules]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
DROP PROCEDURE dbo.GetPortalDesktopModules
System.Data.SqlClient.SqlException: There is already an object named 'GetPortalDesktopModules' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.GetPortalDesktopModules
@PortalId int,
@DesktopModuleId int
AS
SELECT PortalDesktopModules.*,
PortalName,
FriendlyName
FROM PortalDesktopModules
INNER JOIN vw_Portals ON PortalDesktopModules.PortalId = vw_Portals.PortalId
INNER JOIN DesktopModules ON PortalDesktopModules.DesktopModuleId = DesktopModules.DesktopModuleId
WHERE ((PortalDesktopModules.PortalId = @PortalId) OR @PortalId is null)
AND ((PortalDesktopModules.DesktopModuleId = @DesktopModuleId) OR @DesktopModuleId is null)
ORDER BY PortalDesktopModules.PortalId, PortalDesktopModules.DesktopModuleId