ChrisMaga
2017-01-23T22:15:48Z
Hi developers,

I am transitioning from forums v2.0.0 to v.2.2.3. I downloaded YAF.NET v2.2.3 upgrade package and reached to step 4 (install screen for upgrading forums) sucessfully. When it asks me to upgrade database to the latest version (check mark on "Upgrade BBCode Extensions, File Extensions, Topic Status Lists and Spam Words") and I click "Next", it shows me the following error:

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.

Quote:

Exception Details: System.Exception: FILE:
mssql/upgrade/views.sql

ERROR:
The REFERENCES permission was denied on the object 'yaf_UserGroup', database 'yafnet', schema 'dbo'.
Cannot find the object "yaf_UserGroup" because it does not exist or you do not have permissions.

STATEMENT:
IF NOT exists (select top 1 1 from sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[yaf_vaccess_group]') AND type in (N'V'))
EXEC sys.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'



I checked out yafnet database and "yaf_UserGroup" table is there.
Do you have any idea what could be the problem? How can I resolve this issue?
Sponsor
tha_watcha
2017-01-25T10:16:13Z
if you are sure that the dbo.yaf_UserGroup table exist then you need to check if the database user have the correct permissions (db owner)
UserPostedImage
ChrisMaga
2017-01-25T17:08:00Z
Your are right.
It seems my database user didn't have permissions, and I had to fix it.

It works great.

Thanks

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