solved Forum showing 0 topics

Elise
Elise
@elise
4 years ago
249 posts
It looks like my database has some kind of data corruption issue. I've seen some sporadic database error while consolidating categories, but something happened during maintenance that made the count show 0.

How can I fix this?
https://empathcommunity.eliselebeau.com/community/forum
updated by @elise: 09/25/20 08:15:58AM
michael
@michael
4 years ago
7,714 posts
When you add a new topic does it go to 1 or stay at 0?
Elise
Elise
@elise
4 years ago
249 posts
Goes to 1.
paul
@paul
4 years ago
4,326 posts
Not sure how this might have happened, but have now patched the number of topics (2119) directly into the database table, so you should be now ok going forward.
hth


--
Paul Asher - JR Developer and System Import Specialist
Elise
Elise
@elise
4 years ago
249 posts
Thank you!
Elise
Elise
@elise
4 years ago
249 posts
Oh, @paul I didn't check after you fixed it. This is still showing 0 topics?
https://empathcommunity.eliselebeau.com/community/forum
updated by @elise: 06/26/20 09:25:16AM
paul
@paul
4 years ago
4,326 posts
Odd, I checked it after I made the database adjustment so it has somehow been reset again.
Can you recall doing any topic moves that may have caused this? Not just within the forum categories but maybe from group discussions?
I've set it again to its correct value of 2118, but if you can keep an eye on it and if it happens again, let me know if you were doing any forum work or topic moves so that I can try and replicate it here.
Thanks


--
Paul Asher - JR Developer and System Import Specialist
Elise
Elise
@elise
4 years ago
249 posts
The problems started after I did a category move and got a database connection error.
But I haven't touched categories since you fixed it.

I did a core update + integrity check this morning. Did that revert the change?

Tags