Simple Machines Community Forum

SMF Support => Converting to SMF => IPB => Topic started by: JayBachatero on February 08, 2007, 11:52:13 AM

Title: [SMF Converter] IPB 2.0.x
Post by: JayBachatero 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 (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: Craw4x4PH 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.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: JayBachatero on March 02, 2007, 01:48:04 AM
It should work.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: Craw4x4PH 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
Title: Re: [SMF Converter] IPB 2.0.x
Post by: Hixpano 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...  :)
 
Title: Re: [SMF Converter] IPB 2.0.x
Post by: zerofill 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?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: JayBachatero on March 31, 2007, 11:26:35 PM
Any errors?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: zerofill 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
Title: Re: [SMF Converter] IPB 2.0.x
Post by: JayBachatero 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?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: zerofill on April 01, 2007, 02:08:15 AM
2.0.3
Title: Re: [SMF Converter] IPB 2.0.x
Post by: InvisibleMan78 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?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: zerofill 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?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: JayBachatero 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?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: InvisibleMan78 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.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: FromUA 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 ?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: InvisibleMan78 on May 17, 2007, 05:37:32 AM
Is there any hope, that we get a solution for our problems ???
Title: Re: [SMF Converter] IPB 2.0.x
Post by: JayBachatero 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 :(.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: sokoll 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?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: SleePy on September 16, 2008, 05:04:02 PM
What version of MySQL are you using?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: sokoll on September 17, 2008, 12:13:12 AM
MySQL 5.0.45
Title: Re: [SMF Converter] IPB 2.0.x
Post by: sokoll on September 17, 2008, 01:26:18 PM
Hi!
What's new?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: SleePy on September 17, 2008, 06:52:46 PM
Does this one work
Title: Re: [SMF Converter] IPB 2.0.x
Post by: sokoll on September 20, 2008, 01:34:37 AM
Hi, sorry! I tested your sript, but it caused an error
I understood that it was a test base -  MySQL 5.0.45, but real one - phpMyAdmin 2.6.3-pl1 MySQL 3.23.58.
Could You help me in this case?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: SleePy on September 20, 2008, 11:32:59 PM
Where did you get the first one btw?

What errors are you getting?

I would highly recommend contacting your host and ask about MySQL version and possibly upgrading if they are using such an old version of MySQL (3.23.58). MySQL 4.x.x itself is no longer supported by MySQL AB and so is MySQL 3.x.x.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: sokoll on September 23, 2008, 12:13:52 PM
Hi, ok! What version MySQL will be better for this converter?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: SleePy on September 23, 2008, 02:36:09 PM
Personally I would recommend any MySQL 5 version (I am using the latest 5.0 release which is 5.0.51 5.0.67 I believe) as it is supported by the MySQL AB team and has improvements over the older versions, but even having any version of MySQL 4 would be better than what you currently have.

If you are going to upgrade MySQL, please make sure to read the MySQL documentation on upgrading and have backups incase the worse happens.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: sokoll on September 27, 2008, 01:00:09 AM
Hi, I backup Data Base hosts  MySQL (3.23.58) and restored at localhost ( MySQL 5.0.45). Started converter and it caused an error

"Сonverting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)...Error in convert script - line 321!
Error in convert script - line 323!
Error in convert script - line 324!
Error in convert script - line 335!
Error in convert script - line 338!
Successful.
Converting topic notifications... Unsuccessful!
This query:
SELECT pm.ID_PM, m.mt_vid_folder AS folder
FROM `db_premacy`.smf_personal_messages AS pm
INNER JOIN `db_premacy`.ipb_message_topics AS m ON (m.mt_msg_id = pm.ID_PM)
WHERE m.mt_vid_folder = 'sent'
TRUNCATE `db_premacy`.smf_log_notify;
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 'TRUNCATE `db_premacy`.smf_log_notify' at line 5"

Please, give me some recommendations
 
Title: Re: [SMF Converter] IPB 2.0.x
Post by: SleePy on September 28, 2008, 05:32:59 PM
Ooops forgot the closing ; on two queries.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: sokoll on September 29, 2008, 10:22:31 AM
Thank's, but it caused the next error:

"Converting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Unsuccessful!
This query:
INSERT INTO `db_premacy`.smf_membergroups
(ID_GROUP, groupName, maxMessages, onlineColor, stars)
VALUES
(7 + 3, SUBSTRING('Модераторы', 1, 255), 50, '', '');
Caused the error:

Duplicate entry '10' for key 1"

Title: Re: [SMF Converter] IPB 2.0.x
Post by: SleePy on September 29, 2008, 06:49:57 PM
Alright, hopefully this one gets it.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: sokoll on October 07, 2008, 12:13:59 PM
Hi, thank you! Congratulations, you are  the best!
Converter is finished, but there are some errors. Look file.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: SleePy on October 07, 2008, 12:29:24 PM
Well it appears that a few attachments and some avatars did not convert. If that isn't a worry to you then you can ignore those.

For the avatars not converting it looks like it is missing a setting that tells it where the avatars are uploaded.

For attachments it looks like the attachments path may be incorrect.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: mestresan on August 21, 2010, 05:31:48 PM
I am trying convert my invision 2.0.3 for SMF, but I receive message:

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

Title: Re: [SMF Converter] IPB 2.0.x
Post by: Norv on August 25, 2010, 07:10:13 PM
Can you please make sure to use the last package for download on the Downloads > Converters page, for SMF 2.0 RC3? (or to confirm if you were using it)
Title: Re: [SMF Converter] IPB 2.0.x
Post by: pk74 on September 04, 2011, 10:34:01 PM
Trying to convert ipb 2.0.4 free hosted to SMF 2.0.

I downloaded the .sql backup of my ipb, imported it into a new database.  Downloaded SMF 2.0, installed it to the SAME db with the same user and perms.   Installed the convert files, created a custom conf_global.php, put it in the correct place, gave it the correct parameters, and the conversion starts...

except..

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

Any suggestions?
Title: Re: [SMF Converter] IPB 2.0.x
Post by: rtil on September 05, 2011, 11:34:35 PM
Trying to convert ipb 2.0.4 free hosted to SMF 2.0.

I downloaded the .sql backup of my ipb, imported it into a new database.  Downloaded SMF 2.0, installed it to the SAME db with the same user and perms.   Installed the convert files, created a custom conf_global.php, put it in the correct place, gave it the correct parameters, and the conversion starts...

except..

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

Any suggestions?
i get this as well. there are posts about this all over the forum with no real solution. i'm surprised a major error like this has persisted in the converters.
Title: Re: [SMF Converter] IPB 2.0.x
Post by: WesternDigi on May 11, 2017, 03:21:34 PM
A year ago had to convert my IPB v2.0.* forum to new SMF 2.0.11 version.
It was very hard, but I did it  :D

Improvements I made:
1)Changed old domain "olddomain.org" to "newdomain.com" in every post(even pm).
2)Fixed attachment problem(converter couldnt find them).
3)Fixed all IPB-style links, like "index.php?showtopic=", "index.php?showforum=", "index.php?showuser=" to SMF-style.

Enjoy this script  ;)

P.S: I want to thank the converter.php authors for such a great work !

Title: Re: [SMF Converter] IPB 2.0.x
Post by: autonomy on May 18, 2020, 02:30:19 AM
have IPB 2.0.0 PF 4 trying to migrate to smf. getting the date error...

trying your modified script WesternDigi, but it just sits on "converting members..." not doing anything.

error log shows:

[18-May-2020 06:26:28 UTC] PHP Notice:  Undefined property: mysqli_result::$EOF in /home/public_html/convertcustom/convert.php on line 2760
[18-May-2020 06:26:28 UTC] PHP Notice:  Undefined property: mysqli_result::$Fields in /home/public_html/convertcustom/convert.php on line 2764
[18-May-2020 06:26:28 UTC] PHP Notice:  Trying to get property of non-object in /home/public_html/convertcustom/convert.php on line 2765
[18-May-2020 06:26:28 UTC] PHP Fatal error:  Call to undefined method mysqli_result::MoveNext() in /home/public_html/convertcustom/convert.php on line 2770

Title: Re: [SMF Converter] IPB 2.0.x
Post by: autonomy on May 18, 2020, 04:07:34 AM
To clarify, I am trying to migrate IPB 2.0.0 PF 4 (trial i believe) to any version of SMF.

I have a centos server running the old IPB under php 5.1 using cloudlinux php selector. server running mysql 5.6. i have mydomain.com/ipb2 for the IPB 2.0.0 install and mydomain.com/smf for whatever version of SMF I attempt to convert to.

So far I have failed using old convertors built to migrate IPB 2.0.x to SMF 1.1.x. I am getting the following errors:

1) first errors about SQL_MAX_JOIN_SIZE, which i remove the related function according to this topic: https://www.simplemachines.org/community/index.php?topic=528263.0

2) then i rerun convert.php which works for a few tables but gets the following error at topic conversion:

Quote
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `mydomain_smf1`.smf_topics
(ID_TOPIC, isSticky, ID_BOARD, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_POLL, numReplies, numViews, ID_FIRST_MSG, ID_LAST_MSG, locked)
VALUES ('3', '0', '2', '1', '153', '', '53114', '537032', '3', '801314', '1'),
('4', '0', '2', '1', '6659', '', '29214', '274098', '4', '801168', '1'),
('5', '0', '2', '1', '69', '', '37960', '407549', '5', '801040', '1'),
...
...
...
('2184', '0', '2', '87', '9', '', '117', '1101', '100510', '620633', '0'),
('2185', '0', '2', '87', '87', '', '171', '1267', '100565', '926012', '0');
Caused the error:
Incorrect integer value: '' for column `mydomain_smf1`.`smf_topics`.`ID_POLL` at row 1

Not sure where to go from there... Had to give up trying to convert to SMF version 1.x

When using convert scripts to migrate IPB 2.0.x to SMF 2.0.x, I have also failed getting the following error:

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

Using WesternDigi's attached convert.php, as above, I get a little more detail on the error_log:

Quote
[18-May-2020 06:26:28 UTC] PHP Notice:  Undefined property: mysqli_result::$EOF in /home/public_html/convertcustom/convert.php on line 2760
[18-May-2020 06:26:28 UTC] PHP Notice:  Undefined property: mysqli_result::$Fields in /home/public_html/convertcustom/convert.php on line 2764
[18-May-2020 06:26:28 UTC] PHP Notice:  Trying to get property of non-object in /home/public_html/convertcustom/convert.php on line 2765
[18-May-2020 06:26:28 UTC] PHP Fatal error:  Call to undefined method mysqli_result::MoveNext() in /home/public_html/convertcustom/convert.php on line 2770

not really sure where to go from there troubleshooting those error points. any suggestions?