I have a problem with User DB Relationships. It appears that the old style tables (UserPortals and UserProfile) are missing a field which is causing the error below .
It seems like registration is working fine when it is set to public. The user is created, and is able to log in and everything. However, when it is set to "Verified", it doesn't appear to be creating the user properly in the database, causing the user to be placed in the database, but it appears that it doesn't complete the registration process. The user is unable to log into the site, and doesn't receive any sort of registration email or anything.
If I try to delete the users, his email is deleted from dbo.Users but not from dbo.aspnet_Membership. I check this with:
SELECT * (or DELETE) from dbo.aspnet_Membership
where email not in
(select email from dbo.Users)
The problem seem similar to this:
in fact if I run these scripts below, I have 10.884 entries:
SELECT * FROM UserProfile WHERE (UserID NOT IN (SELECT UserID FROM Users))
and also... (13 entries)
SELECT * FROM UserPortals WHERE (UserID NOT IN (SELECT UserID FROM Users))
What are the difference between old and new UserPortals and UserProfile Tables?
How can I check my Tables to verify the integrity?
Is it possible to correct the database errors and change it to the new UserPortals and UserProfile tables?
Thank you very much for your support,
any help is apreciated
UserAgent:Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko
InnerException:Object reference not set to an instance of an object.
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 propertyName, String format, CultureInfo formatProvider, UserInfo accessingUser, Scope currentScope, Boolean& propertyNotFound) 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.Register.CreateUser() in \httpdocs\DesktopModules\Admin\Security\Register.ascx.cs:line 412 --- End of inner exception stack trace ---