| Bug #41654 | FindProfilesByUserName error into Connector .NET | ||
|---|---|---|---|
| Submitted: | 20 Dec 2008 11:56 | Modified: | 4 Mar 15:31 |
| Reporter: | Duff McKagan | ||
| Status: | Closed | ||
| Category: | Connector/Net | Severity: | S1 (Critical) |
| Version: | 5.2.5 | OS: | Any |
| Assigned to: | Target Version: | ||
| Tags: | profile, 5.2.5, C#, connector | ||
| Triage: | D2 (Serious) | ||
[20 Dec 2008 12:47]
Miguel Solorzano
Changing category to Connector .NET
[12 Feb 14: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 22: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: http://lists.mysql.com/commits/68147
[3 Mar 22:15]
Reggie Burnett
fixed in 5.2.6
[4 Mar 15: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”.
Description: 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(); colProfileProviders.Add(pp); colProfileProviders.SetReadOnly(); 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").