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.

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.