Author Topic: [SMF Converter] IPB 3.0 (Read 131837 times)

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:

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 · « **Reply #1 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'

Sirandilas · « **Reply #2 on:** November 04, 2010, 01:31:07 PM »

Not work convert.php, please upload now.

n3ronx · « **Reply #3 on:** November 04, 2010, 01:40:25 PM »

Quote from: Sirandilas on November 04, 2010, 01:31:07 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.

Sirandilas · « **Reply #4 on:** November 04, 2010, 01:50:38 PM »

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

silabsoft · « **Reply #5 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.

Qsa · « **Reply #6 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

Norv · « **Reply #7 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.

DeWo · « **Reply #8 on:** December 05, 2010, 02:09:46 PM »

Quote from: Sirandilas on November 04, 2010, 01:50:38 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

ThorstenE · « **Reply #9 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.

DeWo · « **Reply #10 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

ThorstenE · « **Reply #11 on:** December 11, 2010, 02:56:55 AM »

Quote from: DeWo on December 11, 2010, 02:41:45 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.

DeWo · « **Reply #12 on:** December 11, 2010, 03:40:17 AM »

Quote from: TE on December 11, 2010, 02:56:55 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

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 · « **Reply #13 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

ThorstenE · « **Reply #14 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.

hiredgunz · « **Reply #15 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"

DeWo · « **Reply #16 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

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]

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

And then run converter

hiredgunz · « **Reply #17 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...

ThorstenE · « **Reply #18 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;

hiredgunz · « **Reply #19 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

News:

Author Topic: [SMF Converter] IPB 3.0 (Read 131837 times)

ThorstenE

ThorstenE

ThorstenE

ThorstenE