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.

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
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
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)
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
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
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