Convertor from old versions of phpBB3 to phpBB 3.0.RC3

[LEW21 Janusz]

Replace the content of install/upgrade_tables/ranks.php with this code:

Code: Select all

<?php
if (!defined('IN_PHPBB'))
{
    exit;
}

// Grab the data from the old table
$rowset = old_sql('SELECT * FROM phpbb_ranks ORDER BY rank_id ASC');

// Empty the new table
clear();

foreach ($rowset as $row)
{
    // Insert data to the new table
    insert(array(
        'rank_id'        => $row['rank_id'],
        'rank_title'    => recode_value('rank_title'),
        'rank_min'        => value('rank_min', 0),
        'rank_special'    => value('rank_special', 0),
        'rank_image'    => value('rank_image', ''),
    ));
}
?>

[John Hjorth]

Hi LEW,

I'll give it a shot and report back here when done.

[LEW21 Janusz]

So try 2nd release and forgot about that 1st, buggy, release Changelog is in first post.

[John Hjorth]

Hi LEW,

Great

[th23]

Hi together,

I'm about to update a BETA 4 board to RC3... Has anyone tried this? Are there any known issues? How about UTF-8 conversion...is that covered by the converter as well?

Thanks LEW for the great work

Thorsten

[John Hjorth]

As already mentioned above, I´m working with this script both locally on fresh test installs of Beta 1 and a live Beta 1 board. I haven't had time so far to move further on and tested the new version uploaded by LEW yesterday, but I will report back here my conclusions when I do. The change to UTF-8 encoding was between Beta 2 and Beta 3, that should not be an issue for you updating a Beta 4 board with this script.

[LeRob]

Works perfectly on Beta 5 once you figure out what you're doing.

[John Hjorth]

I have the second version of the script to work properly on a Beta 1 fresh install to RC3 conversion now. When I try to convert my live Beta 1 board, I now get this error :

[WanderingFox]

Only a few very minor issues going from B5->RC3.

My phpbb3_bots table got reemed. Had the wrong users in it for the bots, was easily fixed by emptying the table and filling it back in with the right info.

Also, my private messages got messed up... They were all there, but the routing information was gone (ie. they were all in one of the private message tables, but not in the other, so only the sender of the message could see the message, the receiver couldn't, but it was counting towards his inbox count). I simply just dumped this table as well as there wasn't anything terribly important in it. Really not a bad sacrifice to get out of Beta and into the RC releases.

[CuLT]

Hey, just want to say that this worked a charm, I was really worried that I had boxed myself into a corner with upgrading to a beta and was dreading having to write a convertor myself. You've made my life significantly easier Thanks!

I did get a NULL conversion error on the bots table, but a refresh seemed to fix it.

FYI, I upgraded from Beta 5-dev to RC3.

Edit: now that you mention it, I've had a chance to explore, and it does indeed appear that PMs aren't showing.

Edit2: running

Code: Select all

INSERT INTO phpBB33_privmsgs SELECT * FROM phpbb3_privmsgs

fixed it for me (where phpBB33_privmsgs was the new table and phpbb3_privmsgs was the old).

Edit 3: Also the bots table was messed up... I just cleared it and copied across the values from the old database.