mklllllllll
2015-09-13T19:00:01Z
I install the forum.
http: // localhost / test1001 / install /

Server = DESKTOP-PH5D0TI; Database = test1001; User ID = aa; Password = ●●


ERROR:
The database already exists an object named "yaf_prov_upgrade".




Server Error in '/test1001' Application.
FILE:
mssql/install/providers/procedures.sql

ERROR:
В базе данных уже существует объект с именем "yaf_prov_upgrade".

STATEMENT:
-- =============================================
-- Author: Mek
-- Create date: 30 September 2007
-- Description: Membership Provider, Roles Provider SPROCS
-- =============================================

-- =============================================
-- Membership Create Procedures
-- =============================================

CREATE PROCEDURE [dbo].[yaf_prov_upgrade]
(
@PreviousVersion int,
@NewVersion int,
@UTCTIMESTAMP datetime
)
AS
BEGIN
IF (@PreviousVersion = 31) OR (@PreviousVersion = 32)
BEGIN
-- RESOLVE SALT ISSUE IN 193 BETA and RC2
UPDATE [dbo].[yaf_prov_Membership] SET PasswordSalt='UwB5AHMAdABlAG0ALgBCAHkAdABlAFsAXQA=' WHERE PasswordSalt IS NOT NULL;
UPDATE [dbo].[yaf_prov_Membership] SET Joined=@UTCTIMESTAMP WHERE Joined IS NULL;
END
END
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: FILE:
mssql/install/providers/procedures.sql

ERROR:
В базе данных уже существует объект с именем "yaf_prov_upgrade".

STATEMENT:
-- =============================================
-- Author: Mek
-- Create date: 30 September 2007
-- Description: Membership Provider, Roles Provider SPROCS
-- =============================================

-- =============================================
-- Membership Create Procedures
-- =============================================

CREATE PROCEDURE [dbo].[yaf_prov_upgrade]
(
@PreviousVersion int,
@NewVersion int,
@UTCTIMESTAMP datetime
)
AS
BEGIN
IF (@PreviousVersion = 31) OR (@PreviousVersion = 32)
BEGIN
-- RESOLVE SALT ISSUE IN 193 BETA and RC2
UPDATE [dbo].[yaf_prov_Membership] SET PasswordSalt='UwB5AHMAdABlAG0ALgBCAHkAdABlAFsAXQA=' WHERE PasswordSalt IS NOT NULL;
UPDATE [dbo].[yaf_prov_Membership] SET Joined=@UTCTIMESTAMP WHERE Joined IS NULL;
END
END

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[Exception: FILE:
mssql/install/providers/procedures.sql

ERROR:
В базе данных уже существует объект с именем "yaf_prov_upgrade".

STATEMENT:
-- =============================================
-- Author: Mek
-- Create date: 30 September 2007
-- Description: Membership Provider, Roles Provider SPROCS
-- =============================================

-- =============================================
-- Membership Create Procedures
-- =============================================

CREATE PROCEDURE [dbo].[yaf_prov_upgrade]
(
@PreviousVersion int,
@NewVersion int,
@UTCTIMESTAMP datetime
)
AS
BEGIN
IF (@PreviousVersion = 31) OR (@PreviousVersion = 32)
BEGIN
-- RESOLVE SALT ISSUE IN 193 BETA and RC2
UPDATE [dbo].[yaf_prov_Membership] SET PasswordSalt='UwB5AHMAdABlAG0ALgBCAHkAdABlAFsAXQA=' WHERE PasswordSalt IS NOT NULL;
UPDATE [dbo].[yaf_prov_Membership] SET Joined=@UTCTIMESTAMP WHERE Joined IS NULL;
END
END]
YAF.Classes.Data.LegacyDb.system_initialize_executescripts(String script, String scriptFile, Boolean useTransactions) +643
YAF.Core.Services.InstallUpgradeService.ExecuteScript(String scriptFile, Boolean useTransactions) +226
YAF.Core.Services.InstallUpgradeService.<ExecuteInstallScripts>b__4(String script) +7
YAF.Types.Extensions.EnumerableExtensions.ForEach(IEnumerable`1 list, Action`1 action) +184
YAF.Core.Services.InstallUpgradeService.ExecuteInstallScripts(Boolean isAzureEngine) +140
YAF.Core.Services.InstallUpgradeService.UpgradeDatabase(Boolean fullText, Boolean upgradeExtensions) +114
YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) +1618
System.Web.UI.WebControls.Wizard.OnNextButtonClick(WizardNavigationEventArgs e) +111
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +406
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +121
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +164
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +12
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +15
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +31
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3582


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.79.0
Sponsor
hanopro
2015-10-14T13:57:07Z
i understand , thanks you!
bbobb
  •  bbobb
  • 100% (Exalted)
  • YAF Developer
2015-10-14T17:46:18Z
Originally Posted by: mklllllllll 


ERROR:
The database already exists an object named "yaf_prov_upgrade".


Version? Delete it and look what happens next.
starkruzr
2015-11-12T21:23:49Z
Hi,

This happened to me too. I downloaded the YAF.NET software last week. When I ran the installation it timed out, and now it continues to try to run the installation over and over. It finishes with this "yaf_prov_upgrade" message every time.

How do I unset whatever state is telling it "the software is not installed yet?" If I look at the database, it's clear YAF has created the tables, etc. it needs in order to run. It just seems to think it needs to upgrade or reinstall.
starkruzr
2015-11-15T00:27:42Z
Just as an FYI: I deleted and recreated the database, and this resolved the issue for me.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved