6 years, 8 months ago
Just started to investigate using bbPress and migrate over from phpBB.
After the migration I noticed that all my posts were from the username “imported_Glenn”. I feel that this was due to the user “Glenn” already existing. No one else inherited the suffix.
Is there a way I can easily replace the author name from “imported_Glenn” with “Glenn”?
I’m reasonable with SQL.
First of all: MAKE A BACKUP before touching (but that should be obvious).
Just an idea. I have never tried it, but when you delete a user, does it not ask you to what user you want to move the posts and pages ? So just deleting ‘imported_Glenn’ …
If you really want to go the SQL way, then most probably changing the ‘post_author’ in the ‘posts’ table should be sufficient. Find the old and the new one from the field ‘ID’ in the ‘users’ table.
Hope this helps.
I look at the SQL and saw that ‘imported_Glenn’ was 3228 and ‘Glenn’ was 1. Tested and changed one of them to 1 and it worked OK. I will look at replacing them all tonight.
Unless anyone shouts out not to do it. 🙂
I think everybody will tell you: Don’t mess with the database 🙂
Follow bbPress on Twitter •
Contact Us •
Terms of Service