Existing topics disappeared after database "reconstruction" (Solved)

[Catalyst]

So, I hadn't used a board in a very long time and decided to reopen it. The problem is, the reason I closed it was the mass amount of spam from neglect. I decided instead of wasting time and energy on trying to find and delete them all, I would export the topics and posts that were authorized from the database, truncate the table, then import the old posts. The problem is, not all of them are showing up. Particularly early topics. I can access them through checking member posts, but they just aren't showing up.

http://hissy.catalyst-pub.com/index.php [nofollow]

It's easy to see without even logging in what I'm talking about.

[Burke ♞ Knight]

Try this:

Admin -> Maintenance

Find and repair any errors

Then

Recount all forum totals and statistics

[Catalyst]

Try this:

Admin -> Maintenance

Find and repair any errors

Then

Recount all forum totals and statistics

I tried that. It found a lot of other threads and posts, but mainly ones that came later. The early ones don't show up still. I've tried re-importing them and doing the same, but it didn't work. I don't know why.

[Illori]

which tables did you modify? there is more then one table that handles messages and topics.

sounds like you might have caused more damage then can be fixed.

[Catalyst]

I exported and imported from messages and members. Everything was exact as far as I know. I did have to reattribute some profiles to posts, but that hasn't affected the other threads that did show up. In fact, some boards are perfect. Just a few boards are being troublesome. And it only seems to be the only some of the older threads.

[Burke ♞ Knight]

Need to export/import Topics, too.

[Catalyst]

Okay, that got me closer. It showed a post off to the side on the main page, but if I move it, that spot goes blank again, and it still doesn't show up in the boards. I suppose that's next to try.

[Kindred]

you really can't do direct database edits like than and expect things to work correctly afterwards....   there is a reason that we have functions in the admin tools to remove posts correctly...

[Catalyst]

I know. But it had been over a year of neglect and not thinking about it and had more spam posts than authorized posts. Sadly, the faster way to get it done was to go through the database. Plus I already screwed up by accidentally deleting some members I didn't mean to through the admin tools.

I found a new problem, but the solution doesn't help the current problem. So going back to square one. I did find one of the threads and posted on it, and it worked semi-correctly, so that may end up being my solution if I can't find anything else.

[Arantor]

If early ones aren't showing up and the find any errors didn't find them, that suggests they might be gone entirely

[Catalyst]

The problem was I could still find them. I did find the problem, though. The threads that I was having trouble with were ones that I removed spam from, and the accounts with them. But when I removed the accounts and spam, it still listed the last post as one of the deleted ones. I pulled it all into a spreadsheet, fixed it, then csv'd it and imported over the old topics. They're showing up now. Thanks to all those who responded! Suggesting importing the topics over again gave me the idea to really look at it.

[Arantor]

Ahhhh, that sounds like something the find/repair should be fixing.

[Catalyst]

Sadly, it didn't, no matter how many times I ran it. I missed a few and am going back over them looking for any discrepancies. Thankfully I know the last post number made, so anything over that is easy to spot.