Woah!
There's more!
Doing further research and queries, I notice problematic threads not appearing on the search results lead to a forumid which does not exist.
Quering that forumid in table threadid throws... 257 records!
257 threads pointing to a non existant forumid!
How can this be possible?
Now, is there any query that would allow me to FIND (not delete!) ORPHAN threads? Ie threads pointing to invalid forumids? (ie forumids no longuer existing!)
Where can this problem come from?
I've managed to run tables check in a monthly basis with no errors ever!
DB is around 200Mb, including attachments.
Please advice.
Thanks!
|