Forum Replies Created
bbPress does not create any tables of its own, it uses WordPress custom post types for forums, topics, topic tags and replies.
I am slowly getting updated and more docs in the codex starting here:
To customize the Example.php importer I have started this doc which follows this topic on building a new custom importer for the Mingle forums.
This is all a work in progress and has a few moving targets so any questions ask away
I have succumbed and installed Mingle in the need to find what’s going on with the rogue post!
Smileys & Open/Closed Topics are done, stickies we can’t do for now and that will have to wait.
Grab the latest again with https://gist.github.com/4534229/download
I’m still not sure why the extra blank post is turning up
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)
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.
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?
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.
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)
The WP site you are importing into
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?
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.
Can you create a ticket for this over in trac for this please: http://bbpress.trac.wordpress.org/
(Adding some ‘numbers’ would also help eg #subscribers & #posts so we can test this ourselves.)
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
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)
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.
Create a WordPress page called ‘Support’ and use the [bbp-forum-index] shortcode on that page.
I didn’t recogonize it of the top of my head but a quick search landed me here:
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?
I am fairly new around here and have hardly touched the old standalone bbPress.
The following page in the docs was last updated 341 days ago, that said I don’t think there should be that many differences in upgrading from 1.0.x to 1.1/1.2 based on these docs.
Has anyone actually tried this? What breaks if you do follow these steps?
Remember: Constantly make backups of your site with FTP and your SQL Database/s with myPhpAdmin.
Just saying it doesn’t work is not enough, give us detailed information: on what breaks, what doesn’t work, detailed specs of your site, extremely detailed error messages, steps for us and others to reproduce the problem and with this type of information we can all help each other.
This worked for me…
I have just been updating the bbPress importers to support mentions eg. @rossagrant over the past few days and have had ~500,000 posts go through the DB and test site and maybe 1% would have a quote or mention, maybe less, it’s still quite a few and I have don’t see any of the SQL errors you @mention.
Is your site title issue a URL that is displaying like this?
If so it is because the URL is wrapped in single or double quotes and will be fixed in the next version of bbPress, if not could you give us some more detailed info, what it should be and what it is sending in the email.
Edit: Ha, I cant force the error in that URL above, does it look like the URL with the ‘& # 8217′ at the end like your first post here in this topic?