Advertisement:

Author Topic: [SMF Converter] IPB 2.1.x  (Read 229434 times)

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,931
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.1.x
« Reply #140 on: August 24, 2008, 11:03:18 AM »
try this one
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline DistantJ

  • Semi-Newbie
  • *
  • Posts: 94
Re: [SMF Converter] IPB 2.1.x
« Reply #141 on: August 24, 2008, 01:22:21 PM »
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.

Offline NuLLCoDe

  • Newbie
  • *
  • Posts: 2
  • Gender: Male
    • ApaFun Forum - APATIN
Re: [SMF Converter] IPB 2.1.x
« Reply #142 on: September 08, 2008, 09:17:54 AM »
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?

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,931
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.1.x
« Reply #143 on: September 08, 2008, 03:37:54 PM »
Try this attached file and see if it provides better results.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Aen Sidhe

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.1.x
« Reply #144 on: February 15, 2009, 01:50:01 PM »
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

  • Guest
Re: [SMF Converter] IPB 2.1.x
« Reply #145 on: February 15, 2009, 02:36:24 PM »
DB only conversion is possible, but you must emulate the conf_global.php file from IPB.
Create a file named conf_global:
Code: [Select]
<?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

Offline Aen Sidhe

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.1.x
« Reply #146 on: February 15, 2009, 04:33:46 PM »
Thank you a lot, it helps me to convert DB.

One more fix in your file (you forgot quotes in array indexes):
Code: [Select]
<?php
$INFO
['sql_database'] = 'name_of_your_database';
$INFO['sql_tbl_prefix'] = 'ibp_table_prefix';
?>

Offline SteveMD6

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.1.x
« Reply #147 on: August 06, 2009, 12:39:46 AM »
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:

Quote
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.
« Last Edit: August 06, 2009, 10:48:33 AM by SteveMD6 »

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.1.x
« Reply #148 on: August 06, 2009, 12:12:35 PM »
You can try to reduce the numer of parallel converted posts:
in invision21_to_smf.sql find:
Code: [Select]
---* {$to_prefix}messages 200replace it with:
Code: [Select]
---* {$to_prefix}messages 100If you get the same error again you can reduce the number to 50, hopefully that helps...

Offline SteveMD6

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.1.x
« Reply #149 on: August 06, 2009, 03:08:35 PM »
Had to reduce it to 25...but now it is running.  WIll give you an update...whenever it gets done.  Thanks!

Offline SteveMD6

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.1.x
« Reply #150 on: August 06, 2009, 05:22:09 PM »
 :D Making Progress!

Made it through the topic and post conversion, then got:
Quote
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! 
« Last Edit: August 06, 2009, 05:42:34 PM by SteveMD6 »

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.1.x
« Reply #151 on: August 07, 2009, 01:55:34 AM »
that's not a problem (minor bug in convert.php), the conversion has already finished:
Quote
Recalculating forum statistics... Successful.
Everything should be fine  ;)

Offline SteveMD6

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.1.x
« Reply #152 on: August 07, 2009, 08:20:27 AM »
that's not a problem (minor bug in convert.php), the conversion has already finished:
Quote
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

  • Guest
Re: [SMF Converter] IPB 2.1.x
« Reply #153 on: January 05, 2010, 06:16:59 AM »
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?

Offline q8hma

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.1.x
« Reply #154 on: December 25, 2015, 01:50:53 PM »
I have big problem

Code: [Select]
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
« Last Edit: December 25, 2015, 02:03:37 PM by q8hma »

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,069
Re: [SMF Converter] IPB 2.1.x
« Reply #155 on: December 25, 2015, 02:12:41 PM »