phpBB3 upgrade

So I updated the Slash forum to phpBB3 since it solves many annoyances I had on there in the past 5 years or so. The conversion of the 400000+ posts went relatively smooth but took a while to finish. I had to let it run overnight.

After the initial setup and style changes, I went ahead and started to rearrange the forums and categories. As it turns out, that was a bad idea. For some reason I couldn’t move some of the forums or they were just nested under random other ones. So without a backup I cleared some of the fields in the database. Another bad idea…

After hours and hours of trying to figure out how they are sorted I came across a support article about something called a “binary tree”. Whatever that might be (I couldn’t really understand anything beyond the most basic explanation), but that was my problem.

A few minutes later I found this handy script. It rebuilds the binary tree based on the parent_forum ID I put into the DB manually… And it worked! Just execute that code and you can move and edit and delete the forums and all sub-forums.

I’m glad it saved me from having to reconvert all the posts and users!! But it did take a few hours off my afternoon (and evening.. and night)…

Now I’m off to enjoy washing the dishes…


Published by


I've always been interested in all kinds of art because I felt the need to express myself in many different ways. I paint, draw, create 3D models, motion graphics & designs of all sorts, play guitar, love photography and whatever else is in between... I was born in Hungary and lived in Hungary, Germany, Australia and the UK for a number of years. I speak German, English and a little Hungarian (I'm working on improving that one again!).

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s