After further investigations I’ve found a workaround that should work.
Just to recap on the error: it seems like several posts are left with the old phpBB poster id rather than using the new wordpress user_id (which really makes me think that somewhere in the converter code a wrong reference has been used).
The best way to work around the issue is the following (assuming a fresh installation):
1) before migration
– check what is the highest user_id in your phpBB installation (e.g.: 6235)
– insert a dummy row in wp_users with id grater than that (e.g.: 6236, or even better, round it up to 10000). In this way all the converted users will have their IDs starting from a higher value (e.g.: 10001, 10002, …) and it will be easy to spot the posts with wrong author (e.g. post_author < 10000).
2) launch migration as usual
3) after migration, create a temporary table that lists all the bbpress posts with wrong author
/* Get all posts with wrong author and correspondent right author from bbpress 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,
pescasubac,
wp_posts.quea.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 /* all posts of type forum looks to be assigned to the site admin (id=1 in my case)*/
wp_bbp_converter_translator.value_type = 'user' and
wp_bbp_converter_translator.meta_key = '_bbp_old_user_id';
/* this is to be able to create indexes later */
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);
/* indexes to speed up access to the table (some are useless) */
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);
4) Now that you’ve got the list of posts with wrong authors, you can update your wp_posts table accordingly
/* Revert bad authors to good authors */
UPDATE
wp_postsINNER 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') ;
Final consideration:
– this workaround seems to be working for me, but of course I don’t assume any responsibility in case it doesn’t work for you. The update trusts the converter table generated by the bbpress forum converter and assumes that a wrong author id matches the original author id of phpBB forum (I executed some checks and it seems like the problem is always the same = phpBB author id rather than new wordpress author id).
– the update doesn’t fix posts of type ‘forum’ because by default these are assigned to the wordpress site administrator. If you wish to assign them to the original phpBB author, just modify the where condition:
where wp_posts.post_type in ('forum','reply', 'topic') ;
message to the developers: I truly believe somewhere in the converter code a wrong reference is used under certain conditions. The pattern of the error is always the same: when the author doesn’t match it’s because the author id of the phpBB forum rather than the new converted author id.
@netweb
