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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.