Not a bug customer user field display issue

Affected version
2.1.5

jimcaldwell

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
------------------------------------------------------------------------

None
user_field_choice.genetic_mutation_1_donotknow
user_field_choice.genetic_mutation_1_donothavecf
Other
F508del
G542X
G551D
user_field_choice.genetic_mutation_1_N1303K
user_field_choice.genetic_mutation_1_W1282X
user_field_choice.genetic_mutation_1_R117H
user_field_choice.genetic_mutation_1_R553X
user_field_choice.genetic_mutation_1_1717minus1GminusgtA
user_field_choice.genetic_mutation_1_621plus1GminusgtT
user_field_choice.genetic_mutation_1_2789plus5GminusgtA
user_field_choice.genetic_mutation_1_3849plus10kbCminusgtT
user_field_choice.genetic_mutation_1_R1162X
user_field_choice.genetic_mutation_1_2183AAminusgtG
user_field_choice.genetic_mutation_1_CFTRdele2comma3
user_field_choice.genetic_mutation_1_G85E
user_field_choice.genetic_mutation_1_3120plus1GminusgtA
user_field_choice.genetic_mutation_1_I507del
user_field_choice.genetic_mutation_1_1898plus1GminusgtA
user_field_choice.genetic_mutation_1_3659delC
user_field_choice.genetic_mutation_1_R347P
user_field_choice.genetic_mutation_1_D1152H
user_field_choice.genetic_mutation_1_R560T
user_field_choice.genetic_mutation_1_3272minus26AminusgtG
user_field_choice.genetic_mutation_1_Q493X
user_field_choice.genetic_mutation_1_E60X
user_field_choice.genetic_mutation_1_R334W
user_field_choice.genetic_mutation_1_394delTT
user_field_choice.genetic_mutation_1_2184insA
user_field_choice.genetic_mutation_1_5T
user_field_choice.genetic_mutation_1_3905insT
user_field_choice.genetic_mutation_1_Y1092X
user_field_choice.genetic_mutation_1_A455E
user_field_choice.genetic_mutation_1_2184delA
user_field_choice.genetic_mutation_1_R1066C
user_field_choice.genetic_mutation_1_1078delT
user_field_choice.genetic_mutation_1_1154insTC
user_field_choice.genetic_mutation_1_R1158X
user_field_choice.genetic_mutation_1_2183delAAminusgtG
user_field_choice.genetic_mutation_1_R347H
user_field_choice.genetic_mutation_1_S1251N
user_field_choice.genetic_mutation_1_L206W
user_field_choice.genetic_mutation_1_S549N
user_field_choice.genetic_mutation_1_M1101K
user_field_choice.genetic_mutation_1_711plus1GminusgtT
user_field_choice.genetic_mutation_1_Y122X
user_field_choice.genetic_mutation_1_2143delT
user_field_choice.genetic_mutation_1_S945L
user_field_choice.genetic_mutation_1_I148T
user_field_choice.genetic_mutation_1_R117C
user_field_choice.genetic_mutation_1_V520F
user_field_choice.genetic_mutation_1_S1235R
user_field_choice.genetic_mutation_1_T338I
user_field_choice.genetic_mutation_1_P67L
user_field_choice.genetic_mutation_1_G1244E
user_field_choice.genetic_mutation_1_G178R
user_field_choice.genetic_mutation_1_1677delTA
user_field_choice.genetic_mutation_1_R352Q
user_field_choice.genetic_mutation_1_711plus5GminusgtA
user_field_choice.genetic_mutation_1_R668C
user_field_choice.genetic_mutation_1_S549R
user_field_choice.genetic_mutation_1_A559T
user_field_choice.genetic_mutation_1_L1077P
user_field_choice.genetic_mutation_1_W1089X
user_field_choice.genetic_mutation_1_I1027T
user_field_choice.genetic_mutation_1_G576A
user_field_choice.genetic_mutation_1_M470V
user_field_choice.genetic_mutation_1_3120GminusgtA
user_field_choice.genetic_mutation_1_R75X
user_field_choice.genetic_mutation_1_W846X
user_field_choice.genetic_mutation_1_E585X
user_field_choice.genetic_mutation_1_1811plus1dot6kbAminusgtG
user_field_choice.genetic_mutation_1_3876delA
user_field_choice.genetic_mutation_1_D1270N
user_field_choice.genetic_mutation_1_Q220X
user_field_choice.genetic_mutation_1_2307insA
user_field_choice.genetic_mutation_1_D110H
user_field_choice.genetic_mutation_1_4016insT
user_field_choice.genetic_mutation_1_4382delA
user_field_choice.genetic_mutation_1_I336K
user_field_choice.genetic_mutation_1_R1066H
user_field_choice.genetic_mutation_1_2347delG
user_field_choice.genetic_mutation_1_L997F
user_field_choice.genetic_mutation_1_K710X
user_field_choice.genetic_mutation_1_E822X
user_field_choice.genetic_mutation_1_L1065P
user_field_choice.genetic_mutation_1_Q552X
user_field_choice.genetic_mutation_1_R74W
user_field_choice.genetic_mutation_1_2622plus1GminusgtA
user_field_choice.genetic_mutation_1_2789plus2insA
user_field_choice.genetic_mutation_1_E92X
user_field_choice.genetic_mutation_1_Q39X
user_field_choice.genetic_mutation_1_R75Q
user_field_choice.genetic_mutation_1_D579G
user_field_choice.genetic_mutation_1_E831X
user_field_choice.genetic_mutation_1_3007delG
user_field_choice.genetic_mutation_1_405plus1GminusgtA
user_field_choice.genetic_mutation_1_406minus1GminusgtA
user_field_choice.genetic_mutation_1_711plus3AminusgtG
user_field_choice.genetic_mutation_1_Q1313X
user_field_choice.genetic_mutation_1_R709X
user_field_choice.genetic_mutation_1_2711delT
user_field_choice.genetic_mutation_1_4005plus1GminusgtA
user_field_choice.genetic_mutation_1_574delA
user_field_choice.genetic_mutation_1_1525minus1GminusgtA
user_field_choice.genetic_mutation_1_1812minus1GminusgtA
user_field_choice.genetic_mutation_1_I1234V
 

Jeremy P

XenForo developer
Staff member
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.
 
Top