Empty spaces / create from blueprint loads forever

[naturwundR]

Hello!

I have some problems with my fresh installed confluence.

1 - I am not able to see or create any spaces:

The drop down menu is just blank.

2 - When i try to create a page from a blueprint it just loads forever:

I already tried to reindex the content of the installation. Do i overlook something here?

EDIT:  Solved the problem with the latest jdbc driver. Now everything works fine.

[Shannon S]

Hello @naturwundR,

Thank you for letting us know you were able to solve the issue.

Can you let us know exactly what you did to solve it? It can potentially help other Confluence users in the future.

Thank you!

Regards,

Shannon

[naturwundR]

Hello @Shannon S 

Sure! Sorry for not posting the solution right away.

• First i stopped confluence
• Then I downloaded the latest jdbc driver from https://jdbc.postgresql.org/download.html (42.2.8) onto the server and placed it in /opt/atlassian/confluence/confluence/WEB-INF/lib
• After that i just restarted confluence.

That's all! :)

Before i used the driver which was mentioned here : https://confluence.atlassian.com/doc/database-jdbc-drivers-171742.html (postgres-9.4-1202)

I just really tried the latest version of the driver because this line in the log cached my attention:

Caused by: org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
Position: 427

So i thought i would give another driver a try because i saw that there are newer drivers available.