[SMF Converter] IPB 3.0

[Nibogo]

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:

   
• Members
• Administrators
• Categories
• Topics
• Boards
• Posts
• Polls
• Poll Votes
• Personal Messages (Conversations)
• Topic Notifications
• Board Notifications
• Censored Words
• Moderators
• Calendar Events
• Smileys
• Attachments
• Avatars
• Settings

[n3ronx]

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 Expand

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'

[Sirandilas]

Not work convert.php, please upload now.

[n3ronx]

Not work convert.php, please upload now.

It works actually. If you browse with IE you'll get 404 error. Try with Mozilla Firefox.

[Sirandilas]

Converting members...Wrong value type sent to the database. Date expected. (birthdate) ? why

[silabsoft]

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.

[Qsa]

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

[Norv]

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.

[DeWo]

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

[ThorstenE]

DeWo,
in ipb3_to_smf.sql find:

Code Select Expand

---* {$to_prefix}members
add after:

Code Select Expand

---{
/* Fix for invalid birthdays */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';
---}
then restart the conversion.

[DeWo]

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

[ThorstenE]

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 Expand

/* The converter will set id_cat for us based on id_parent being wrong. */
but you could re-arrange the boards after the conversion.

[DeWo]

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 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 )

[hiredgunz]

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

[ThorstenE]

hiredgunz,
in ipb3_to_smf.sql find:

Code Select Expand

---* {$to_prefix}messages 200
---{
add after:

Code Select Expand

if(empty($row['id_board']))
$row['id_board'] = 1;
then restart the converter.

[hiredgunz]

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"

[DeWo]

Change TE code to:

Code Select Expand

if(empty($row['id_board']))
$row['id_board'] = rand(99, 900);

Then restart the converter. Should works

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


OK, I think I know

Go to phpMyAdmin and exec this SQL query:

Code Select Expand

TRUNCATE smf_personal_messages
(if you have diffrent prefix replace "smf_" to other)

And then run converter

[hiredgunz]

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...

[ThorstenE]

hopefully that works, in ipb3_to_smf.sql find:

Code Select Expand

---* {$to_prefix}pm_recipients
---{
$no_add = true;
replace with:

Code Select Expand

---* {$to_prefix}pm_recipients
---{
$no_add = true;
$ignore = true;

[hiredgunz]

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