andylaubSo, I recently updated our WPMU site with a new design, buddypress, and to the latest version. Everything *seems* to be running pretty smoothly, with one exception:
One blog had 122,000 comments. All spam. All building, and building, and building, for the last year. It was so much that the WP Admin couldn't handle loading the page to delete them.
So I exported the non-spam comments in PHPMyAdmin, renamed the comment table for that blog (wp_84_comments) and imported the non-spam comments back into a new table.
I don't know if that has anything to do with the issue at hand, though. The problem is, when I click on any of the permalinks (for blog posts, not pages), they just bring me right back to the index.php page, with the "content not found" message. I've noticed that the post counts on the articles don't match up with the number of actual comments because that value is stored in a different table, but even on new posts (I tried creating a test post) where it is accurate the problem still exists. And once again, it's only on this blog.
So, what say you? Because I am out of ideas. Thanks!
