We have moved to GitHub Issues
You are viewing the read-only archive of Umbraco's issue tracker. To create new issues, please head over to GitHub Issues.
Make sure to read the blog posts announcing the move for more information.
Created by Charles Zipp 13 Oct 2013, 17:37:46 Updated by Shannon Deminick 22 Oct 2013, 22:24:58
Description When I use an email address as the user name, i get this server error when attempting to log in. I was able to use email address as user name in previous versions of umbraco.
Steps to Reproduce
If you have chrome dev tools, you will get a HTTP status code 500 on PostLogin. Below is the stack trace.
Configuration DB - SQL CE Host - Running in debug in VS2012 Browser - Chrome
Justification If this issue is not resolved, all of our users' user names would have to be reset to something without special characters. We would likely opt to not move forward until this is resolved as it adds cost to our migration. In addition, this is a loss of functionality from earlier versions.
Error Message & Stack Login failed for user somebody@gmail.com Parameter '@gmail' specified but none of the passed arguments have a property with this name (in 'WHERE ([umbracoUser].[userLogin] = 'somebody@gmail.com')')
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Parameter '@gmail' specified but none of the passed arguments have a property with this name (in 'WHERE ([umbracoUser].[userLogin] = 'somebody@gmail.com')')
Stack Trace:
at Umbraco.Core.Persistence.Database.<>c__DisplayClass1.1 args_dest) at Umbraco.Core.Persistence.Sql.Build(StringBuilder sb, List
1 args, Sql lhs)
at Umbraco.Core.Persistence.Sql.Build(StringBuilder sb, List1 args, Sql lhs) at Umbraco.Core.Persistence.Sql.Build(StringBuilder sb, List
1 args, Sql lhs)
at Umbraco.Core.Persistence.Sql.Build(StringBuilder sb, List1 args, Sql lhs) at Umbraco.Core.Persistence.Sql.Build(StringBuilder sb, List
1 args, Sql lhs)
at Umbraco.Core.Persistence.Sql.Build(StringBuilder sb, List1 args, Sql lhs) at Umbraco.Core.Persistence.Sql.Build() at Umbraco.Core.Persistence.Sql.get_SQL() at Umbraco.Core.Persistence.Database.Fetch[T1,T2,TRet](Func
3 cb, Sql sql)
at Umbraco.Core.Persistence.Repositories.UserRepository.1 source) at Umbraco.Core.Services.UserService.GetUserByUserName(String username) at Umbraco.Web.Editors.AuthenticationController.PostLogin(String username, String password) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.<GetExecutor>b__c(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.<>c__DisplayClass5.<ExecuteAsync>b__4() at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func
1 func, CancellationToken cancellationToken)
Yup we'll need to escape the '@' symbols for petapoco for these queries.
Priority: Normal
Type: Bug
State: Fixed
Assignee: Shannon Deminick
Difficulty: Normal
Category:
Backwards Compatible: True
Fix Submitted:
Affected versions: 7.0.0
Due in version: 7.0.0
Sprint:
Story Points:
Cycle: