SQL Shows page in different space

[Geeks]

There are many pages on our site which, when opened, show as being where we expect them - in the space we wanted.  However I've just looked at the SQL table for content and found that many are shown there as being in a different space.  Any idea how this happens?

[Nic Brough -Adaptavist- · Accepted solution]

The data structures have evolved over the years, and

• You could be looking at the wrong fields
• You may be seeing updated data from the caches

Simple answer - don't look in the database.  It is the single worst possible way you can report on Confluence data (and Jira while I'm here)

Why are you reading the database?  The UI data is correct, and the REST API will give you the right answers as well.

[Geeks]

Thanks Nic.  I'm trying to get a list of all pages on the site including the space they are in.  I found https://confluence.atlassian.com/confkb/how-to-obtain-a-list-of-all-pages-their-authors-and-related-information-from-the-confluence-database-968687591.html

This is because we are looking at a design change to make it more transparent as to locations for finding and saving pages and will need a comprehensive list so we can move pages as required.