We had our webmaster adjust our SSO to pass data to some custom user fields. Sadly he didn’t assign them the right field ID’s. Is there any way that I, on my end, can change our custom user field ID’s in (or out) of Discourse? I tried deleting all of our user fields and starting over thinking they …

Why do you need the user_fied id for?

[image] zogstrip: Why do you need the user_fied id for? How else would I direct values from the SSO payload unless I knew what the field ID’s were?

Right. I’m not familiar with that part of the code. I agree that if we’re using the id to store their value, it should be visible somewhere. As for the original question, you’ll have to reset the counter with some SQL ALTER SEQUENCE user_fields_id_seq RESTART WITH 1;

[image] zogstrip: As for the original question, you’ll have to reset the counter with some SQL ALTER SEQUENCE user_fields_id_seq RESTART WITH 1; Thank you @zogstrip ! Now would that reset the counter for existing fields, or subsequently created fields? I presume I would have to delete my fi…

That’ll reset the counter on the table. So it will only be used for subsequently created fields.

[image] zogstrip: That’ll reset the counter on the table. So it will only be used for subsequently created fields. Just did it and it worked perfectly! Many thanks!

Changing custom user field ID#

Support

Denis_Heraud (Denis Heraud) April 30, 2018, 2:57pm 8

Just did it and it worked perfectly! Many thanks!

Topic		Replies	Views
Unused TOS custom user field safe to delete? Support	3	1928	April 14, 2015
Extended Set of User Fields Resequences itself Bug	2	1288	September 15, 2015
Auto populate custom userid identifier field on user creation Support	1	567	February 6, 2019
Populating a custom user data field Support	3	798	May 22, 2023
User custom field with plugin Development	2	2064	May 5, 2017

Changing custom user field ID#

Related topics