Wednesday, November 28, 2007

Converting phpBB2 to phpBB3

phpBB is my favorite bulletin board system. After 4 years running on phpBB2, I tried to convert my board to phpBB3 RC7 (this is the latest at the time of writing). My phpBB2 version was 2.0.21. I read many in phpBB community forums, many people had some kinds of problem in conversion with the built-in convertor. I tried it myself and failed for 3 times. The problem was connection timed-out during conversion. Googling a bit, I found a solution. Thanks for the problem solver. You are a hero!. :-) Check it out here. This is how I did it:

Open phpbb3/install/install_convert.php

Find these lines:

/**
*
* @package install
* @version $Id: install_convert.php,v 1.53 2007/10/11 08:12:25 acydburn Exp $
* @copyright (c) 2006 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*/

After those lines, add:
@set_time_limit(0);
@ini_set('memory_limit', '256M');
@ini_set('upload_max_filesize', '128M');
@ini_set('post_max_size', '256M');
@ini_set('max_input_time', '-1');
@ini_set('max_execution_time', '-1');
@ini_set('expect.timeout', '-1');
@ini_set('default_socket_timeout', '-1');
(Adjust timeouts and size as needed.)

Next find:
var $batch_size = 2000;
Change to:
var $batch_size = 6000;
It worked for me. I hope this benefits others. Good luck! :-)


7 comments:

Anonymous said...

Just what I needed! Many thanks man I've posted this article on PHPBB support forums as there was no real help there.

Anonymous said...

How big was your database prior to conversion?

Mine is around 600mb and I have had no joy with the PHPBB suggested fixes, they haven't even been able to get people with 50mb databases up and running!

Anonymous said...

Will this work for a database of 300 megs??? My host is COMPLETELY STUMPED. They have customers coming out of their ears with the same problem and they have tried it all.. cept for this suggestion..

Anonymous said...

My database is only 24MB or so but this worked perfectly to get the forum back up and running.

The one thing I will say which is not the fault of this is that the search index hasn't indexed anything prior to the new install and BB Code doesn't automatically work on all users accounts without them amending a few things.

Zamri said...

All you can try is changing the all of the directives to higher values and then test it. My DB is about 100MB. Change the values higher if you have bigger db and lower bandwidth connection to your server.

Anonymous said...

Hi,
it's not helpful at all to spread knowledge about specific themes all over the web - just because one can.
It makes much more sense to gather, concentrate and discuss this kind of knowledge and experience where it belongs: In the phpBB support forum i.e.
It's a short sightened egoistic act to decentralize this kind of info in private blogs and to only leave links at the places, where the discussion should take place for the benefit of everybody.
My 2 cts.

Zamri said...

Hi there,

The knowledge was taken from there (phpbb forum). Speading the knowledge in a blog/website than can be viewed publicly is the best way to spread it and for others to quickly find answers to their problems. This blog doesn't mean to replace phpbb forum afterall.

Anyway thanks for ur comment.