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

Scott Willhite, Co-Founder DNN