Bug #41654 FindProfilesByUserName error into Connector .NET
Submitted: 20 Dec 2008 10:56 Modified: 4 Mar 2009 14:31
Reporter: Duff McKagan Email Updates:
Status: Closed Impact on me:
Category:Connector / NET Severity:S1 (Critical)
Version:5.2.5 OS:Any
Assigned to: CPU Architecture:Any
Tags: 5.2.5, C#, connector, profile

[20 Dec 2008 10:56] Duff McKagan
Thres'a an error into ProfileProvider class at private ProfileInfoCollection GetProfiles(...) function.
The column of the final table is named "lastUpdatdDate" (there's no E) insted the correct "lastUpdatedDate".

How to repeat:
Use this approach:

MySQLProfileProvider pp = new MySQLProfileProvider();
configProvider = new System.Collections.Specialized.NameValueCollection();
configProvider.Add("connectionStringName", "LocalMySqlServer");
configProvider.Add("applicationName", "/");
configProvider.Add("name", "Prof");
pp.Initialize(configProvider["name"], configProvider);
ProfileProviderCollection colProfileProviders = new ProfileProviderCollection();
int size = 0;
string userName = "Duff";
ProfileInfoCollection colProf = pp.FindProfilesByUserName(System.Web.Profile.ProfileAuthenticationOption.Authenticated, userName, 0, 1, out size);

The FindProfilesByUserName(...) return a column error!

Suggested fix:
Recompile the source with the correct name of the colum ("lastUpdatedDate").
[20 Dec 2008 11:47] MySQL Verification Team
Changing category to Connector .NET
[12 Feb 2009 13:47] Tonci Grgin
Hi Duff and thanks for your report.

Truly, spelling error is still there in latest sources in trunk:
  ProfileProvider.cs, Ln:679, reader.GetDateTime("lastUpdatdDate"),

Thanks for spotting this and for your interest in MySQL.
[3 Mar 2009 21:11] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

[3 Mar 2009 21:15] Reggie Burnett
fixed in 5.2.6
[4 Mar 2009 14:32] Tony Bedford
An entry was added to the 5.2.6 changelog:

There was an error in the ProfileProvider class in the private ProfileInfoCollection GetProfiles() function. The column of the final table was named “lastUpdatdDate” ('e' is missing) instead of the correct “lastUpdatedDate”.