Skip to:
Content
Pages
Categories
Search
Top
Bottom

Fix for PHPBB3 to BBPress conversion script


  • pixelnated
    Participant

    @pixelnated

    Since I was helping a friend convert a phpbb2 board to phpbb3 I thought I’d take the time to also import the forums into bbpress (my preference).
    I initially tried the import but could not get it to work and after looking on the forums saw that I was not alone.
    To get the import to work I had to remap some fields in the phpbb conversion script and comment out some obsolete ones (took about 30 minutes.

    If anyone needs to get your PHPBB3 users and forums converted in BBPress you can replace the phpBB.php file in wp-content\plugins\bbpress\includes\admin\converters to match the following updated code: https://gist.github.com/pixelnated/a7a9c41154cf64696ddd1c2e4f4327ed

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

  • Stephen Edgar
    Keymaster

    @netweb

    @pixelnated, if you use the version here it includes a bunch of other enhancements 🙂
    https://bbpress.trac.wordpress.org/browser/trunk/src/includes/admin/converters/phpBB.php


    pixelnated
    Participant

    @pixelnated

    Thanks @netweb! I should have known that bridge had already been crossed 🙂


    pixelnated
    Participant

    @pixelnated

    In an unrelated item – whenever I post on these forums in FireFox my posts seem to vanish as soon as I hit submit (although the forum post time seems to have updated) & the formatting tools can’t be seen.

    Writing this from chrome….


    pixelnated
    Participant

    @pixelnated

    No dice with bbPress 2.6-beta-2 either 🙁
    No biggie – I’ll just rollback and get it done. I like where it is heading with all the additional info though

    WordPress database error: [Unknown column ‘users.id’ in ‘field list’]
    SELECT convert(users.id USING “utf8mb4”) AS id,convert(users.password USING “utf8mb4”) AS password,convert(users.salt USING “utf8mb4”) AS salt,convert(users.username USING “utf8mb4”) AS username,convert(users.email USING “utf8mb4”) AS email,convert(users.www USING “utf8mb4”) AS www,convert(users.r_time USING “utf8mb4”) AS r_time,convert(users.aim USING “utf8mb4”) AS aim,convert(users.yim USING “utf8mb4”) AS yim,convert(users.icq USING “utf8mb4”) AS icq,convert(users.msn USING “utf8mb4”) AS msn,convert(users.gmail USING “utf8mb4”) AS gmail,convert(users.sig USING “utf8mb4”) AS sig,convert(users.location USING “utf8mb4”) AS location,convert(users.users_text USING “utf8mb4”) AS users_text FROM phpbb3_users AS users LIMIT 0, 250

    No users to convert

    No data to clean

    Starting Conversion


    pixelnated
    Participant

    @pixelnated

    This one seemed to work for me – added some of the additional profile meta info hooks that were in the trunc version and added/edited them in here – https://gist.github.com/pixelnated/5c27a64c450578440554ba902560178f

    50k users and the full forums imported without issue 🙂
    Thanks!


    jimblais
    Participant

    @jimblais

    I replaced the phpBB converter code as above and when I run it, it finds nothing. It runs through but does not create forums nor topics, etc. Please advise.


    jimblais
    Participant

    @jimblais

    Update: this latest posts’ scripts seems to be working


    lantaarntje
    Participant

    @lantaarntje

    This fix indeed has the intention to convert my phpbb3.2 forum to bbpress 2.6 beta 2 😉 The conversion is still running so i don’t know for sure 😛 #goodjob


    jh20001
    Participant

    @jh20001

    Woot. This worked for me, however it didn’t properly import the forums/topics. They would list the count but would display as no topics under each. I then used this to get the users over and then paused it, switched over to the normal importer from RC6 for the rest, but it still listed them all as Anonymous (although brought in all of the forums, subforums and topics).

    Before and after, the RC6 importer gets stuck at step 8 with a looping “Converting anonymous topic authors (500 through 500 of 500)” every 2 seconds for what seems to be indefinitely. Forums are such a pain in the arse. 🙂


    spaceman_qc
    Participant

    @spaceman_qc

    I have the same problem here. First few user have been converted then it keeps looping without doing anything. Please help.


    jh20001
    Participant

    @jh20001

    I finally gave up and spent the ungodly amount of hours repairing and bringing the phpbb board back to life and went with that. This was a nice hope for a good change though as WordPress is so much easier to work with stability wise.


    spaceman_qc
    Participant

    @spaceman_qc

    Well I guess I’ll have to dig into both database and do it myself 🙁

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