netghost
  •  netghost
  • 80.6% (Honored)
  • YAF Lover Topic Starter
2012-04-25T20:17:01Z
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
2012-04-26T10:26:05Z
SOLVED :cheesy: :-d
mnazirp
2012-10-22T04:15:45Z
Can You please show me, how to solve this,
because I have same problem here,.

Thaks in advance

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