Hello,

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.

Thanks!

Glenn.

[@casiepa Moderator 8 years, 11 months ago]

Hi Glenn,

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.
Pascal.

[@glenn955 Participant 8 years, 11 months ago]

Thanks Pascal,

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. 🙂

Glenn.

[@casiepa Moderator 8 years, 11 months ago]

I think everybody will tell you: Don’t mess with the database 🙂

gl,
Pascal.