[SMF Converter] IPB 2.3.x

[SleePy]

Software: IPB
Version: 2.3.x

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

Changelog

convert.php
Use this convert.php with the .sql file attached in this topic.

[Crivelli]

I get a lot of errors but this I can't solve...

Converting permissions... Successful.
Converting board permissions...
Notice: unserialize() [function.unserialize]: Error at offset 5 of 194 bytes in /home/galeraon/public_html/forum/convert.php(910) : eval()'d code on line 89

Fatal error: Unsupported operand types in /home/galeraon/public_html/forum/convert.php(910) : eval()'d code on line 89

[SleePy]

If you go into your IPB database and look at the ipb_forums table
Can you paste a sample from the permissions_array column?

That column should have a serialized array of the permissions. So that is odd why its happening.

Try opening the ipb23_to_smf.sql
Find:

Code Select Expand

        $row += unserialize(stripslashes($row['permission_array']));
        $row = addslashes_recursive($row);

Replace:

Code Select Expand

        $row += @unserialize(stripslashes($row['permission_array']));
         $row = addslashes_recursive($row);

This will hopefully tell it to be quiet if it has errors and the rest of it should hopefully quietly give up.

[GrandTheftGamer]

I ran through everything and the conversion seems to have gone 100% successful. Thank you.

[Bulent]

Good job. ipb 2.3.1 100% successful.
Thank you.

[lvzifer]

I was trying to convert 2.3.4 to SMF but I just can't from some reason :

Which software are you using?
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!
After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.

Try again

I resolve this problem .. it was file extension of invision23_to_smf.sql  .. when I download it the file was .html .. Now it works great ! Many 10x

[iSplicer]

2.3.3 works great... thanks.

Although towards the end of the process I recieved this error, but it didn't make any difference in the end:

Converting user avatars...
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-2.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-3.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-7.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-64.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-13.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-17.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-18.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-20.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-23.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-27.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-46.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-28.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-31.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-32.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-33.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-58.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-61.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-51.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58

Warning: copy(/av-54.png) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.
Conversion Complete

[SleePy]

iSplicer,

The avatars path is missing in the IPB settings so it isn't able to copy the avatars over.
If you don't mind that you are missing those, then you can just ignore the user avatar errors and can use SMF fine

[theglobe]

I keep getting this when I try to convert:

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Unsuccessful!
This query:
INSERT INTO `theglobe_smf`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, SUBSTRING('Should it?', 1, 255), 'Array', 1, 255), 'Array'),
(2, SUBSTRING('Shoult it?', 1, 255), 'Array', 1, 255), 'Array'),
(3, SUBSTRING('Do you think ...', 1, 255), 'Array', 1, 255), 'Array'),
(4, SUBSTRING('Which decade were you born?', 1, 255), 'Array', 1, 255), 'Array'),
(5, SUBSTRING('Pick The Robot You'd Marry.', 1, 255), 'Array', 1, 255), 'Array'),
(6, SUBSTRING('Will Hillary still be a serious presidential contender after today?', 1, 255), 'Array', 1, 255), 'Array'),
(7, SUBSTRING('Should gay marriage be banned?', 1, 255), 'Array', 1, 255), 'Array'),
(8, SUBSTRING('Do you believe your country should use the military draft in times of war?', 1, 255), 'Array', 1, 255), 'Array'),
(9, SUBSTRING('Do you believe in the death penalty?', 1, 255), 'Array', 1, 255), 'Array'),
(10, SUBSTRING('How tall are you?', 1, 255), 'Array', 1, 255), 'Array'),
(11, SUBSTRING('Where do you stand spiritually?', 1, 255), 'Array', 1, 255), 'Array'),
(12, SUBSTRING('Should It Be Allowed??? Ban it or Support it???', 1, 255), 'Array', 1, 255), 'Array'),
(13, SUBSTRING('Has The Time Come For The U.N. To Go?', 1, 255), 'Array', 1, 255), 'Array'),
(14, SUBSTRING('What should the law's stance be on incest?', 1, 255), 'Array', 1, 255), 'Array'),
(15, SUBSTRING('Pick a favorite species', 1, 255), 'Array', 1, 255), 'Array');
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 ''Array'),
(2, SUBSTRING('Shoult it?', 1, 255), 'Array', 1, 255), 'Array'' at line 3

Anyone know how I can fix that?

[theglobe]

It bears to note that I can see member names as well as some of the threads that have converted, BUT none of the threads are appearing and I can't access the admin panel.

[SleePy]

Are you sure you are using the ipb 2.3 converter?

It doesn't add a substring at all and the inserts you show it is :|

[crackos]

where is the convert.php file? O_o

[SleePy]

It is linked to in the first post this converter topic 

[razorb]

I have just tried to do a conversion from ipb2.3.x to smf and all seemed to be going well when I got this error. Do I need to worry about it and if so how can I fix it or should I just forget it and get on with life. My host has just upgraded to these new versions

Apache version   1.3.41 (Unix)
PHP version   4.4.8
MySQL version   5.0.51a-community

also forum_domain has been altered from the original so as not to reveal personal settings.


Converting...
Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `forum_domain`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2

[ThorstenE]

it's a MySQL-Bug, a fix is available here: Common conversion errors

[razorb]

took a few minutes to find the text but once I did and changed it I ran the convert.php again and all worked fine so thanks for the help.


Cheers
Razorb

[mystified]

I have an ipb sql database and an smf sql database combined as one.  I need to convert the ipb to smf but it seems to cause errors because of duplicate member ids.  Is there a way around this?

[SleePy]

Are you clicking continue or letting it do its work?
The converter will automatically do the work and refresh as needed.

[mystified]

I found that by not clicking continue it continued to work.  However at the end there were a bunch of errors.  It said it was successful but it was not.

[SleePy]

What errors?