bbPress phpBB import via https://bbpress.org/forums/topic/replies-not-showing-in-backend-strange-issue-with-froumstopics/#post-162848

gistfile1.sql

INSERT INTO bb_users(ID,user_login,user_nicename,user_email,user_url,user_registered, display_name) SELECT user_id, username, username, user_email, user_website, FROM_UNIXTIME(user_regdate), username FROM phpbb_users;
INSERT INTO bb_bp_xprofile_data(field_id,user_id,value) SELECT '3', user_id, user_from FROM phpbb_users;

INSERT INTO bb_bp_xprofile_data(field_id,user_id,value) SELECT '4', user_id, REPLACE (user_sig, CONCAT (":", user_sig_bbcode_uid), "") FROM phpbb_users;


INSERT INTO bb_bp_xprofile_data(field_id,user_id,value) SELECT '7', user_id, user_occ FROM phpbb_users;
INSERT INTO bb_bp_xprofile_data(field_id,user_id,value) SELECT '8', user_id, user_interests FROM phpbb_users;
INSERT INTO bb_bp_xprofile_data(field_id,user_id,value) SELECT '5', user_id, user_aim FROM phpbb_users;
INSERT INTO bb_bp_xprofile_data(field_id,user_id,value) SELECT '6', user_id, user_yim FROM phpbb_users;
INSERT INTO bb_bp_xprofile_data(field_id,user_id,value) SELECT '9', user_id, user_gtalk FROM phpbb_users;
INSERT INTO bb_bp_xprofile_data(field_id,user_id,value) SELECT '10', user_id, user_jabber FROM phpbb_users;
INSERT INTO bb_bp_xprofile_data(field_id,user_id,value) SELECT '12', user_id, user_icq FROM phpbb_users;
INSERT INTO bb_bp_xprofile_data(field_id,user_id,value) SELECT '13', user_id, user_msnm FROM phpbb_users;
INSERT INTO bb_posts(post_content,post_title,post_excerpt,post_name,post_type) SELECT forum_desc, forum_name, forum_id, forum_name, 'forum' FROM phpbb_forums;
INSERT INTO bb_terms(term_id,name,slug) SELECT cat_id, cat_title, cat_order FROM phpbb_categories;
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '2', '2', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '3', '3', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '4', '4', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '5', '5', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '6', '6', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '7', '7', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '8', '8', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '9', '9', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '10', '10', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '11', '11', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '12', '12', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '13', '13', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '14', '14', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '15', '15', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '16', '16', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '17', '17', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '18', '18', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '19', '19', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '20', '20', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '21', '21', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '22', '22', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '23', '23', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '24', '24', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '25', '25', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '26', '26', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '27', '27', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '28', '28', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '29', '29', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '30', '30', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '31', '31', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '32', '32', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '33', '33', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '34', '34', 'category';
INSERT INTO bb_term_taxonomy(term_taxonomy_id,term_id,taxonomy) SELECT '35', '35', 'category';

UPDATE phpbb_topics t1, (
	SELECT ID, post_excerpt from bb_posts
) t2
SET t1.forum_id = t2.ID
WHERE t1.forum_id is not null and t1.forum_id = t2.post_excerpt;

INSERT INTO
	bb_posts(post_title,post_excerpt,post_author,post_name, post_date, post_type, post_parent)
	SELECT topic_title, topic_id, topic_poster, topic_title, FROM_UNIXTIME(topic_time),'topic', forum_id FROM phpbb_topics;

INSERT INTO
	bb_posts(post_title,post_excerpt,post_name,post_content,post_type)
	SELECT post_subject, post_id, post_subject, REPLACE (post_text, CONCAT (":", bbcode_uid), ""), 'reply' FROM phpbb_posts_text;
	
UPDATE bb_posts t1, (
	SELECT post_id, topic_id, poster_id, post_time from phpbb_posts
) t2
SET t1.post_parent = t2.topic_id,
	t1.post_author = t2.poster_id,
	t1.post_date = FROM_UNIXTIME(t2.post_time),
	t1.post_modified = FROM_UNIXTIME(t2.post_time)
WHERE t1.post_type = 'reply' and t1.post_excerpt = t2.post_id;


INSERT INTO bb_usermeta(user_id,meta_key,meta_value) SELECT user_id,'bb_capabilities', 'a:2:{s:10:"subscriber";b:1;s:15:"bbp_participant";b:1;}' FROM phpbb_users;



UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[b:", 1),
    "[b",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[b:", post_content)))
)
WHERE post_content LIKE "%[b:%]%";
UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[/b:", 1),
    "[/b",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[/b:", post_content)))
)
WHERE post_content LIKE "%[/b:%]%";

UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[u:", 1),
    "[u",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[u:", post_content)))
)
WHERE post_content LIKE "%[u:%]%";
UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[/u:", 1),
    "[/u",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[/u:", post_content)))
)
WHERE post_content LIKE "%[/u:%]%";

UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[i:", 1),
    "[i",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[i:", post_content)))
)
WHERE post_content LIKE "%[i:%]%";
UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[/i:", 1),
    "[/i",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[/i:", post_content)))
)
WHERE post_content LIKE "%[/i:%]%";

UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[s:", 1),
    "[s",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[s:", post_content)))
)
WHERE post_content LIKE "%[s:%]%";
UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[/s:", 1),
    "[/s",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[/s:", post_content)))
)
WHERE post_content LIKE "%[/s:%]%";

UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, LOCATE(":", post_content, LOCATE("[color=", post_content)), 1),
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[color:", post_content)))
)
WHERE post_content LIKE "%[color=%]%";

UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[/color:", 1),
    "[/color",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[/color:", post_content)))
)
WHERE post_content LIKE "%[/color:%]%";

UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[quote:", 1),
    "[quote",
    SUBSTRING(post_content, LOCATE("=", post_content, LOCATE("[quote:", post_content)))
)
WHERE post_content LIKE "%[quote:%=%]%[/quote:%]%";
UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[/quote:", 1),
    "[/quote",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[/quote:", post_content)))
)
WHERE post_content LIKE "%[/quote:%]%";



UPDATE bb_bp_xprofile_data SET value = CONCAT (
    SUBSTRING_INDEX(value, "[img", 1),
    "[img",
    SUBSTRING(value, LOCATE("]", value, LOCATE("[img", value)))
)
WHERE field_id=4;
UPDATE bb_bp_xprofile_data SET value = CONCAT (
    SUBSTRING_INDEX(value, "[/img", 1),
    "[/img",
    SUBSTRING(value, LOCATE("]", value, LOCATE("[/img", value)))
)
WHERE field_id=4;








UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[img:", 1),
    "[img",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[img:", post_content)))
)
WHERE post_content LIKE "%[img%[/img%";
UPDATE bb_posts SET post_content = CONCAT (
    SUBSTRING_INDEX(post_content, "[/img:", 1),
    "[/img",
    SUBSTRING(post_content, LOCATE("]", post_content, LOCATE("[/img:", post_content)))
)
WHERE post_content LIKE "%[img%[/img%";


UPDATE bb_bp_xprofile_data SET value = CONCAT (
    SUBSTRING_INDEX(value, "[img", 1),
    "[img",
    SUBSTRING(value, LOCATE("]", value, LOCATE("[img", value)))
)
WHERE field_id=4;
UPDATE bb_bp_xprofile_data SET value = CONCAT (
    SUBSTRING_INDEX(value, "[/img", 1),
    "[/img",
    SUBSTRING(value, LOCATE("]", value, LOCATE("[/img", value)))
)
WHERE field_id=4;