Not a bugcustomer user field display issue

New member

We have 2 personal custom fields, called genetic_mutation_1 and genetic_mutation_2. When we moved to xenforo in the last six months for vBulletin, the definitions were migrated but not the individual. After some investigating, I determined that those were lost during an upgrade on the vBulletin. My plan was to use an older database and write a script to adapt the settings to Xenforo.

First, I needed to populate the genetic mutations for both genetic_mutatation_1 and genetic_mutation_2. Since there are 164 entries, I created the json and manually changed the xf_user_field.field_choices field. I then mapped the users from the previous database to the new database, and then updated xf_user_field_data.field_value for each respective user, using the key from the choices. All seemed to go well, and I think the mapping has gone well other the display in the user search field (admin) and also the popup for these custom values in the user profile show like this below. There seems to be some mapping I am missing or a cache that needs updated, in order to remove the prefix user_field_choice.genetic_mutation_1_ and user_field_choice.genetic_mutation_2_

Thanks for your help
------------------------------------------------------------------------

XenForo developer

Yes, custom user field values are cached to the custom_fields column on the xf_user_profile table. Rebuilding users in your control panel will rebuild the cache, or alternatively you can adapt your script to run \XF\Repository\UserField::rebuildUserFieldValuesCache() for each updated user.