YAFLogo

icnsupport
  • icnsupport
  • 50.2% (Neutral)
  • YAF Forumling Topic Starter
2012-12-30T15:20:24Z
Hello folks,

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

Sponsor
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer
Users browsing this topic