maximemue (@maximemue)

Forum Replies Created

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

  • maximemue
    Participant

    @maximemue

    its really a pitty. It runs so smoothly, but will only convert 15000 replies. Last try: does anyone moved from phpBB to bbpress with more than 15000 replies???


    maximemue
    Participant

    @maximemue

    Hi all,

    still having trouble to migrate from phpBB 3.2 to latest WP and bbpress. After having added some lines in the phpBB database and changed everything to UTF8 it runs smoothly, converts all 1700 users, converts the forums converts the topics (22,000) and then starts with all replies (200,000). And it will always stop at Topics 14,000 to 14,099. No error message.

    What can I do?? I really need this conversion…

    Thanks for your help!

    Best

    Maxime


    maximemue
    Participant

    @maximemue

    …is it an issue with topics which have been created by authors having deleted their account in the meantime?


    maximemue
    Participant

    @maximemue

    Hi,

    the routine looks more powerful and more transparent, that’s great. However it is doing step 8 again and again:

    “Converting anonymous topic authors (50 through 50 of 50)100%”

    and again, and again, and again…. please help, I am really looking Forward using WordPress, but I need this integrated forum solution 🙁

    Thanks!!

    Maxime


    maximemue
    Participant

    @maximemue

    I have 2.5.16 installed, will try with 2.6, thanks!

    In reply to: phpBB import (again)

    maximemue
    Participant

    @maximemue

    …doh… started the routine in the office, PC will shut down automatically. Ok, will restart it again at home 🙁

    In reply to: phpBB import (again)

    maximemue
    Participant

    @maximemue

    ok, new and perhaps/hopefully last question: the Import is running smoothly but very slowly. 3,5 hours for 16,000 answers/posts (so 200,000 left…).

    Will the import routine stop when I close the admin back-end?

    In reply to: phpBB import (again)

    maximemue
    Participant

    @maximemue

    yeah, it’s stuck…

    In reply to: phpBB import (again)

    maximemue
    Participant

    @maximemue

    Thanks Gregg, I did add the missing columns and now the import routine is doing its job. It takes very long for the answers 13400-13499, let’s hope it is not stuck…

    In reply to: phpBB import (again)

    maximemue
    Participant

    @maximemue

    Hi,

    ok, I have copied the phpBB database into a fresh one. It was UTF8_unicode before, the copy is now utf8mb4_unicode. I have linked the import routine to this new database. I still get this message:

    WordPress-Datenbank-Fehler: [Unknown column ‘users.user_website’ in ‘field list’]
    SELECT convert(users.user_id USING “utf8mb4”) AS user_id,convert(users.user_password USING “utf8mb4”) AS user_password,convert(users.user_form_salt USING “utf8mb4”) AS user_form_salt,convert(users.username USING “utf8mb4”) AS username,convert(users.user_email USING “utf8mb4”) AS user_email,convert(users.user_website USING “utf8mb4”) AS user_website,convert(users.user_regdate USING “utf8mb4”) AS user_regdate,convert(users.user_aim USING “utf8mb4”) AS user_aim,convert(users.user_yim USING “utf8mb4”) AS user_yim,convert(users.user_icq USING “utf8mb4”) AS user_icq,convert(users.user_msnm USING “utf8mb4”) AS user_msnm,convert(users.user_jabber USING “utf8mb4”) AS user_jabber,convert(users.user_occ USING “utf8mb4”) AS user_occ,convert(users.user_interests USING “utf8mb4”) AS user_interests,convert(users.user_sig USING “utf8mb4”) AS user_sig,convert(users.user_from USING “utf8mb4”) AS user_from,convert(users.user_avatar USING “utf8mb4”) AS user_avatar FROM phpbb_users AS users LIMIT 0, 100

    Any thoughts where I could start searching for errors?

    Thanks a lot!

    Best

    Maxime

    In reply to: phpBB import (again)

    maximemue
    Participant

    @maximemue

    ahhh ok, understood, it’s just about preparing the old database so the import routine will work. Ok, thanks für your help, will try it!!

    In reply to: phpBB import (again)

    maximemue
    Participant

    @maximemue

    @Gregg: thanks a lot for your problem and solution description. I think I have the same issue (phpBB 3.1, current WordPress/bbpress)

    WordPress-Datenbank-Fehler: [Unknown column 'users.user_website' in 'field list']
    SELECT convert(users.user_id USING "utf8mb4") AS user_id,convert(users.user_password USING "utf8mb4") AS user_password,convert(users.user_form_salt USING "utf8mb4") AS user_form_salt,convert(users.username USING "utf8mb4") AS username,convert(users.user_email USING "utf8mb4") AS user_email,convert(users.user_website USING "utf8mb4") AS user_website,convert(users.user_regdate USING "utf8mb4") AS user_regdate,convert(users.user_aim USING "utf8mb4") AS user_aim,convert(users.user_yim USING "utf8mb4") AS user_yim,convert(users.user_icq USING "utf8mb4") AS user_icq,convert(users.user_msnm USING "utf8mb4") AS user_msnm,convert(users.user_jabber USING "utf8mb4") AS user_jabber,convert(users.user_occ USING "utf8mb4") AS user_occ,convert(users.user_interests USING "utf8mb4") AS user_interests,convert(users.user_sig USING "utf8mb4") AS user_sig,convert(users.user_from USING "utf8mb4") AS user_from,convert(users.user_avatar USING "utf8mb4") AS user_avatar FROM phpbb_users AS users LIMIT 0, 100
    

    If you say you exported the phpBB Database, do you mean simply with phpmyamdin? But then what do I have to do, simply create a new one in phpMyAdmin and import this database? this I would understand, but how do I tell bbpress to use this database?

    Thanks for your help!!

    Best

    Maxime

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