BuddyPress->bbPress forum migration loses replies
I’m going through the odious task of importing a Ning forum to bbPress. The hard part (or so I thought) is done. I was able to get about everything from Ning into BuddyPress.
However, when I get to the last phase–BuddyPress to bbPress migration–which I thought would be easy-peasy, I lose all the replies to the forum topics! I’m following the migration process exactly (as far as I know) but it always fails. Here are the details:
I’m currently on a local server using XAMPP.
BuddyPress 2.3.3 (using the default theme)
The only other plugins I have installed are The Events Calendar (which you kind of need for the Ning conversion) and BackupBuddy, so that I can restore/reset after every unsuccessful attempt.
I have a smallish forum of fewer than 100 people and 4 groups.
At the time of this writing, I’ve restored the site to its last successful state:
– All data successfully imported into BuddyPress
– bbPress is installed and activated
– Final migration has not yet been attempted.
So, you can see all forums and replies, etc., in the BuddyPress theme on the site. The bbPress forums section in the admin menu is empty, as expected.
Now my typical next step, which always fails, is to follow the codex on migrating forums from BuddyPress to bbPress. I’ve been following it to the letter:
Unfortunately, during Step 5, the actual import step, I get the following error message:
WordPress database error: [Table 'foo.wp_bb_terms' doesn't exist]
SELECT convert(term_relationships.object_id USING "utf8mb4") AS object_id,convert(term_taxonomy.term_taxonomy_id USING "utf8mb4") AS term_taxonomy_id,convert(terms.name USING "utf8mb4") AS name,convert(terms.slug USING "utf8mb4") AS slug FROM wp_bb_term_relationships AS term_relationships INNER JOIN wp_bb_term_taxonomy AS term_taxonomy USING (term_taxonomy_id) INNER JOIN wp_bb_terms AS terms USING (term_id) LIMIT 0, 100
I can’t tell if it is just complaining or if the import has actually failed at that point. Nevertheless, I finish all the steps. At that point, the groups have become forums in bbPress and the topics have transferred but only the first post in each. All replies are gone and I haven’t found any way to restore them.
One additional detail–I don’t know if it’s relevant. In order to do the Ning conversion, it’s best if you use BuddyPress v1.6, which I did. Afterward, I updated to the latest version. (Is that why wp_bb_terms didn’t get created?)
I’d greatly appreciate any insight on this. I’m so happy to be getting away from Ning–I can’t believe I’m getting tripped up on the WP side! 🙂
- You must be logged in to reply to this topic.