XF 2.1 Change Field ID of a custom user field

[abdfahim]

I know it's written that "This is the unique identifier for this field. It cannot be changed once set.", but I badly want to change a few. Can I manually rename the field_id in xf_user_field and xf_user_field_value table? Would that work without any adverse effect?

I would create a new custom user field, but transferring the existing data from one field to another seems like a PIA.

 

[Joe Link]

Anyone know the answer to this?

 

[Paul B]

You can try to see if it works - I haven't tested it so can't confirm either way.

As always though, we wouldn't condone or be able to support direct database manipulation in this manner.

 

[Ron Natalie]

You might be better off creating a new field with a different id and writing a script to copy the data values over.

If you want to try, you have the user_field table PLUS all the values in the user_field_values table that match. You also need to go over to the phrase_map table and change the description, title, and choice fields there. That and rebuild the caches.