Problem Statement: Under "Admin > Users and Roles > Users", no users are listed. (Yes, I clicked 'Search'). Old and new users are able to login and show up under the "Members" and "Unverified Users" sections; all roles show up under the "Roles" section. This functionality was working previously.

• YAF Version: v1.9.4
• IIS Version: v7.0
• .NET Version: v4.0.30319
• Windows Version: Windows NT 6.0 (Build 6002: Service Pack 2)
• SQL Server Version: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)
• Membership Provider Type: System.Web.Security.SqlMembershipProvider

What Changed: We recently moved our ASP.NET membership provider to a new database. Moving it back to the same database as YAF, however, doesn't seem to have an impact.

SQL Profile: We've ran SQL Profiler while performing a user search. The following commands are executed:

• yaf_registry_list (1 record, 'version 41')
• aspnet_Membership_GetUserByName (1 record, for current user)
• yaf_pageload (1 record)
• yaf_user_list (18 records)
• aspnet_Membership_GetUserByName (1 record, for current user)
• yaf_user_list (1 record, for current user)
• yaf_mail_list (0 records)

Manually executing these in SQL seems to return the expected data (record counts noted above).

Troubleshooting Steps: In addition to the steps taken above, we've also tried:

• "Synch all membership users", no impact.
• "New User", after creating a new user with the admin tool, we are returned to a blank "New User" form (no errors or status notificiations). The user is created properly and able to login (once approved).
• Temporarily granted the Application Pool identity full DBO privs on the membership database, no impact.

Other Issues: For the most part, the forum appears to be responding as expected. We have noticed two other issues, however, which may or may not be related:

• While events show up under the Event Log, clicking "Show" brings up an event log page without any details.
• When clicking "Version Check", we receive an "Object Moved" error.

The event log has two exceptions listed, although their times don't correspond to the admin tool.

• WebException: Object Moved error. Relates to "Version Check".
• SqlException: Missing 'yaf_prov_getuser' sproc. Note: This procedure exists.

Thoughts?

Jeremy

We've resolved this issue. It turns out the "Other Issues" were, in fact, related.

Cause: We modified our implementation of YAF to inherit from our site's Master Page Template so that the overall layout would be consistent across our site. While this worked fine, a modification to that template was resulting in a call to Page.DataBind() during the Page.PreRender event. This was interfering with YAF's own data binding. This became obvious when we noticed that dropdown lists were defaulting to their first value, a symptom we hadn't picked up on initially.

Resolution: To mitigate this, we better defined the scope of the data binding so that it didn't include the control.