Forum Replies Created
-
It is indeed, just follow the instructions via the docs
Apologies for the late reply but a severe case of the flu has kept me from thinking
Firstly @clicknathan the bbconverter plugin has not been updated in a long time and is what the actual included converter with bbPress 2.x is based upon and indeed if you keep importing on top of imports you are going to have issues.
@trisham I cannot come up with a specific SQL query for you to delete the duplicates, ideally what you want to do is open phpMyAdmin and find the post ID’s of your imports.
i.e. Find the ‘first’ and ‘last’ post ID from your first import and then find the ‘first’ and ‘last’ post ID from your second import.
`SELECT * FROM ‘wp_posts’ WHERE ‘post_type’ LIKE ‘forum’`
`SELECT * FROM ‘wp_posts’ WHERE ‘post_type’ LIKE ‘topic’`
`SELECT * FROM ‘wp_posts’ WHERE ‘post_type’ LIKE ‘reply’`The above queries you should see you started to see the post ‘ID’ for the duplicates and I would expect to find them in a numerical order by post ‘ID’ and this starts to build you a range of post ‘ID’ that you will want to delete.
You may find that the range of post ID’s are eg. 2650 – 5299 that are the duplicates that you need to remove and this SQL query highlights those posts `SELECT * FROM ‘wp_posts’ WHERE ID BETWEEN 2650 AND 5299 ` and this query `SELECT * FROM ‘wp_postmeta’ WHERE post_id BETWEEN 2650 AND 5299 ` finds the same posts in `wp_postmeta`
Once you have confirmed the post ID’s for your duplicates with the queries above and you are confident you have the correct ID’s you grab those SQL statements eg. `SELECT * FROM ‘wp_posts’ WHERE ID BETWEEN 2650 AND 5299 ` and `SELECT * FROM ‘wp_postmeta’ WHERE post_id BETWEEN 2650 AND 5299 ` and change the `SELECT * ` to `DELETE` for both of those queries to remove the posts from `wp_posts` & `wp_postmeta` tables.
I hope this makes some kind of sense and if you have any questions please ask away.
@ianhaycox Many thanks for this Ian
@ianhaycox Excellent news, glad you are now on the case
These two comments should help get you going:
http://bbpress.trac.wordpress.org/ticket/2207#comment:8
http://bbpress.org/forums/topic/bbpress-2-3-now-available/page/2/#post-133211
Cool… Fix is in
Also updated http://codex.bbpress.org/bbpress-user-roles-and-capabilities/
