i got error on upgrade from 5.2.2 to 5.2.3 - tested ok offline but live had this error in log
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
all previous logs are clear, what steps should i take. do i need to do a restore or can i manualy rerun the upgrade script
Thanks