Hi , I have only yaf.net solution on my site and after few months, I figure it out there is a sync problem with these two tables.
When a user registered. there is only yaf_prov_profile record on db not yaf_userProfile record. and when the user update it from cp_editprofile yaf_userProfile was created with new values not from yaf_prov_Profile table values. And old values in prov_profiles overwritten by new values. So I can not get users' custom properties what I set on registration.

I try to update register.ascx.cs with the sync code on EditUsersProfile.ascx.cs as below


but at that point user does not have a username on UserList table.

Is this a normal thing on yaf.net or an issue ?

I use yaf.net 1.9.6 with .Net 4.0 and not integrate anything like dnn etc.

You should make 2 things.
1.Add user name to the methods
LegacyDb.SetPropertyValues(PageContext.PageBoardID, UserMembershipHelper.ApplicationName(), this.currentUserID, userProfile.UserName,
settingsPropertyValueCollection);

LegacyDb.SetProfileProperties(
string connectionString,
[NotNull] int boardId,
[NotNull] object appName,
[NotNull] int userID,
[NotNull] string userName,
[NotNull] SettingsPropertyValueCollection values,
[NotNull] List settingsColumnsList,
bool dirtyOnly)
And remove LegacyDb.UserList dependency.

2. Drop the FK.
[FK_{objectQualifier}UserProfile_{objectQualifier}User] foreign key (UserID) references [{databaseOwner}].[{objectQualifier}User]

I made a change like you suggested. But is it normal for yaf.net or an issue ?

You should make 2 things.
1.Add user name to the methods
LegacyDb.SetPropertyValues(PageContext.PageBoardID, UserMembershipHelper.ApplicationName(), this.currentUserID, userProfile.UserName,
settingsPropertyValueCollection);

LegacyDb.SetProfileProperties(
string connectionString,
[NotNull] int boardId,
[NotNull] object appName,
[NotNull] int userID,
[NotNull] string userName,
[NotNull] SettingsPropertyValueCollection values,
[NotNull] List settingsColumnsList,
bool dirtyOnly)
And remove LegacyDb.UserList dependency.

2. Drop the FK.
[FK_{objectQualifier}UserProfile_{objectQualifier}User] foreign key (UserID) references [{databaseOwner}].[{objectQualifier}User]

I made a change like you suggested. But is it normal for yaf.net or an issue ?

This was normal for YAF and has become an issue after you've modified the source code 🙂
But the change may be included into YAF as it obviously makes it more flexible.