Hi,

We are using umbraco version 7.2.8, on the first install when we want to create "Document Type" we had an error like

Server Error in '/' Application. Invalid column name 'id'. [SqlException (0x80131904): Invalid column name 'id'.]

and we execute the following query

ALTER DATABASE DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE DBName COLLATE Latin1_General_CI_AS
ALTER DATABASE DBName SET MULTI_USER

and problem solved.

But the interesting part is when SQL collation is "Latin1_General_CI_AS" we couldn't create any Umbraco User contains "i" letter. For example when creating test1, test2, user1, user2 there is no problem. But if it contains "i" like william, ali, veli, test1i umbraco throws error and says "check log". And log says:

System.Configuration.Provider.ProviderException: Could not find user in the membership provider with login name william  

and if we change database collation to "Turkish_CI_AS" this problem is also solved. And users with "i" could be created. But this time, when collation is "Turkish_CI_AS" the first error (Invalid 'id') occurs again.

We try other collations, but we couldn't find the solution. What can we do to solve both errors?

Any ideas?

Thanks.