Hey,
I performed a merge from vB3.6 to the latest MyBB on some other forums I have.
I merged the users module, however, I forgot I already had a user 'Sgt. D. Pilla' in the database, so when I did the merge, it created the user...
'Sgt. D. Pilla_vb3_import2'
And ofcourse, before thinking, I deleted that user, so I still have the post entries by that user, It looks quite ugly having that username all over the forums.
How can I correct this?[/align]
Any Ideas?
Does anyone have ideas about this?
I would like to get this user removed from the database, or change the User ID to point to the correct Sgt. D. Pilla account, or something!
As long as I can keep the other posts, and just remove the 'Sgt. D. Pilla_vb3_import2' name!
The username?
Go to phpmyadmin and delete it from there
Can't, its not in the database, I used MyBB to delete the user after the merge, and now the remains of his posts and threads have his user name, linking to an invalid user...
Can I associate the posts from that account, with the posts of my new account?
(06-17-2008 04:21 PM)dikidera Wrote: [ -> ]The username?
Go to phpmyadmin and delete it from there
(06-18-2008 10:59 AM)Sgt. D. Pilla Wrote: [ -> ]Can't, its not in the database, I used MyBB to delete the user after the merge, and now the remains of his posts and threads have his user name, linking to an invalid user...
Can I associate the posts from that account, with the posts of my new account?
If they still show up, then posts are the ones who have that username saved. Go to mybb_posts (or whatever your table prefix is) and look for all the posts containing that username with phpmyadmin, and then replace it with the correct one.
:|
That is heaps of posts lol, nearly 1000, is there an easier way? *Like running a query or something?*
Just and update, I managed to run...
UPDATE `pillasoft_forums`.`mybb_forums` SET `lastposter` = 'Sgt. D. Pilla' WHERE `mybb_forums`.`lastposter` = 'Sgt. D. Pilla_vb3_import2' LIMIT 100
Which worked well, along with another query which replaced all thread names by vb3_import2 to the correct name...
Now, my final question is, CAN I link the changed users names, which are now black, to my user profiles UID?
Currently they don't link to anywhere