Hello, I think I have messed up my User database relationships and would like to know if it is possible to fix them...a little background:  We needed to delete quite a few users from the database...I am quite new to DNN and thought I could delete them from the dbo.Users table (which I find out is horribly wrong now) and since then I have run into major problems.  I finally am at the point now, where my aspnet_users, aspnet_membership, and dbo.Users database all contain all the same user accounts and same number of rows.  My problem now is that if I add a user, I get a Error: Add New User is currently unavailable. However, the user is added to all three tables successfully-and login works fine.  When I try to delete that user I just added, I get an "Error Deleting Users" and the user is dropped off the list, but only actually deleted from the dbo.users table.  It still remains in the aspnet_users and aspnet_membership tables.  Anyone have any ideas on this?  This has been driving me nuts.  Thanks in advance for any help!  Another interesting point is that the add new user error only appears when the "Notify" box is checked.

I thought about that...this is how I checked:

SELECT     * FROM  UserProfile WHERE     (UserID NOT IN (SELECT     UserID  FROM          Users))

and also...

SELECT     * FROM  UserPortals WHERE     (UserID NOT IN (SELECT     UserID  FROM          Users))

And it seems that both returns no results and appear to have only the proper entries in them.  I went from almost 3000 users down to ~950 so it is usually decently noticeable when there is a lot of garbage left over.  There must be something still hanging out somewhere...any other ideas?

So here is the full error when adding a user in the eventlog:

ModuleId: 1066
ModuleDefId: 15
FriendlyName: Add New User
ModuleControlSource: Admin/Users/ManageUsers.ascx
AssemblyVersion: 04.09.00
Method: DotNetNuke.Entities.Users.UserInfo.GetProperty
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Entities.Users.UserInfo.GetProperty(String strPropertyName, String strformat, CultureInfo formatProvider, UserInfo AccessingUser, Scope CurrentScope, Boolean& PropertyNotFound) at DotNetNuke.Services.Tokens.BaseCustomTokenReplace.replacedTokenValue(String strObjectName, String strPropertyName, String strformat) at DotNetNuke.Services.Tokens.BaseTokenReplace.ReplaceTokens(String strSourceText) at DotNetNuke.Services.Localization.Localization.GetSystemMessage(String strLanguage, PortalSettings objPortal, String MessageName, UserInfo objUser, String ResourceFile, ArrayList Custom, String CustomCaption, Int32 AccessingUserID) at DotNetNuke.Services.Mail.Mail.SendMail(UserInfo user, MessageType msgType, PortalSettings settings) at DotNetNuke.Entities.Modules.UserModuleBase.CompleteUserCreation(UserCreateStatus createStatus, UserInfo newUser, Boolean notify, Boolean register) at DotNetNuke.Modules.Admin.Users.ManageUsers.UserCreateCompleted(Object sender, UserCreatedEventArgs e) --- End of inner exception stack trace ---

Funny thing is that even though when you delete a user and it says "Error deleting User" the event log shows that the user was deleted fine.  Also, I noticed that  I had said that it was deleting the user only from dbo.Users...that is not the case...the user is actually deleted properly from those 3 tables, if not more of them, but still throws that error.  My primary issue is the exception on adding a user and getting the above error, I could even live with the "Error deleting user" error.  It seems that the exception is thrown when the profile properties are pulled to send the "New registration e-mail".  I thought maybe this was an error caused by the e-mail server, but I have other domains working fine and also if I go and send a test e-mail through Host settings, that works fine.