MyBB Community Forums

Full Version: phpBB3 to MyBB total post and thread count incorrect
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
On my phpBB3 forum I have 19600+ posts and 2200+ threads

after converting I have only 15600+ posts and 1700+ threads

phpBB3 link: http://www.wiimaddencup.com/phpBB3
MyBB link: http://www.wiimaddencup.com/forum

I've done the recount and rebuild multiple times.


MyBB Merge System - Merge Report
--------------------------------------------------------
Welcome to the MyBB Merge System Generated Report. This
report shows a small overview of this merge session.

General
-------
Board merged: phpBB 3
Import began: Tue, 15 Jun 2010 18:21:53 +0000
Import finished: Tue, 15 Jun 2010 18:28:31 +0000

Database Query Statistics
-------------------------
Queries on MyBB database: 61,428
Queries on old database: 5,940
Total query time: 24 seconds

Modules
-------
The following modules from this converter were completed:
Database Configuration
Users
Usergroups
Forums
Forum Permissions
Threads
Polls
Poll Votes
Posts
Private Messages
Moderators
Settings
Attachments


Import Statistics
-----------------
The MyBB import system imported the following from your copy of phpBB 3:
User Groups: 1
Users: 452
Forums: 228
Forum Permissions: 0
Moderators: 0
Threads: 2,211
Posts: 19,621
Attachments: 0
Polls: 0
Poll Votes: 0
Private Messages: 0
Settings: 23


Errors
------
The following errors were logged during the process of the Merge System:
None


--------------------------------------------------------
Generated: Tue, 15 Jun 2010 18:29:22 +0000
Some settings will probably be messed up. The same happened to me when I converted from phpBB.

Check that "Yes, posts in this forum should count towards user post counts" is ticked for all the forums you want it to be. Smile
Quick way to make sure that's checked:

UPDATE `mybb_forums` SET `usepostcounts` = '1';

Then ACP > Tools & Maintenance > Cache Manager > forums > Rebuild.

Then run the recount and rebuild tools again, any joy??
Where do I update this 'usepostcounts' ?
Run that query in phpMyAdmin, should be in your host control panel somewhere.
That didn't help Sad


@AJS.. I tried what you suggested too but they were all set to that already.
Found out part of my problem.. I was only clicking the "proceed" button in the rebuild and recount once and then going back b/c nothing happened.. i tried clicking many times then it went forward..

I now have

18,385 posts in 2,211 threads.

Thread count is correct but post count is not
haha now it says I have

21,830 posts in 2,211 threads.

some post counts say I have replies in threads with no replies.. and in general some forums say they have more posts than they should
This whole process is a mess lol

I've converted from forumotion to phpBB3 to MyBB

each time the post counts in each category/forum have changed
(2010-06-15, 07:49 PM)Civil Engineer Wrote: [ -> ]Found out part of my problem.. I was only clicking the "proceed" button in the rebuild and recount once and then going back b/c nothing happened.. i tried clicking many times then it went forward..

Next time have patience because it is running. Once you click the button you won't immediately see a new page because it has to run the script first in the background. You know that it's running by looking at the little spinner up in the topish of your browser or the progress bar, depending on your browser.
Ya I know but the spinner would stop.. so I'd have to click it about 10-20 times before it would actually run
Actually it is running. It has to run in multiple steps to prevent overloading the server and going over your PHP time limit. Each time you click Proceed its moving on to another "page" of data. However many you selected per page... I think it defaults to 500? Anyways, thats something I've been meaning to suggest to the Devs... take the autopaging system from the Merge Module and make it do that for Recount/Rebuild... along with telling the user where they're at in it.