YAFLogo

jackiechou
  • jackiechou
  • 66.4% (Friendly)
  • YAF Camper Topic Starter
7 years ago
Hi YAF Team,

I have my site thegioi360.vn by yafnet forum. And it works okay for a long time, but now it is got stuck with a issue. The install screen appears, and if I click install, the error message is shown below

FILE:

mssql/install/providers/procedures.sql

ERROR:

There is already an object named 'yaf_prov_upgrade' in the database.

CREATE PROCEDURE [dbo].[yaf_prov_upgrade]

(

@PreviousVersion int,

@NewVersion int,

@UTCTIMESTAMP datetime

)

I wonder whether there is a new version and the auto updating proces makes the forum error or not

Please help me ! Give me an advice if possible.

Thanks,

Jackie

Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
7 years ago
There is is a problem with the upgrade proccess which in some cases run the install script on a upgrade instead of the upgrade script. this will be fixed in the next version.

You can try to skip the upgrade process by increasing the version in the sql table with...

update [{databaseOwner}].[{objectQualifier}registry] set Value = '60' where lower(Name)=lower('version')