YAFLogo

ChrisMaga
  • ChrisMaga
  • 57.2% (Neutral)
  • YAF Camper Topic Starter
7 years ago
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.

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?

View All Posts by User
Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
7 years ago
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)
View All Posts by User
ChrisMaga
  • ChrisMaga
  • 57.2% (Neutral)
  • YAF Camper Topic Starter
7 years ago
Your are right.

It seems my database user didn't have permissions, and I had to fix it.

It works great.

Thanks

View All Posts by User
Similar Topics
Users browsing this topic