我尝试从源代码安装orchard CMS.我在VS 2012中打开它,我使用的是Sql Server 2012.
我发现以下错误.
错误文字:
Setup failed: could not execute query [ select rolerecord0_.Id as Id13_,rolerecord0_.Name as Name13_ from Test_Orchard_Roles_RoleRecord rolerecord0_ where rolerecord0_.Name=@p0 ] Name:p1 – Value:Anonymous [SQL: select rolerecord0_.Id as Id13_,rolerecord0_.Name as Name13_ from Test_Orchard_Roles_RoleRecord rolerecord0_ where rolerecord0_.Name=@p0]
我找不到任何解决此错误的方法.我哪里做错了?我该如何解决这个错误?当我选择内置存储时,它会运行.另外,如果我使用内置的那个有什么缺点吗?
更新(新的错误消息)
Setup failed: could not execute query [ SELECT TOP (@p0) this_.Id as Id17_2_,this_.Number as Number17_2_,this_.Published as Published17_2_,this_.Latest as Latest17_2_,this_.Data as Data17_2_, this_.ContentItemRecord_id as ContentI6_17_2_,contentite1_.Id as Id16_0_,contentite1_.Data as Data16_0_,contentite1_.ContentType_id as ContentT3_16_0_,contenttyp4_.Id as Id18_1_,contenttyp4_.Name as Name18_1_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id left outer join Orchard_Framework_ContentTypeRecord contenttyp4_ on contentite1_.ContentType_id=contenttyp4_.Id WHERE contentite1_.Id = @p1 and this_.Published = @p2 ] Name:cp0 – Value:2 Name:cp1 – Value:True [SQL: SELECT TOP (@p0) this_.Id as Id17_2_,this_.Number as Number17_2_,this_.Published as Published17_2_,this_.Latest as Latest17_2_,this_.ContentItemRecord_id as ContentI6_17_2_,contentite1_.Id as Id16_0_,contentite1_.Data as Data16_0_,contentite1_.ContentType_id as ContentT3_16_0_, contenttyp4_.Id as Id18_1_,contenttyp4_.Name as Name18_1_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id left outer join Orchard_Framework_ContentTypeRecord contenttyp4_ on contentite1_.ContentType_id=contenttyp4_.Id WHERE contentite1_.Id = @p1 and this_.Published = @p2]
解决方法
在创建SQL Server数据库之前,将collocation设置为Latin1_General_100_CI_AS
执行此操作,右键单击SQL Server管理工具上的数据库注释,然后单击“新建数据库”.当您看到“新建数据库”窗口时,键入数据库名称,然后单击“新建数据库”窗口左侧的“选项”选项卡.
您将在New Database窗口中看到Collocation combobox top.将默认值更改为Latin1_General_100_CI_AS.然后再次运行Orchard设置.
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|