A confluence search returns the same page twice

We do a normal confluence search, and it returns the same page twice. We can check as both result have the same page id.

We did rebuild the index, but these pages are still showing as duplicate results.

1 answer

You could also run the below query in your DB, replace "Home" by the the page name:

SELECT * FROM CONTENT WHERE TITLE = 'Home' AND PREVVER IS NULL;

Hope that helps !!!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

What should the effect be when running the SQL, I assume the query will only bring up one entry?

Both entries in the search result have the same page id...

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.