shide
  •  shide
  • 80.6% (Honored)
  • YAF Lover Topic Starter
2014-03-10T16:29:48Z
Hi,

We've been using yaf since mmh..2001, maybe 2002 ?
and the version of our forums is 1.7 with more than 2.5 million users registered, wich makes a lot of data...

I've made a copy of the actual DB and i'm trying to upgrade this installation to version 2.1.1,
but i get that SQL error on the mssql/tables.sql file when trying to upgrade :

http://i57.tinypic.com/2wgx56o.jpg (http://i57.tinypic.com/2wgx56o.jpg)
Quote:


URL : http://localhost/Forums2014/forum/install/default.aspx

FILE:
mssql/tables.sql

ERROR:
The index '_dta_index_yaf_Message_9_757577737__K2_K1_K12_K6_4_5_7_8_10_11' is dependent on column 'IP'.
ALTER TABLE ALTER COLUMN IP failed because one or more objects access this column.

STATEMENT:
if exists (select top 1 1 from sys.columns where object_id=object_id('[dbo].[yaf_Message]') and name='IP' and precision < 39)
begin
alter table [dbo].[yaf_Message] alter column [IP] varchar(39) not null
end

YAF.Classes.Data.LegacyDb.system_initialize_executescripts(String script, String scriptFile, Boolean useTransactions) +1540
YAF.Core.Services.InstallUpgradeService.ExecuteScript(String scriptFile, Boolean useTransactions) +188
YAF.Core.Services.InstallUpgradeService.UpgradeDatabase(Boolean fullText, Boolean upgradeExtensions) +205
YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) +1559
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +584
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +84
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804



do i have to modify some table fields ?
the other solution i have is to import manually every single user, forum etc...but it would take quite some time :cry: ..
So i'm realy looking forward to let the install upgrade the DB automaticaly

Thanx in advance
Sponsor
shide
  •  shide
  • 80.6% (Honored)
  • YAF Lover Topic Starter
2014-03-11T08:54:25Z
btw, i have checked the "Attempt to Install FullText Search Support" checkbox, can it be the source of the problem ?
shide
  •  shide
  • 80.6% (Honored)
  • YAF Lover Topic Starter
2014-03-13T13:49:56Z
as said here ,
i just dropped the index that was causing this error and everything went well, untill i got another error..

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