I am having a membership site in wordpress where there are more than 10K users. Now when the user having a single word user_nicename ( http://example.com/author/james ) try to access their respective author page, then it works just perfectly fine. But when a user having user_nicename including a space character in between ( http://example.com/author/james bond ), it gets converted to this url ( http://example.com/author/james%20bond ) and redirects them to a 404 Error Page.
I have gone through some forums and everybody has suggested to modify the db value for this. Since, in my case I am having more than 10K users, its very time consuming to go to the specific table and edit the value for each particular user and moreover, I'll not prefer this solution.
Can anybody suggest me some solution for this issue?