| 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: | |
| 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 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.

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.