Jump to content
Sign in to follow this  
  • entries
  • comments
  • views

Migration of Old Posts and Topics

Paul D


Old Forum migration


Had some real fun moving the topics and posts from the old 1.3 version of the IPB software to the latest version.

was well pleased when I actually managed to get it all working.


Anyone thinking of doing the same it is not too bad once you work it all out.


I transferred the members table over, but every member will require to request a new password. Then I found that I could use the old passwords stored in the original database to authenticate. Works a treat :)

The migrated the topics and posts over. The new IPB doesnt have categories, so I had to do some jiggerypockery with the SQL to create my own parent topics which were based upon the categories

( I wish I had saved all the steps as could write a convertor fairly easily now I have done the task once. )


The structure of the old 1,3 database and the latest database though has not changed that dramatically, therefore it is fairly straightforward.



Once I had all my categories amended so that they were loaded as Topics with a parent = -1 and the topics within each category were amended so the parent = new topic created from the category.

I loaded all the Posts and all seemed to work but profile lists werent showing posts made by the members.


Then found this was related to the last_posted,last_visited dates ( I had neglected to copy these over ). Ran some more sql and copied over and members listings then worked.


Then realised everyone had no post counts, so copied these over, only to find the tool that did the task for me.


Still getting there. - Just need to set a date to switch over the old forum ( ie. Switch it off and make everyone use the new one )


Recommended Comments

Well done Paul it's all coming together now


One problem I found was that some forum headings such as lounge, jokes,recipes and forum and site talk were not showing to members.  Investigated and found that permissions had not been set so I went through and ticked the appropriate boxes and now all showing again.  There are one or two other headings but I don't think they are really necessary so will leave unless anyone notices

Share this comment

Link to comment

There were a fair few permissions to set. I also inadvertently left guest posting available and realised because someone posted a "test" posting. I deleted it and set permissions correctly.

We want guests viewing but not posting.

Share this comment

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now