The Case of the Missing PostsWrÅith was shocked to discover this morning that one of his admins has all of his posts missing.
"Where have they gone," he asked himself.
So, being the dutiful admin that he is, he immediately began an investigation. Calling in the infamous
Dr. Watson (o.k. not really, it was me), he began a search of the database. Performing endless query after endless query, he soon discovered that the posts were indeed located within the database, complete with all of the information required.
Stumped, he began another search of the forums.
"By jove," he exclaimed. "They just aren't there!"
"Hmm," he thought to himself. "Let me check the user's profile."
Sure enough, the posts were listed when
Dr. Watson clicked on the
Show all user's posts link, yet when
Dr. Watson clicked on one of the post titles, there was no post! (Reference attached image
Flat.jpg)
*Audience gasps*
Being the astute investigator that he was,
Dr. Watson immediately changed his view to
Threaded, and was astounded to see a mysterious post appear. (Reference attached image
ThreadedPost.jpg) The displayed list of threaded posts even correctly showed the entry from the user. (Reference attached image
Threaded.jpg)
Thinking that perhaps it was a mistake with the table,
Dr. Watson immediately did a repair and optimization with no success. Baffled, he thought he might try a drastic approach and he dropped all of the indexes and recreated them. Still no success.
Finally, admitting defeat,
Dr. Watson has called in his trusted mentor
Sherlock Holmes to help....
Thoughts anyone???