Greetings...
If you have access to SQL Query Analyzer, this script will update her userid for you ( you'll have to notify her of the change ). Note that this SQL handles the DNN forums too... if you don't use them, take this bit out ( highlighted ).
This should not cause an error... and should be considered a bug, in my estimation. Please feel free to log this problem at http://support.dotnetnuke.com. We appreciate your help.
Cheers
DECLARE @OldUsername varchar(50)
DECLARE @NewUsername varchar(50)
SET @OldUsername='enter old username here'
SET @NewUsername='enter new username here'
BEGIN TRAN
update aspnet_users
set UserName = @NewUsername, LoweredUsername=lower(@NewUsername)
where lower(UserName)=lower(@OldUsername)
IF @@ROWCOUNT=0
PRINT 'User ' + @OldUsername + ' not found in aspnet_users table.'
ELSE
PRINT 'User ' + @OldUsername + ' changed to ' + @NewUsername + ' in aspnet_users table.'
update users
set Username = @NewUsername
where lower(UserName)=lower(@OldUsername)
IF @@ROWCOUNT=0
PRINT 'User ' + @OldUsername + ' not found in users table.'
ELSE
PRINT 'User ' + @OldUsername + ' changed to ' + @NewUsername + ' in users table.'
update forum_users
set alias=@NewUsername
where lower(alias)=lower(@OldUsername)
IF @@ROWCOUNT=0
PRINT 'User ' + @OldUsername + ' not found in forum_users table.'
ELSE
PRINT 'User ' + @OldUsername + ' changed to ' + @NewUsername + ' in forum_users table.'
If @@ERROR=0
BEGIN
COMMIT TRAN
PRINT 'username change committed'
END
ELSE
BEGIN
ROLLBACK TRAN
PRINT 'username change rolled back'
END
GO