Can't delete Announcement Banner contents

[Cierra Lewis]

So I made a horrible mistake in testing, and long story short I set the Announcement Banner to redirect to Jira home, which of course no matter what you try to go to it will try and redirect to Jira home, which then Jira home will redirect to itself. So it's in an infinite loop and won't let me get to System or do anything as it keeps redirecting. I've read that you can access the database to delete it from there, I'm using the embedded H2 database and tried running the follow script: 

select pt.id, pt.propertyvalue from propertytext pt join propertyentry pe on pt.id=pe.id where pe.property_key='jira.alertheader';

As well as: 

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');

Neither of these work it says:

Table "PROPERTYTEXT" not found; SQL statement:
DELETE from propertytext WHERE ID = (select id from propertyentry where property_key='jira.alertheader') [42102-185] 42S02/42102 (Help)

and I can't seem to find anything else on the subject of using H2 to correct this problem. If there's any other way I can reset the announcement banner contents that would work as well. 

[Dave Theodore [Coyote Creek Consulting] · Accepted solution]

Did you shut Jira down before deleting the table? You should be able to replace "DELETE" with "SELECT" and see what's there.

[Cierra Lewis]

I believe I did, I went to Administrative Tools>Services and shut down Atlassian Jira and nothing seems any different and I get the same results. I tried using "SELECT" instead and it gets the same errors.

[Cierra Lewis]

I was not able to do anything in the database, I simply deleted the server.xml and reinstalled Jira.