[SMF Converter] IPB 2.1.x

[SleePy]

try this one

[DistantJ]

Thanks for the updated files but since I manually edited the database, everything's been fine and I've set the SMF forum up, so I can't really go back and redo it now. Thank you for all your help, though.

[NuLLCoDe]

I converted my forum successful, but emotions not show in posts.

[img src=\"style_emoticons/[#EMO_DIR#]/biggrin.gif\" style=\"vertical-align:middle\" emoid=\"\" border=\"0\" alt=\"biggrin.gif\" /]  [img src=\"style_emoticons/[#EMO_DIR#]/biggrin.gif\" style=\"vertical-align:middle\" emoid=\"\" border=\"0\" alt=\"biggrin.gif\" /]  [img src=\"style_emoticons/[#EMO_DIR#]/biggrin.gif\" style=\"vertical-align:middle\" emoid=\"\" border=\"0\" alt=\"biggrin.gif\" /]

How I can solve this?

[SleePy]

Try this attached file and see if it provides better results.

[Aen Sidhe]

Hello,

I have a question: how to convert from ipb 2.1 if I have only database (and I don't want to buy ipb 2.1.3 for migrating to smf)

This database is from some project of other person and he doesn't want to give me IPB as well.

Can I convert only DB by some mean?

[ThorstenE]

DB only conversion is possible, but you must emulate the conf_global.php file from IPB.
Create a file named conf_global:

Code Select Expand

<?php
$INFO[sql_database] = 'name_of_your_database';
$INFO[sql_tbl_prefix] = 'ibp_table_prefix';
?>
replace name_of_your_database with the database name and ipb_table_prefix with the prefix from all tables ( I think it's ipb_ or similar).
the upload this file to a directory and specify this directory in convert.php

[Aen Sidhe]

Thank you a lot, it helps me to convert DB.

One more fix in your file (you forgot quotes in array indexes):

Code Select Expand

<?php
$INFO['sql_database'] = 'name_of_your_database';
$INFO['sql_tbl_prefix'] = 'ibp_table_prefix';
?>

[SteveMD6]

Hi,
Thanks for SMF and all the excellent support.

I am converting a big board from IPB2.1.6 and am getting this error when I get to converting posts:

Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO ...(lists entire database)

Caused the error:

Got a packet bigger than 'max_allowed_packet' bytes

Any ideas?  Thank you very much.

[ThorstenE]

You can try to reduce the numer of parallel converted posts:
in invision21_to_smf.sql find:

Code Select Expand

---* {$to_prefix}messages 200
replace it with:

Code Select Expand

---* {$to_prefix}messages 100
If you get the same error again you can reduce the number to 50, hopefully that helps...

[SteveMD6]

Had to reduce it to 25...but now it is running.  WIll give you an update...whenever it gets done.  Thanks!

[SteveMD6]

  Making Progress!

Made it through the topic and post conversion, then got:

Recalculating forum statistics... Successful.
Unsuccessful!
This query:
REPLACE INTO {$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1249593263),
("conversion_from", "invision21_to_smf.sql");
Caused the error:

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 '{$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1249593263)' at line 1

Thanks again for any suggestions! 

[ThorstenE]

that's not a problem (minor bug in convert.php), the conversion has already finished:

Recalculating forum statistics... Successful.

Everything should be fine 

[SteveMD6]

that's not a problem (minor bug in convert.php), the conversion has already finished:

Recalculating forum statistics... Successful.

Everything should be fine 

Yes, I checked the board and it's alive!  Thank you so much, this will make alot of people happy! 

[xeniac]

Hello There!

I tried to convert our IPB 2.1 Installation to SMF 2.0RC2.
I used the IPB21_to SMF2 Converter from the Download Section and followed some Advices and chaged a few SQL Statements in this Forum to handle some converting-errors.

now the converter stops at /convert.php?step=1&substep=7&start=9500 with this Messages on Screen:

Notice: Undefined index: convert_script in /var/www/smf/convert.php on line 977

Warning: Invalid argument supplied for foreach() in /var/www/smf/convert.php on line 980

Notice: Undefined index: convert_script in /var/www/smf/convert.php on line 992
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /var/www/smf/convert.php on line 2513

Notice: Undefined variable: result in /var/www/smf/convert.php on line 2514

Notice: Undefined index: db_fetch_assoc in /var/www/smf/convert.php on line 1391

Fatal error: Function name must be a string in /var/www/smf/convert.php on line 1391

Does anybody has some advice for me?

[q8hma]

I have big problem

Code Select Expand

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


this is the ipb data base structure
hxxp:pastie.org/10652450 [nonactive]


any help ??

thnx

[Illori]

take a look at http://www.simplemachines.org/community/index.php?topic=527681.0