社区服务器用户名问题 - 用户名成员在店里没有发现不存在 [英] Community server Username issue - User Username not found in membership store does not exist
问题描述
我有一个错误，从每当googlesitemap.ashx是在一个特定的sectionID走过我们的社区服务器安装经常存在的。我怀疑用户名已经被修正，但职位没有带重新缓存，以反映这一点。
I have an error occuring frequently from our community server installation whenever the googlesitemap.ashx is traversed on a specific sectionID. I suspect that a username has been amended but the posts havn't recached to reflect this.
有没有一种方式可以检查由数据库上执行select语句的数据integruity，或者是有没有办法强制数据库重新缓存？
Is there a way a can check the data integruity by performing a select statement on the database, alternatively is there a way to force the database to recache?
推荐答案
此错误可能是由社区服务器如果发现不在MemberRoleProfileProvider的实例的用户被抛出。
This error could be thrown by community server if it finds users that aren't in the instance of MemberRoleProfileProvider.
请参阅CommunityServer.Users AddMembershipDataToUser（）的作为例子
See CommunityServer.Users AddMembershipDataToUser() as an example
更新：
UPDATE:
我被注意到，用户名是存储在两个表解决了这个问题我的情况。原来不知怎么的用户名是在每个表中的不同。手动更新这样的名字是相同的固定这个问题。
I Solved this problem for my case by noticing that the usernames are stored in two tables - cs_Users and aspnet_Users. Turns out somehow the username was DIFFERENT in each table. Manually updating so the names were the same fixed this problem.
此外，用户会漏掉成员的以下行的存储过程的 cs_Membership_GetUsersByName 的：
Also, the user would left out of membership in the following line of the stored procedure cs_Membership_GetUsersByName:
INSERT INTO @tbUsers
SELECT UserId
FROM dbo.aspnet_Users ar, @tbNames t
WHERE LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @ApplicationId
的@tbNames是名称表来自cs_Users（？）在一些点，因此，用户名不匹配和用户不是在该结果插入以后。
The @tbNames is a table of names comes from cs_Users(?) at some point and therefore the usernames didn't match and user was not inserted in to the result later on.
另请参阅： http://dev.communityserver.com/forums /t/490899.aspx?PageIndex=2
这篇关于社区服务器用户名问题 - 用户名成员在店里没有发现不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
