• Off-topic

  • PhpBB migrate script - Updated for beta 5

VIRUXE
no problem I only really got back to it today, On of my plans now is to work on some rewrite rules for nginx / Apache since now topic/discussion id's are preserved its now possible for old forum links to work ?

    I wonder if we could rewrite the phpbb session handler code to work with flarum so the passwords from phpbb would work with flarum on imported users.

    The seo is a little more complicated, I think one should avoid phpbb/nginx rewrites and stick to routing from the database.

      isti37 There is the possibility to create a phpbb authentication plugin for flaurm that would allow them to log in with the old username and password without having to do any sort of decryption.

      On the seo how would you do it since old links to domain/viewtopic.php?f=12&?t=121 would not work My plan is to have a viewtopic.php the would get the topic id and redirect to the correct post but I am open to suggestions

        a month later

        I am going to just hook into phpbb and send the form from flarum to phpbb auth and login the user on flarum if the phpbb session is set. (the user doesn't have a set password field in flarum -> phpbb login until one changes its password and flarum takes over the login)

        I am waiting for beta 0.6 and I'll migrate a big forum to flarum. I'll keep the old forum locked and redirect everyone to the new forum.

        23 days later

        Which phpBB version is stable for this script?

          3 months later

          Finally, after few hours... I am able to convert phpBB to Flarum Beta 5 succesfully.
          Now my 2 millions++ posts forum has alive, and being checked before release it to production forum..
          Proud being the biggest one..

          Yes, the SSH Composer setup make little bit headacache, but I satisfied with the results.
          I am going to write the installation tricks in separate discussion

          I think, I can modified the database schemes from the script, to convert MyBB forum into Flarum easily with ?

            FBI wow I am amazed it work that well on that size of forum thanks for using the script

                robrotheram
                Your migration scripts so great.
                I have experience to migration at least 4-5 forum engine for many years, and use their popular migrating script also. My big forum cause a huge cpu load, and mostly shared-hosting company "push-me-out" and leave from their server ?

                Thats why, migrating and moving from server to server is my job before LoL :p
                And your script is the coolest, let the process continue even some error occurs.

                By modifying database schemes etc, you have just put the foundation-line for others to get migration tools for any forum.. As long We know the database scheme.

                Thanks Bro, for such great tool...
                After my forum alive, I will trying to convert MyBB also..

                  2 months later
                  20 days later

                  Thanks! Just migrated our old forum with 3000+ users and 100000+ messages to Flarum.

                  I've added some useful stuff in my fork, such as basic attachment transition, discussions time update and cyrillic tags support.
                  Very quick and dirty code (and that's why there is no pull request for it), don't touch it you don't know what you're doing.

                    6 months later

                    Hey,

                    I recently tried this script.
                    I was able to migrate all post and topics, but the username in the posts view are [deleted]

                    But on the home page, i was able to see the correct username of users for the specific post. When checking the database 'post' table the user_id is 0 for all.

                    How can I solve that? @robrotheram @deseven

                    On the way, i have actually solved it ?

                    On line 161 its says $posterID = 0; which i chnaged to
                    $posterID = $post['poster_id'];

                    Solving the issue. now looking for a appropriate way to redirect the Xenforo URL to flarum ?

                    2 months later

                    deseven

                    Parse error: syntax error, unexpected '$exportDbConnection' (T_VARIABLE) in /home/nomakele/public_html/flarum/phpbb/php_to_flarum.php on line 21

                      I can not login with any user of imported, it is as if all the passwords were wrong

                      2 months later

                      @Nomak; check out the README.md file ?
                      The passwords are reset for all users.

                      @robrotheram I haven't checked how passwords are handled in Flarum but sha1(md5(time())) is extremely easy to brute force. time() only changes once per second. It's probably safer to set this the password to something like 'disabled' or an empty string (depending on how passwords in Flarum are handled).

                      a month later

                      I uploaded the php_to_flaurm.php file to the directory where my flarum is installed. I edited the file and entered the username and password of the phpBB database and the phpBB database name for export and Flarum database name for import.

                      I accessed the script at /flarum/php_to_flaurm.php and I get:

                      Export - Connected successfully
                      Current character set: utf8
                      Warning: mysqli::mysqli(): (HY000/1044): Access denied for user 's_scitommy'@'localhost' to database 's_flarum' in /home/s/public_html/flarum/php_to_flaurm.php on line 39
                      Import - Connection failed: Access denied for user 's_scitommy'@'localhost' to database 's_flarum'

                      The instructions never said where to upload the file or how to edit the file. Please help.

                      Thanks,

                      Thomas

                        scitommy Modify php_to_flarum.php and make sure the following variables are filled-in correctly with regards to your phpbb DB config settings:

                        $servername = "localhost";
                        $username = "user";
                        $password = "password";
                        $exportDBName = "PHPforums";
                        $importDBName = "flarum";

                        You ideally drop it in the root of your phpbb installation and make your way to it.

                        When it completes, it will dump a sql file in the same root directory.

                          Thanks for your response. I originally uploaded the file to my flarum root and got the error above. I moved the file to my phpbb root and I get the same error.