[Stephen Edgar]

So it imported users, forums, topics & replies? Nice 🙂

There is a blank post by the original author at the start of each topic causing false count

Let me double check that I am not importing something twice…

Parent forums are missing (everything was imported under ‘Forum’)

Joining the `wp_forum_groups` will be a pain if there are ‘id’ conflicts, easy workaround is just manually create the parent category with bbPress.

Custom Smileys, Closed Topics are open again & Stick Topics are normal topics

These three are easy,

Smiley’s: I think these are done 😉

Closed Topics: Does the table `wp_forum_threads` have a specific column for the open/closed status of a topic? If so what are the potential values?

Sticky Topics: Does the table `wp_forum_threads` have a specific column for the sticky status of a topic? If so what are the potential values?

(For the closed and sticky table options, sometimes its numerical 0,1,2 or it might have a value normal or sticky or closed etc)

[srjrol]

I downloaded the new version and the import was successful under wp_ prefix but it seems the same issues remain as I listed above. Many of these are not a problem for me personally except for the blank first post issue which would be nice to correct.

[Stephen Edgar]

Cool…. Everything should work…

With the two posts above of your errors.

Case 1. You used `wp_forum_` on that first revision when I used forum , threads, posts & user as the from_tablename’s, the error you posted was `’str1210409063589.wp_forum_user’` and that is correct as the importer was trying to find `wp_forum_user` which indeed does not exist.

Case 2. You used `wp_` on that second revision when I used forum_forums , forum_threads, forum_posts & users as the from_tablename’s, the error you posted was `’str1210409063589.wp_forums’` and that is not what I would expect to see here, it should be forum_forums.

Can you confirm by downloading the latest revision with this link and replacing Mingle.php with the version extracted from this zip file and use `wp_` as the table prefix.
https://gist.github.com/4534229/download

[srjrol]

I do have them, I was just listing what was relevant to the Mingle Forums but here is the entire list which contains tables from activate and inactive plugins not related to the forums.

wp_blogs
wp_blog_versions
wp_commentmeta
wp_comments
wp_forum_forums
wp_forum_groups
wp_forum_posts
wp_forum_reputation_posts
wp_forum_threads
wp_forum_usergroup2user
wp_forum_usergroups
wp_links
wp_options
wp_postmeta
wp_posts
wp_site
wp_sitemeta
wp_terms
wp_term_relationships
wp_term_taxonomy
wp_usermeta
wp_users
(Edit: I just culled unneeded tables from the list, Netweb)

[Stephen Edgar]

Yes, thats what I wanted…. Why do you not have any WordPress tables in your old site?
Specificity if your users are not stored in `wp_users` where are they stored?

[Stephen Edgar]

If you view the source of the importer browser window, the ‘yellow window’ panel you should see the SQL queries listed in the source…

There are 4 main queries and they should look like this:

• SELECT convert(forum_forums.id USING …
• SELECT convert(forum_threads.id USING …
• SELECT convert(forum_posts.id USING …
• SELECT convert(users.ID USING …

This matches the table structure I listed above and use `wp_` as the table prefix.

[srjrol]

PHPMyAdmin for the OLD site im importing from:

wp_forum_forums
wp_forum_groups
wp_forum_posts
wp_forum_reputation_posts
wp_forum_threads
wp_forum_usergroup2user
wp_forum_usergroups

I hope this is what you were asking, it was not clear to me exactly.
PHPMyAdmin for the NEW site im importing into:

wp_bbp_converter_translator
wp_commentmeta
wp_comments
wp_links
wp_options
wp_postmeta
wp_posts
wp_terms
wp_term_relationships
wp_term_taxonomy
wp_usermeta
wp_users

[Stephen Edgar]

Ok… What is the table structure showing in phpMyAdmin?
This would be the old WP/Mingle site (these are based on the DB schema in your first post)

• wp_commentmeta
• wp_comments
• wp_forum_forums
• wp_forum_groups
• wp_forum_posts
• wp_forum_threads
• wp_forum_usergroup2user
• wp_forum_usergroups
• wp_links
• wp_options
• wp_postmeta
• wp_posts
• wp_terms
• wp_term_relationships
• wp_term_taxonomy
• wp_usermeta
• wp_users

The WP site you are importing into

• wp_commentmeta
• wp_comments
• wp_links
• wp_options
• wp_postmeta
• wp_posts
• wp_terms
• wp_term_relationships
• wp_term_taxonomy
• wp_usermeta
• wp_users

[srjrol]

Yes for the newest file but for the import that worked I used the older file and wp_forum_

[Stephen Edgar]

Did you use `wp_` as the table prefix?

[srjrol]

Using the older version was successful, but the new file gives me this error when importing with or without the users box checked.

`
WordPress database error: [Table ‘str1210409063589.wp_forums’ doesn’t exist]
SELECT convert(forums.id USING “utf8”) AS id,convert(forums.parent_id USING “utf8”) AS parent_id,convert(forums.name USING “utf8”) AS name,convert(forums.description USING “utf8”) AS description,convert(forums.sort USING “utf8”) AS sort FROM wp_forums AS forums LIMIT 0, 100
`

Before anything appeared on the site I ran a complete repair with all option checked. After this was done and the wp_users table was exported/imported through phpMyAdmin everything is showing up. Before the users were imported it still worked but all except the admin posts were Anonymous.

Working:

• All forums that contained posts are present
• Forum descriptions
• The timestamps
• User account links and info (Forum Role,Topics Started, Replies Created)
• Topic/Voice counts
• bbcode is working for text formatting
• Started By and Freshness authors
• HTML code was imported and is displaying correctly

Not working:

• Parent forums are missing (everything was imported under ‘Forum’)
• There is a blank post by the original author at the start of each topic causing false count
• Custom Smileys “
• Closed Topics are open again.
• Stick Topics are normal topics

[Stephen Edgar]

What’s next? What works and doesn’t work?

• Is the imported forum hierarchy and order correct?
• Sticky topics, eg ‘sticky’ and/or ‘global sticky’ topics?
• Open or closed topics?
• Does Mingle use BBCodes eg [b]blod[/b] and do we need to convert them from custom HTML to WordPress/bbPress friendly HTML? If so what BBCodes does Mingle use?

Are there any other forums, topics or replies behaviour that has not been imported?

[Stephen Edgar]

Ahhh… Yes, if you are importing to the existing install of WordPress that Mingle is using you do not need to import the users as the existing users will have the same mappings.

If you want to import to a separate WordPress install you will need to import the users.

That was the reason I originally had each field as `’forum_forums’` and I have switched all the fields back to this so now and you should use the table prefix `wp_` on the import settings. I also updated user mappings, I just copied them in from the bbPress1.php importer as this is in the same boat.

I also added some extra phpdoc’s to the code and cleaned up some whitespace and changed the code layout style to match the other importers.

You should be able to use the same links above to download and compare the revisions.

[srjrol]

Thank you Stephen you are my hero! It appears to have worked flawlessly for the forums, but the users were not included. Here is the error I see when trying the import including users:

`
WordPress database error: [Table ‘str1210409063589.wp_forum_user’ doesn’t exist]
SELECT convert(user.userid USING “utf8”) AS userid,convert(user.password USING “utf8”) AS password,convert(user.salt USING “utf8”) AS salt,convert(user.username USING “utf8”) AS username,convert(user.email USING “utf8”) AS email,convert(user.homepage USING “utf8”) AS homepage,convert(user.joindate USING “utf8”) AS joindate,convert(user.aim USING “utf8”) AS aim,convert(user.yahoo USING “utf8”) AS yahoo FROM wp_forum_user AS user LIMIT 0, 500
`
From what I can tell bbpress uses the same registered users as WordPress so I may be able to import those separately.

On another note, if I import to an existing installation instead of a fresh one would the forums be duplicated or just skipped during the import, so only the topics and replies are added?

[Stephen Edgar]

Can you create a ticket for this over in trac for this please: https://bbpress.trac.wordpress.org/
(Adding some ‘numbers’ would also help eg #subscribers & #posts so we can test this ourselves.)

[LiveFreeOrDie]

I’m having this issue after having the issue in this thread, and following the instructions by mesayre:

Custom Theme critical fault: Class 'BBP_Theme_Compat' not found…Whut!?

Did anybody solve this?

Warning: get_class() called without object from outside a class in /home//public_html/wp-content/themes/theme1/functions.php on line 825

[Tippon]

I’m setting up a site at http://aberdaremctc.co.uk/forums/ and using BuddyPress and bbPress for the first time. I’ve managed to set everything up ok, but I can’t adjust the colour of the forum.

I want to either make it the same colour as the rest of my site, or make it transparent, so it fits in a bit better. Can anyone give me some pointers please, even if it’s just the name of the box I want to change so I can search properly 😛

[Stephen Edgar]

Nice… An extremely good first shot at mapping the MySQL database tables…

I have updated the file with a few things and it should now work…

If your WordPress database uses the out of the box `wp_` table prefix then for the Mingle.php converter we will use `wp_forum_` as the table prefix on the import setting.

• The forum slug is the same process as you did for topics & replies
• A couple of `id` vs `parent_id`
• Dates, WordPress stores four dates for a post in the `wp_posts` table, ‘post_date’, ‘post_date_gmt’, ‘post_modified’ and ‘post_modified_gmt’.
  • Forums – In this case forum creation dates do not exist, this will default to the current date
  • Topics – We map ‘date’ to ‘post_date’ & ‘post_date_gmt’ and ‘last_post’ to ‘post_modified’ & ‘post_modified_gmt’
  • Replies – We map ‘date’ to all four ‘post_date’, ‘post_date_gmt’, ‘post_modified’ & ‘post_modified_gmt’.

So as I said, nice first go at it 🙂

You can view the changes inline I made here and download the full file from here.

[latas]

For all users who couldn’t fix the issue that basic users can not reply or create a new topic, I found at least where is my problem.

It is located in the functions.php file in the line 216. This is for the version 2.2.3. I’m using bbpress as plugin in WordPress 3.5.

File located at bbpress plugin folder -> includes/replies/functions.php

The code that does not allow me to post as a Participant is this:
if ( !bbp_check_for_blacklist( $anonymous_data, $reply_author, $reply_title, $reply_content ) )
bbp_add_error( ‘bbp_reply_blacklist’, __( ‘ERROR: Your reply cannot be created at this time.’, ‘bbpress’ ) );

So it looks some blacklist check is working on. And the question is, where in the setup of WordPress, is located the blacklisted information, to verify why this is happening.

By the way, if that function only does what it looks to do by its name, I commented it.
Everything works now.

Can you give me further info about this?

Thanks.

[marvelidea]

I am having a similar problem….

Using WP 3.5 BuddyPress 1.6.3 and bbPress 2.2.3

I have the “Yes. I want this group to have a forum.” CHECKED when creating the group

but I am NOT seeing the forum tab or the group shown in the forum

Any suggestions?

PS.. I followed the latest video tutorial on Labzip.com http://labzip.com/the-definitive-guide-to-buddypress-bbpress-configuration/

[srjrol]

Mingle.php

Thanks for taking a look!

[Stephen Edgar]

Can you upload a copy of your Mingle.php https://gist.github.com/ (or pastebin.com)
(Its much easier for me to look at the code directly)

[simplyivy19]

I am using the latest version of worspress.org and bbpress I am trying to link the forum page into my navigation bar but when i click new page it does not link both of them together. I am very very new to this and I am doing this for a school project.

Thank you in advance for your help.

[apet083]

Hi @johnjamesjacoby, thanks for your reply and for the helpful places to look. I have debugged functions.php in bbpress/includes/replies and it seems that the `redirect_to` is being set to the forum’s URL as in this image:

http://dl.dropbox.com/u/100066470/replyURL.PNG

Thus giving the wrong `reply_url` at the end. Where does `redirect_to` get set?

Thanks

[John James Jacoby]

The stack here is:

• `bbp_get_reply_url()`
• `bbp_get_topic_permalink()`
• `get_permalink( $topic_id )`

The only place this could occur is if `bbp_get_reply_url()` is passed both a `$reply_id`, and a `$redirect_to`, and the `$redirect_to` is the forum permalink, which shouldn’t happen. `bbp_get_redirect_to()` is what gets it in trunk, which is a wrapper for `$_REQUEST[‘redirect_to’]`.

Which is to say, if you have a `$_REQUEST[‘redirect_to’]` field being submitted with the forum permalink, that’s where it will go. Otherwise, I don’t see any other way this could happen in bbPress core.