orchard setup problem

Topics: Installing Orchard
Jul 23, 2013 at 1:49 AM
Edited Jul 23, 2013 at 9:48 AM
When I selected sql server to setup, there is something wrong,then I found the reason, my sql server's collate is Chinese_PRC_CS_AS, when I changed it to SQL_Latin1_General_CP1_CI_AS ,it works.I want to know how to resolve this trouble.
Coordinator
Jul 23, 2013 at 8:24 AM
Please file a bug.
Jul 23, 2013 at 9:48 AM
First of all Thanks to BertrandLeRoy .

I found the problem. My sql server'collate is Chinese_PRC_CS_AS,it is Case sensitive.The sql query is

select contentpar0_.Id as Id1_0_, contentpar1_.Id as Id2_1_, contentfie2_.Id as Id0_2_, contentpar0_.Name as Name1_0_, contentpar0_.Hidden as Hidden1_0_, contentpar0_.Settings as Settings1_0_, contentpar1_.Name as Name2_1_, contentpar1_.Settings as Settings2_1_, contentpar1_.ContentFieldDefinitionRecord_id as ContentF4_2_1_, contentpar1_.ContentPartDefinitionRecord_id as ContentP5_0__, contentpar1_.Id as Id0__, contentfie2_.Name as Name0_2_ from Settings_ContentPartDefinitionRecord contentpar0_ left outer join Settings_ContentPartFieldDefinitionRecord contentpar1_ on contentpar0_.Id=contentpar1_.ContentPartDefinitionRecord_id left outer join Settings_ContentFieldDefinitionRecord contentfie2_ on contentpar1_.ContentFieldDefinitionRecord_id=contentfie2_.Id

System.Data.SqlClient.SqlException: the Column 'ContentPartDefinitionRecord_id' is invalid.

The table Settings_ContentPartFieldDefinitionRecord's Column ContentPartDefinitionRecord_Id is Case sensitive.

Case sensitive, that is the problenm.