View Full Version : After Conversion my postings say "GUEST"
tlwwolfseye
Sun 10th May '09, 7:00am
So far I solved most of the issues from my SMF to vB Conversion, but something odd happend. Though I am the Main Admin (otherwise I couldnīt do what I can do) all the postings of me in the Forum that are imported from the other say that I am "GUEST" and donīt even show my new set Avatar & Signature. Why am I a "GUEST" according to the threads ?
Any help on that please ?
Thanks in advance.
Wolfseye
tlwwolfseye
Sun 10th May '09, 8:00am
Solved. :)
ciosclone
Thu 14th May '09, 1:15pm
How did you solve this ?
tlwwolfseye
Thu 14th May '09, 2:13pm
I found a topic here in this Forum or in vBulletin.com, i think it was vbulletin.com where someone had a similiar problem and there was a reply with a MySQL query with what all posts with a specific Username got attached to a specific UserID. So that in the end it was like all those were actually again my postings, like before, but not as guest.
I would have to search for that thread again, donīt know atm.
Steve Machol
Thu 14th May '09, 3:05pm
You would run this query:
UPDATE post SET userid='xxx' WHERE username='Old Name';
...with 'xxx' being the userid number of the new account and 'Old Name' being the username on those posts.
Then rebuild the thread and forum counters in that order:
Admin CP -> Maintenance -> Update Counters
Powered by vBulletin™ Version 4.0.0 Beta 4 Copyright © 2009 vBulletin Solutions, Inc. All rights