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