Space Tools does not show. How to reset layout?

[Kwanthar]

I have customized the decorator for the one of the Layouts, but now I cannot access the space tools, it appears blank. Is there a way to reset the layouts? I cannot even delete the space.

i.e. when at .../spaces/spacepermissions.action?key=MAINPAGE

It is just blank white space.

[Kwanthar · Accepted solution]

Just to update, I wasn't able to get permission to use SQL, but using the following did the trick.

Comment Jan-14 by Anonymous

https://confluence.atlassian.com/display/DOC/Deleting+a+Space

[Amalia]

Hi Kwanthar!

All edited layouts are saved into DECORATOR table. I would recommend you to backup your Confluence instance and run the following SQL queries to see which layout you would like to delete:

select * from decorator where spacekey='MAINPAGE';

You can then delete a specific layout:

delete from decorator where decoratorid=<ID>

or delete all layouts in one go:

truncate table decorator;

Of course, you would need restart Confluence after marking those changes :)

[Kwanthar]

Hi Amalia,

Thanks for your response, I will give that a go.