[sbroways]

If anyone has any ideas I’m working on this issue on Stack Overflow as well. I think I’ve done a better job explaining it there and getting some good code put together from contributors but haven’t reached the finish line.

MySQL query help moving data between tables

[sbroways]

I was able to complete step 1 with the following sql query:

INSERT INTO wp_users (user_login)
SELECT DISTINCT post_username FROM phpbb_posts


Now I have transferred over the user names and need to work on step 2 which I think can actually be combined with step 3 as one function… but would still love to hear any ideas.

[sbroways]

I know! You guys have great product. I love that it is so light-weight at not packed down with features I may never need! Plus the seamless integration into WordPress is fantastic. I hope I can get it to work.

[sbroways]

I’m really hoping someone can help me figure out some sql queries I would like to run (especially spwestwood). I have been working on migrating a forum for a number of days now and would love if I could get some help on this last piece. I started out with a Phorum > migrated to SMF > migrated to phpBB3 > migrated to bbPress. The first 3 conversions were all successful. I would stay with phpBB3 but even after I loaded WordPress I could not get all my PHP to work properly on the forum page and I really like the bbPress integration into WordPress. But, I have the same anonymous error on the majority of my posts (55k) because, I believe, these are actually anonymous users who were not required to sign-up in order to post. The problem seems to be that bbPress uses only an ‘id’ to attach the name of the poster to the post and phpBB3 uses a ‘username’ field that actually contains the name within the table. All of these unregistered users simply default to user id = anonymous (1998 in my case). Here’s my solution… only, I don’t really know how to implement it as I have limited mySQL experience.. so please bare with me as this is all theoretical and I have no idea if it will work… and how to write it out in sql commands.

Step 1: I want to take phpbb_posts.post_username and assign new users in wp_users for each unique user name (I want to avoid duplicates obviously!). I would like that user_name assigned to both wp_users.user_login and wp_users.display_name. Now I have user accounts for all these anonymous posters.

Step 2: Convert the date format in phpbb_posts.post_time from an integer to the ‘datetime’ php format using the from_unixtime sql command… or something. That way I can accurately match the date/time field in both databases since they currently use different encoding.

Step 3. When wp_posts.post_date = phpbb_posts.post_time match phpbb_posts.post_username to wp_users.user_login GET id and assign to wp_posts.post_author

Does this make any sense? Or am I completely off the ball here? THANK YOU SO MUCH for any help!!

[sbroways]

Go into wp-admin>settings>forums. You can set the slug there for the different levels within the forum and then create a custom menu link to that slug. By default the root slug for bbPress 2.2 is yourdomain.com/forums. …In case anyone runs across this forum…