Remove the Jira server announcement banner through the database
Symptoms
After modifying the contents of JIRA's Announcement Banner, pages are not loading properly, making it impossible to reach the page to edit the contents of the Announcement Banner.
Diagnosis
The Announcement Banner was recently changed, causing all pages in JIRA to not render properly.
Cause
Contents in the Announcement Banner may cause all pages in JIRA to become useless.
Resolution
- Stop JIRA
- Backup database
Run the following SQL to remove the contents of the Announcement Banner:
DELETE from propertytext WHERE ID = (select id from propertyentry where property_key='jira.alertheader'); DELETE from propertystring where ID = (select id from propertyentry where property_key='jira.alertheader.visibility'); DELETE from propertyentry where property_key in ('jira.alertheader','jira.alertheader.visibility');
The above SQL commands will remove the contents of the Announcement Banner.
- Start JIRA