• Welcome to Simple Machines Community Forum. Please login or sign up.
December 07, 2021, 05:33:59 AM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) Read more.


[SMF Converter] IPB 2.1.x

Started by JayBachatero, February 10, 2007, 02:03:49 PM

Previous topic - Next topic

SleePy

Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

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.

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

How I can solve this?

SleePy

Try this attached file and see if it provides better results.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

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:
<?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):
<?php
$INFO
['sql_database'] = 'name_of_your_database';
$INFO['sql_tbl_prefix'] = 'ibp_table_prefix';
?>

SteveMD6

August 06, 2009, 12:39:46 AM #147 Last Edit: August 06, 2009, 10:48:33 AM by 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:

QuoteConverting 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:
---* {$to_prefix}messages 200
replace it with:
---* {$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

August 06, 2009, 05:22:09 PM #150 Last Edit: August 06, 2009, 05:42:34 PM by SteveMD6
 :D Making Progress!

Made it through the topic and post conversion, then got:
QuoteRecalculating 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:
QuoteRecalculating forum statistics... Successful.
Everything should be fine  ;)

SteveMD6

Quote from: TE on August 07, 2009, 01:55:34 AM
that's not a problem (minor bug in convert.php), the conversion has already finished:
QuoteRecalculating 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:
Quote
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

December 25, 2015, 01:50:53 PM #154 Last Edit: December 25, 2015, 02:03:37 PM by q8hma
I have big problem

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


Advertisement: