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