phpBB2 + CH to phpBB3 Upgrade Script(s) Package

[EXreaction]

[quote="jimmygoon":c0ba4]
Actually I didn't "backup" anything, I just copied the directory and the database on my server and used them to play with. I was using the word "luckily" as an expression; I'm actually usually more of a hypocondriak about these things than most people are.

BTW: It wasn't even so much that the script didn't copy the avatars as it was the fact that it failed because of the avatars... luckily my addition fixes that.
[/quote:c0ba4]

Using words in the correct situation, and where they mean what you think helps a lot.

It is fine when you joke around other places, but please don't do so when your asking for support, it confuses the people that are trying to help.

[Handyman]

Exreaction, here are the files I used for my upgrade https://svn.sourceforge.net/svnroot/olympus/phpBB3/UI/
Most of them are duplicates of the ones that were used in the upgrade directory, except for the forums, topics and possibly posts.

[EXreaction]

Thanks.

[EXreaction]

Well yours was nowhere near working for CH 1.6.

So I made my own:

Spoiler:

Code: Select all

<?php
/**
*
* @package Categories Hiearchy 1.6 to phpBB3
* @copyright  2006 EXreaction
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

function add_subforums($forum_id, $parent_id, &$left_id)
{
    global $phpbb2_prefix, $db_phpbb2, $db, $forums_assignment;

    $sql = "SELECT * FROM {$phpbb2_prefix}forums
        WHERE forum_main = '" . $forum_id . "'
        ORDER BY forum_order ASC";
    $subforum_ids = $db_phpbb2->sql_query($sql);
    while($row = $db_phpbb2->sql_fetchrow($subforum_ids))
    {
        // set the forum type
        switch ($row['forum_type'])
        {
            case 'c': // category
                $forum_type = 0;
            break;
            case 'f': // forum
                $forum_type = 1;
            break;
            case 'l': // link
                $forum_type = 2;
            break;
        }

        $db->sql_transaction();
        $sql_ary = array(
            'parent_id'                    => $parent_id,
            'left_id'                    => $left_id,
            'forum_name'                => $row['forum_name'],
            'forum_desc'                => ($row['forum_desc'] == NULL) ? '' : $row['forum_desc'],
            'forum_desc_options'        => 7,
            'forum_link'                => ($row['forum_link'] == NULL) ? '' : $row['forum_link'],
            'forum_rules_options'        => 7,
            'forum_type'                => $forum_type,
            'forum_posts'                => $row['forum_posts'],
            'forum_topics'                => $row['forum_topics'],
            'forum_last_post_id'        => $row['forum_last_post_id'],
            'forum_last_poster_id'        => $row['forum_last_poster'],
            'forum_last_post_time'        => $row['forum_last_time'],
            'forum_last_poster_name'    => $row['forum_last_title'],
            'forum_last_poster_name'    => $row['forum_last_username'],
        );
        $sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
        $db->sql_query($sql);

        $left_id++;

        // $new_id is the new forum's id
        $new_id = $db->sql_nextid();

        // we use this later in the posts and topics upgrade
        $forums_assignment[$row['forum_id']] = $new_id;

        // add all subforums for the current forum
        add_subforums($row['forum_id'], $new_id, &$left_id);

        // Update the right_id
        $sql = 'UPDATE ' . FORUMS_TABLE . " SET right_id = '" . $left_id . "'
            WHERE forum_id = '" . $new_id . "'";
        $db->sql_query($sql);

        $left_id++;
    }
}

// Truncate the forums table so we don't have any duplicate entry problems from old data
$sql = 'TRUNCATE TABLE ' . FORUMS_TABLE;
$db->sql_query($sql);

// initiate the left id
$left_id = 1;

// Start at the first level with main categories
$sql = "SELECT * FROM {$phpbb2_prefix}forums
    WHERE forum_type = 'c'
    ORDER BY forum_order ASC";
$phpbb2_categories = $db_phpbb2->sql_query($sql);
while ($row = $db_phpbb2->sql_fetchrow($phpbb2_categories))
{
    // set the forum type
    switch ($row['forum_type'])
    {
        case 'c': // category
            $forum_type = 0;
        break;
        case 'f': // forum
            $forum_type = 1;
        break;
        case 'l': // link
            $forum_type = 2;
        break;
    }

    $db->sql_transaction();
    $sql_ary = array(
        'parent_id'                    => 0,
        'left_id'                    => $left_id,
        'forum_name'                => $row['forum_name'],
        'forum_desc'                => ($row['forum_desc'] == NULL) ? '' : $row['forum_desc'],
        'forum_desc_options'        => 7,
        'forum_link'                => ($row['forum_link'] == NULL) ? '' : $row['forum_link'],
        'forum_rules_options'        => 7,
        'forum_type'                => $forum_type,
        'forum_posts'                => $row['forum_posts'],
        'forum_topics'                => $row['forum_topics'],
        'forum_last_post_id'        => $row['forum_last_post_id'],
        'forum_last_poster_id'        => $row['forum_last_poster'],
        'forum_last_post_time'        => $row['forum_last_time'],
        'forum_last_poster_name'    => $row['forum_last_title'],
        'forum_last_poster_name'    => $row['forum_last_username'],
    );
    $sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
    $db->sql_query($sql);

    $left_id++;

    // $new_id is the new forum's id
    $new_id = $db->sql_nextid();

    // we use this later in the posts and topics upgrade
    $forums_assignment[$row['forum_id']] = $new_id;

    // add all subforums for the current forum
    add_subforums($row['forum_id'], $new_id, &$left_id);

    // Update the right_id
    $sql = 'UPDATE ' . FORUMS_TABLE . " SET right_id = '" . $left_id . "'
        WHERE forum_id = '" . $new_id . "'";
    $db->sql_query($sql);

    $left_id++;
}

// used later on in the posts upgrade script to make sure the correct forum_id is used with the topics and posts which are converted
$handle = fopen("{$phpbb_root_path}cache/forums.dat", 'w');
fwrite($handle, serialize($forums_assignment));
fclose($handle);
?>

Also...I wish converting the forum wouldn't take so long.
...there are only 196 members...but 84,068 posts.

The 500 second php time limit wasn't enough.

[lord idiot]

Try migrating a 770,722 post forum I had to add limits to the sql query's otherwise the server went down But I'm halfway now

[Highway of Life]

greetings foks. first time caller, long time listener. Any changes I can make to get this to allow the NULL? Many thanks in advance for your help.

Spoiler:

Code: Select all

SQL ERROR [ mysql4 ]

Column 'topic_id' cannot be null [1048]

SQL

INSERT INTO phpbb_attachments (attach_id, post_msg_id, topic_id, in_message, poster_id, physical_filename, real_filename, download_count, attach_comment, extension, mimetype, filesize, filetime, thumbnail) VALUES ('14', '570', NULL, '0', 9, 'thechamp_252.jpg', 'THECHAMP.JPG', '32', '', 'jpg', 'image/jpeg', '10988', '1128471294', '0')

BACKTRACE


FILE: includes/db/mysql4.php
LINE: 120
CALL: dbal_mysql4->sql_error()

FILE: upgrade/attach_upgrade.php
LINE: 109
CALL: dbal_mysql4->sql_query()

FILE: upgrade/index.php
LINE: 405
CALL: include_once('upgrade/attach_upgrade.php')

[Highway of Life]

Try this, in attach_upgrade.php
FIND:

Code: Select all

'topic_id'                    => $phpbb2_topic_id,

REPLACE, WITH

Code: Select all

'topic_id'                    => ($phpbb2_topic_id == NULL) ? '' : $phpbb2_topic_id,

If you are still getting an error, use:

Code: Select all

'topic_id'                    => ($phpbb2_topic_id == NULL) ? 0 : $phpbb2_topic_id,

instead.

[Overfiend]

your heroism is legendary, sir.

[EXreaction]

Try migrating a 770,722 post forum I had to add limits to the sql query's otherwise the server went down But I'm halfway now

Try this, in attach_upgrade.php
FIND:

Code: Select all

'topic_id'                    => $phpbb2_topic_id,

REPLACE, WITH

Code: Select all

'topic_id'                    => ($phpbb2_topic_id == NULL) ? '' : $phpbb2_topic_id,

If you are still getting an error, use:

Code: Select all

'topic_id'                    => ($phpbb2_topic_id == NULL) ? 0 : $phpbb2_topic_id,

instead.

Eh, that isn't a good idea.

[Overfiend]

ran the script and it went through with no errors. But none of the attachments are showing in the posts.