Bug #36157 Calling "GetNumberOfUsersOnline" in Membership throw error
Submitted: 16 Apr 2008 19:59 Modified: 16 May 2008 13:16
Reporter: Lynn Eriksen Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:5.1.5 OS:Any
Assigned to: CPU Architecture:Any

[16 Apr 2008 19:59] Lynn Eriksen
Description:
When calling the method 'GetNumberOfUsersOnline' for the membership provider there is an exception thrown due to a missing parameter.

This is around line 755 in the C# code.

How to repeat:
Same as above.

Suggested fix:
Add the follwing parameter:

cmd.Parameters.Add("?LastActivityUpdate", MySqlDbType.DateTime).Value = compareTime;
[25 Apr 2008 19:43] 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/46047
[25 Apr 2008 19:44] Reggie Burnett
Fixed in 5.1.6, not a bug in 5.2+
[16 May 2008 13:16] MC Brown
A note has been added to the 5.1.6 changelog: 

When calling GetNumberOfUsersOnline an exception is raised on the submitted query due to a missing parameter