vB to vB import messed up

[njkhatri]

I have two vB forums - both running 3.8.1 Patch Level 1.

I needed to copy some of the threads/posts from one froum to another. Therefore, I ran the impex on the destination forum and deleted all the forums/posts that I didn't need to get copied. So far, so good.

However, lot of replies to the threads happened to be from me and I am the administrator on the both the forums. However, the destination forum shows my replies as 'Guest' and not as any user.

How do I transfer those posts to my username?

[Steve Machol]

That means those posts were either from 'Guests' to begin with or you removed that account before importing.

To assign thos posts to your account, run this query:

UPDATE post SET userid='xxx' WHERE username='Name';

...with 'xxx' being the userid number of your account and 'Name' being the username on those posts.

Then rebuild the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

[njkhatri]

No, those posts were NOT from 'Guests' to begin with. They were from the administrator.I didn't remove that account before importing. That was an administrator account.
However, I definitely have that user prohibited from changing in config.php Could that be the problem?

I did what you said and it works fine now.

Also, I see several users whose usernames start with imported_xxxx. It he username was robort in source forum, his posts show up as imported_robert. Anyway to fix that, other than one by one merge robert and imported_robert, then merge bob with imported_bob and so on?

[Steve Machol]

You have to merge those accounts.

[njkhatri]

I had already selected the option to associated the accounts if the email address matched.

In that case, why does it have two different account names, robert and imported_robert?

My question is more like why does this happen in the first place?

And why do we have to merge the accounts manually? It is very cumbersome if I have thousands of users like that.

[Steve Machol]

Because the names were the same but the email addresses were different.

[njkhatri]

I verified and that is not the case.

[Steve Machol]

Honestly that is not possible. The only way vB would do this is under the conditions I specified. I really don't know what else it could be.