YAFLogo

Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • YAF Leader Topic Starter YAF Version: YAF 3.1.16
10 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: 3.0.3
10 years ago
Sorry this was my mistake i rolled back to previous version. Issue is fixed in change set
a267118ed645
squirrel
10 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
10 years ago
That did the trick, 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