Advertisement:

Author Topic: [SMF Converter] IPB 2.3.x  (Read 213332 times)

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
[SMF Converter] IPB 2.3.x
« on: May 09, 2008, 10:35:02 PM »
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.
« Last Edit: July 18, 2009, 02:48:10 PM by TE »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Crivelli

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.3.x
« Reply #1 on: May 17, 2008, 08:17:03 AM »
I get a lot of errors but this I can't solve...

Quote
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

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #2 on: May 17, 2008, 05:54:21 PM »
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]
        $row += unserialize(stripslashes($row['permission_array']));
        $row = addslashes_recursive($row);

Replace:
Code: [Select]
        $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.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline GrandTheftGamer

  • Newbie
  • *
  • Posts: 3
  • Gender: Male
  • Unoriginal Gangster
    • GrandTheftGamer.com
Re: [SMF Converter] IPB 2.3.x
« Reply #3 on: June 01, 2008, 10:50:13 PM »
I ran through everything and the conversion seems to have gone 100% successful. Thank you. :)
hxxp:"http://www.grandtheftgamer.com/" [nonactive]

Offline Bulent

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.3.x
« Reply #4 on: June 14, 2008, 10:33:22 AM »
Good job. ipb 2.3.1 100% successful.
Thank you.

Offline lvzifer

  • Jr. Member
  • **
  • Posts: 103
  • Gender: Male
Re: [SMF Converter] IPB 2.3.x
« Reply #5 on: June 19, 2008, 05:23:14 AM »
I was trying to convert 2.3.4 to SMF but I just can't from some reason :

Quote
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
« Last Edit: June 19, 2008, 05:59:34 AM by lvzifer »

Offline iSplicer

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #6 on: July 13, 2008, 07:44:21 PM »
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

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #7 on: July 13, 2008, 10:26:02 PM »
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 :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline theglobe

  • Semi-Newbie
  • *
  • Posts: 62
  • Gender: Male
Re: [SMF Converter] IPB 2.3.x
« Reply #8 on: July 15, 2008, 03:31:33 PM »
I keep getting this when I try to convert:

Quote
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?

Offline theglobe

  • Semi-Newbie
  • *
  • Posts: 62
  • Gender: Male
Re: [SMF Converter] IPB 2.3.x
« Reply #9 on: July 15, 2008, 05:27:03 PM »
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.

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #10 on: July 15, 2008, 06:47:10 PM »
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 :|
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline crackos

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.3.x
« Reply #11 on: July 23, 2008, 11:09:20 PM »
where is the convert.php file? O_o

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #12 on: July 23, 2008, 11:26:04 PM »
It is linked to in the first post this converter topic  :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline razorb

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] IPB 2.3.x
« Reply #13 on: July 25, 2008, 11:54:35 AM »
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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #14 on: July 25, 2008, 02:51:07 PM »
it's a MySQL-Bug, a fix is available here: Common conversion errors

Offline razorb

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] IPB 2.3.x
« Reply #15 on: July 25, 2008, 10:56:36 PM »
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
« Last Edit: July 26, 2008, 02:38:43 PM by razorb »

Offline mystified

  • Semi-Newbie
  • *
  • Posts: 68
Re: [SMF Converter] IPB 2.3.x
« Reply #16 on: July 26, 2008, 07:37:38 AM »
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?

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #17 on: July 26, 2008, 02:21:49 PM »
Are you clicking continue or letting it do its work?
The converter will automatically do the work and refresh as needed.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline mystified

  • Semi-Newbie
  • *
  • Posts: 68
Re: [SMF Converter] IPB 2.3.x
« Reply #18 on: July 26, 2008, 02:24:00 PM »
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.

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #19 on: July 26, 2008, 02:28:19 PM »
What errors?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub