How to remove a field screen that can't be removed via the easy "Delete" button ?

[Martin MEYNET]

Hello,

I was doing some manipulation on a field screen to test some things out but at one point, i wasn't able to access the "configure" menu as well as delete the screen. I can't tell you how i did that because i have absolutely no idea.

I need to find a way to remove this screen from my jira, one way or the other. My first idea was to use a JQL query on my server instance to remove the screen but i am not sure if that's a good idea.

Does someone have a JQL query to help me ? or an other way around ?

For information on the files, the first image is my screen that i want to remove (with the delete button active), the second one is the message i receive when i try to delete it and the last one is what happens when i try to configure it.

Martin.

PS: this is the message i get when i try to delete the screen in Jira : (i can't post the complete error message in here)

java.lang.NullPointerException

[Martin MEYNET · Accepted solution]

Ok, i actually found how to correct alone ^^ .

Here is how i did it :

1. I connected to my server and accessed my SQL database.
2. I then use the command : SELECT * FROM fieldscreen ORDER BY 2; to find the ID of the screen i wanted to delete.
3. I then deleted it : DELETE FROM fieldscreen WHERE ID = 10409; (of course you should modify the ID field for your need).
4. Then I restarted my Jira instance and the screen disappeared.