After updating from 4.5.3 to 4.5.5 or 4.6.2, whenever I "Add New User" in Admin > User Accounts
1) I click "Add New User" to save
2) the Add New User page refreshes, i.e., it hits the server and then stays on the same page.
3) If I click "Add New User" again, I get an error:
A User Already Exists For the Username Specified. Please Register Again Using A Different Username.
The user is added to aspnet_users table, but NOT to the Users table.
This has happened on the Production host AND various dev instances.
I've tried synching the above two tables using http://blogs.snapsis.com/PermaLink,guid,591a79b3-b758-4653-af09-75c488b7d960.aspx before upgrade.
all the machine keys, db conn strings updated before running update.
This is the SQL trace after the upgrade. In my working 4.5.3 version, @portalId = 0, @p12 = [guid].
exec dbo.GetUserByUsername @PortalId=NULL,@Username=N'bearf'
declare @p12 uniqueidentifier
set @p12=NULL
exec dbo.aspnet_Membership_CreateUser
@ApplicationName=N'DotNetNuke',@UserName=N'bearf',@Password=N'DkdZByxln6mwO0RaVn/yURj2Re3krYcgxv847pa+JqU=',@PasswordSalt=N'T5cXG4+HqCIYQ8pVK/N4Sw==',@Email=N'Bear@Bear.com',@PasswordQuestion=NULL,@PasswordAnswer=NULL,@IsApproved=1,@UniqueEmail=0,@PasswordFormat=2,@CurrentTimeUtc=''2007-10-19
19:59:26:000'',@UserId=@p12 output
select @p12