Downgrade the app to version 3

Owned by Antonella Capalbo
Last updated: Nov 08, 2017
1 min read


You must have the Jira System Administrators global permission before you can carry out the instructions on this page.


On downgrading the app to the earlier version 3.x  you can encounter the following error:

java.sql.SQLException: Cannot drop index 'index_ao_d195e9_cus1061972428': needed in a foreign key constraint

If you encounter this problem you need to run the following script:

ALTER TABLE <<dbname>>.AO_D195E9_CUSTOM_MAIL_TEMPLATE DROP FOREIGN KEY fk_ao_d195e9_custom_mail_template_icon_id ;
Commit;

The query above was written in MySQL syntax, so you may need to tweak it depending on the database you are using.