Advertisement:

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

Offline Nibogo

  • SMF Hero
  • ******
  • Posts: 6,531
  • Gender: Male
    • smfpacks on Facebook
    • @smfpacks on Twitter
    • SMFPacks
[SMF Converter] IPB 3.0
« 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

Offline n3ronx

  • Newbie
  • *
  • Posts: 4
Re: [BETA] [SMF Converter] IPB 3.0
« 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'
« Last Edit: November 04, 2010, 10:32:33 AM by n3ronx »

Offline Sirandilas

  • Newbie
  • *
  • Posts: 2
Re: [BETA] [SMF Converter] IPB 3.0
« Reply #2 on: November 04, 2010, 01:31:07 PM »
Not work convert.php, please upload now.

Offline n3ronx

  • Newbie
  • *
  • Posts: 4
Re: [BETA] [SMF Converter] IPB 3.0
« Reply #3 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.

Offline Sirandilas

  • Newbie
  • *
  • Posts: 2
Re: [BETA] [SMF Converter] IPB 3.0
« Reply #4 on: November 04, 2010, 01:50:38 PM »
Converting members...Wrong value type sent to the database. Date expected. (birthdate) ? why :(

Offline silabsoft

  • Newbie
  • *
  • Posts: 1
Re: [BETA] [SMF Converter] IPB 3.0
« 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.

Offline Qsa

  • Newbie
  • *
  • Posts: 1
Re: [BETA] [SMF Converter] IPB 3.0
« 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

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [BETA] [SMF Converter] IPB 3.0
« 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.
To-do lists are for deferral. The more things you write down the later they're doneā€¦ until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline DeWo

  • Newbie
  • *
  • Posts: 5
Re: [BETA] [SMF Converter] IPB 3.0
« Reply #8 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

ThorstenE

  • Guest
Re: [BETA] [SMF Converter] IPB 3.0
« 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.

Offline DeWo

  • Newbie
  • *
  • Posts: 5
Re: [BETA] [SMF Converter] IPB 3.0
« 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

  • Guest
Re: [BETA] [SMF Converter] IPB 3.0
« Reply #11 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.

Offline DeWo

  • Newbie
  • *
  • Posts: 5
Re: [BETA] [SMF Converter] IPB 3.0
« Reply #12 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 :))

Offline hiredgunz

  • Newbie
  • *
  • Posts: 5
Re: [BETA] [SMF Converter] IPB 3.0
« 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
« Last Edit: December 12, 2010, 05:29:50 AM by hiredgunz »

ThorstenE

  • Guest
Re: [BETA] [SMF Converter] IPB 3.0
« 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.

Offline hiredgunz

  • Newbie
  • *
  • Posts: 5
Re: [BETA] [SMF Converter] IPB 3.0
« 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"


Offline DeWo

  • Newbie
  • *
  • Posts: 5
Re: [BETA] [SMF Converter] IPB 3.0
« 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 :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 :)
« Last Edit: December 12, 2010, 04:50:18 PM by DeWo »

Offline hiredgunz

  • Newbie
  • *
  • Posts: 5
Re: [BETA] [SMF Converter] IPB 3.0
« 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

  • Guest
Re: [BETA] [SMF Converter] IPB 3.0
« 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;

Offline hiredgunz

  • Newbie
  • *
  • Posts: 5
Re: [BETA] [SMF Converter] IPB 3.0
« 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