Custom GreenHopper project template lost after restart or migration.
Referring to the raised bug: GHS-2276
- Back up your SQL data
Determine the current GH general settings using a query like:
Save those results to a file.
Edit the file, add or change to declare 'CUSTOM_TEMPLATES':
Please note:If there're multiple custom templates, they should be all declared with separated by a comma, as in:
The IDs of existing custom templates can be found with this SQL query:
- The IDs is listed under the property_keycolumn right before the work 'CONFIGURATION.
- Example: 1332882417462_CONFIGURATION has the ID of 1332882417462
Turn the XML output into an update statement by enclosing it an an update statement, for example:
- Run the SQL statement you've prepared, preferably by "sourcing" the file from within the MySQL command line client.
- Restart JIRA to pick up the changes.