can't mark spaces as favorites

[Brendon Baumgartner]

I'm on Confluence 6.7.2. I ran through the docs here but it didn't fix my issue.

https://confluence.atlassian.com/confkb/cannot-add-or-remove-a-favourite-space-from-the-dashboard-270828848.html

After doing the above I still get results from the query that apparently shouldn't.

> select count(*) from CONTENT where contentid in (select spaceid from SPACES);
+----------+
| count(*) |
+----------+
| 6 |
+----------+
1 row in set (0.00 sec)

[Brendon Baumgartner · Accepted solution]

I ended up fixing this. I Found two things that helped. (1) Dump and re-import a space. But that was going to appear to take a lot of work. (2) I modified the query above to reveal pages with issues. I deleted them and re-created them and now the problem is completely gone. No issues tagging as favorites from what I can tell.

I now have a new problem but I opened a ticket with support.

[Shannon S]

Brendon,

Thank you for letting me know how you were able to fix the issue!

Take care and kind regards,

Shannon

[Shannon S]

Hello Brendon,

Am I correct to assume this is happening for all spaces or only certain spaces? 

Could you let me know which queries you ran from the article in particular? What is your database type and version?

Lastly, did you stop Confluence completely prior to running the queries and start it up again once the changes were made?

Regards,

Shannon