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-

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.