Skip to main content

We have one user where their personal profile is not loaded, when looking in Options - User Profile, all the functionality options are greyed out, Reset, Save Profile etc.as per attached image.

All other users with same base profile have no issue and personal profiles are working. 

Both Profiles are enabled.

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

Reply


Terms & ConditionsCookie settings