Simple Machines Community Forum

SMF Support => Converting to SMF => IPB => Topic started by: Nibogo on October 13, 2010, 07:32:18 PM

Title: [SMF Converter] IPB 3.0
Post by: Nibogo on October 13, 2010, 07:32:18 PM
Software: Invision Power Board (IPB)
Version: 3.0
NOTE: You should test the converted forum before delete your IPB installation, if you need to do it.

Here's the converter from IPB 3.0 to SMF 2.0 RC3, this was tested under an small database so if you have any issues please report them here, data that will be converted:

Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: n3ronx on November 04, 2010, 07:28:00 AM
I'll try this converter with IPB 3.1.   Hope it works  :)

Edit: Is there any guidance for this converter? For example, should i use the same DB for IPB and SMF? Coz I got that error:

Code: [Select]
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 3.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'onderim_smf'@'localhost' for table 'members'
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: Sirandilas on November 04, 2010, 01:31:07 PM
Not work convert.php, please upload now.
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: n3ronx on November 04, 2010, 01:40:25 PM
Not work convert.php, please upload now.

It works actually. If you browse with IE you'll get 404 error. Try with Mozilla Firefox.
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: Sirandilas on November 04, 2010, 01:50:38 PM
Converting members...Wrong value type sent to the database. Date expected. (birthdate) ? why :(
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: silabsoft on November 05, 2010, 01:40:32 PM
I had this problem too change the date structure in the SQL file provided.

mine hangs on coverting topics when it gets to topic 26546 it hangs talking about a duplicate key.
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: Qsa on December 04, 2010, 11:42:07 AM
Fatal error: Call to undefined function loadDatabase() in /home/acropoli/public_html/domain.com/forum/convert.php on line 414

i get this after enthering the pats
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: Norv on December 04, 2010, 03:34:40 PM
Please make sure you're using the converter to SMF 1.1.x on a SMF 1.1.12 installation, and the converter to SMF 2.0 RC4 on a SMF 2.0 RC4 installation.
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: DeWo on December 05, 2010, 02:09:46 PM
Converting members...Wrong value type sent to the database. Date expected. (birthdate) ? why :(

I've got this problem too. Please help ASAP!
My IPB version is 3.1.2
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: ThorstenE on December 11, 2010, 01:47:10 AM
DeWo,
in ipb3_to_smf.sql find:
Code: [Select]
---* {$to_prefix}membersadd after:
Code: [Select]
---{
/* Fix for invalid birthdays */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';
---}
then restart the conversion.
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: DeWo on December 11, 2010, 02:41:45 AM
Thanks TE!
I tried do it by myself but I only deleted converting members.

And I see next problem - SMF doesn't have subforum functions and converted subforums are on main page.

Maybe time to add this function? ;)

DeWo
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: ThorstenE on December 11, 2010, 02:56:55 AM
I tried do it by myself but I only deleted converting members.
huh, could you please test the attached version?

for the subforums: sure, SMF has subforum functionality.. AFAIK the converter skips the board order (parent & childs) because the structure in IPB is completely different (can't test it though, because IPB is paid software and I don't have a copy from an IPB database anymore)
Code: [Select]
/* The converter will set id_cat for us based on id_parent being wrong. */but you could re-arrange the boards after the conversion.
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: DeWo on December 11, 2010, 03:40:17 AM
for the subforums: sure, SMF has subforum functionality.. AFAIK the converter skips the board order (parent & childs) because the structure in IPB is completely different (can't test it though, because IPB is paid software and I don't have a copy from an IPB database anymore)

Oh c'mon :D For these purposes you can use nulled informally ;)
I think it'll  be useful for all of us :)

PS: I'll test attached file tonight (my timezone :))
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: hiredgunz on December 12, 2010, 05:10:01 AM
I am (unfortunately) using ipb 3_0_5, and trying to convert to SMF 2.0 RC4 (RC3 wasn't available) and I'm getting this error:

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)...Wrong value type sent to the database. Integer expected. (id_board)

Looks like it's hanging up on the posts after a certain amount as the conversion script gets around 3K posts and dies.

Jan
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: ThorstenE on December 12, 2010, 08:44:47 AM
hiredgunz,
in ipb3_to_smf.sql find:
Code: [Select]
---* {$to_prefix}messages 200
---{
add after:
Code: [Select]
if(empty($row['id_board']))
$row['id_board'] = 1;
then restart the converter.
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: hiredgunz on December 12, 2010, 04:02:03 PM
Thank you TE, that worked for getting thru step 1, but at step 2 the converter says,

"Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)...Duplicate entry '1-1' for key 1"

Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: DeWo on December 12, 2010, 04:29:11 PM
Change TE code to:
Code: [Select]
if(empty($row['id_board']))
 $row['id_board'] = rand(99, 900);

Then restart the converter. Should works :)

Oh no.. My error :P I didn't finish reading your post and i wrote aswer :P
Take a while, I'll try to help you :)



OK, I think I know :D

Go to phpMyAdmin and exec this SQL query:
Code: [Select]
TRUNCATE smf_personal_messages(if you have diffrent prefix replace "smf_" to other)

And then run converter :)
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: hiredgunz on December 12, 2010, 05:43:54 PM
Thank you kindly for your help, but still got

Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)...Duplicate entry '1-1' for key 1

after a retry...

Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: ThorstenE on December 13, 2010, 02:15:44 AM
hopefully that works, in ipb3_to_smf.sql find:
Code: [Select]
---* {$to_prefix}pm_recipients
---{
$no_add = true;
replace with:
Code: [Select]
---* {$to_prefix}pm_recipients
---{
$no_add = true;
$ignore = true;
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: hiredgunz on December 13, 2010, 06:04:21 AM
So close to finishing .. but,

Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting user avatars... Successful.
Converting settings...
Fatal error: Call to undefined function updateSettingsFile() in /forums/convert.php(1099) : eval()'d code on line 57
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: Norv on December 13, 2010, 10:24:00 AM
Please make a little more modification, to convert.php:
Code: (find) [Select]
require($sourcedir . '/Security.php');
Code: (add after) [Select]
require($sourcedir . '/Subs-Admin.php');
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: cashwed on December 13, 2010, 04:53:15 PM
i have a problem and i don't know what to do :(

Code: [Select]
Converting members... Unsuccessful!
This query:

    SELECT
    m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
    SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
    SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
    SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
    m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
    SUBSTRING(pc.field_3, 1, 255) AS website_title,
    SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
    SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
    SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
    IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
    CASE
    WHEN (m.member_group_id = '4') THEN 1
    WHEN (m.member_group_id = '2') THEN -1
    WHEN (m.member_group_id = '6') THEN 2
    ELSE 0
    END AS id_group,
    CASE
    WHEN (pc.field_5 = 'm') THEN 1
    WHEN (pc.field_5 = 'f') THEN 2
    ELSE 0
    END AS gender
    FROM `fanart_azpire`.members AS m
    LEFT JOIN `fanart_azpire`.pfields_content AS pc ON (pc.member_id = m.member_id)
    LEFT JOIN `fanart_azpire`.profile_portal AS pp ON (pp.pp_member_id = m.member_id)
    LIMIT 0, 500;

Caused the error:

    Unknown column 'pc.field_1' in 'field list'
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: hiredgunz on December 13, 2010, 05:19:06 PM
I made your suggested change Norv and got:

Converting...
Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting user avatars... Successful.
Converting settings...
Warning: filemtime() [function.filemtime]: stat failed for /Settings.php in /****/****/****/forums/Sources/Subs-Admin.php on line 260

Warning: file_get_contents(/Settings.php) [function.file-get-contents]: failed to open stream: No such file or directory in /***/***/***/forums/Sources/Subs-Admin.php on line 263
Successful.
Recalculating forum statistics... Duplicate key name 'ip_index'

Still, the conversion got even closer to the end!
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: ThorstenE on December 14, 2010, 02:40:49 AM
Quote
Recalculating forum statistics... Duplicate key name 'ip_index'
please check http://www.simplemachines.org/community/index.php?topic=242961.msg2867944#msg2867944
Title: Re: [SMF Converter] IPB 3.0
Post by: Insane33 on January 01, 2011, 07:21:47 AM
Converting moderators...Wrong value type sent to the database. Integer expected. (id_board)

How can this be solved?
Title: Re: [SMF Converter] IPB 3.0
Post by: ThorstenE on January 01, 2011, 07:41:19 AM
in invision30_to_smf.sql find:
Code: [Select]
if (empty($row['id_member']))replace with:
Code: [Select]
if (empty($row['id_member']) || empty($row['id_board']))then restart the converter.
Title: Re: [SMF Converter] IPB 3.0
Post by: Insane33 on January 01, 2011, 08:07:47 AM
Actually I have ipb3_to_smf.sql ..did what you said and it's the same error...

Other solutions?
Title: Re: [SMF Converter] IPB 3.0
Post by: ThorstenE on January 01, 2011, 08:12:03 AM
ok, let's try this instead..
Code: [Select]
if (empty($row['id_member']) || !is_int($row['id_board']))
Title: Re: [SMF Converter] IPB 3.0
Post by: Insane33 on January 01, 2011, 08:17:35 AM
Now I get this:
Code: [Select]
Notice: Undefined variable: row in /***/****/*****/smf/convert.php on line 1284

Warning: Invalid argument supplied for foreach() in /***/****/*****/smf/convert.php on line 1284

Warning: array_combine() [function.array-combine]: Both parameters should have at least 1 element in /*****/****/******/smf/Sources/Subs-Db-mysql.php on line 635
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
Title: Re: [SMF Converter] IPB 3.0
Post by: ThorstenE on January 01, 2011, 08:33:13 AM
ok, I believe it might be better to completely remove the moderators block..
Code: [Select]
/******************************************************************************/
--- Converting moderators...
/******************************************************************************/

TRUNCATE {$to_prefix}moderators;

---* {$to_prefix}moderators
---{
$ignore = true;

if (empty($row['id_member']))
unset($row);
---}
SELECT member_id AS id_member, forum_id AS id_board
FROM {$from_prefix}moderators
WHERE member_id != -1;
---*
After removing this code the converter should finish without errors.

I'd be interested in the result of this query:
Code: [Select]
SELECT member_id AS id_member, forum_id AS id_board
FROM ipb_moderators
WHERE member_id != -1;
maybe you can execute it via phpMyAdmin and post the result.
Title: Re: [SMF Converter] IPB 3.0
Post by: Insane33 on January 01, 2011, 08:52:11 AM
I managed to convert something,but all users have 0 posts altough the posts appear on the forums.

I also got an error while converting
Code: [Select]
Converting settings...
Warning: filemtime() [function.filemtime]: stat failed for /Settings.php in /****/****/****/smf/Sources/Subs-Admin.php on line 260

Warning: file_get_contents(/Settings.php) [function.file-get-contents]: failed to open stream: No such file or directory in /****/*****/*****/smf/Sources/Subs-Admin.php on line 263
Successful.
Title: Re: [SMF Converter] IPB 3.0
Post by: ThorstenE on January 01, 2011, 09:00:34 AM
the error in covert.php:
http://www.simplemachines.org/community/index.php?topic=404732.msg2879776#msg2879776
the post counter is fixable via modification:
http://custom.simplemachines.org/mods/index.php?mod=2324
Title: Re: [BETA] [SMF Converter] IPB 3.0
Post by: kR105! on January 14, 2011, 05:54:27 PM
I had this problem too change the date structure in the SQL file provided.

mine hangs on coverting topics when it gets to topic 26546 it hangs talking about a duplicate key.
same error here: "Duplicate entry '1454' for key 1", I tried deleting the topic with that ID and re-run the converter, but the same error appeared but with different number.

Edit: Full log from the converter:
Quote
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Duplicate entry '1454' for key 1
Title: Re: [SMF Converter] IPB 3.0
Post by: ThorstenE on January 15, 2011, 01:33:54 AM
kR105!,
in ipb3_to_smf.sql find:
Code: [Select]
---* {$to_prefix}topics 250add after
Code: [Select]
---{
$ignore = true;
---}
Title: Re: [SMF Converter] IPB 3.0
Post by: kR105! on January 15, 2011, 07:08:49 PM
Worked! Thank you!

The convertion ended with some warnings, but the topics and users was converted sucessfully. The problem now is that my board is mostly spanish text and in the convertion process some characters now appear weird, for example:

IPB: Preséntate
Converted SMF: Preséntate

I tried changing the charset of my new board to ISO-8859-1 but more weird characters appeared so I reverted it to UTF-8.

Can you please help me? Maybe I'm missing something..



Convertion log:
Quote
Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting user avatars...
Warning: copy(/home/kr105/public_html/foro/uploads/av-1247.txt) [function.copy]: failed to open stream: No such file or directory in /home/kr105/public_html/foro2/convert.php(1263) : eval()'d code on line 59
Successful.
Converting settings...
Warning: filemtime() [function.filemtime]: stat failed for /Settings.php in /home/kr105/public_html/foro2/Sources/Subs-Admin.php on line 260

Warning: file_get_contents(/Settings.php) [function.file-get-contents]: failed to open stream: No such file or directory in /home/kr105/public_html/foro2/Sources/Subs-Admin.php on line 263
Successful.
Recalculating forum statistics... Successful.
Title: Re: [SMF Converter] IPB 3.0
Post by: ThorstenE on January 16, 2011, 02:22:35 AM
the warning is a missing avatar file, nothing to worry about.

the charset issue: 
I believe your IPB is UTF-8? you should install SMF with UTF-8 as character set (there should be an option list in install.php) and re-convert the forum.
Title: Re: [SMF Converter] IPB 3.0
Post by: imno007 on January 28, 2011, 12:25:10 PM
Has anyone tried this with IPB 3.1? I need to do a 3.1 conversion to SMF 2.0 RC4, but I'm hesitant to get into it if it's gonna turn into a major pain in the arse.

EDIT: Okay, I see that it has been attempted, though it does look like it will be a pain. ;)
Title: Re: [SMF Converter] IPB 3.0
Post by: Arrnea on February 02, 2011, 03:13:00 AM
Can this be used to convert from IPB 3.0.x to SMF 1.1.12, or only to SMF 2.0 RC?
Title: Re: [SMF Converter] IPB 3.0
Post by: Nibogo on February 02, 2011, 09:04:09 AM
Only SMF 2.0
Title: Re: [SMF Converter] IPB 3.0
Post by: Banksy on February 18, 2011, 01:39:48 PM
I get this error. :(
Converting members...
Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `banksy_ipb`.members AS m
LEFT JOIN `banksy_ipb`.pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `banksy_ipb`.profile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'pp.pp_bio_content' in 'field list'

Title: Re: [SMF Converter] IPB 3.0
Post by: Kaelhy on April 07, 2011, 07:19:30 PM
I have same problem that Banksy. Any Idea what can I do?


OK  I could convert from 3.1.4 to SMF 2.0 RC5 but It had 2 BUT

First: I commented one of last part of convert, this is the code that I commented, I don't know what do that part:

Code: [Select]
                if (!isset($indexes['showPosts']))
                        $smcFunc['db_add_index']($to_prefix . 'messages', array(
                                'type' => 'INDEX', // no key
                                'name' => 'show_posts',
                                'columns' => array('id_member', 'id_member')),
                                array('no_prefix' => true));

Second: I use bio to fill user_title.

USE THIS FILES OVER YOUR OWN RISK.
Title: Re: [SMF Converter] IPB 3.0
Post by: osamabinmusic on April 19, 2011, 09:11:25 PM
I have same problem that Banksy. Any Idea what can I do?


OK  I could convert from 3.1.4 to SMF 2.0 RC5 but It had 2 BUT

First: I commented one of last part of convert, this is the code that I commented, I don't know what do that part:

Code: [Select]
                if (!isset($indexes['showPosts']))
                        $smcFunc['db_add_index']($to_prefix . 'messages', array(
                                'type' => 'INDEX', // no key
                                'name' => 'show_posts',
                                'columns' => array('id_member', 'id_member')),
                                array('no_prefix' => true));

Second: I use bio to fill user_title.

USE THIS FILES OVER YOUR OWN RISK.
Ouch ... Converting moderators...Wrong value type sent to the database. Integer expected. (id_board)
The IPB version is 3.1.0
I will check it. If anyone has the solution, tell us.
Title: Re: [SMF Converter] IPB 3.0
Post by: The 12th Doctor on May 10, 2011, 11:44:39 AM
Just tried converting from 3.1.4 to 2 RC5 and i got this error... Anyone know if theres a fix, nothing came up for me in search...

Quote
Converting members... Unsuccessful!
 This query:<blockquote>SELECT
 m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
 SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
 SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
 SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
 m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
 SUBSTRING(pc.field_3, 1, 255) AS website_title,
 SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
 SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
 SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
 IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
 CASE
 WHEN (m.member_group_id = '4') THEN 1
 WHEN (m.member_group_id = '2') THEN -1
 WHEN (m.member_group_id = '6') THEN 2
 ELSE 0
 END AS id_group,
 CASE
 WHEN (pc.field_5 = 'm') THEN 1
 WHEN (pc.field_5 = 'f') THEN 2
 ELSE 0
 END AS gender
 FROM `doctor`.ipb_members AS m
 LEFT JOIN `doctor`.ipb_pfields_content AS pc ON (pc.member_id = m.member_id)
 LEFT JOIN `doctor`.ipb_profile_portal AS pp ON (pp.pp_member_id = m.member_id)
 LIMIT 0, 500;</blockquote> Caused the error:
 <blockquote>Unknown column 'pp.pp_bio_content' in 'field list'
</blockquote>
Title: Re: [SMF Converter] IPB 3.0
Post by: cam177 on June 22, 2011, 05:47:14 PM
Okay major problem the converter doesnt seem to want to work it isnt detecting my file is there any certain way it is suppose to be uploaded (the IPB) board im using 3.1.4 I need help ASAP
Title: Re: [SMF Converter] IPB 3.0
Post by: bros on June 25, 2011, 12:32:52 AM
So i'm running a conversion for a guy and he was only able to get the database from his old host and he doesn't have a backup of the files. What modifications do I need to make to convert.php to make it so it doesn't need any of the files? I know less things will convert, but the person is alright with that
Title: Re: [SMF Converter] IPB 3.0
Post by: DieWacht on August 04, 2011, 04:19:13 PM
I've done all the Fixes here in the Thread and have update the two files.

Use it on Your own Risk please.

Kind regards, Andy
Title: Re: [SMF Converter] IPB 3.0
Post by: VanKlomp on August 25, 2011, 04:46:39 PM
Doesn't seem to work for IPB 3.2.X
Title: Re: [SMF Converter] IPB 3.0
Post by: nerix on September 04, 2011, 01:59:37 PM
When i try to convert to smf it shows this error:

"Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 3.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'dono91_diskusije'@'localhost' for table 'ipforum_members'"

i have installed ipboard 3.1.4 and smf 2.0 version. Can you help me pls.
Title: Re: [SMF Converter] IPB 3.0
Post by: HAMBONE0 on October 23, 2011, 01:41:11 PM
I've done all the Fixes here in the Thread and have update the two files.

Use it on Your own Risk please.

Kind regards, Andy

I have tried using these files and I still get the same error:


Code: [Select]
Converting members...
Unsuccessful!
 This query:
SELECT
 m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
 SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
 SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
 SUBSTRING(pc.field_3, 1, 255) AS website_title,
 SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
 SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
 SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
 IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
 CASE
 WHEN (m.member_group_id = '4') THEN 1
 WHEN (m.member_group_id = '2') THEN -1
 WHEN (m.member_group_id = '6') THEN 2
 ELSE 0
 END AS id_group,
 CASE
 WHEN (pc.field_5 = 'm') THEN 1
 WHEN (pc.field_5 = 'f') THEN 2
 ELSE 0
 END AS gender
 FROM `kiss-clan_com_-_kissmain1`.ibf_members AS m
 LEFT JOIN `kiss-clan_com_-_kissmain1`.ibf_pfields_content AS pc ON (pc.member_id = m.member_id)
 LEFT JOIN `kiss-clan_com_-_kissmain1`.ibf_profile_portal AS pp ON (pp.pp_member_id = m.member_id)
 LIMIT 0, 500;
 Caused the error:

Unknown column 'pp.pp_bio_content' in 'field list'

IPB version 3.2.3

Any help would be greatly appreciated!
Title: Re: [SMF Converter] IPB 3.0
Post by: eddie1973 on January 13, 2012, 01:56:36 PM
I get this error. IPB 3.2

Code: [Select]
Converting members... Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `flyakaco_myaka`.ibp_members AS m
LEFT JOIN `flyakaco_myaka`.ibp_pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `flyakaco_myaka`.ibp_profile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'pp.pp_bio_content' in 'field list'
Title: Re: [SMF Converter] IPB 3.0
Post by: phantomm on January 25, 2012, 09:36:33 AM
Anyone knows how to fix this converter for IPB 3.2?
Title: Re: [SMF Converter] IPB 3.0
Post by: Sefket on May 05, 2012, 11:38:31 AM
This is for IPB 3.0.

3.2 is a different version.
Title: Re: [SMF Converter] IPB 3.0
Post by: z_0 on May 13, 2012, 03:19:40 PM
well, I made some fixes and seems like it was converted fine from IPB 3.1.2 to the latest SMF (2.0.2).
please check it and use as you want, it worked for me, but seems like I'll not make any changes anymore.
Title: Re: [SMF Converter] IPB 3.0
Post by: fhsds on May 17, 2012, 03:58:06 AM
does not work your converter
Title: Re: [SMF Converter] IPB 3.0
Post by: x1337 on May 26, 2014, 01:20:31 AM
Im getting this any solution please suggest me ?


Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 3.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'xnonymo2_smf1'@'localhost' for table 'members'
Title: Re: [SMF Converter] IPB 3.0
Post by: maav on August 06, 2014, 04:06:49 PM
Hello,
I need to convert from the forum from IP.Board 3.1.4.
Looking converter is, but I can not find it anywhere.
Can you please advise.
thank you
Maav
Title: Re: [SMF Converter] IPB 3.0
Post by: margarett on August 06, 2014, 04:18:44 PM
You can find the "official" converters in our download page

You can also try this one from emanuele
http://www.simplemachines.org/community/index.php?topic=477019.0
Title: Re: [SMF Converter] IPB 3.0
Post by: maav on August 07, 2014, 07:03:56 AM
Hello,
so I got further, but still writes me an error:

The converter detected that your host has open_basedir enabled on this server. Please ask your host to disable this setting or try moving the contents of your Invision Power Board 3.0 to the public html folder of your site.

I have only a backup of the database (.sql).
What this The converted after me really wants?
Thank you
Title: Re: [SMF Converter] IPB 3.0
Post by: margarett on August 07, 2014, 07:44:19 AM
That's a problem... The converter needs to read your IPB's config files to get the database details.
In which folder have you installed SMF?
Title: Re: [SMF Converter] IPB 3.0
Post by: maav on August 07, 2014, 08:10:44 AM
That's a problem... The converter needs to read your IPB's config files to get the database details.
In which folder have you installed SMF?

Since it via forum was too lengthy, so I took the liberty to send a PM.

Thanks
Title: Re: [SMF Converter] IPB 3.0
Post by: margarett on August 07, 2014, 10:37:37 AM
That's not what I meant ;)

Since we only have the database available, we need to "trick" the converter and create a fake "conf_global.php".

What I asked you is what is the folder (on the server) where SMF is installed (eg: /home/user123/public_html)

Also, is your IPB database already imported into phpmyadmin?
Title: Re: [SMF Converter] IPB 3.0
Post by: maav on August 07, 2014, 03:06:09 PM
Hello,
I replied to the PM.
Thank you
Title: Re: [SMF Converter] IPB 3.0
Post by: Owdy on August 30, 2014, 03:49:27 AM
Code: [Select]
Converting...
Converting members... Unsuccessful!
This query:
SELECT
id AS id_member, SUBSTRING(name, 1, 80) AS member_name,
joined AS date_registered, posts,
IF(mgroup = 4, 1, IF(mgroup > 5, mgroup + 3, 0)) AS id_group,
last_visit AS last_login, SUBSTRING(name, 1, 255) AS real_name,
IFNULL(msg_total, 0) AS instant_messages,
SUBSTRING(password, 1, 64) AS passwd,
SUBSTRING(email, 1, 255) AS email_address,
SUBSTRING(website, 1, 255) AS website_title,
SUBSTRING(website, 1, 255) AS website_url,
SUBSTRING(location, 1, 255) AS location,
SUBSTRING(icq_number, 1, 255) AS icq, signature,
IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, 1, bday_year), IF(bday_month = 0, 1, bday_month), IF(bday_day = 0, 1, bday_day))) AS birthdate,
SUBSTRING(aim_name, 1, 16) AS aim, SUBSTRING(yahoo, 1, 32) AS yim,
SUBSTRING(msnname, 1, 255) AS msn, hide_email AS hide_email,
SUBSTRING(IF(avatar = 'noavatar' OR INSTR(avatar, 'upload') > 0, '', avatar), 1, 255) AS avatar,
IFNULL(email_pm, 0) AS pm_email_notify, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS message_labels, '' AS personal_text,
'' AS time_format, '' AS usertitle, '' AS member_ip, '' AS secret_question,
'' AS secret_answer, '' AS validation_code, '' AS additional_groups,
'' AS smiley_set, '' AS password_salt, '' AS member_ip
FROM `hoi_vara`.ipb_members
WHERE id != 0
LIMIT 0, 500;
Caused the error:
Unknown column 'id' in 'field list'

Any ideas?  :-\
edit. This works http://www.simplemachines.org/community/index.php?topic=477019.0