YAFLogo

netghost
  • netghost
  • 80.6% (Honored)
  • YAF Lover Topic Starter
10 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
10 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