Bug #28648 bug in user creation
Submitted: 24 May 2007 10:54 Modified: 6 Jun 2007 10:31
Reporter: Steffen Rathsack Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:5.1.1.0 OS:Windows (xp pro sp2)
Assigned to: CPU Architecture:Any
Tags: roleprovider, user creation

[24 May 2007 10:54] Steffen Rathsack
Description:
(Framework 2.0, mysql 5.0.41)

if I create a user from the Memberchip roleprovider it works fine.
but if i return to the "Security" Page after creation it shows something like this 

"An exception occurred. Please check the Event Log."

Eventlog: 

An exception occurred communicating with the data source.

Action: GetAllUsers

Exception: MySql.Data.MySqlClient.MySqlException: Parameter '?ApplicationName' has already been defined.
   bei MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Int32 index)
   bei MySql.Data.MySqlClient.MySqlParameterCollection.Add(String parameterName, MySqlDbType dbType, Int32 size)
   bei MySql.Web.Security.MySqlMembershipProvider.GetAllUsers(Int32 pageIndex, Int32 pageSize, Int32& totalRecords)

How to repeat:
go to the Memberchip Roleprovider configuration page ("asp-net Configuration" Button in your website in Visual studio 2005)

-> click Security
-> create user
-> fill in user data
-> press the creation button
-> go back to Security page

Suggested fix:
i looked into the mysql_membership table and see that the Applicationname of the new user is "/" changed it to the name of the related site e.g. "/testside" an it works.
[24 May 2007 21:45] 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/27315
[24 May 2007 21:45] Reggie Burnett
Fixed in 5.1.2
[6 Jun 2007 10:31] MC Brown
A note has been added to the 5.1.2 changelog.