[rossagrant]

Done:
https://bbpress.trac.wordpress.org/ticket/2162

Thanks!
🙂

[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?

[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.)

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

[srjrol]

I created a new WordPress installation Version 3.5 and installed bbpress plugin Version 2.2.3. Uploaded the Mingle.php file to /bbpress/includes/admin/converters/ and then ran the Tools > Forums > Import Forums tool using the following settings:

Select Platform: Mingle
Database Server: Server IP
Database Port: 3306
Database Name: My database name confirmed with host.
Database User: Same as database name, also confirmed.
Database Password: Confirmed correct password.
Table Prefix: I tried two settings here with the same result (‘wp_’ and ‘wp_forums’)
Rows Limit: 100
Delay Time: 1
Convert Users: Yes (checked)
Start Over: No (unchecked)
Purge Previous Import: No (unchecked)

The result is below:
`
Repair any missing information: Continue
Conversion Complete
No replies to convert
No tags to convert
No topics to convert
No forum parents to convert
No forums to convert
No passwords to clear
No users to convertStarting Conversion
`

I checked after importing and nothing was imported successfully. Any ideas what would cause this? I feel like I have one of the basic import settings wrong (maybe the database table prefix) since nothing is being found at all here.

[srjrol]

Next in the Forum Section for the third database mapping ‘Title’ in Example.php Line#30
`
‘from_tablename’ => ‘forum_forums’
‘from_fieldname’ => ‘name’
`

I was not sure what matched with the fourth mapping for the ‘Forum Slug’ so I have commented that out for now assuming that there is just nothing to import.

For the fifth database mapping ‘Description’ in Example.php Line#43
`
‘from_tablename’ => ‘forum_forums’
‘from_fieldname’ => ‘description’
`

Sixth mapping for ‘Forum display order’ in Example.php Line#50
`
‘from_tablename’ => ‘forum_forums’
‘from_fieldname’ => ‘sort’
`

I also commented out the ‘Forum date update’ in Example.php Lines #56-72 section as there don’t appear to be any corresponding field names.

That wraps up the database mapping for the ‘Forums Section’. Moving along to the ‘Topics Section’ the ‘from_tablename’ appears to be ‘forum_threads’.

The first mapping for the ‘Topic id’ in Example.php Line#76
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘id’,
`

Mapping ‘Forum id’ in Example.php Line#82
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘parent_id’
`

Mapping ‘Topic author’ in Example.php Line#89
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘starter’
`

Mapping ‘Topic Title’ in Example.php Line#96
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘subject’
`

Mapping for ‘Topic Slug’ in Example.php Line#102
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘subject’
`

Mapping ‘Forum id’ (again?) in Example.php Line#109
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘id’
`

For the Topic dates I only found two matching tables instead of four. One is called ‘date’ the other ‘last post’. I assume that bbpress just needs either the GMT time or another format. I confirmed that the format Mingle uses does appear to be GMT based on the database showing “2012-04-29 20:55:59” and checking this. Therefore, I am only editing ‘post_date_gmt’ and ‘post_modified_gmt’ and commenting out the other two as follows.

Mapping ‘post_date_gmt’ in Example.php line#123
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘date’
`

Mapping ‘post_modified_gmt’ in Example.php line#133
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘last_post’
`

That completes the ‘Threads’ section, next are the ‘Tags’ which Mingle does not appear to support.

This section has been commented out entirely.

Next up the ‘Post’ Section appears to map to the ‘forums_posts’ table from Mingle. There are only two ID fields present (id and parent_id) but both have the same values. I was not sure whether it would be better to only import one of the bbpress ids (post,forum,topic) or all three, so I have done all three below.

Mapping ‘Post id’ in Example.php Line#156
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘id’
`

Mapping ‘Forum id’ in Example.php Line#162
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘parent_id’
`

Mapping ‘Topic id’ in Example.php Line#169
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘id’
`

No match found for ‘Author IP’ in Example.php Line#176 – Commented out

Mapping ‘Post author’ in Example.php Line#182
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘author_id’
`

Mapping ‘Topic Title’ in Example.php Line#189
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘subject’
`

Mapping ‘Topic slug’ in Example.php Line#195
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘subject’
`

Mapping ‘Post content’ in Example.php Line#202
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘text’
`

Mapping ‘Topic id’ in Example.php Line#209
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘id’
`

Mapping ‘Topic Dates’ for ‘post_date_gmt’ and ‘post_modified_gmt’ in Example.php Line#223 and #232 (commented out non-GMT imports)
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘date’
`

This ends the ‘Post’ section. I did not make any modifications to the ‘User’ Section. Are changes here required to import normal WordPress users?

The ‘wp_forum_groups’, ‘wp_forum_usergroups’, ‘wp_forum_usergroup2user’ and ‘wp_forum_reputation_posts’ tables are all empty so those must have been for other plugins that I have integrated with Mingle Forums.

I don’t see any further changes to make here so if someone would be kind enough to review this for any mistakes before I give it it a try I will let everyone know how it goes. 🙂

[jwrbloom]

I’m using the bbPress plugin for WordPress, and I’m wondering how to go about changing the theme of the bbPress. Is it mostly dependent upon the WP theme I’m using, aside from CSS changes I make?

[Jared Atchison]

If you’d like to completely hide your forum for non-logged in users there is a plugin for that 🙂

https://wordpress.org/extend/plugins/bbpress-members-only/

[Stephen Edgar]

Hmmmm…. Progress…. That’s good news

I will try to get some time and have a look through the patches for 2.1 and see if anything stands out.

The other problem is that as yet I have not been able to duplicate your bug on my IIS install, I will see if I can spin up a Windows 7/IIS 7.5/PHP 5.3/MySQL 5.1 VM this week and take a further look.

[Stephen Edgar]

Create a WordPress page called ‘Support’ and use the [bbp-forum-index] shortcode on that page.

https://codex.bbpress.org/shortcodes

[Stephen Edgar]

I didn’t recogonize it of the top of my head but a quick search landed me here:

https://core.trac.wordpress.org/ticket/15499 & https://core.trac.wordpress.org/ticket/22742

So it looks like it is generated from RSS Feed requests and that would make sense.

Does your site use the same URL’s now RSS Feeds as it did before and what are your RSS subscribers numbers like?

[Stephen Edgar]

Fair enough, I don’t know of any plugins that support this, you could ask @jaredatch if that’s something he could add to his plugin or head over to trac and create a new detailed ticket of the enhancement you would like to see in future versions of bbPress.

[Ramiuz]

I´m having the exact same problem as Limbobski is questioning. And nobody here is bothering to answer him either.

This question needs a proper solution. There are many of us who have been with BBPress for YEARS now, and we have WordPress and forums on different databases. We need a step-by-step guide on how to keep the content and merge the two together. To successfully update to the newest version of BBpress.

[Lynq]

Topics are custom post types. When you save a post in wordpress and then rename it, the permalink doesn’t change, it stays the same.
This is the same for bbPress.

[Lynq]

You might be better off asking this on the wordpress forums: https://wordpress.org/support/

[yngyachting]

We know wordpress is great system for web world. I already using wordpress website and I am thinking open a new video website with wordpress but not sure yet.. cause of wordpress plugins..wordpress system enough for video website u think ?
Please give some advice.. thank you

[Stephen Edgar]

I just came across this post and it might help

WordPress on Windows Server 2012 with IIS 8 and SQL Server 2012

[Stephen Edgar]

There are a couple of routes you could go down depending on how you plan on running WordPress:

• WIMP (Windows, IIS, MySQL/MS SQL & PHP)

• http://blog.rajenki.com/2012/12/wordpress-on-windows-server-2012-with-iis-8-and-sql-server-2012/
• http://wordpress.visitmix.com/
• (I have no idea how or even if the current logic of the MS SQL WP DB Abstraction plugin would allow us to connect to the DNN database to perform the import)

• LAMP (Linux, Apache, MySQL & PHP)

• Convert your database to MySQL
• http://stackoverflow.com/questions/6315582/how-do-i-convert-files-mdf-ldf-to-mysql-format

Once you have either of the above up and running and my suggestion is most definitely the second option to convert your database to MySQL then it would involve writing a custom import script based on the included example `Example.php` included with bbPress.
(I have been updating all the import scripts lately so hopefully a new version of `Example.php` will not be far away, if not `bbPress1.php` and `phpBB.php` would be better to use as a basis for a custom DNN import script.)

[Lynq]

Well it depends on what your theme uses as it’s sidebar container.

.bbPress is a class which is applied to the body tag so you can tell if it is on a bbPress page.
.sidebar is a guess at what the sidebar container is on your theme.
stack them together and then use display:none to hide the sidebar on all bbPRess pages.
You can add this into your bbPress stylesheet or your wordpress stylesheet (it is usually nicer to add it into your bbPress stylesheet so that all bbPress styles are contained in one place).

Good luck!

[Rachel Biel]

Here is one thing I found:

1. In Settings>Forums, it says:
Archive Slugs
Custom root slugs to prefix your forums and topics with. These can be partnered with WordPress pages to allow more flexibility.

Forums base
 Possible BuddyPress conflict: Member Forums page

Topics base

 

 

I disabled Forums in the BuddyPress area, following a tutorial I found here from you guys.  So, there should be no conflict, right?