博客升级到BlogEngine 3.1

花了一个下午时间把博客升级到BlogEngine 3.1了

中途遇到一个错误:

Invalid column name 'SortOrder'.

执行下面的SQL脚本成功解决了

ALTER TABLE dbo.be_Pages ADD
	SortOrder int NOT NULL CONSTRAINT DF_be_Pages_SortOrder DEFAULT 0
GO
CREATE NONCLUSTERED INDEX IX_be_Pages ON dbo.be_Pages
	(
	SortOrder
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
不允许评论