PhpBB migrate script - Updated for beta 5

robrotheram

I have updated the top of the post with instructions and a updated scipt that now does formatting and fixes a few bugs.

ozkans

Oh, you mean prior to install?

robrotheram

ozkans You can run the script at anytime to generate the flaurm.sql file. The most reliable way to import the data into flarum is to have a fresh forum with the admin account you setup with a username and email different to any stored in the phpbb database / flaurm.sql.

I went for a sql file export rather then some direct database changes because some people aka me for example have phpbb running but are testing or have flarum on a different machine but still want to see there phpbb data.

VTX

Thanks for providing this script. Any idea's how to handle attachments? Is there already some kind of plugin/extension for flarum to support attachments?

robrotheram

VTX I have to admit I have not looked at attachments mainly due to the forum I was migrating did not allow attachments to be uploaded only public links to places such as imgur. It would depend on the url phpBB gives for the links. if they are relative such as /uploads/filename.ext then you should be able to copy over the folder and set a static path in apache / nginx config. The other option is change the link URL could be done with some find and replace magic on the resulting sql file. Sadly I don't have the time to investigate further

KarlWard

Sorry to butt in to this discussion, but are there any suggestions how to migrate or redirect existing phpBB urls? I have a forum with 7000 unique topics, using the standard viewtopic.php?f=52&t=8814. As far as I can see, when migrating to flarum, all existing url's would simply become 404.

VIRUXE

I've been editing this script for quite a while now. It's still not finished but it has worked great for me.
P.S.: Don't mind Github's silly indentation.

gist.github.com/viruxe/5a1be93ec1e8e6c9288b

robrotheram

VIRUXE wow excellent work I been meaning to get back to this but life been getting in the way glad someone else has done more work on it ?

VIRUXE

robrotheram well I'm not too happy about the code but as long as it does the job it should be fine.
Although I think this would benefit from a proper repository.

robrotheram

VIRUXE I think you are right so I went ahead and created one https://github.com/robrotheram/phpbb_to_flarum I added my script and then committed your script so we can see the changes you are welcome to do with this as you want

VIRUXE

robrotheram Actually I was thinking about having your script in a repo and then I would commit my parts of code and document all the changes with each commit instead.

robrotheram

Updated the initial post.
Thanks to all the contributions the script has had

TLDR script works for beta 5
now only does DB --> DB migration (no messy sql files to worry about)
script is here: https://github.com/robrotheram/phpbb_to_flarum

VIRUXE

I totally forgot about this. I'll have a look and see if I can help with anything.

robrotheram

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 ?

isti37

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.

robrotheram

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

isti37

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.

viet

Which phpBB version is stable for this script?

VIRUXE

viet the latest one.

« Previous Page Next Page »