YAFLogo

Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • YAF Leader Topic Starter YAF Version: YAF 3.1.16
11 years ago
Upgrading to yafnet_ed82d60d0814 and I received this error. Both Attempt Full Search and BBCode checkboxes were unchecked.

My site is up and running, but when I try to complete /install I receive this error. It's probably something simple, but very tired.

Server Error in '/' Application.

FILE:

mssql/indexes.sql

ERROR:

Invalid object name 'dbo.sys.indexes'.

STATEMENT:

IF NOT EXISTS (SELECT 1 FROM dbo.sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[yaf_Message]') AND name = N'IX_yaf_Message_Posted_Desc')

CREATE NONCLUSTERED INDEX [IX_yaf_Message_Posted_Desc] ON [dbo].[yaf_Message]

(

[Posted] DESC

) ON [PRIMARY]

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/indexes.sql

ERROR:

Invalid object name 'dbo.sys.indexes'.

STATEMENT:

IF NOT EXISTS (SELECT 1 FROM dbo.sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[yaf_Message]') AND name = N'IX_yaf_Message_Posted_Desc')

CREATE NONCLUSTERED INDEX [IX_yaf_Message_Posted_Desc] ON [dbo].[yaf_Message]

(

[Posted] DESC

) ON [PRIMARY]

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: FILE:

mssql/indexes.sql

ERROR:

Invalid object name 'dbo.sys.indexes'.

STATEMENT:

IF NOT EXISTS (SELECT 1 FROM dbo.sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[yaf_Message]') AND name = N'IX_yaf_Message_Posted_Desc')

CREATE NONCLUSTERED INDEX [IX_yaf_Message_Posted_Desc] ON [dbo].[yaf_Message]

(

[Posted] DESC

) ON [PRIMARY]]

YAF.Classes.Data.LegacyDb.system_initialize_executescripts(String script, String scriptFile, Boolean useTransactions) +567

YAF.Core.Services.InstallUpgradeService.ExecuteScript(String scriptFile, Boolean useTransactions) +247

YAF.Core.Services.InstallUpgradeService.UpgradeDatabase(Boolean fullText, Boolean upgradeExtensions) +78

YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) +1353

System.Web.UI.WebControls.Wizard.OnNextButtonClick(WizardNavigationEventArgs e) +111

System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +401

System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +16

System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37

System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +114

System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +159

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) +35

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18010

Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
11 years ago
Sorry this was my mistake i rolled back to previous version. Issue is fixed in change set

a267118ed645

squirrel
11 years ago
I was going to mention this as I encountered having to roll it back to remove the dbo. from the sql as it failed on the upgrade I just performed.


If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • YAF Leader Topic Starter YAF Version: YAF 3.1.16
11 years ago
That did the trick, thanks.