Skip to:
Content
Pages
Categories
Search
Top
Bottom

phpbb to bbpress


  • aeneas1
    Participant

    @aeneas1

    1. phpbb import seemed to go ok, as did the repair process, all of my phpbb forums appear correctly and so do topics and posts… however no usernames seemed to make the journey, every posts shows “anonymous” as the poster… what can i do to fix this?

    2. read about the lack of avatar migration support, so what’s the best way to add the same user avatars that were used at the phpbb board, i’m guessing this is a manual process, and if so what are the steps?

    thanks very much…

Viewing 5 replies - 1 through 5 (of 5 total)

  • aeneas1
    Participant

    @aeneas1

    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”?

    ex1

    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.

    ex2


    aeneas1
    Participant

    @aeneas1

    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


    Helmuts
    Participant

    @hmprivate

    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


    senatorman
    Participant

    @senatorman

    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

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.
Skip to toolbar