A confluence search returns the same page twice

[Francis Martens]

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.

[Abdoulaye Kindy Diallo]

Kindly try to rebuild from scratch: https://confluence.atlassian.com/display/CONFKB/Rebuild+the+Content+Indices+from+Scratch

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 !!!

[Francis Martens]

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...