1. the info in the red box looks odd, “index” is the name of the parent directory/forum, don’t want the name “index” to appear in this area, also “anonymous” (given usernames weren’t transferred) should appear in this area, no? after “by”?
2. here you can see that “anonymous” has been entered for all members rather than their actual member names, how do i fix this? also, is there a way to get the same info below the avatar that shows in this forum, the bbpress forum, to show in my forum? is this a plugin? and finally, how do i move the post date from a row above the topic to below the avatar? thanks.
can anyone help me with my above questions?
@aeneas1 I’ve split this into it’s own topic, things can be hard to track otherwise.
Did you do the import with bbPress 2.5.x or 2.6 alpha?
The 2.6 alpha now supports importing from phpBB 3.1.x which fixes quite a few issues with phpBB users, you can get it from https://bbpress.org/download
hi, how did the phpbb import go for you? .. I have a phpbb forum with 11k posts/comments and I’m a bit afraid to make this move..
tx, H
one best way.ive done with my forum. All other ways are not working
-Update phpbb to the latest version
-use the BBpress Alpha 2.6
-import the data from phpbb
-do the fixes down under in separatly ( run sql in 5 steps, begin with the first)
/* Get all posts with wrong author and correspondent right author from translator table */
create table TMP_ORPHANS as
select
wp_posts.ID,
wp_posts.post_author,
wp_bbp_converter_translator.value_id real_author,
IFNULL(wp_posts.post_date, NULL) post_date,
IFNULL(wp_posts.post_date_gmt, NULL) post_date_gmt,
wp_posts.post_content,
CASE
WHEN wp_posts.post_type = 'reply'
THEN (SELECT tmposts.post_title from wp_posts as tmposts where tmposts.id = wp_posts.post_parent)
ELSE wp_posts.post_title
END post_title,
wp_posts.post_excerpt,
wp_posts.post_status,
wp_posts.comment_status,
wp_posts.ping_status,
wp_posts.post_password,
wp_posts.post_name,
wp_posts.to_ping,
wp_posts.pinged,
IFNULL(wp_posts.post_modified, NULL) post_modified,
IFNULL(wp_posts.post_modified_gmt, NULL) post_modified_gmt,
wp_posts.post_content_filtered,
wp_posts.post_parent,
wp_posts.guid,
wp_posts.menu_order,
wp_posts.post_type,
wp_posts.post_mime_type,
wp_posts.comment_count,
( select wp_postmeta.meta_value
from wp_postmeta
where
wp_postmeta.meta_key = '_bbp_author_ip' and
wp_postmeta.post_id = wp_posts.id
) user_ip
from wp_posts
left join wp_users on wp_posts.post_author = wp_users.id
left join wp_bbp_converter_translator on wp_posts.post_author = wp_bbp_converter_translator.meta_value
where
wp_posts.post_type in ('forum', 'reply', 'topic') and
(wp_users.id is null or
wp_users.id = 1) and
wp_bbp_converter_translator.value_type = 'user' and
wp_bbp_converter_translator.meta_key = '_bbp_old_user_id';
/* Do this to be able to create indexes later – some may not work */
ALTER TABLE TMP_ORPHANS modify column post_date datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_date_gmt datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_modified datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_modified_gmt datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column user_ip varchar(40);
ALTER TABLE TMP_ORPHANS modify column post_title varchar(255);
/* we create indexes to speed up the update process */
ALTER TABLE TMP_ORPHANS ADD INDEX(post_date);
ALTER TABLE TMP_ORPHANS ADD INDEX(post_author);
ALTER TABLE TMP_ORPHANS ADD INDEX(real_author);
ALTER TABLE TMP_ORPHANS ADD INDEX(user_ip);
ALTER TABLE TMP_ORPHANS ADD INDEX(post_title);
/* Revert bad authors to good authors */
UPDATE
wp_posts INNER JOIN TMP_ORPHANS
ON wp_posts.id = TMP_ORPHANS.id
set wp_posts.post_author = TMP_ORPHANS.real_author
where wp_posts.post_type in ('reply', 'topic') ;
/* Drop TMP table */
DROP TABLE TMP_ORPHANS;
The result is a compleet database with the good relation between post and author