U4-3211 - User.GetAllByEmail has malformatted SQL in !useExactMatch branch

Created by Randy McCluer 22 Oct 2013, 02:14:37 Updated by Shannon Deminick 21 Jun 2017, 07:58:15

Looks like maybe there was a string.format call in some older version, perhaps.

dr = SqlHelper.ExecuteReader("Select id from umbracoUser where userEmail LIKE {0} @email", SqlHelper.CreateParameter("@email", String.Format("%{0}%", email)));

Not sure if this code will remain after new User API is available, so may be irrelevant.


Sebastiaan Janssen 22 Oct 2013, 06:34:12

What's the problem and how does it manifest itself?

Randy McCluer 22 Oct 2013, 17:41:44

If you call GetAllByEmail with useExactMatch==false, you get a sql exception due to syntax error.

Shannon Deminick 21 Jun 2017, 07:58:15

Closing issue due to inactivity - see blog post for details https://umbraco.com/blog/issue-tracker-cleanup/

Priority: Normal

Type: Bug

State: Closed


Difficulty: Normal


Backwards Compatible: True

Fix Submitted:

Affected versions: 6.2.0

Due in version:


Story Points: