Question

Personal Profile Unavailable

I
Rank
Userlevel 2
Badge +4
  • Istar
  • Do Gooder (Customer)
  • 6 replies

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.

1 Attachment

3 replies

D
Rank
Userlevel 5
Badge +11

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

I
Rank
Userlevel 2
Badge +4

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

D
Rank
Userlevel 5
Badge +11

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