How can I rename a theme in greenhopper

[Stephane Renou]

I am using epics/theme implementation providing some themes names as I did not enjoy setting JIRA ID when assigning a story to an epic.

I would need to rename some of my themes or fix some spelling errors, is there any easy way to achieve this?

[Foong · Accepted solution]

Please use the following workaround:

1. Backup JIRA for rollback purposes

2. Shutdown JIRA

3. Search for the affected entries in the database:

SELECT * FROM label WHERE LABEL='<the_problematic_name>' AND FIELDID=(SELECT ID FROM customfield WHERE cfname='Epic/Theme');

4. Change the content of the name:

UPDATE label SET LABEL='<the_correct_name>' WHERE LABEL='<the_problematic_name>' AND FIELDID=(SELECT ID FROM customfield WHERE cfname='Epic/Theme');

5. Restart JIRA