[@srjrol Participant 11 years, 11 months ago]

Thanks for trying to solve that. I was just going to let it go but it’s turning into a problem when I try to make use of the “bbPress Topic Thumbnails” plugin which attempts to find the image in that first post only and does not look further. At least new posts will not be an issue but it sure would be nice to have the rest discovered.

[@srjrol Participant 11 years, 11 months ago]

edit: host was having an issue.

[@srjrol Participant 11 years, 11 months ago]

‘wp_forum_threads’ has a ‘closed’ column where 0 is open and 1 is closed.

‘wp_forum_threads’ has a ‘status’ column with values of ‘sticky’ or ‘open’.

I have no problems re-creating the parent forums personally, I just wanted to make sure we had the correct setting as I am sure there will be others who try to use this.

Everything has really gone so much better than I hoped for so I could not be happier with the outcome. Thanks again for all of your help with this!

[@srjrol Participant 11 years, 11 months ago]

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.

[@srjrol Participant 11 years, 11 months ago]

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)

[@srjrol Participant 11 years, 11 months ago]

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

[@srjrol Participant 11 years, 11 months ago]

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

[@srjrol Participant 11 years, 11 months ago]

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

[@srjrol Participant 11 years, 11 months ago]

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?

[@srjrol Participant 11 years, 11 months ago]

Mingle.php

Thanks for taking a look!

[@srjrol Participant 11 years, 11 months ago]

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 Participant 11 years, 11 months ago]

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

[@srjrol Participant 11 years, 12 months ago]

Thank you for taking the time to put this together Stephen. I’ve read the codex a few times over but it’s still a bit over my head. Hopefully over the weekend I will have some more time to make sense of things, but I do appreciate the prompt and very helpful response 🙂

[@srjrol Participant 11 years, 12 months ago]

I would like to try this but I am having some trouble figuring out how to edit the example.php. Are there any instructions for this besides the comments?

Here is the file for reference: http://pastebin.com/MgUCdDp5

Here is the database structure from within phpmyadmin:
` wp_forum_forums
id
name
parent_id
description
views
sort
wp_forum_groups
id
name
description
usergroups
sort
wp_forum_posts
id
text
parent_id
date
author_id
subject
views
wp_forum_reputation_posts
id
author_id
post_id
post_author_id
value
date
wp_forum_threads
id
parent_id
views
subject
date
status
starter
last_post
closed
mngl_id
wp_forum_usergroup2user
id
user_id
group
wp_forum_usergroups
id
name
description
leaders`

If anyone can take a moment to help me get started here it would be very much appreciated. I’m happy to provide any other information that may be helpful, so please just ask.