Advertisement:

Author Topic: [SMF Converter] IPB 2.0.x  (Read 112413 times)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
[SMF Converter] IPB 2.0.x
« on: February 08, 2007, 11:52:13 AM »
Software: IPB
Version: 2.0.x

This is the official support topic for IPB 2.0.x converter.  Use this topic to ask for support for this converter. 

Special thanks goes to Sarke for the help in fixing these bugs and testing the converter out.

Changelog
+ Added support for converting user uploaded avatars (invision2_to_smf.sql)
! Regular Expression was chopping the font-size when converting bbc tags. (invision2_to_smf.sql)
! passwordSalt field was being replaced with an empty string causing passwords to be incorrect. (invision_to_smf.sql) [sarke]
! Poll choices were not being converted proeprly. (invision2_to_smf.sql) [sarke]
! Personal Messages were not being converted properly. (invision2_to_smf.sql) [sarke]
! When converting maintenance mode message change \n to <br />. (invision2_to_smf.sql)
! When converting attachments set the width and height for images (invision2_to_smf.sql)

convert.php
Use this convert.php with the .sql file attached in this topic.
« Last Edit: July 18, 2009, 02:46:06 PM by TE »
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Craw4x4PH

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.0.x
« Reply #1 on: March 02, 2007, 01:12:16 AM »
This might be a stupid question, but I just want to make sure: I have the IPB 2.0.0 (Trial), will the converter work with this?

Thanks.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.0.x
« Reply #2 on: March 02, 2007, 01:48:04 AM »
It should work.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Craw4x4PH

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.0.x
« Reply #3 on: March 04, 2007, 03:03:43 AM »
Thanks. I hope someone can answer with a 100% guarantee. I'm scared to lose all the data and posts :D

Offline Hixpano

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.0.x
« Reply #4 on: March 15, 2007, 07:18:24 PM »
Hi!

I convert successfully my forum to SMF but now I'm not able to login with my account. I use the attached sql file in the 1st post.

Thx for your answers!

Edit: I found. Just delete all cookies...  :)
 
« Last Edit: March 17, 2007, 03:08:39 AM by Hixpano »

Offline zerofill

  • Semi-Newbie
  • *
  • Posts: 49
Re: [SMF Converter] IPB 2.0.x
« Reply #5 on: March 31, 2007, 10:55:40 PM »
This thing seems to work and it finishes the upgrade...but it isn't importing all my posts...it seems to stop importing anything after like 2005 heh...

Any ideas?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.0.x
« Reply #6 on: March 31, 2007, 11:26:35 PM »
Any errors?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline zerofill

  • Semi-Newbie
  • *
  • Posts: 49
Re: [SMF Converter] IPB 2.0.x
« Reply #7 on: March 31, 2007, 11:37:47 PM »
Well...oldavatar...but that is after the posts are imported and it continues and finishes anyway...
When it is doing the posts the last number I see is 34600...if that is the rows?

There are like 39,000 posts though

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.0.x
« Reply #8 on: March 31, 2007, 11:50:48 PM »
Yes that is an approximate number of rows of posts that have been converted.  What version of IPB are you running?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline zerofill

  • Semi-Newbie
  • *
  • Posts: 49
Re: [SMF Converter] IPB 2.0.x
« Reply #9 on: April 01, 2007, 02:08:15 AM »
2.0.3

Offline InvisibleMan78

  • Semi-Newbie
  • *
  • Posts: 35
  • Gender: Male
Re: [SMF Converter] IPB 2.0.x
« Reply #10 on: April 01, 2007, 07:51:31 AM »
This is my 7. attempt to convert my IBP 2.0.0 (trial) to SMF.

Some things are better now:
- Users can now login with same username, but have to "update" the passwords (even with the old one)

But then we have some still not working issues:
1.) The memberships are not converted correct and not one single Board is visible:
Quote
Board #2 befindet sich in der fehlenden Kategorie #0.
Board #3 befindet sich in der fehlenden Kategorie #0.
Board #4 befindet sich in der fehlenden Kategorie #0.
Board #5 befindet sich in der fehlenden Kategorie #0.
Board #6 befindet sich in der fehlenden Kategorie #0.
Board #7 befindet sich in der fehlenden Kategorie #0.
Board #11 befindet sich in der fehlenden Kategorie #0.
Board 2 hat kein existierendes übergeordnetes Board (übergeordnetes Board: 8 ).
Board 3 hat kein existierendes übergeordnetes Board (übergeordnetes Board: 8 ).
Board 4 hat kein existierendes übergeordnetes Board (übergeordnetes Board: 8 ).
Board 5 hat kein existierendes übergeordnetes Board (übergeordnetes Board: 8 ).
Board 6 hat kein existierendes übergeordnetes Board (übergeordnetes Board: 8 ).
Board 7 hat kein existierendes übergeordnetes Board (übergeordnetes Board: 8 ).
Board 11 hat kein existierendes übergeordnetes Board (übergeordnetes Board: 8 ).
Der Titel des Themas #2 ist momentan nicht im Zwischenspeicher.
Der Titel des Themas #3 ist momentan nicht im Zwischenspeicher.
....
Das zwischengespeicherte Wort 'SMF' ist mit einem nicht existierenden Thema verknüpft.
...
In the Maintenance-Menu I have executed the "finding errors and repair it". After that, all the missing Boards appears as wished. Unfortunately, the most top title was converted to "Gerettete Daten" (something like "recovered Data" and "Gerettete Themen" (something like "recovered Topics").

2.) In the single topic, there are still format-issues like:
Code: [Select]
[span style=\'color:purple\'][span style=\'font-size:14pt;line-height:100%\']wichtige Information:[/span][/span]
3.) Some smilies are converted, some others not, like:
Code: [Select]
:rolleyes:  :lol:  :unsure:  :huh:  <_<
4.) All the avatars (uploaded by users and the default-one from the board) are gone

5.) On the left side, between the numbers of topics and the "show profile"-icon should be a icon for the link "http://www.icq.com/whitepages/about_me.php?uin=0". There is no picture for that.

6.) If more then one attachment was uploaded for a single answer, they appear vertical - I would like to see them on one line (at least 3 or 4 of them) like in IBP.

Is there any hope, that you can fix this issues?

Offline zerofill

  • Semi-Newbie
  • *
  • Posts: 49
Re: [SMF Converter] IPB 2.0.x
« Reply #11 on: April 03, 2007, 12:49:55 AM »
No ideas anyone on why it doesn't seem to go past about 34k posts when importing from 2.0.3?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.0.x
« Reply #12 on: April 16, 2007, 04:01:13 PM »
InvisibleMan78 you are using the .sql file in this topic right?

zerofill It should work with more than 34k posts.  I've converter boards much bigger than that before.  Any errors while converting?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline InvisibleMan78

  • Semi-Newbie
  • *
  • Posts: 35
  • Gender: Male
Re: [SMF Converter] IPB 2.0.x
« Reply #13 on: April 27, 2007, 10:06:26 AM »
Sorry for the late reply (was in holiday in a country without I-Net!!  :-X )

Yes, I'm using the .sql-file attached to the first entry in this topic.

Offline FromUA

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.0.x
« Reply #14 on: April 29, 2007, 05:53:41 PM »
Hello!
I have the same error with "Undefined variable: oldAvatarDir" when converting from IPB 2.0.x as other users of IPB 2.1.x and 2.2.x in other topics.

Could you help to solve this problem in script for IPB 2.0.x ?
« Last Edit: April 29, 2007, 06:04:22 PM by FromUA »

Offline InvisibleMan78

  • Semi-Newbie
  • *
  • Posts: 35
  • Gender: Male
Re: [SMF Converter] IPB 2.0.x
« Reply #15 on: May 17, 2007, 05:37:32 AM »
Is there any hope, that we get a solution for our problems ???

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.0.x
« Reply #16 on: May 29, 2007, 12:36:00 AM »
Ummm maybe the 2.0 trial is a bit different than the full version.  I would have to look more into the problem.  At the moment I don't have any time to do so :(.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline sokoll

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.0.x
« Reply #17 on: September 16, 2008, 02:34:56 PM »
Hi, convert IBP 2.0.4 to SMF 1.1.6
invision2_to_smf.sql
convert.php

Start -ok!
.....

"Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Unsuccessful!
This query:
UPDATE (`db_premacy`.smf_personal_messages AS pm, `db_premacy`.ipb_message_topics AS m)
SET pm.deletedBySender = '0'
WHERE m.mt_msg_id = pm.ID_PM
AND m.mt_vid_folder = 'sent';
Caused the error:
You have an error in your SQL syntax near '(`db_premacy`.smf_personal_messages AS pm, `db_premacy`.ipb_message_topics AS m)' at line 2"

Could You help me?

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,936
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.0.x
« Reply #18 on: September 16, 2008, 05:04:02 PM »
What version of MySQL are you using?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline sokoll

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.0.x
« Reply #19 on: September 17, 2008, 12:13:12 AM »
MySQL 5.0.45