Change MyBB Post Author

[Fluffybunny]

How does one change the post author on a MyBB thread/post? After the merge there's a couple of posts/topics that say 'Guest' instead of the actual user.

[faviouz]

You'd have to edit the username field in the mybb_threads or mybb_posts table.

[Fluffybunny]

I tried that it just seems that it does the same thing. Shows up a guest... I've done both username and user ID fields.

[Paul H.]

Rebuild the posts?

[faviouz]

If you were editing the first post of a thread, you need to do the change in the mybb_posts table as well.

Rebuild the posts?

That'll just set it back to its correct value.

[Fluffybunny]

UPDATE webbedfo_fcmybb.mybb_threads SET uid = '2',
username = 'GhostFace' WHERE mybb_threads.tid =441;

Still makes the topic appear as a guest.

[faviouz]

Are you editing the first post of a thread? If so, like I just said, you need to update both mybb_threads and mybb_posts table.

[Fluffybunny]

That fixed that part of it but now when viewing the forum I get:

07-01-2011 06:35 PM
Last Post: Guest

[faviouz]

That's a different thing. It's in the lastposter field.

[Fluffybunny]

All working now. Thanks.