• Off-topic

  • PhpBB migrate script - Updated for beta 5

luceos I've not used composer before, so which part of the installation command needs to change to pull beta 5 instead of 7?

    Out of my head,

    composer create-project flarum/flarum -s beta directory 0.1.0-beta.5

    @ThomasLewis there was a new column that was introduced called "is_private" in beta 7, though, beta 5 to 7 is still a big leap and that script was last updated in May.

    As @luceos stated, you have those two options until the script is updated (or someone makes a mind-blowing importer/migrator through an extension lol)

    Digging a bit further, it seems the failure is after an SQL query to the phpBB DB. $result->num_rows gets set to a Boolean instead of an int count of the number of rows. I’m thinking the DB format for 3.2.1 may be different than the one the script was written for. I’m going to look at the tables and see if there are differences that would cause the query to not return any results.

    I found the error. The SQL queries to the phpBB database used "FROM phpbb_[field]", and the database contained "bb_[field]". So, a quick removal of "php" from each of those lines allowed the script to run successfully.

    7 months later

    Not much action in this thread for a while. I'm trying to run this on a site with ~10000 posts and keep getting a 503. Any simple way to get things to work? Would increasing the memory potentially help?

    Edit: looks like the script actually worked reasonably well! It's really nice...except one pretty big issue: the thread starter's username shows up in the main boards section, but when you enter a thread, everyone is suddenly [deleted]. Any one else had a similar issue? Could it be that the posts etc worked ok, but the users table didn't? Checking the database, the users are indeed in there.

      Hi guys,

      When i importing from phpbb3 to flarum i have errors:

      Wrong SQL: INSERT INTO users (id, username, email, password, join_time, is_activated) VALUES ( '4009', 'x', 'x', 'x', '2016-12-14 15:57:11', 1) Error: Table 'flarumbeta5.users' doesn't exist

      my config:

      $servername = "localhost";
$username = "AgostSan";
$password = "MY_PASS:)";
$exportDBName = "phpbb3";
$importDBName = "flarumbeta5";

      it looks as if the flarumbeta5.users' doesn't exist:
      https://i.imgur.com/WVMYhG2.png

      What am I doing wrong?

        miczja94 I had the same issue, it's fixed by manually adding your table prefix (flarum_) to all table names after INSERT INTO.

        For example:

        $query = "INSERT INTO users (id, username, email, password, join_time, is_activated) VALUES ( '$id', '$formatedUsername', '$email', '$password', '$jointime', 1)";

        Becomes

        $query = "INSERT INTO flarum_users (id, username, email, password, join_time, is_activated) VALUES ( '$id', '$formatedUsername', '$email', '$password', '$jointime', 1)";

          4 months later
          3 months later

          I get these errors...

          Export - Connected successfully
          Current character set: utf8 Import - Connected successfully
          Current character set: utf8
          Step 1 - Users
          Something went wrong.
          Step 2 - Categories
          Something went wrong.
          Step 3 - Topics
          User Discussions
          Table is empty
          last Step Update User table
          Success

          13 days later

          ChrisG

          The reason why you are not seeing any error is because they are most likely disabled. You would like to see the errors then you should enable them via php.ini. Obviosly never do that in production.

          I have been trying to modify the original script as the database structure seems to have changed in beta 0.8

          Try the following script at your risk of course.

              7 months later

              Seems like the last year of posts is missing when I used the script. Any idea what happened?

                Applepiee what version of Flarum are you using this script with ? The title seems to indicate it's for up to beta 5 only (now very old). From the messages above it seems it didn't support beta 8, so it won't support beta 9 either.

                    a month later

                    tommysvr There's a fixed above by varma

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

                      @Applepiee - Hey buddy, are you able to successfully migrate phpBB to Flarum 8.0? Did you encounter any Critical that prevents from migrating to Flarum? Thanks

                      To everyone: I read through the discussion from 2015 to 2019 about phpBB to Flarum migration. It seems that we could migrate phpBB to Flarum. Some key points below:

                      1) Migrate phpBB posts to Flarum
                      -Based on the discussion above this is possible, but need to check.

                      2) Retain old URLs from phpBB posts
                      -As per @robrotheram we could create a viewtopic.php that would get the topic id and redirect to the correct.
                      -Does anyone from 2019 tried this and was able to retain old URLs from phpBB posts? Thanks!

                      3) Retain user data and password
                      -There are 2 fixes provided on this discussion:
                      1st fix:
                      On line 161 its says $posterID = 0; which i chnaged to
                      $posterID = $post['poster_id'];

                      2nd fix:
                      manually adding your table prefix (flarum_) to all table names after INSERT INTO.

                      For example:

                      $query = "INSERT INTO users (id, username, email, password, join_time, is_activated) VALUES ( '$id', '$formatedUsername', '$email', '$password', '$jointime', 1)";

                      Becomes

                      $query = "INSERT INTO flarum_users (id, username, email, password, join_time, is_activated) VALUES ( '$id', '$formatedUsername', '$email', '$password', '$jointime', 1)";

                      Thanks all! Let me know if anyone were able to migrate phpBB with Flarum this 2019 🙂 Thanks!

                      3 months later

                      I've managed to adjust this script to wpForo forum software and successfully converted the wpForo forum of 14k threads, 257k posts, and over a thousand users.

                      How can I proceed to share it with others?

                      @jeopangindian I didn't manage to migrate from phpBB (never worked with it before) but thanks to your help I was able to adjust the script for wpForo 😄