Due to a DB breakdown we needed to change the MSSQL DB for the forum. But when we try to change the DB, the system wants to upgrade or to update the DB, But when an update is attempted, this error occurs:

Server Error in '/' Application.

FILE:

mssql/views.sql

ERROR:

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

STATEMENT:

IF NOT exists (select top 1 1 from dbo.sysobjects where id = OBJECT_ID(N'[dbo].[yaf_vaccess_group]') AND OBJECTPROPERTY(id, N'IsView') = 1)

EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[yaf_vaccess_group]

WITH SCHEMABINDING

AS

select

b.UserID,

c.ForumID,

d.AccessMaskID,

b.GroupID,

ReadAccess = convert(int,d.Flags & 1),

PostAccess = convert(int,d.Flags & 2),

ReplyAccess = convert(int,d.Flags & 4),

PriorityAccess = convert(int,d.Flags & 😎,

PollAccess = convert(int,d.Flags & 16),

VoteAccess = convert(int,d.Flags & 32),

ModeratorAccess = convert(int,d.Flags & 64),

EditAccess = convert(int,d.Flags & 128),

DeleteAccess = convert(int,d.Flags & 256),

UploadAccess = convert(int,d.Flags & 512),

DownloadAccess = convert(int,d.Flags & 1024),

AdminGroup = convert(int,e.Flags & 1)

from

[dbo].[yaf_UserGroup] b

INNER JOIN [dbo].[yaf_ForumAccess] c on c.GroupID=b.GroupID

INNER JOIN [dbo].[yaf_AccessMask] d on d.AccessMaskID=c.AccessMaskID

INNER JOIN [dbo].[yaf_Group] e on e.GroupID=b.GroupID'

Any ideas?

The version of YAF should be the latest one, and the .Net version is 4.0.30319.1

http://forum.yetanotherforum.net/yaf_search.aspx?search=yaf_vaccess_group