Hi,

We at NRL.com are experiencing the same issue: when a user joins the site everything goes fine except their roles aren't added to the aspnet_usersinroles table.

This works on our local builds but for some reason on our Production server we have issues.

Currently we are running the following SQL Script to fix it up but we would rather the site was doing this automatically, of course:

INSERT INTO aspnet_usersinroles
        SELECT aspnet_users.UserID,
            'df890364-7a14-4eda-981e-d6421f69b177'
        FROM aspnet_users
        WHERE aspnet_users.userid not in
            (
                SELECT    R.userid FROM aspnet_usersinroles as R
                    LEFT JOIN aspnet_Users as U
                    ON U.UserId = R.UserId
                WHERE    R.RoleId =
                    'df890364-7a14-4eda-981e-d6421f69b177'
            )

INSERT INTO aspnet_usersinroles
        SELECT aspnet_users.UserID,
        '804784f5-951e-4da3-af3d-2ac4ebc0c48a'
        FROM aspnet_users
        WHERE aspnet_users.userid not in
            (
                SELECT    R.userid FROM aspnet_usersinroles as R
                    LEFT JOIN aspnet_Users as U
                    ON U.UserId = R.UserId
                WHERE    R.RoleId =
                     '804784f5-951e-4da3-af3d-2ac4ebc0c48a'
            )

Where the UIDs correspond to the RoleIDs for subscribers/registered users.

Any help would be greatly appreciated.

Cheers, arron
(arron<at>cfour.com.au)