Topic: Import bbpress users into buddypress?

Import bbpress users into buddypress?

Hard Seat Sleeper
Participant

@hseatsleeper

15 years, 1 month ago

I have a wp blog and a bbpress forum and I want to integrate them both into buddypress, so that the whole site works together, rather than each section operating independantly.

So my idea is to import all my bbpress users into my wp-mu installation. Does that sound sane? I have 5000 users in my bbpress, I’d hate to cut them off.

First things first, bbpress has a display_name field that’s empty. This is used in wp-mu, so I guess I will have to put something there.

Has anyone ever attempted this before? It seems like a lot of work to go through to do something that should be relatively cut and dried.

Viewing 7 replies - 1 through 7 (of 7 total)

circuit
Member

@circuit

15 years, 1 month ago

+1 for this question. I would also like to know..
Ivaylo Draganov
Member

@dragunoff

15 years, 1 month ago
I am currently attempting something similar. I have an integrated WP and bbPress but want to switch to WPMU. I’ve successfully imported the user tables through phpMyAdmin. There are three columns you need to add to the wp_users table:
```
display_name - varchar(250) - blank default value

spam - tinyint(2) - default value = 0

deleted - tinyint(2) - default value = 0
```
And in wp_usermeta table you need to do a SQL search and replace to change all values that have wp_ to wp_1_ (because the main blog in WPMU has got that table prefix)
```
UPDATE wp_posts SET meta_key = replace(meta_key, 'wp_','wp_1_');
```
circuit
Member

@circuit

15 years, 1 month ago

brilliant, thanks! this is exactly what i needed.

all my users currently have ‘contributor’ status in WP (the blog that would become ‘1’) – do you know if they would retain this permission if i upgraded to MU?

i am hoping that everything would work the same way, and i’d just be adding the additional benefits that MU brings rather than changing existing permissions.

Ivaylo Draganov
Member

@dragunoff

15 years, 1 month ago

Yes, in my case user statuses were preserved. I have done just basic testing so far but things are looking good for me and soon I’ll be doing it on the live site.

Hard Seat Sleeper
Participant

@hseatsleeper

15 years, 1 month ago

Just a note here – I did the same thing as dragunoff. The only snag I encountered was that the admin account(s) needed special care, or I was locked out of my blog.

Also, I dumped the nicename data into the display_name field.

citizenkeith
Participant

@citizenkeith

15 years, 1 month ago

Can I do this and keep all the existing topics and posts from my current bbPress install?

citizenkeith
Participant

@citizenkeith

15 years, 1 month ago

Nevermind… I figured that part out.

@HSeatSleeper: Can you talk a little bit more about the special care you gave to the admin account? When testing, I got locked out of my blog as well, and couldn’t figure out why (my wp_1_capabilities were set correctly, as was user_level).

Can you easily list the steps you took to secure the admin account? Thanks!