I can't change custom field type

[Pierre Cattin]

Hi, I am using Jira 3.5, and I need to change some custom fields' type.

Here's what I did to test the procedure:

1. Create a new radio buttons custom field

2. Stop Jira

3. Execute:

UPDATE CUSTOMFIELD
    SET CUSTOMFIELDTYPEKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselect',
    CUSTOMFIELDSEARCHERKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselectsearcher'
WHERE ID=10570

4. Start Jira

5. Re-index

But in Jira, the type of the custom field is still radio buttons. Moreover, after doing that, it's impossible to delete the custom field (the webpage never finishes to load).

Please could anybody tell me what did I do wrong?

[Pierre Cattin · Accepted solution]

Ok I got it, it's because I didn't commit after the database update :)

[Bharadwaj Jannu]

you can see the answer by Maxim Abramovich

in https://answers.atlassian.com/questions/102209/how-do-i-change-the-type-of-a-custom-field

[Pierre Cattin]

thanks, but I used the same procedure and it doesn't work...

[Bharadwaj Jannu]

1 2 3 4

UPDATE CUSTOMFIELD SET CUSTOMFIELDTYPEKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselect', CUSTOMFIELDSEARCHERKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselectsearcher' WHERE ID=10570 is that you tried select also in place of multiselect? UPDATE customfield SET CUSTOMFIELDTYPEKEY = 'com.atlassian.jira.plugin.system.customfieldtypes:select',

[Bharadwaj Jannu]

UPDATE CUSTOMFIELD

SET CUSTOMFIELDTYPEKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselect',

CUSTOMFIELDSEARCHERKEY='com.atlassian.jira.plugin.system.customfieldtypes:multiselectsearcher'

WHERE ID=10570

is that you tried select also in place of multiselect?

UPDATE customfield SET CUSTOMFIELDTYPEKEY = 'com.atlassian.jira.plugin.system.customfieldtypes:select',

The above comment is appearing with improper readability.so I again posted

[Pierre Cattin]

Yes I tried it.

But I have just noticed something important: when I re-index Jira, the custom field type is set back to radio button in the database.

Do you have any idea how this could happen?