• Welcome to Simple Machines Community Forum. Please login or sign up.
October 26, 2021, 10:00:50 PM

News:

Want to get involved in developing SMF, then why not lend a hand on our github!


[SMF Converter] IPB 3.0

Started by Nibogo, October 13, 2010, 07:32:18 PM

Previous topic - Next topic

Nibogo

October 13, 2010, 07:32:18 PM Last Edit: December 15, 2010, 03:28:00 PM by 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

November 04, 2010, 07:28:00 AM #1 Last Edit: November 04, 2010, 10:32:33 AM by 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:

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

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

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

DeWo

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

DeWo,
in ipb3_to_smf.sql find:
---* {$to_prefix}members
add after:
---{
/* 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

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

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

hiredgunz

December 12, 2010, 05:10:01 AM #13 Last Edit: December 12, 2010, 05:29:50 AM by 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:
---* {$to_prefix}messages 200
---{

add after:
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

December 12, 2010, 04:29:11 PM #16 Last Edit: December 12, 2010, 04:50:18 PM by DeWo
Change TE code to:
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:
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:
---* {$to_prefix}pm_recipients
---{
$no_add = true;

replace with:
---* {$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

Advertisement: