YAFLogo

netghost
  • netghost
  • 80.6% (Honored)
  • YAF Lover Topic Starter
11 years ago
i tried installing yaf 1.9.6.1 using my previous database from yaf 1.9.5 but i am getting the following error below


Quote:


Stack Trace:


[Exception: 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']
YAF.Classes.Data.LegacyDb.system_initialize_executescripts(String script, String scriptFile, Boolean useTransactions) in D:\YAF-v1.9.6.1-RTW-SRC\YAF.Classes\YAF.Classes.Data\mssql\LegacyDb.cs:7656
YAF.Install._default.ExecuteScript(String scriptFile, Boolean useTransactions) +360
YAF.Install._default.UpgradeDatabase(Boolean fullText) +77
YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) +1290
System.Web.UI.WebControls.Wizard.OnNextButtonClick(WizardNavigationEventArgs e) +115
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +413
System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +19
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +125
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +167
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Sponsor

netghost
  • netghost
  • 80.6% (Honored)
  • YAF Lover Topic Starter
11 years ago
SOLVED :cheesy: :-d
mnazirp
  • mnazirp
  • 50.2% (Neutral)
  • YAF Forumling
10 years ago
Can You please show me, how to solve this,
because I have same problem here,.

Thaks in advance
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