Many issues due to no title for a page in confluence database.

I received few issues from many users about some of the behavior of our upgraded confluence 4.2.1. The issues reported by them are as follows.

•Not able to set home page for a space

•Tree view of the pages not working for many spaces

•Page Index macro showing Null pointer exception

*Root Cause*

Exploring all these issue I conclude only one reason for all these issues. There are many entries in the confluence database for the pages with no title. Although Confluence does not allow creation of pages without a title but somehow these entries exist.

*Reason for creation of pages without title*

To explore this, I tried many things and was able to reproduce this scenario. It looks like, there is a bug in confluence in creating/editing a page template. If we are creating a page template and if there is an issue in using a macro (it can be incorrect parameters or anything that prohibits the macro used in the template to render it correctly), and if we save it without correcting the issue, there will be a page created in the confluence database without a title. The same is true when we are editing a template containing macro issues. Please note that templates in confluence still use wiki markup style and not a rich text style. The pages without the title can be listed in ‘orphaned pages’ section.

*Workaround Solution*

If we change title of these pages containing no title to some title (example – ‘Blank Title’) through following database query directly in the database, and flush the cache of the confluence, all these issue will be resolved without restarting the confluence instance.


update CONTENT set TITLE = 'Blank title' where TITLE is null AND CONTENTTYPE = 'PAGE';


Please confirm it as a bug and provide a fix in the future releases

1 answer

0 votes

If it's a bug, you need to raise it in Atlassian's bug tracker at - here, at Answers, is a user community. Atlassian lurk here and often post, but bugs need to go directly to them.

From memory (and in Confluence 3.4) there are some pages which legitimately have no titles, so a blanket "fix" for all the untitled pages might not be the correct answer. Also, in my test Confluence 4.2, I don't see this behaviour, so you probably need to do some more diagnosis with Atlassian. Before raising a bug, it may be better to raise a proper support issue with them for your installation.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

1,133 views 61 8
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you