[ALPHA] Phorum 5.0.x to phpBB 3.0.x Convertor

[camel1cz]

Hi guys,

after some research I desided to write new native convertor from Phorum 5 for board I administer.
As it may be useful for ppl facing the same problem I do, I share the code here.

It works quite well for my board (about 30,000 users and 2,000,000 posts in 300,000 topics).

Instalation is straight forward - unzip the archive into root of phpBB install. In convert menu of installation should popup new option for conversion.

I'll try to give some support for this code

Download here

[CADC]

Just used converter to go from Phorum 5.2.9a and when I got to the new forums there was no user accounts available except the one that I setup for administrator! Is there something that I don't know about for the converter? Does it not support 5.2.9a?

Any support is good support and thanks for getting me one step closer to being there!

[camel1cz]

Hmmmm, actually I didn't test the user accounts conversion very much as I use custom authentication plugin against external authentication server - my user accounts are automatically created after successfull authentication.

However the conversion code should be quite strightforward... if you have some PHP skills, feel free to modify my code.

[ishvarko]

thank a lot for this convertor. It works fine. Good job.
Users are converted, but you have to move them to REGISTERED group. I did it manualy.
One problem I faced with: my attachments haven't converted. filenames seems to be pulled to attachment db table, but there are no files anywhere.
I found these comments in code:
// with this you are able to import all attachment files on the fly. For large boards
// this is not an option, therefore commented out by default.
// Instead every file gets copied while processing the corresponding attachment entry.
// if (defined("MOD_ATTACHMENT")) { import_attachment_files(); phpbb_copy_thumbnails(); }
But I don't understand where to put this line for copying files

[D¡cky]

The convertor expects the Phorum attachment files to be in the Phorum attach directory. The convertor then copies them to the phpBB3 files directory.

[ishvarko]

thanks, I have succesfully convert attachments las night. Had to install "Store files to disk" Phorum module and change some code in it to store files in one dir. Also some changes for converter required.
Here is 2 string I changed:

Code: Select all

				array('physical_filename',		'files.file_id',	'import_attachment'),
				array('real_filename',			'files.filename',		''),

Attachments are shown in the end of each post/ But i also wnat them to be shown among some text. I made changes for every post_text with regular expresions. Now bbcode for attachments looks like

filename.jpg

.
Here is a sample code for it:

Code: Select all

 <?php
require_once 'MDB2.php'; //PEAR MDB2 used here

$dsn = 'mysqli://user:password@host/dbName';
$options = array(
    'debug' => 2,
    'result_buffering' => false,
);

$mdb2 =& MDB2::factory($dsn, $options);
if (PEAR::isError($mdb2)) {
    die($mdb2->getMessage());
}

$sql="SELECT post_id,post_text  from phpbb_posts";
$res =& $mdb2->query($sql);

if (PEAR::isError($res)) {
    die($res->getMessage());
}
$done=0;
while (($row = $res->fetchRow())) {
    $count=0;
    $updated_text=preg_replace('/\[attachment \d+ (\S+\.\S+)\]/i', '[attachment=0]$1\[/attachment]', $row[1],-1,$count);
    if($count>0){
        $update="UPDATE phpbb_posts set post_text='$updated_text',post_attachment=1 where post_id=$row[0]";
        $affected =& $mdb2->exec($update);
        $done++;
    }
    echo $done.'\n';
}
$mdb2->disconnect();
?>

[hhouwaard]

I have used the convert to convert phorum to phpBB. However, the users do not show up and I am unsure as to how to get the users all to be member of the registered users group. The only user that shows up on the list is the user admin, which is created when phpbb is installed.

Can someone assist me in this? I very much want to be able to convert away from phorum.

Hans

[ishvarko]

Can someone assist me in this? I very much want to be able to convert away from phorum.
Hans

Hi! It was few years ago when I've converted my phorum to phpbb. I realy can't remember exactly what i did, but I'll try to help. First, tell me can you see your users in Database table phpbb_users.

[nbennett]

Hi camel1cz

I am looking to download the Phorum -> phpBB converter you refer to in your original post. Unfortunately, the link you posted is dead. Can you help me out?

Best regards.

[ishvarko]

I have one. Just uploaded to my server: http://perukar.org/exchange/phorum5-php ... 0.1.tar.gz

[Dismal_Bliss]

Awesome! I just registered because I was looking for the same converter. I tried sending a PM but you have to have 5 posts before you can start sending PM's.

Thanks for the link. I will be trying this converter shortly

[Dismal_Bliss]

Everything has worked great except for file attachments. I'm gonna study up what was said above about attachments and see if I can make sense of it.

[Dismal_Bliss]

Hmmm.... not sure if I am getting it.

Sure would like to PM that guy above and pick his brain a bit but I still gotta find another thread or 2 to post in to get my count above 5.

[camel1cz]

Guys, I've just updated the URL for download of the converter in my first post...

[ss18]

hey guys, any help, i keep getting this error while trying to convert

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 3592142 bytes) in /home/site/public_html/phpbb/install/install_convert.php on line 1294