Existing fields | change order & amount of values

Maybe a dumb question between all those advanced and complex topics

Is it possible to edit existing fields without errors?

1.) What happens to the (user)data for a multi-checkbox field, if I would...:

- Add a new value
- Delete a value
- ReOrder the values


2.) What is best practice, if I want to replace ALL values of an existing select-field?
For instance I would have to change and update:

ValueOld1, ValueOld2, ValueOld3
to
1stValueNew, 2ndValueNew, 3rdValueNew


Thanks in advance.

1.) What happens to the (user)data for a multi-checkbox field, if I would...:

- Add a new value
- Delete a value
- ReOrder the values

- Nothing, use can select the new value
- Users with the value selected will reset to blank
- Nothing, just changes display order

2.) What is best practice, if I want to replace ALL values of an existing select-field?
For instance I would have to change and update:

Direct database query to #__comprofiler is probably the best approach.

krileon wrote:

2.) What is best practice, if I want to replace ALL values of an existing select-field?
For instance I would have to change and update:

Direct database query to #__comprofiler is probably the best approach.

I am asking, because I remember an older project, where I had a similar task. I don´t want to get in trouble again I don´t know exactly the error-messages, but there were a serious problem on edit-profile... i try to explain what I have done:

- a select-field with
OLDvalue1, OLDvalue2, OLDvalue3

- changed them to
NEWvalue1, NEWvalue2, NEWvalue3

- changed all comprofiler User tables and their respective field values to
NEWvalue1 etc. ...

Is this all I have to check? Are there other references to the older values?
I remember there was an error, as soon as I tried to edit a user profile with this select field.

The naff way to get rid of an error, was to ADD the OLD values again... with an additional separator/hint:

NEWvalue1
NEWvalue2
NEWvalue3
--outdated--
OLDvalue1
OLDvalue2
OLDvalue3

After all values were in the select, everything went smooth...
What is the cause of this behaviour?

Thanks in advance.

Just query to update a specific field and its value. Example as follows.

You need to ensure the new values actually exist within the field for this to actually work after the query has been made. The new values added via query must also match the values you specified in the field EXACTLY, this is case sensitive.