Double posting in stats

[nsusa]

I imported a phpBB forum. It seems like the stats got messed up due to a re-run of the postings. Now every user has twice the number of postings and the forum stats show twice as much postings.

I did run the deletion of duplicate threads but that did not clean up the stats. I re-ran the post count but that did not clean up the stats, too.

Any idea how I can fix this?

Thanks.

Christoph

[Steve Machol]

Clean out the import and start over.

[nsusa]

Ouch. That's not good. :(

I do not see any double postings or so. It is just the stats itself. So, there is no other way of doing this I guess.

Christoph

[Steve Machol]

Did you rerun the thread and forum counters? Did you rebuild the statistics?

[nsusa]

I re-ran the forum and thread counters. The thread counter starts at the actual number of threads - meaning if I have 17,000 threads it starts at 17,000 and then goes to 34,000. Do you know where the importer stores that information so that I can reset it manually?

I am hesitating to re-run the statistics. Will that not wipe out all existing forum and thread views? The warning message in the admin panel scares me a little bit.

Christoph

[Jerry]

That is the ID number opposed to going from 0-17000 its counting from 17000-34000.

There will still only be 17000 in there.

Have you updated the user post count ?

[nsusa]

I did run the update user post count AFTER I noticed the problem.

Christoph

[Jerry]

Then it will count all the posts in the database, if they are twice as high then there are that many in the database.

Must of been a broken import where one import of posts was re-run with out being cleaned out.

Whats the count() of the post table ?

[nsusa]

It shows the higher (unexpected) number. I assume re-running the whole import would leave new postings and threads unaffected and only touches postings with an import ID?

Christoph

[Jerry]

Unless the posts and threads had been made to imported threads and forums.

i.e. if you post to an imported thread then delete the thread, you have orphan the posts and on the next import they are lost.

This is the reason for advising testing an import till all the issues are solved then going live.

Though what is the post count in the database ?

[nsusa]

Everything went well during the test. That's why I was stunned when the problems occured.

Anyway - I did the ugly step of reverting back and re-import. Backed up all new postings and topics and (partially) restored them after the successful import. All stats are now up to date and look good. Could not import all postings from the backup due to a change in the Post IDs and thread IDs but things are looking much better now. :)

Christoph