Manually added a bunch of posts, cant find how to reset count on index page

[pattycake]

I really hate asking... I should be able to find this but I haven't been able to.

I manually added a boatload of missing posts - which "counter" do I rebuild to get the post count at the bottom of the index page to reflect the correct number of posts?

[Zachery]

How did you manually add them?

[pattycake]

I was converting from another forum software... I did not use Impex, it could not handle the size of my database... I wrote my own conversion program. Everything is there, all of the posts are there, I just need to update the count on the index page.

[RichieBoy67]

If you want your posts to be recounted you use the Post count update tool in the maintenance section. Be sure to clear your cache in the maintenance section as well.

Are you saying you want a fake count number?

[Zachery]

impex could have handled the size of your database :)

Anyway, you'd still likely need to follow the after the import rules.

Rebuild the thread, and forum counters.

[RichieBoy67]

impex could have handled the size of your database :)

Anyway, you'd still likely need to follow the after the import rules.

Rebuild the thread, and forum counters.

True, I have imported sites over 10 gigs before using Impex. It just takes a very long time and you have to be sure it doesn't get hung up by packet size settings, etc but it works fine.

Patty - You should generally update all the counters after running an import. At least I always do.:)

[pattycake]

impex could have handled the size of your database :)

Anyway, you'd still likely need to follow the after the import rules.

Rebuild the thread, and forum counters.

I tried impex several times... 5 million posts, and gave up after waiting as long as 5 days just for the posts and, it wasn't even halfway thru the posts.

140,000 users took 48 hours. It flat out died so many times I just said the heck with it and wrote my own in C.

140,000 users added in 11 minutes, 5 million posts in 2 1/2 hours.

--------------- Added 1388364349 at 1388364349 ---------------

If you want your posts to be recounted you use the Post count update tool in the maintenance section. Be sure to clear your cache in the maintenance section as well.

Are you saying you want a fake count number?

no, I don't want to use a fake number - I have over 5 million posts. Do you know where that value is stored (in what table)?

If I can just edit that number, I won't have to wait for hours for the 140,000 threads and 200 forums to process (assuming I have to do the thread and forum counters as mentioned below)

--------------- Added 1388364459 at 1388364459 ---------------

If you want your posts to be recounted you use the Post count update tool in the maintenance section. Be sure to clear your cache in the maintenance section as well.

Are you saying you want a fake count number?

tried that... it updated the post counts for all members (4 hours runtime), but not that total at the bottom of the index page

[Zachery]

You also ran the rebuild forum counter too, right?

The import going slowly sounds like a MySQL tuning issue, more than anything else.

[RichieBoy67]

5 million posts is a lot. The only time I ever had issues with the posts importing was due to very, very large posts and threads holding things up due to the packet size which I just needed to adjust.

If you updated the thread, posts and forum counters at the very least and cleared the cache it should work.

You wrote a program to import threads, posts, forums, etc? What forum script were you importing from? 11 minutes for 5 million posts seems very fast! On some of the larger forums I imported with Impex I ended up going to sleep and just let it run but that was mostly7 for attachments.

[pattycake]

You also ran the rebuild forum counter too, right?

The import going slowly sounds like a MySQL tuning issue, more than anything else.

I tried the forum counter first, hoping it would do the trick because it was the fastest. No go... bummer. Then did the post count that took almost 5 hours, again no go. I have not tried the thread counter yet. What happens if i try it on a live site?

--------------- Added 1388366797 at 1388366797 ---------------

5 million posts is a lot. The only time I ever had issues with the posts importing was due to very, very large posts and threads holding things up due to the packet size which I just needed to adjust.

If you updated the thread, posts and forum counters at the very least and cleared the cache it should work.

You wrote a program to import threads, posts, forums, etc? What forum script were you importing from? 11 minutes for 5 million posts seems very fast! On some of the larger forums I imported with Impex I ended up going to sleep and just let it run but that was mostly7 for attachments.

>You wrote a program to import threads, posts, forums, etc? What forum script were you importing from?

Forum was a very very old and heavily modified version of Invision Board (v 1.2)

Yep... wrote my own program. The only thing that remains to be converted is the PM's... have not figured out the table yet... what the heck is:
a:1:{s:2:"cc";a:1:{i:1642;s:9:"RacerX317";}}
a:1:{i:32;s:13:"bullardracing";}

:)

[Zachery]

I'm a bit concerned you were able to import posts/threads so quickly. I think you might have missed some critical data, which is causing problems for your thread and post counts...

[pattycake]

everything is there, all posts etc, all forumid's, thread ids, etc.. I'm pretty sure it's clean.

Everything works, I just need to reset that Total Posts number on the index page.

--------------- Added 1388503787 at 1388503787 ---------------

done deal.... it was the Thread Index, followed by the Forum index... total post count at bottom of index is now correct.

Thank you everyone