YetAnotherForum升级sql问题

Question

我们一直在使用YAF自mmh..2001，也许2002我猜？ 和我们的论坛版本是1.7，有超过250万用户注册，这使得大量的数据...

我已经做了一个实际的数据库的副本，我试图升级这个安装到版本2.1.1， ，但我得到的MSSQL/tables.sql文件SQL错误试图升级的时候：

http://i57.tinypic.com/2wgx56o.jpg][1 http://i57.tinypic.com/2wgx56o.jpg

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]'Wink 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

我一定要修改一些表中的字段？ 我的另一个解决方案是手动导入每一个用户，论坛等......但这需要相当长的时间..所以我真的很期待让安装升级数据库automaticaly

Answer 1

你可以理论上做到以下几点;

Backup DB (again) 
Script the index to a new window. 
Drop the index. 
Apply the udpate. 
Check the data does not have nulls and fix if required. 
Recreate the index.