Personal Profile Unavailable

Hi @Istar,

Please run the below queries and check whether the user has more than one default personal profile.

SELECT * from fndrr_user_client_profile_tab t WHERE ordinal=0 AND user_id='USERID'; 

SELECT * FROM fndrr_client_profile_value_tab WHERE profile_id IN (SELECT Profile_ID from fndrr_user_client_profile_tab t WHERE ordinal=0 AND user_id='USERID');

Thank you

Thankyou, the user has 7 entries, I presume 6 need to be removed.

Hi @Istar,

Yes, Please use the below queries.

DELETE FROM fndrr_client_profile_value_tab  WHERE profile_id in ('…, ');

DELETE FROM fndrr_user_client_profile_tab WHERE profile_id in ('...');

DELETE from fndrr_user_client_profile_tab t WHERE profile_id in ('...');

Commit the changes.

Thank you