Description:
Can't use the following ASP.NET 2.0 built-in Membership provider-method in MySQL
Connector/Net 5.1.4.
Public Shared Function FindUsersByEmail(ByVal emailToMatch As String, ByVal pageIndex As
Integer, ByVal pageSize As Integer, ByRef totalRecords As Integer) As
System.Web.Security.MembershipUserCollection
Member of: System.Web.Security.Membership
The following errormessage appears:
An exception occurred. Please check the Event Log. vid
System.Web.Administration.WebAdminPage.CallWebAdminHelperMethod(Boolean isMembership,
String methodName, Object[] parameters, Type[] paramTypes) vid
System.Web.Administration.SecurityPage.SearchForUsers(Object sender, EventArgs e, Repeater
repeater, GridView dataGrid, DropDownList dropDown, TextBox textBox) vid
ASP.security_users_manageusers_aspx.SearchForUsers(Object sender, EventArgs e) vid
System.Web.UI.WebControls.Button.OnClick(EventArgs e) vid
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) vid
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(St
ring eventArgument) vid System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) vid
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) vid
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean
includeStagesAfterAsyncPoint)
This is what the Event-log printed:
An exception occurred communicating with the data source.
Action: FindUsersByEmail
Exception: MySql.Data.MySqlClient.MySqlException: Parameter '?EmailSearch' has already
been defined.
vid MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value,
Int32 index)
vid MySql.Data.MySqlClient.MySqlParameterCollection.Add(String parameterName,
MySqlDbType dbType, Int32 size)
vid MySql.Web.Security.MySQLMembershipProvider.FindUsersByEmail(String emailToMatch,
Int32 pageIndex, Int32 pageSize, Int32& totalRecords)
Mer information finns i Hjälp- och supportcenter på sidan
http://go.microsoft.com/fwlink/events.asp.
How to repeat:
Use the method "Membership.FindUsersByEmail()" to find users registered.
The method "Membership.FindUsersByName()" on the other hand does NOT throw any Exception.
The latter also correctly supports wildcard characters.
Suggested fix:
This is what the Event-log printed:
An exception occurred communicating with the data source.
Action: FindUsersByEmail
Exception: MySql.Data.MySqlClient.MySqlException: Parameter '?EmailSearch' has already
been defined.
vid MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value,
Int32 index)
vid MySql.Data.MySqlClient.MySqlParameterCollection.Add(String parameterName,
MySqlDbType dbType, Int32 size)
vid MySql.Web.Security.MySQLMembershipProvider.FindUsersByEmail(String emailToMatch,
Int32 pageIndex, Int32 pageSize, Int32& totalRecords)
Mer information finns i Hjälp- och supportcenter på sidan
http://go.microsoft.com/fwlink/events.asp.
