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.
You'd have to edit the username field in the mybb_threads or mybb_posts table.
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.
If you were editing the first post of a thread, you need to do the change in the mybb_posts table as well.
(2011-07-11, 08:17 PM)Darth Stabro Wrote: [ -> ]Rebuild the posts?
That'll just set it back to its correct value.
Quote:UPDATE webbedfo_fcmybb.mybb_threads SET uid = '2',
username = 'GhostFace' WHERE mybb_threads.tid =441;
Still makes the topic appear as a guest.
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.
That fixed that part of it but now when viewing the forum I get:
Quote:07-01-2011 06:35 PM
Last Post: Guest
That's a different thing. It's in the lastposter field.