import from Kunena to vbulletin 4.2.1

[s_cocis]

I followed this guide http://www.technopat.net/forum/web-p...n-4-2-0-a.html

but are not detected all sections and not detected all thread/post

can you help me?

[s_cocis]

during import there is not 4.2,* from menu option "Select version and product to export to :: "

[Ivan Beser]

Import from Kunena with users, forums, threads and posts worked fine for me after some adjustments with base from http://www.technopat.net/forum/web-p...n-4-2-0-a.html. Thanks for that! :-)

You need a new database with a backup of your kunena / joomla database in it.
You have to delete every table in new database except the following tables:
(The Table have to be renamed after import from [tableprefix_]kunena_groups to kunena_groups or [tableprefix_]users to users!)

kunena_attachments
kunena_categories
kunena_favorites
kunena_groups
kunena_messages
kunena_messages_text
kunena_moderation
kunena_sessions
kunena_smileys
kunena_subscriptions
kunena_users
kunena_whoisonline

and the joomla -tables users and usergroups
******************
Now download impex and install it to your new VBulletin (tested with 4.2.2). Please remind your self to fill the config file!
Delete every system from impex\systems\* except impex\systems\fireboard.
Open the file impex\systems\fireboard\000.php and replace the following codes:

mark at row 51:

var $_valid_tables = array (
        'fb_announcement', 'fb_attachments', 'fb_categories', 'fb_favorites', 'fb_groups', 'fb_messages', 'fb_messages_text', 'fb_moderation',
        'fb_ranks', 'fb_sessions', 'fb_smileys', 'fb_subscriptions', 'fb_users', 'fb_whoisonline'
    ); 

replace with this:

var $_valid_tables = array (
        'attachments', 'categories', 'favorites', 'groups', 'messages', 'messages_text', 'moderation',
        'sessions', 'smileys', 'subscriptions', 'users', 'whoisonline'
    ); 

mark at 91:

if ($databasetype == 'mysql')
        {
            $sql = "SELECT users.id, users.username
            FROM {$tableprefix}users as users
            LEFT JOIN {$tableprefix}fb_users AS fb_users ON (users.id = fb_users.userid)
            WHERE users.id > {$start_at}
            ORDER by users.id
            LIMIT {$per_page}";
            
            $dataset = $Db_object->query($sql);

            while ($row = $Db_object->fetch_array($dataset))
            {
                $return_array["$row[id]"] = $row['username'];
            } 

replace with:

if ($databasetype == 'mysql')
        {
            $sql = "SELECT users.id, users.name
            FROM {$tableprefix}users
            LEFT JOIN users ON ({$tableprefix}users.userid = users.id)
            WHERE users.id > {$start_at}
            ORDER by users.id
            LIMIT {$per_page}";
            
            $dataset = $Db_object->query($sql);

            while ($row = $Db_object->fetch_array($dataset))
            {
                $return_array["$row[id]"] = $row['username'];
            } 

mark at 119:

if ($databasetype == 'mysql')
        {
            $sql = "SELECT users.*,
             fb_users.*
            FROM {$tableprefix}users as users
            LEFT JOIN {$tableprefix}fb_users AS fb_users ON (users.id = fb_users.userid)
            WHERE users.id > {$start_at}
            ORDER by users.id
            LIMIT {$per_page}";
            
            $dataset = $Db_object->query($sql);

            while ($row = $Db_object->fetch_array($dataset))
            {
                $return_array['data']["$row[id]"] = $row;
                $return_array['lastid'] = $row['id'];
            } 

replace with:

if ($databasetype == 'mysql')
        {
            $sql = "SELECT users.*,
             {$tableprefix}users.*
            FROM {$tableprefix}users
            LEFT JOIN users ON ({$tableprefix}users.userid = users.id)
            WHERE users.id > {$start_at}
            ORDER by users.id
            LIMIT {$per_page}";
            
            $dataset = $Db_object->query($sql);

            while ($row = $Db_object->fetch_array($dataset))
            {
                $return_array['data']["$row[id]"] = $row;
                $return_array['lastid'] = $row['id'];
            } 

Now you have to search every "fb_" (prefix) and replace it with "" (NULL) in every file ... 000.php till 007.php
In some files may no fb_ tags be! Don't wonder!

Now you could start the import!
Take step after step and you will have your data at VBulletin.

If you have any issues while install or import-beginning please google first! There was a error with Mysam engine or somting like that for me ... googled and fixed!

Hope that will help you!

regards
CJ