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…

Advertisements

Published by

attilaacs

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s