PhpBB migrate script - Updated for beta 5

tommysvr

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.

jeopangindian

tommysvr There's a fixed above by varma

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

miczja94

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?

tommysvr

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)";

TidbitSoftware

@tommysvr I've forked the repo and added a variable that allows the user to provide the Flarum database table prefix they selected during setup. Here's the link until it gets merged to master (hopefully)...

https://github.com/TidbitSoftware/phpbb_to_flarum

UPDATE: The above changes have been merged into the master now.

ChrisG

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

ChrisG

Anybody got any ideas? 🙂

sivivan

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.

jslirola

Applepiee you could try the sivivan's script for beta 8 published in this message. sivivan

Applepiee

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

clarkwinkelmann

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.

Applepiee

clarkwinkelmann I see. I did try it on Beta 8. So I guess Phpbb migration is impossible now?

jeopangindian

@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!

hrvoje_hr

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 😄

clarkwinkelmann

hrvoje_hr you are welcome to open a thread under "Off topic > Showcase" to show us your forum 😃

jordanjay29

hrvoje_hr How can I proceed to share it with others?

To add to what Clark said, feel free to open a new discussion in Resources to post it! If you cross-link the updated version to here, I can close this thread and point to yours.

hrvoje_hr

clarkwinkelmann not yet, still waiting for your magic to put it in production 🙂 For now, we are still on wpForo.

clarkwinkelmann

hrvoje_hr oh you meant share the script then ? I thought you wanted to share the forum 😇

SamOlamilekan

Hello, Please i need video on how to migrate from PHPbb to flarum, am a beginner here

« Previous Page Next Page »