Issue while Upgrading from 1.7 · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

10 years ago

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)

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

10 years ago

btw, i have checked the "Attempt to Install FullText Search Support" checkbox, can it be the source of the problem ?

10 years ago

as said here ,

i just dropped the index that was causing this error and everything went well, untill i got another error..