[phpBB2] ImpEx importing deleted posts/users

[mOdEtWo]

I've used the latest version of ImpEx, and it's getting close. Won't be long until I will convert my live forums. Anyway, over to the problem:

NOTE: This is currently not a bug report, as I'm going to investigate this case further. Maybe Jerry can enlighten it.

My phpBB2 forums contained:
72,472 posts
557 registered users

After the import (on a clean vB3 database) the vB3 forums contained:
72,575 posts
1,085 registered users

Now, that's strange. The postcount might be correct if ImpEx is also importing deleted posts. We also had a user-cleanup way back when we deleted all non-active users. But I doubt that was ~500 usernames.

I'll try on an old version of ImpEx again, to see if I had this problem before - I vagely remember that the member counter was correct with an older version, but I'll doublecheck.

Jerry, got any idea what's going on? And is ImpEx importing deleted posts/users?

[Jerry]

Are thoses figures from the front end or the dB directly ?

If the posts exsist in the phpBB database they will be imported.

[mOdEtWo]

Are thoses figures from the front end or the dB directly ?
Frontend. How can I check it in the database, and what difference does it make?

[Jerry]

Front end being ImpEx, not the admincp count.


SELECT count(*) from user;


Will tell you how many are really in there.

Depending on how you imported them and if you cleared the sessiion during the import it can confuse it.

[mOdEtWo]

SELECT count(*) from user;

That gave me 1085 too.

What do you mean with "depending on how you imported them and if you cleared the sessiion during the import"?

EDIT: I ran the sql query on the post table, and ended up with 72,477. That's not excactly the same as on the phpBB2 board, but more like it on the vB3 frontend (5 posts too many).

[Jerry]

If you re-run the import users module, that will clear all exsisting imported users (any with importuserid <> 0).

If the session is changed in the database directly while a page is running it can mess it up, but to have to modify the database directly with the intent of breaking it to get that to happen.


SELECT count(*) from phpbb_users; ?

[Jerry]

Just done quite a lot of updates and bugs, download the latest and give that a go.

[mOdEtWo]

If you re-run the import users module, that will clear all exsisting imported users (any with importuserid <> 0).

If the session is changed in the database directly while a page is running it can mess it up, but to have to modify the database directly with the intent of breaking it to get that to happen.
Hmm, I know I messed one thing up. I think I pressed OK on import users before I realised I'd set the option to import user avatars. Then I clicked on STOP in my browser window (Opera) and went back to uncheck that option - before I ran the script again. I didn't think it had imported any users, but it seems like it did. I'll start over with a clean database. ;)

SELECT count(*) from phpbb_users; ?
557, as the phpBB frontend says.

[mOdEtWo]

Ugh, the ImpEx screen says it imported 554 users.

:confused: Lemme doublecheck this...

[Jerry]

I'll start over with a clean database. ;)

That and downloading the lastest impex build is the best way of doing it.

[mOdEtWo]

That and downloading the lastest impex build is the best way of doing it.
Hey, I downloaded it 3 hours ago. ;)

Sure, I'll give it a go. Thank you.

[Jerry]

I've updated it about 4 times today, last time was about 20 mins ago.

Just about to finished the sourceexists catch as well, so that will be another one ;)