Simple Machines Community Forum

SMF Support => Converting to SMF => IPB => Topic started by: SleePy on May 09, 2008, 10:35:02 PM

Title: [SMF Converter] IPB 2.3.x
Post by: SleePy 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 (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Crivelli on May 17, 2008, 08:17:03 AM
I get a lot of errors but this I can't solve...

QuoteConverting 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
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy 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:
        $row += unserialize(stripslashes($row['permission_array']));
        $row = addslashes_recursive($row);


Replace:
        $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.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: GrandTheftGamer on June 01, 2008, 10:50:13 PM
I ran through everything and the conversion seems to have gone 100% successful. Thank you. :)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Bulent on June 14, 2008, 10:33:22 AM
Good job. ipb 2.3.1 100% successful.
Thank you.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: lvzifer 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 :

QuoteWhich 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
Title: Re: [SMF Converter] IPB 2.3.x
Post by: iSplicer 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
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy 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 :)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: theglobe on July 15, 2008, 03:31:33 PM
I keep getting this when I try to convert:

QuoteConverting 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?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: theglobe 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.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy 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 :|
Title: Re: [SMF Converter] IPB 2.3.x
Post by: crackos on July 23, 2008, 11:09:20 PM
where is the convert.php file? O_o
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on July 23, 2008, 11:26:04 PM
It is linked to in the first post this converter topic  :)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: razorb 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
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on July 25, 2008, 02:51:07 PM
it's a MySQL-Bug, a fix is available here: Common conversion errors (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: razorb 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
Title: Re: [SMF Converter] IPB 2.3.x
Post by: mystified 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?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy 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.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: mystified 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.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on July 26, 2008, 02:28:19 PM
What errors?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Dark-Master on August 01, 2008, 06:03:06 AM
Is this compatible with smf 2.0 ?

I got an error like this when I try to convert ipb 2.3.4 to smf 2.0 beta3.1

-----------------------------------------------

Converting members... Unsuccessful!
.........bla bla bla,,,,,,,
Caused the error:

    Unknown column 'memberName' in 'field list'
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on August 01, 2008, 07:08:05 AM
no, not at this time..

converters for 2.0  are still in developement (like SMF 2.0 itself). you have to convert to SMF 1.1.5 first and then upgrade the 1.1.5 to 2.0 Beta 3.1.. But remember: 2.0 is Beta and not recommended for production environments..

Title: Re: [SMF Converter] IPB 2.3.x
Post by: Dark-Master on August 01, 2008, 07:44:36 AM
Quote from: ThorstenE on August 01, 2008, 07:08:05 AM
no, not at this time..

converters for 2.0  are still in developement (like SMF 2.0 itself). you have to convert to SMF 1.1.5 first and then upgrade the 1.1.5 to 2.0 Beta 3.1.. But remember: 2.0 is Beta and not recommended for production environments..

Ok thanks a lot, but I got this error with 1.1.5 too

-------------
Converting members... Unsuccessful!
This query:

    INSERT INTO `xgsmf`.smf_members
----- bla bla bla-----

Caused the error:

    Incorrect date value: '' for column 'birthdate' at row 1
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on August 01, 2008, 08:09:16 AM
are you using the invision23_to_smf.sql from this topic (attachment in first post) and convert.php from here (http://www.simplemachines.org/community/index.php?topic=140741.0)?
maybe, you are using the wrong conversion file from the download page?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Dark-Master on August 01, 2008, 08:15:56 AM
Sure,

I'm using

convert.php from another topic and invision23_to_smf.sql from this topic .

And this is my phpinfo http://bbs.xgaming.in.th/info.php
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on August 01, 2008, 11:04:11 AM
i have no database-dumb from an ipb2.3 myself so i cannot check it.. there are two possible solutions:

1) remove this block from the invision23_to_smf.sql
IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate,
it is converting the birthdates from your users.. if you delete this block birthdays would not be converted.

2) post a screenshot from ipb's members-table, so that i can see which format the birthdays have and i will modify this block for you..
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on August 01, 2008, 07:52:01 PM
Dark-Master,

I think MySQL is running in strict mode here. Though I am not to sure why you still receive that error. It would only occur if it was empty or not used during part of the conversion. Which is odd as it is being used right there.
                        
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Dark-Master on August 01, 2008, 10:42:49 PM
THANKS you both, I removed the error thing from invision23_to_smf.sql.

There were

IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate, */

p.edit_time AS modifiedTime

p.pid AS ID_POLL

.

After I removed those 3s, the conversion can be done. Thanks to smf and you all.

And here is the result.
http://bbs.xgaming.in.th/

IPB date tables.
http://img.xgaming.in.th/temp/2008-08-02_093410.png
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Djuka on August 14, 2008, 02:14:48 PM
I get this message when trying to convert from 2.3.4 to SMF 1.1.5

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2.3. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'username'@'localhost' for table 'ibf_members'
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on August 14, 2008, 03:25:37 PM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Naerth on August 17, 2008, 04:04:21 PM
Hello,

for me, Converter was OK from IPB 2.3.1 to SMF 1.1.

all is fine but just BBCode not run good since i do converter

now where i read all topics where we have photos, color code and quote i have this kind of line on all my messages

[img src=\"http://farm2.static.flickr.com/1076/527942244_324d8f3580_o.jpg\" border=\"0\" class=\"linked-image\" /]


when i was on IPB the code was [img][/img]

do know how i can resolv this problem, i use the Panel Admin for check errors en problems : SMF is ok

thanks a lot for your answer

Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on August 18, 2008, 12:32:26 AM
Can you provide us a raw message from the IPB database that has this issue?
You will need to use phpMyAdmin or similar to get ahold of this, but this will provide us the message in its raw format so we know what it is looking like before any bbc code work is done on it.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Naerth on August 18, 2008, 10:56:08 AM
how i do that fort give you a Raw

i have 65100 messages (photos on the forum)

my forum it's a photo-forum
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on August 18, 2008, 01:35:07 PM
Do you know the message id of a post that has this issue?
If you link me to a post I could most likely figured out its message id.

We then go look at just that message body in the database.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Naerth on August 18, 2008, 03:35:07 PM
well i have 1567 topics and 65129 messages

this is the typical bug that i have on all my message


[!--coloro:#4169E1--][span style=\"color:#4169E1\"][!--/coloro--]Merci Nikolas pour cette info.
Je passerai à la FNAC évaluer le contenu des 2 livres.[!--colorc--][/span][!--/colorc--]

Ci-joint 2 des clichés tout juste pris à Lyon ce week-end sans réelle prise en main du K20

[img src=\"http://jpoilleux.neuf.fr/Photos/Partage/Lyon05-07-08.jpg\" border=\"0\" class=\"linked-image\" /]

[img src=\"http://jpoilleux.neuf.fr/Photos/Partage/Lyon02.jpg\" border=\"0\" class=\"linked-image\" /]
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on August 18, 2008, 06:15:01 PM
How does this one work?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Naerth on August 19, 2008, 03:20:06 AM
well i have this message of the end

Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `db214843381`.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
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Naerth on August 19, 2008, 03:23:12 AM
but for images all is fine now

thanks a lot
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on August 19, 2008, 01:27:41 PM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Ellion Cold on August 19, 2008, 10:54:12 PM
I have a problem, when i was converting i got this error:

Converting...
Converting poll logs... Unsuccessful!
This query:

    INSERT INTO `bgforum`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('1', '31'),
    ('1', '50'),
    ('1', '188'),
    ('1', '517'),
    ('2', '2'),
    ('2', '5'),
    ('2', '7'),
    ('2', '12'),
    ('2', '14'),
    ('2', '15'),
    ('2', '16'),
    ('2', '31'),
    ('2', '43'),
    ('2', '50'),
    ('2', '56'),
    ('2', '68'),
    ('2', '73'),
    ('2', '79'),
    ('2', '80'),
    ('2', '156'),
    ('2', '208'),
    ('2', '224'),
    ('2', '312'),
    ('2', '503'),
    ('2', '520'),
    ('3', '3'),
    ('3', '5'),
    ('3', '7'),
    ('3', '9'),
    ('3', '10'),
    ('3', '12'),
    ('3', '14'),
    ('3', '16'),
    ('3', '31'),
    ('3', '68'),
    ('3', '312'),
    ('3', '503'),
    ('', '3'),
    ('', '5'),
    ('', '7'),
    ('', '9'),
    ('', '10'),
    ('', '12'),
    ('', '14'),
    ('', '16'),
    ('', '31'),
    ('', '68'),
    ('', '312'),
    ('', '503'),
    ('1', '31'),
    ('1', '50'),
    ('1', '188'),
    ('1', '517'),
    ('2', '2'),
    ('2', '5'),
    ('2', '7'),
    ('2', '12'),
    ('2', '14'),
    ('2', '15'),
    ('2', '16'),
    ('2', '31'),
    ('2', '43'),
    ('2', '50'),
    ('2', '56'),
    ('2', '68'),
    ('2', '73'),
    ('2', '79'),
    ('2', '80'),
    ('2', '156'),
    ('2', '208'),
    ('2', '224'),
    ('2', '312'),
    ('2', '503'),
    ('2', '520'),
    ('3', '3'),
    ('3', '5'),
    ('3', '7'),
    ('3', '9'),
    ('3', '10'),
    ('3', '12'),
    ('3', '14'),
    ('3', '16'),
    ('3', '31'),
    ('3', '68'),
    ('3', '312'),
    ('3', '503'),
    ('', '3'),
    ('', '5'),
    ('', '7'),
    ('', '9'),
    ('', '10'),
    ('', '12'),
    ('', '14'),
    ('', '16'),
    ('', '31'),
    ('', '68'),
    ('', '312'),
    ('', '503'),
    ('4', '510'),
    ('4', '503'),
    ('4', '508'),
    ('4', '171'),
    ('5', '171'),
    ('5', '503'),
    ('5', '15'),
    ('5', '508'),
    ('5', '68'),
    ('5', '510'),
    ('5', '80'),
    ('5', '5'),
    ('6', '171'),
    ('6', '508'),
    ('6', '503'),
    ('6', '68'),
    ('7', '171'),
    ('7', '5'),
    ('7', '15'),
    ('7', '80'),
    ('7', '510'),
    ('7', '50'),
    ('7', '593'),
    ('8', '171'),
    ('8', '520'),
    ('8', '5'),
    ('8', '31'),
    ('8', '80'),
    ('8', '7'),
    ('8', '647'),
    ('8', '50'),
    ('8', '545'),
    ('8', '15'),
    ('8', '68'),
    ('8', '16');

Caused the error:

    Duplicate entry '1-31-0' for key 1



Can someone help me please? ^^
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on August 20, 2008, 01:33:19 AM
edit the invision23_to_smf.sql with  a text-editor and search for this line:
---* {$to_prefix}log_polls

add after
---{
$ignore = true;
---}

then upload the file via FTP and restart the conversion..
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on August 20, 2008, 04:31:41 PM
open the .sql file

find:
---* {$to_prefix}log_polls

replace:
---* {$to_prefix}log_polls
---{
$ignore = true;
---}
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Ellion Cold on August 21, 2008, 09:46:20 AM
Thanks for the help! :D
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Ferkel on September 05, 2008, 03:49:51 AM
Welcome you!
I'm trying to convert IP.Board v2.3.1 (ID: 23004) to SMF 1.1.5 with smf_1-1-5_invision2_converter.
But I'm getting error.

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Unsuccessful!
This query:
    INSERT INTO `seat_club`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (2, SUBSTRING('Какая Ибица вам нравится больше???', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (3, SUBSTRING('Вариант 1', 1, 255), 'Array', 1, 255), 'Array'),
    (4, SUBSTRING('А ты что бы выбрал для себя? ', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (5, SUBSTRING('Кто же он?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (6, SUBSTRING('Кто же она?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (7, SUBSTRING('Кто же лучший?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (8, SUBSTRING('Кто же этот красавец?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (9, SUBSTRING('У кого самая улетная тачка?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (10, SUBSTRING('Кто же больше всех помогает нам?', 1, 255), '1', 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', 1, 255), 'Array'),
    (3, SUBSTRING('Вариант 1', 1, 255), 'Array',' at line 3

PLEASE!!! HELP!!!
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Ferkel on September 05, 2008, 05:12:31 AM
Well I found resolution for my problem, I think.
I've just delete everything from MySQL field "poll_question" in original table "ibf_polls"

And now I have new problem:

Converting poll logs... Unsuccessful!
This query:
INSERT INTO `seat_club`.smf_log_polls
(ID_POLL, ID_MEMBER)
VALUES ('', '18'),
('', '31'),
('', '55'),
('', '19'),
('', '13'),
('', '70'),
('', '25'),
('', '46'),
('', '16'),
('', '12'),
('', '42'),
('', '23'),
('', '74'),
('', '6'),
('', '67'),
('', '27'),
('', '41'),
('', '12'),
('', '31'),
('', '92'),
('', '13'),
('', '13'),
('', '10'),
('', '9'),
('', '92'),
('', '22'),
('', '5'),
('', '55'),
('', '47'),
('', '77'),
('', '22'),
('', '12'),
('', '69'),
('', '108'),
('', '41'),
('', '108'),
('', '109'),
('', '16'),
('', '100'),
('', '41'),
('', '109'),
('', '25'),
('', '9'),
('', '13'),
('', '92'),
('', '92'),
('', '92'),
('', '41'),
('', '108'),
('', '108'),
('', '13'),
('', '109'),
('', '96'),
('', '96'),
('', '96'),
('', '100'),
('', '16'),
('', '16'),
('', '100'),
('', '13'),
('', '25'),
('', '25'),
('', '31'),
('', '31'),
('', '31'),
('', '5'),
('', '6'),
('', '41'),
('', '25'),
('', '108'),
('', '41'),
('', '25'),
('', '108'),
('', '41'),
('', '16'),
('', '108'),
('', '100'),
('', '100'),
('', '92'),
('', '92'),
('', '100'),
('', '92'),
('', '25'),
('', '96'),
('', '109'),
('', '109'),
('', '109'),
('', '9'),
('', '9'),
('', '9'),
('', '9'),
('', '9'),
('', '13'),
('', '13'),
('', '5'),
('', '5'),
('', '5'),
('', '31'),
('', '5'),
('', '31'),
('', '5'),
('', '10'),
('', '10'),
('', '10'),
('', '10'),
('', '10'),
('', '10'),
('', '6'),
('', '99'),
('', '99'),
('', '99'),
('', '99'),
('', '99'),
('', '3'),
('', '3'),
('', '3'),
('', '16'),
('', '16'),
('', '12'),
('', '12'),
('', '12'),
('', '12'),
('', '12'),
('', '12'),
('', '31'),
('', '6'),
('', '6'),
('', '6'),
('', '74'),
('', '74'),
('', '74'),
('', '74'),
('', '74'),
('', '74'),
('', '22'),
('', '22'),
('', '22'),
('', '22'),
('', '22'),
('', '22'),
('', '7'),
('', '7'),
('', '7'),
('', '7'),
('', '7'),
('', '7'),
('', '99'),
('', '70'),
('', '70');
Caused the error:

Duplicate entry '0-12-0' for key 1

What should I do? :(
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on September 06, 2008, 05:12:45 PM
That is most likely due to your previous fix you did :(
Do you have a backup to revert that?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Ferkel on September 08, 2008, 09:04:39 AM
Quote from: SleePy on September 06, 2008, 05:12:45 PM
That is most likely due to your previous fix you did :(
Do you have a backup to revert that?
Well, that is not a problem anymore.
I've just disable (rem'it) poll while converting...
Thank you for your answer.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Reinaldo122 on September 23, 2008, 06:27:51 PM
hi, where I have to put the convert.php file to could convert the BD to the SMF¿?
i'm looking but I can't find
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on September 23, 2008, 09:42:02 PM
Please only ask your question once.
http://www.simplemachines.org/community/index.php?topic=190907.msg1720839#msg1720839
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Cool Surfer on October 17, 2008, 01:24:26 PM
Hi
I am getting duplicate entry255 error
I tried makinh int value to 4, but its already 4.
What else can be done?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on October 17, 2008, 05:56:41 PM
You may need to change this int to 4 in the smf_categories, smf_boards and smf_collapsed_categories board. As well it is supposed to be a "BIGINT" of 4 not int.

If you run this script, http://www.simplemachines.org/community/index.php?topic=246700.0
It will do this for you. Remember to stop after the first step and let the conversion process complete before completing the rest of the steps in that script.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Sefer on December 02, 2008, 11:57:16 AM
Converting...
Converting members... Successful.
Converting categories... Unsuccessful!
This query:

    INSERT INTO `sozbitti_pedigo`.smf_categories
    (ID_CAT, name, catOrder)
    VALUES ('3', 'Önsöz Edebiyat (SB)', '3'),
    ('13', '2. Perde', '6'),
    ('26', '3. Perde', '7'),
    ('33', '1. Perde', '5'),
    ('38', 'Ve Bitti .', '8'),
    ('44', 'Başla..', '1'),
    ('284', 'Edebiyat Dünyası', '4'),
    ('335', 'İdari Yönetim Lobisi', '2');

Caused the error:

    Duplicate entry '255' for key 1


what does it mean?
what can i do for this error?

I am using IPB 2.3.1 and using true convert files..
Please help me.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on December 02, 2008, 12:04:40 PM
http://www.simplemachines.org/community/index.php?topic=274252.0#post_high_category_ids
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Barnabus on February 11, 2009, 02:50:32 PM
Quote from: SleePy on July 23, 2008, 11:26:04 PM
It is linked to in the first post this converter topic  :)
Please, what am I missing... I look at the first post, there is a link "convert.php", but it just takes me back to this discussion.  I just can't find "convert.php"

Thanks in advance for your help
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on February 11, 2009, 02:59:36 PM
http://www.simplemachines.org/community/index.php?topic=140741.0
convert.php is attached at the end from the first post (scroll down)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Londonms on February 23, 2009, 09:23:02 PM
Help -
QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `smf`.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 ('1', '0', '2', '1', '1', '', '3', '84', '1', '9', '0'),
('2', '0', '13', '1', '1', '', '0', '6', '2', '2', '0'),
('3', '0', '3', '1', '1', '', '6', '55', '3', '12', '0'),
('4', '0', '9', '1', '1', '', '0', '10', '13', '13', '0'),
('5', '0', '6', '1', '1', '', '2', '73', '14', '16', '0'),
('6', '0', '6', '1', '1', '', '1', '97', '17', '18', '0');
Caused the error:

Incorrect integer value: '' for column 'ID_POLL' at row 1
Invision 2.3.6
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on February 24, 2009, 02:37:27 AM
londonms,
I think your MySQL server is in strict mode. edit the invision23_to_smf.sql and find:

---* {$to_prefix}topics 250
SELECT
t.tid AS ID_TOPIC, t.pinned AS isSticky, t.forum_id AS ID_BOARD,
t.starter_id AS ID_MEMBER_STARTED, t.last_poster_id AS ID_MEMBER_UPDATED,
pl.pid AS ID_POLL, t.posts AS numReplies, t.views AS numViews,
MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG,
t.state = 'closed' AS locked
FROM ({$from_prefix}topics AS t, {$from_prefix}posts AS p)
LEFT JOIN {$from_prefix}polls AS pl ON (pl.tid = t.tid)
WHERE p.topic_id = t.tid
GROUP BY t.tid
HAVING ID_FIRST_MSG != 0
AND ID_LAST_MSG != 0;



replace it with:

SELECT
t.tid AS ID_TOPIC, t.pinned AS isSticky, t.forum_id AS ID_BOARD,
t.starter_id AS ID_MEMBER_STARTED, t.last_poster_id AS ID_MEMBER_UPDATED,
IF(pl.pid > 0, pl.pid , 0), t.posts AS numReplies, t.views AS numViews,
MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG,
t.state = 'closed' AS locked
FROM ({$from_prefix}topics AS t, {$from_prefix}posts AS p)
LEFT JOIN {$from_prefix}polls AS pl ON (pl.tid = t.tid)
WHERE p.topic_id = t.tid
GROUP BY t.tid
HAVING ID_FIRST_MSG != 0
AND ID_LAST_MSG != 0;
Title: Re: [SMF Converter] IPB 2.3.x
Post by: candidosa2 on April 08, 2009, 11:58:11 PM
Hello when try to convert a see that msg
thank you
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on April 09, 2009, 12:22:02 AM
candidosa2,

What is the error message you are receiving at the bottom of that message?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: candidosa2 on April 09, 2009, 12:54:39 AM
yes did see imagen attach
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on April 09, 2009, 06:58:00 PM
Your image doesn't show the last half of the error message.
Far as I can tell it may be a duplicate key error or there is something that wasn't escaped properly when SMF converter was trying to insert it into the database.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Tiscan on May 22, 2009, 07:27:09 PM
Got myself an error trying to convert my IPB 2.3 install... any ideas?


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 topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments...
Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-1-1125596689.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1129601073.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1129924461.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1142453192.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-1-1147019334.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1149789666.ipb) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036020.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036030.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036038.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036046.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036054.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036061.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036071.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036081.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334535.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334560.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334571.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334591.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1163618647.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-7-1164218556.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads//post-1-1170731912.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads//post-17-1173815534.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads//post-7-1175548461.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
  Successful.
Converting user avatars...
Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-1.png) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-5.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-6.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-7.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-8.png) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-10.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy() [function.copy]: The first argument to copy() function cannot be a directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-17.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59
  Successful.
Recalculating forum statistics...  Successful.
  Conversion Complete Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support. Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the Invision Power Board 2.3 installation.

We hope you had a smooth transition!
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Tiscan on May 22, 2009, 07:36:30 PM
Ok, so I did some checking... those attachments it is trying to copy don't exist (for some reason) so those are legit errors that can be ignored.

However the avatars not copying is still very strange....
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on May 23, 2009, 05:12:10 PM
Tiscan, are the old IPB avatars located in the "uploads" folder from IPB?
If yes, you can edit the ipb23_to_smf.sql and replace:

if (!isset($oldAttachmentDir))
{
$result = convert_query("
SELECT conf_value
FROM {$from_prefix}conf_settings
WHERE conf_key = 'upload_dir'
LIMIT 1");
list ($oldAvatarDir) = mysql_fetch_row($result);
mysql_free_result($result);

if (empty($oldAttachmentDir) || !file_exists($oldAvatarDir))
$oldAvatarDir = $_POST['path_from'] . '/uploads';
}

with:
$oldAvatarDir = $_POST['path_from'] . '/uploads';
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Python000 on May 29, 2009, 02:34:52 AM
Hi.

When mine is in the process of converting posts, it times out.  I've tried it in IE and Google Chrome.  It appears to have converted successfully up until it times out (members and such are converted).  It keeps doing this every time.

Any ideas?  Please help.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on May 30, 2009, 02:02:02 AM
Any error messages during the conversion (white page, script stops, internal server error) ???
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Punk92 on May 31, 2009, 05:41:33 AM
Hi

in my case the conversion procedure has not given problems. When I enter in board, but the part of the forum there isn't, and also part of the area of admin. why?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on May 31, 2009, 06:20:25 AM
Punk92,
possibly the Group membership wasn't converted right.. You can restore the Admin privilegues for your Account:
Please check: I accidentally deleted my admin account, what do I do? (http://docs.simplemachines.org/index.php?topic=466)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Punk92 on May 31, 2009, 07:15:54 AM
Ok, thanks, now work. But the user avarat there isn't.. how can i resolve?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Tiscan on May 31, 2009, 01:14:39 PM
Thanks TE, looking at it this would indeed have fixed it.. however as it was easy to just tell folks to re-load avatars I had already done that. :)

It would be nice if the converter automatically detected this for older IPB installs.

Quote from: TE on May 23, 2009, 05:12:10 PM
Tiscan, are the old IPB avatars located in the "uploads" folder from IPB?
If yes, you can edit the ipb23_to_smf.sql and replace:

if (!isset($oldAttachmentDir))
{
$result = convert_query("
SELECT conf_value
FROM {$from_prefix}conf_settings
WHERE conf_key = 'upload_dir'
LIMIT 1");
list ($oldAvatarDir) = mysql_fetch_row($result);
mysql_free_result($result);

if (empty($oldAttachmentDir) || !file_exists($oldAvatarDir))
$oldAvatarDir = $_POST['path_from'] . '/uploads';
}

with:
$oldAvatarDir = $_POST['path_from'] . '/uploads';
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Punk92 on June 03, 2009, 07:47:44 AM
I've a problem with Attachments.. during the convertition, some files ( img, zip etc ) are to convert correctly, but the greater part Not. the string appears only [attachments: ....].

why?

p.s. also the avatar, but i copy the original img in /avatar,and work.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Christool on June 11, 2009, 05:57:03 AM
Hello guys,
I am trying to convert IPB 2.3.6 to SMF 1.1.9 and unfortunately, i get an error mesage :


Converting topics... Unsuccessful!
This query:
INSERT INTO `Christoo_ipb`.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 ('331', '0', '28', '190', '20', '', '2', '342', '4795', '4820', '0'),
('332', '0', '6', '58', '58', '', '14', '853', '4828', '5349', '0'),
('333', '0', '10', '313', '61', '', '33', '2701', '4846', '20202', '0'),
('334', '0', '13', '47', '47', '', '13', '167', '4856', '5283', '0'),
('335', '0', '1', '101', '94', '', '62', '1948', '4858', '7558', '0'),
('336', '0', '1', '4', '0', '', '4', '380', '4890', '5741', '0'),
('338', '0', '13', '113', '113', '', '31', '520', '4912', '5406', '0'),
('339', '0', '28', '151', '334', '', '9', '580', '4958', '6847', '0'),
('340', '0', '95', '269', '37', '', '8', '263', '4978', '6409', '0'),
('341', '0', '1', '9', '19', '', '6', '387', '5003', '5018', '0'),
('342', '0', '2', '47', '2', '', '7', '356', '5013', '5379', '0'),
('343', '0', '6', '65', '88', '', '9', '336', '5028', '5293', '0'),
('344', '0', '1', '319', '309', '', '13', '625', '5066', '6314', '0'),
('345', '0', '10', '27', '309', '', '8', '494', '5071', '6318', '0'),
('346', '0', '1', '98', '0', '', '15', '817', '5090', '5737', '0'),
('347', '0', '1', '167', '99', '', '32', '1373', '5104', '5691', '0'),
('348', '0', '28', '98', '99', '', '5', '404', '5110', '5538', '0'),
('349', '0', '28', '320', '47', '', '13', '476', '5123', '6988', '0'),
('350', '0', '6', '160', '317', '', '4', '352', '5127', '5257', '0'),
('351', '0', '1', '237', '81', '', '17', '890', '5139', '5299', '0'),
('352', '0', '8', '240', '455', '', '6', '1445', '5184', '11309', '0'),
('353', '0', '10', '5', '4', '11', '10', '700', '5218', '5712', '0'),
('354', '0', '95', '25', '25', '', '0', '128', '5221', '5221', '0'),
('356', '0', '28', '324', '90', '', '2', '395', '5230', '5844', '0'),
('357', '0', '10', '274', '150', '', '12', '609', '5260', '6256', '0'),
('358', '0', '8', '167', '603', '', '25', '1802', '5261', '70379', '0'),
('359', '0', '6', '47', '65', '', '6', '330', '5297', '6541', '0'),
('360', '0', '28', '47', '192', '', '20', '2096', '5337', '6439', '0'),
('361', '0', '28', '112', '90', '', '2', '259', '5405', '5846', '0'),
('362', '0', '10', '32', '112', '', '9', '520', '7068', '8243', '0'),
('363', '0', '95', '77', '103', '', '14', '456', '5366', '5991', '0'),
('365', '0', '1', '47', '397', '', '3', '257', '5334', '10205', '0'),
('367', '0', '1', '0', '78', '', '7', '667', '5354', '5468', '0'),
('370', '0', '28', '219', '32', '', '33', '2632', '5374', '8041', '0'),
('375', '0', '6', '81', '644', '', '21', '618', '5386', '4370006', '0'),
('376', '0', '14', '2', '2', '', '150', '1702', '5392', '6019', '0'),
('377', '0', '28', '331', '249', '', '12', '737', '5432', '6145', '0'),
('378', '0', '1', '332', '41', '', '4', '429', '5434', '10914', '0'),
('379', '0', '1', '25', '152', '', '14', '868', '5435', '5701', '0'),
('380', '0', '28', '326', '326', '', '3', '319', '5451', '5651', '0'),
('381', '0', '28', '112', '151', '', '68', '5738', '5476', '8752', '0'),
('383', '0', '10', '78', '78', '', '13', '601', '5487', '6411', '0'),
('384', '0', '17', '208', '208', '', '52', '2421', '5566', '35355', '0'),
('385', '0', '16', '213', '361', '', '3', '661', '5571', '6683', '0'),
('386', '0', '6', '14', '668', '', '12', '688', '5615', '29063', '0'),
('387', '0', '28', '143', '132', '', '18', '1275', '5647', '8051', '0'),
('388', '0', '28', '51', '131', '', '8', '481', '5680', '5974', '0'),
('390', '0', '13', '131', '112', '', '33', '585', '5700', '6285', '0'),
('391', '0', '28', '152', '6', '', '11', '585', '5705', '6121', '0'),
('392', '0', '10', '331', '4', '', '18', '616', '5724', '10166', '0'),
('393', '0', '10', '0', '0', '', '3', '356', '5725', '9208', '0'),
('394', '0', '28', '344', '581', '', '20', '1107', '5750', '15752', '0'),
('395', '0', '8', '74', '41', '', '30', '1922', '5778', '26343', '0'),
('396', '0', '10', '124', '1224', '', '51', '2483', '5812', '4377808', '0'),
('397', '0', '1', '25', '25', '', '1', '262', '5850', '5851', '0'),
('398', '0', '28', '229', '1811', '', '17', '1223', '5857', '4440898', '0'),
('399', '0', '28', '88', '29', '', '14', '596', '5890', '6477', '0'),
('400', '0', '28', '9', '625', '', '21', '757', '5898', '57041', '0'),
('401', '0', '2', '0', '2337', '', '5', '735', '5911', '4370284', '0'),
('402', '0', '28', '277', '277', '', '18', '1384', '5944', '6316', '0'),
('403', '0', '28', '192', '90', '', '5', '378', '5957', '6066', '0'),
('404', '0', '28', '125', '428', '', '39', '1643', '5999', '57423', '0'),
('405', '0', '1', '112', '78', '', '17', '559', '6008', '6325', '0'),
('406', '0', '1', '0', '665', '', '50', '1294', '6064', '62790', '0'),
('407', '0', '28', '241', '241', '', '0', '197', '6076', '6076', '0'),
('408', '0', '10', '259', '151', '', '27', '1028', '6088', '26241', '0'),
('410', '0', '6', '6', '60', '', '49', '2123', '6124', '10527', '0'),
('411', '0', '1', '169', '81', '', '10', '436', '6144', '9158', '0'),
('412', '0', '10', '60', '135', '', '15', '704', '6161', '9278', '0'),
('413', '0', '1', '38', '112', '', '39', '1498', '6166', '8342', '0'),
('414', '0', '2', '14', '14', '', '4', '303', '6174', '7763', '0'),
('415', '0', '28', '353', '440', '', '8', '340', '6199', '4314244', '0'),
('423', '0', '28', '48', '57', '', '1', '289', '6218', '6272', '0'),
('424', '0', '1', '249', '19', '', '19', '765', '6219', '6609', '0'),
('425', '0', '1', '356', '356', '', '19', '530', '6224', '21078', '0'),
('426', '0', '95', '285', '277', '', '15', '792', '6270', '15916', '0'),
('427', '0', '28', '285', '75', '', '42', '3603', '6287', '8184', '0'),
('428', '0', '1', '357', '357', '', '0', '281', '6310', '6310', '0'),
('429', '0', '28', '143', '143', '', '2', '388', '6342', '6594', '0'),
('430', '0', '28', '75', '75', '', '4', '444', '6356', '6420', '0'),
('431', '0', '13', '138', '138', '', '20', '184', '6367', '7585', '0'),
('432', '0', '1', '29', '29', '', '34', '1560', '6393', '9916', '0'),
('433', '0', '13', '361', '112', '', '35', '483', '6395', '8593', '0'),
('434', '0', '1', '13', '13', '', '4', '305', '6400', '6537', '0'),
('435', '0', '8', '167', '240', '', '12', '1356', '6404', '7882', '0'),
('436', '0', '95', '25', '25', '', '2', '230', '6406', '6829', '0'),
('437', '0', '8', '167', '125', '', '2', '794', '6407', '6471', '0'),
('438', '0', '28', '363', '363', '', '2', '357', '6433', '7828', '0'),
('439', '0', '1', '101', '38', '', '14', '634', '6469', '6562', '0'),
('440', '0', '28', '274', '23', '', '11', '479', '6505', '7454', '0'),
('441', '0', '10', '114', '309', '', '1', '208', '6515', '6626', '0'),
('442', '0', '2', '98', '33', '', '11', '624', '6540', '9528', '0'),
('443', '0', '28', '346', '237', '', '1', '253', '6548', '6550', '0'),
('444', '0', '28', '219', '90', '', '7', '344', '6566', '6667', '0'),
('445', '0', '1', '51', '56', '', '14', '667', '6571', '6617', '0'),
('446', '0', '28', '51', '92', '', '1', '229', '6572', '6584', '0'),
('447', '0', '28', '39', '107', '', '21', '733', '6573', '38078', '0'),
('448', '0', '8', '29', '455', '', '30', '2876', '6591', '64344', '0'),
('449', '0', '8', '29', '455', '', '3', '965', '6592', '11495', '0'),
('450', '0', '10', '369', '1023', '', '25', '868', '6610', '50128', '0'),
('451', '0', '28', '143', '61', '', '9', '518', '6616', '7597', '0'),
('452', '0', '28', '249', '377', '', '5', '423', '6622', '8179', '0'),
('457', '0', '95', '61', '508', '', '5', '203', '6640', '12181', '0'),
('458', '0', '1', '355', '355', '', '51', '1757', '6641', '11976', '0'),
('459', '0', '1', '61', '6800', '14', '153', '20097', '6643', '4561475', '0'),
('460', '0', '28', '61', '435', '', '1', '242', '6653', '9742', '0'),
('461', '0', '1', '361', '13', '', '2', '228', '6707', '6720', '0'),
('462', '0', '17', '29', '477', '', '4', '337', '6749', '11476', '0'),
('463', '0', '95', '74', '20', '', '37', '1309', '6701', '10856', '0'),
('464', '0', '17', '259', '231', '', '17', '825', '6706', '4323631', '0'),
('465', '0', '14', '0', '2', '', '38', '615', '6712', '7883', '0'),
('466', '0', '13', '309', '377', '', '4', '93', '6726', '7172', '0'),
('467', '0', '13', '259', '2', '', '5', '52', '6731', '7704', '0'),
('468', '0', '10', '269', '61', '', '1', '317', '6735', '7041', '0'),
('469', '0', '1', '65', '240', '', '9', '592', '6737', '7712', '0'),
('470', '0', '6', '29', '127', '', '28', '742', '6807', '7059', '0'),
('471', '0', '28', '283', '283', '', '0', '213', '6811', '6811', '0'),
('472', '0', '1', '29', '29', '', '31', '1062', '6840', '8176', '0'),
('473', '0', '13', '138', '112', '', '25', '134', '6854', '7604', '0'),
('474', '0', '1', '290', '1218', '', '85', '2268', '6857', '66110', '0'),
('475', '0', '1', '342', '342', '', '5', '405', '6891', '7436', '0'),
('476', '0', '28', '375', '26', '', '16', '918', '6961', '8851', '0'),
('477', '0', '28', '179', '190', '', '2', '262', '6970', '7043', '0'),
('478', '0', '1', '254', '254', '', '5', '344', '6977', '8909', '0'),
('479', '0', '6', '17', '16', '', '1', '177', '6985', '7080', '0'),
('480', '0', '13', '377', '2', '', '38', '308', '7013', '7702', '0'),
('482', '0', '28', '160', '435', '', '2', '362', '7015', '9740', '0'),
('483', '0', '28', '94', '435', '', '27', '1616', '7040', '14403', '0'),
('484', '0', '1', '269', '106', '', '1', '257', '7051', '7132', '0'),
('485', '0', '13', '379', '44', '', '16', '213', '7066', '8854', '0'),
('486', '0', '6', '6', '240', '', '10', '367', '7072', '7708', '0'),
('487', '0', '1', '47', '23', '', '15', '636', '7121', '7652', '0'),
('488', '0', '10', '85', '60', '', '11', '528', '7123', '7459', '0'),
('496', '0', '2', '2', '20', '', '5', '397', '7206', '7836', '0'),
('497', '0', '1', '25', '0', '', '14', '625', '7220', '7410', '0'),
('499', '0', '1', '200', '200', '', '0', '177', '7235', '7235', '0'),
('500', '0', '28', '265', '16', '', '5', '481', '7248', '8017', '0'),
('501', '0', '6', '47', '142', '', '11', '522', '7250', '8281', '0'),
('502', '0', '1', '254', '2', '', '22', '887', '7268', '8294', '0'),
('503', '0', '28', '44', '112', '', '14', '632', '7269', '7458', '0'),
('504', '0', '6', '29', '20', '', '65', '1380', '7280', '42580', '0'),
('505', '0', '2', '237', '90', '', '6', '439', '7287', '51462', '0'),
('506', '0', '2', '7', '160', '', '40', '2872', '7298', '9836', '0'),
('507', '0', '28', '114', '205', '', '6', '387', '7308', '12838', '0'),
('508', '0', '1', '114', '20', '', '41', '2698', '7310', '4389714', '0'),
('511', '0', '10', '112', '112', '', '15', '746', '7390', '8968', '0'),
('512', '0', '1', '269', '16', '', '19', '684', '7409', '8543', '0'),
('513', '0', '95', '269', '4', '', '1', '163', '7416', '8029', '0'),
('514', '0', '95', '269', '58', '', '1', '190', '7418', '7593', '0'),
('515', '0', '1', '29', '361', '', '2', '266', '7425', '7495', '0'),
('516', '0', '28', '60', '60', '', '2', '456', '7460', '7567', '0'),
('517', '0', '1', '2', '361', '', '15', '592', '7469', '7577', '0'),
('518', '0', '8', '167', '140', '', '9', '1065', '7479', '7839', '0'),
('519', '1', '14', '0', '1229', '', '29', '1081', '7483', '62703', '0'),
('520', '0', '1', '385', '13', '', '1', '233', '7496', '7528', '0'),
('521', '0', '1', '224', '966', '', '25', '2887', '7506', '4336232', '0'),
('522', '0', '17', '224', '477', '', '14', '2925', '7516', '11041', '0'),
('523', '0', '1', '219', '1546', '', '11', '1417', '7536', '4323728', '0'),
('524', '0', '1', '60', '60', '', '1', '215', '7563', '7565', '0'),
('525', '0', '28', '60', '2182', '', '14', '722', '7566', '4380730', '0'),
('526', '0', '28', '88', '131', '', '6', '354', '7583', '8979', '0'),
('527', '0', '8', '167', '73', '', '4', '555', '7588', '7770', '0'),
('528', '0', '1', '198', '198', '', '13', '693', '7591', '8301', '0'),
('529', '0', '10', '346', '99', '', '11', '657', '7598', '8984', '0'),
('530', '0', '1', '2', '47', '', '47', '1430', '7608', '8218', '0'),
('531', '0', '28', '297', '297', '', '2', '411', '7612', '7944', '0'),
('532', '0', '1', '29', '361', '', '9', '383', '7628', '8359', '0'),
('533', '0', '1', '0', '19', '', '57', '1731', '7634', '12197', '0'),
('534', '0', '13', '202', '44', '', '14', '158', '7640', '8855', '0'),
('535', '0', '28', '202', '161', '', '13', '461', '7657', '12792', '0'),
('536', '0', '1', '101', '74', '', '3', '264', '7666', '11748', '0'),
('537', '0', '13', '47', '377', '', '12', '316', '7673', '8438', '0'),
('539', '0', '10', '179', '99', '', '25', '1785', '7722', '22617', '0'),
('540', '0', '1', '74', '196', '', '75', '2998', '7724', '9688', '0'),
('541', '0', '1', '205', '140', '', '7', '401', '7750', '7801', '0'),
('542', '0', '6', '47', '17', '', '4', '268', '7756', '7788', '0'),
('543', '0', '1', '205', '47', '', '1', '245', '7765', '7767', '0'),
('544', '0', '6', '143', '143', '', '0', '172', '7777', '7777', '0'),
('545', '0', '28', '236', '125', '', '4', '405', '7794', '8156', '0'),
('546', '0', '13', '389', '79', '', '17', '140', '7798', '8423', '0'),
('547', '0', '28', '219', '219', '', '6', '363', '7841', '32385', '0'),
('548', '0', '10', '51', '202', '', '5', '511', '7843', '10019', '0'),
('549', '0', '10', '85', '88', '', '7', '492', '7854', '8096', '0'),
('550', '0', '1', '61', '16', '16', '41', '1184', '7863', '8417', '0'),
('551', '0', '1', '61', '141', '', '3', '172', '7864', '8412', '0'),
('552', '0', '1', '29', '61', '', '2', '261', '7867', '7937', '0'),
('554', '0', '28', '143', '18', '', '5', '612', '7894', '9563', '0'),
('556', '0', '1', '127', '11', '', '25', '1049', '7911', '8384', '0'),
('557', '0', '28', '393', '343', '', '2', '429', '7943', '8349', '0'),
('558', '0', '28', '25', '25', '', '5', '296', '7958', '8104', '0'),
('559', '0', '1', '0', '72', '', '62', '1672', '7990', '9317', '0'),
('560', '0', '28', '186', '186', '', '4', '437', '7994', '8748', '0'),
('561', '0', '1', '196', '199', '', '22', '794', '8001', '8948', '0'),
('562', '0', '13', '132', '603', '', '25', '207', '8063', '31803', '0'),
('563', '0', '28', '31', '26', '', '10', '470', '8064', '8540', '0'),
('564', '0', '1', '269', '37', '', '7', '432', '8103', '8198', '0'),
('565', '0', '1', '377', '398', '', '34', '1320', '8166', '8931', '0'),
('566', '0', '1', '29', '290', '', '10', '495', '8169', '8368', '0'),
('567', '0', '1', '17', '2', '', '58', '1515', '8229', '4509395', '0'),
('568', '0', '1', '17', '78', '', '31', '642', '8244', '33547', '0'),
('569', '0', '1', '151', '151', '', '12', '511', '8274', '8747', '0'),
('570', '0', '6', '47', '88', '', '1', '170', '8284', '8934', '0'),
('571', '0', '95', '184', '52', '', '11', '450', '8300', '10047', '0'),
('572', '0', '95', '398', '248', '', '2', '167', '8387', '8674', '0'),
('573', '0', '13', '398', '23', '', '19', '276', '8397', '8865', '0'),
('574', '0', '1', '29', '406', '', '23', '964', '8403', '9117', '0'),
('575', '0', '10', '259', '114', '', '8', '506', '8444', '8639', '0'),
('576', '0', '1', '103', '17', '', '2', '199', '8522', '8525', '0'),
('577', '0', '10', '17', '17', '', '14', '743', '8517', '9292', '0'),
('578', '0', '1', '2', '454', '', '20', '642', '8529', '10059', '0'),
('579', '0', '28', '352', '352', '', '43', '1387', '8544', '10676', '0'),
('580', '0', '1', '97', '81', '', '50', '903', '8571', '10957', '0'),
('581', '0', '28', '287', '205', '', '6', '421', '8580', '9199', '0'),
('582', '0', '1', '4', '99', '', '7', '262', '8595', '8764', '0'),
('583', '0', '13', '406', '377', '', '7', '113', '8601', '8663', '0'),
('584', '0', '1', '101', '342', '', '31', '1098', '8608', '9527', '0'),
('585', '0', '28', '143', '6', '', '4', '440', '8619', '8649', '0'),
('586', '0', '28', '407', '407', '', '16', '693', '8620', '9188', '0'),
('587', '0', '8', '6', '151', '', '4', '750', '8621', '8750', '0'),
('588', '0', '28', '6', '6', '', '0', '214', '8632', '8632', '0'),
('589', '0', '13', '407', '112', '', '17', '186', '8641', '9058', '0'),
('590', '0', '1', '125', '125', '', '9', '363', '8681', '9191', '0'),
('591', '0', '28', '248', '237', '', '3', '440', '8683', '8814', '0'),
('592', '0', '10', '68', '498', '', '20', '1049', '8724', '13681', '0'),
('593', '0', '28', '219', '140', '', '10', '476', '8728', '9148', '0'),
('594', '0', '28', '410', '14', '', '14', '646', '8730', '12355', '0'),
('595', '0', '95', '411', '411', '', '0', '154', '8738', '8738', '0'),
('597', '0', '28', '412', '283', '', '5', '402', '8744', '8997', '0'),
('598', '0', '8', '151', '151', '', '5', '826', '8762', '9019', '0'),
('599', '0', '8', '205', '167', '', '3', '582', '8768', '8872', '0'),
('600', '0', '10', '44', '140', '', '3', '340', '8780', '8799', '0'),
('601', '0', '10', '2', '2', '', '41', '1987', '8783', '14864', '0'),
('602', '0', '28', '414', '552', '', '2', '220', '8806', '13566', '0'),
('603', '0', '28', '406', '192', '', '8', '369', '8810', '9542', '0'),
('604', '0', '1', '101', '233', '', '17', '569', '8825', '10640', '0'),
('605', '0', '10', '407', '407', '', '3', '372', '8846', '9189', '0'),
('606', '0', '28', '50', '85', '', '5', '333', '8861', '9013', '0'),
('607', '0', '95', '5', '17', '', '4', '269', '8899', '9290', '0'),
('608', '0', '1', '85', '61', '', '1', '113', '8903', '8905', '0'),
('609', '0', '10', '61', '397', '', '4', '292', '8910', '9492', '0'),
('610', '0', '10', '61', '140', '', '3', '300', '8911', '13268', '0'),
('612', '0', '1', '233', '140', '', '13', '386', '8925', '9415', '0'),
('613', '0', '1', '88', '88', '', '8', '428', '8936', '9765', '0'),
('614', '0', '10', '78', '78', '', '9', '399', '8943', '10209', '0'),
('615', '0', '28', '51', '51', '', '4', '363', '8946', '9088', '0'),
('616', '0', '1', '92', '0', '', '15', '728', '8947', '9315', '0'),
('617', '0', '28', '421', '362', '', '26', '1211', '8978', '12369', '0'),
('618', '0', '1', '4', '75', '', '52', '1142', '8982', '4313467', '0'),
('619', '0', '28', '131', '181', '', '39', '1259', '8986', '4330721', '0'),
('620', '0', '1', '112', '172', '', '30', '892', '9034', '10118', '0');
Caused the error:

Duplicate entry '331' for key 1


Can anyone help me please ?
;)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on June 11, 2009, 07:26:08 AM
edit the invision23_to_smf.sql with a text-editor and search for:

---* {$to_prefix}topics 250

replace it with:

---* {$to_prefix}topics 250
---{
$ignore = true;
---}

Then restart the conversion..
Title: Re: [SMF Converter] IPB 2.3.x
Post by: anantgupta on June 12, 2009, 01:36:44 PM
got ths error while converting my forum

plz help

plz gve whole details hw to convert.....
QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2.3. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'forum_smf'@'92.867.546.235' for table 'ibf_members'
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on June 13, 2009, 01:47:30 AM
see Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Christool on June 16, 2009, 12:54:17 PM
Quote from: TE on June 11, 2009, 07:26:08 AM
edit the invision23_to_smf.sql with a text-editor and search for:

---* {$to_prefix}topics 250

replace it with:

---* {$to_prefix}topics 250
---{
$ignore = true;
---}

Then restart the conversion..

Hello Te,
Thank you for your help, it is ok now using your fix.
;)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: limap5 on June 26, 2009, 08:20:00 AM
I got this error,


Invision Power Board 2.3 to SMF Converter
Converting...
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... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments...
Fatal error: Call to undefined function getAttachmentFilename() in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 20

IPB v 2.3.6 to SMF 1.1.9

What is the problem? I could not finish the conversion.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on June 26, 2009, 02:42:57 PM
please use the converter from our downloads page instead: (direct link)
http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-9_invision23_converter.zip


Title: Re: [SMF Converter] IPB 2.3.x
Post by: limap5 on June 27, 2009, 10:11:25 AM
Thanks.
Managed to convert but came to several errors.

Converting...
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... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments...
Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_01_2008/post-51-1200583554.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21

Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202632069.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21

Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202633527.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21

Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202634247.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21

Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202635307.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21
Successful.
Converting user avatars...
Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-2.gif) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-7.gif) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-15.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-40.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-43.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-77.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-201.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on June 27, 2009, 12:37:25 PM
I believe you used this path during conversion?:
/home/sbpimnet/public_html/alumni/

please try /home/sbpimnet/public_html/alumni
(without trailing slash)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Python000 on July 13, 2009, 06:11:13 PM
Quote from: TE on May 30, 2009, 02:02:02 AM
Any error messages during the conversion (white page, script stops, internal server error) ???
My browser says that the page timed out, it is a browser error not a SMF error but I've tried Google Chrome and Internet Explorer and it still happens.

Any ideas?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: SleePy on July 23, 2009, 09:28:35 PM
You might want to convert via command line. It seems like the queries it is executing is causing the server to lock up and your browser is giving up before it does.

Do you have any part of the conversion done? That you know of so far?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Python000 on July 23, 2009, 09:32:16 PM
Quote from: SleePy on July 23, 2009, 09:28:35 PM
You might want to convert via command line. It seems like the queries it is executing is causing the server to lock up and your browser is giving up before it does.

Do you have any part of the conversion done? That you know of so far?
Yeah, like I said it finishes about half of the conversion, and I can see it when I browse the new forum (the parts it converted).  Then that happens.  It converts stuff like members but stops before it converts the important stuff like posts, boards, and stats!
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Python000 on July 28, 2009, 02:40:40 PM
Anybody?  This is getting kind of urgent now.

I don't like my server supports shell access because it wouldn't let me access it. :o

The conversion gets about half way through converting posts when it gives up.  The very last number in the URL was 38500 I believe, the number that progresses up as it converts more posts.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on July 28, 2009, 03:07:05 PM
please try to decrease the number of concurrent converted messages..

edit the invision23_to_smf.sql

find:

---* {$to_prefix}messages 200

replace it with:

---* {$to_prefix}messages 100

then restart the conversion.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Python000 on July 28, 2009, 11:21:26 PM
Quote from: TE on July 28, 2009, 03:07:05 PM
please try to decrease the number of concurrent converted messages..

edit the invision23_to_smf.sql

find:

---* {$to_prefix}messages 200

replace it with:

---* {$to_prefix}messages 100

then restart the conversion.
Didn't work, still stops working when "start=39500" (the url).  It's always that same number where it stops working... :(
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on July 29, 2009, 01:17:12 AM
Any chance to convert your forum offline? You could install a local webserver on your PC (XAMPP for example is an easy to install MySQL, PHP, Apache environment), then import your forum and convert it to SMF, then transfer the converted SMF back to your host..
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Mu3rt31 on July 30, 2009, 03:58:00 AM
Just did download the that .sql file from this thread the error message does not say "script error in line 23" anymore it just says:
Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

http://www.simplemachines.org/community/index.php?topic=325809.0
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Smoerble on August 05, 2009, 03:31:11 PM
I get duplicate entry errors because the answers are the same, but not the polls.

That means I have a lot polls that have the answer "yes". Each produces a duplicate entry error :(.

Anyone has an idea how to fix this?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Metalltony on August 12, 2009, 12:27:54 PM
hi,
I want to convert my board from ipb 2.3.6 to smf 1.1.10 but I get this error msg

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... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments... Successful.
Converting user avatars... Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1250094278),
    ("conversion_from", "invision23_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", 1250094278)' at line 1

What can I do?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on August 12, 2009, 12:33:36 PM
everything should be fine, that's a minor bug in convert.php (we add a database value after the conversion) and the conversion has already finished.

QuoteRecalculating forum statistics... Successful.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Alpha120 on December 14, 2009, 08:52:30 PM
Hello, sorry for this post in this topic, I know the last post is from 12-08, but I need help with my IPB 2.3.6 to SMF 1.1.11 conversion.

I get this error:

Converting members... Unsuccessful!
This query:

    SELECT
    m.id AS ID_MEMBER, SUBSTRING(m.name, 1, 80) AS memberName,
    m.joined AS dateRegistered,
    IF(m.mgroup = 4, 1, IF(m.mgroup = 3, 0, IF(m.mgroup > 5, m.mgroup + 3, 0))) AS ID_GROUP,
    posts, m.last_visit AS lastLogin, SUBSTRING(m.members_display_name, 1, 80) AS realName,
    SUBSTRING(me.yahoo, 1, 32) AS YIM, m.msg_total AS instantMessages,
    SUBSTRING(mc.converge_pass_hash, 1, 64) AS passwd,
    SUBSTRING(mc.converge_pass_salt, 1, 5) AS passwordSalt,
    SUBSTRING(m.email, 1, 255) AS emailAddress,
    IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate,
    SUBSTRING(me.website, 1, 255) AS websiteTitle,
    SUBSTRING(me.website, 1, 255) AS websiteUrl, me.signature,
    SUBSTRING(me.location, 1, 255) AS location,
    SUBSTRING(me.icq_number, 1, 255) AS ICQ,
    SUBSTRING(me.msnname, 1, 255) AS MSN, SUBSTRING(me.aim_name, 1, 16) AS AIM,
    m.hide_email AS hideEmail, m.email_pm AS pm_email_notify,
    SUBSTRING(IF(me.avatar_location = 'noavatar', '', me.avatar_location), 1, 255) AS avatar,
    TRIM(BOTH ',' FROM mgroup_others) AS additionalGroups,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
    '' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
    '' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
    '' AS smileySet, '' AS memberIP2
    FROM `fuertota_ctrlz`.ibf_members AS m
    LEFT JOIN `fuertota_ctrlz`.ibf_member_extra AS me ON (m.id = me.id)
    LEFT JOIN `fuertota_ctrlz`.ibf_members_converge AS mc ON (m.id = mc.converge_id)
    WHERE m.id != 0
    LIMIT 0, 500;

Caused the error:

    Table 'fuertota_ctrlz.ibf_member_extra' doesn't exist

I hope you can help me.
Thanks in advance.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Norv on December 14, 2009, 09:18:52 PM
Is there something, an admin option, in IPB, like enabling extra information about members? If yes, please enable it, then try again.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Alpha120 on December 15, 2009, 07:54:38 PM
Thank you for your fast reply. It seems my pal forgot to put the SMF forum on the same host; he wanted to do a db conversion "on the fly" from one server to another.
Anyway, it is working now. Thank you for your help :)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: adamc72 on January 01, 2010, 05:06:57 PM
Hi,

Happy New Year. I am trying to convert my IPB2.3.6 to SMF1.1.11 and get the following error:
Converting...
Converting topics... Unsuccessful!
This query:
INSERT INTO `db23466_smf`.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 ('1410', '0', '1', '419', '115', '', '6', '290', '17065', '17099', '0'),
('1412', '0', '5', '24', '87', '', '10', '246', '17083', '17449', '0'),
('1413', '0', '3', '374', '1144', '', '7', '348', '17117', '17613', '0'),
('1414', '0', '1', '21', '30', '', '17', '820', '17119', '17255', '0'),
('1415', '0', '1', '125', '512', '', '33', '1113', '17153', '17993', '0'),
('1416', '0', '5', '560', '981', '', '1', '139', '17159', '17296', '0'),
('1417', '0', '1', '560', '86', '', '7', '310', '17173', '17623', '0'),
('1418', '0', '4', '974', '974', '', '5', '757', '17179', '17317', '0'),
('1419', '0', '1', '220', '21', '', '4', '221', '17194', '17201', '0'),
('1420', '1', '7', '262', '390', '', '9', '5182', '17226', '17320', '0'),
('1421', '0', '9', '1', '1', '', '0', '10', '17227', '17227', '0'),
('1422', '0', '4', '262', '359', '', '5', '1492', '17230', '17283', '0'),
('1423', '0', '10', '1074', '289', '', '3', '209', '17231', '17437', '0'),
('1424', '0', '3', '501', '151', '', '24', '846', '17236', '56128', '0'),
('1425', '0', '5', '58', '222', '', '171', '2548', '17261', '19186', '0'),
('1426', '0', '1', '512', '512', '', '14', '645', '17273', '18020', '0'),
('1427', '0', '10', '1055', '1511', '', '34', '1448', '17308', '38867', '0'),
('1428', '0', '10', '359', '359', '', '5', '376', '17326', '17528', '0'),
('1429', '0', '1', '657', '335', '', '20', '750', '17343', '17615', '0'),
('1430', '0', '4', '279', '279', '', '6', '803', '17392', '17454', '0'),
('1431', '0', '1', '98', '512', '', '8', '311', '17403', '17484', '0'),
('1432', '0', '5', '262', '156', '', '1', '228', '17419', '17427', '0'),
('1433', '0', '5', '560', '222', '', '14', '270', '17432', '17630', '0'),
('1434', '0', '5', '250', '250', '', '0', '128', '17455', '17455', '0'),
('1435', '0', '1', '284', '257', '', '12', '608', '17463', '17807', '0'),
('1436', '0', '1', '125', '125', '', '0', '300', '17467', '17467', '0'),
('1437', '0', '10', '1137', '1138', '', '18', '644', '17471', '17972', '0'),
('1438', '0', '10', '803', '1137', '', '4', '333', '17479', '19364', '0'),
('1440', '0', '5', '280', '280', '', '2', '118', '17491', '17494', '0'),
('1441', '0', '5', '30', '981', '', '32', '1311', '17498', '18264', '0'),
('1444', '0', '1', '143', '143', '', '0', '273', '17531', '17531', '0'),
('1445', '0', '3', '170', '512', '', '23', '872', '17556', '35398', '0'),
('1446', '0', '5', '222', '222', '', '2', '198', '17560', '17590', '0'),
('1447', '0', '1', '1143', '512', '', '22', '788', '17585', '17747', '0'),
('1448', '0', '10', '1139', '1139', '', '2', '212', '17596', '17854', '0'),
('1449', '0', '5', '222', '222', '', '2', '125', '17598', '17629', '0'),
('1450', '0', '5', '868', '868', '', '6', '230', '17639', '17961', '0'),
('1451', '0', '5', '222', '222', '', '0', '173', '17643', '17643', '0'),
('1452', '0', '3', '170', '256', '', '2', '387', '17644', '18089', '0'),
('1453', '0', '10', '147', '147', '', '0', '109', '17657', '17657', '0'),
('1454', '0', '10', '147', '1138', '', '2', '170', '17658', '17857', '0'),
('1455', '0', '10', '147', '147', '', '16', '1082', '17659', '22636', '0'),
('1456', '0', '1', '30', '512', '', '21', '619', '17660', '18017', '0'),
('1457', '0', '1', '30', '70', '', '17', '795', '17678', '17885', '0'),
('1458', '0', '5', '156', '156', '', '28', '602', '17680', '18448', '0'),
('1459', '0', '1', '501', '501', '', '7', '524', '17688', '18104', '0'),
('1460', '0', '1', '103', '30', '', '7', '336', '17691', '18522', '0'),
('1461', '0', '1', '1', '1', '', '5', '199', '17714', '17958', '1'),
('1462', '0', '10', '25', '25', '', '2', '250', '17715', '18152', '0'),
('1463', '0', '5', '324', '89', '', '14', '273', '17728', '18509', '0'),
('1464', '0', '5', '222', '222', '', '3', '292', '17786', '17793', '0'),
('1465', '0', '5', '24', '228', '', '3', '211', '17792', '17943', '0'),
('1466', '0', '1', '1148', '197', '', '7', '266', '17815', '17924', '0'),
('1467', '0', '1', '21', '175', '', '2', '229', '17818', '17843', '0'),
('1468', '0', '1', '299', '30', '', '7', '282', '17831', '17862', '0'),
('1469', '0', '5', '143', '222', '', '43', '611', '17860', '19191', '0'),
('1470', '0', '10', '547', '547', '', '0', '128', '17864', '17864', '0'),
('1471', '0', '10', '420', '420', '', '0', '141', '17865', '17865', '0'),
('1472', '0', '1', '38', '262', '', '43', '1710', '17879', '18195', '0'),
('1473', '0', '1', '280', '21', '', '1', '177', '17889', '17891', '0'),
('1474', '0', '4', '121', '430', '', '8', '414', '17894', '23965', '0'),
('1476', '0', '1', '439', '30', '', '10', '301', '17911', '17930', '0'),
('1477', '0', '1', '803', '1157', '', '15', '735', '17916', '19507', '0'),
('1478', '0', '3', '574', '574', '', '6', '833', '17908', '18129', '0'),
('1479', '0', '5', '222', '981', '', '7', '498', '17962', '18308', '0'),
('1480', '0', '1', '831', '222', '', '19', '801', '17975', '18955', '0'),
('1481', '0', '1', '371', '30', '', '6', '547', '17979', '18065', '0'),
('1482', '0', '1', '600', '762', '', '2', '220', '17983', '18005', '0'),
('1483', '0', '1', '412', '412', '', '0', '220', '17996', '17996', '0'),
('1484', '0', '4', '297', '297', '', '2', '435', '17999', '18274', '0'),
('1485', '0', '1', '512', '512', '', '15', '573', '18004', '18140', '0'),
('1486', '0', '1', '306', '126', '', '4', '446', '18007', '18063', '0'),
('1487', '0', '10', '483', '483', '', '5', '484', '18012', '20265', '0'),
('1488', '0', '1', '419', '444', '', '20', '652', '18022', '18653', '0'),
('1489', '0', '1', '371', '371', '', '0', '202', '18025', '18025', '0'),
('1490', '0', '1', '512', '262', '', '5', '252', '18027', '18041', '0'),
('1492', '0', '5', '80', '222', '', '25', '348', '18037', '18906', '0'),
('1493', '0', '5', '250', '981', '', '5', '502', '18050', '18338', '0'),
('1494', '0', '5', '45', '353', '', '3', '156', '18052', '18204', '0'),
('1495', '0', '14', '90', '30', '', '38', '1608', '18061', '25874', '0'),
('1496', '0', '5', '981', '981', '', '8', '196', '18064', '18096', '0'),
('1497', '0', '1', '98', '156', '', '5', '338', '18077', '18166', '0'),
('1499', '0', '5', '981', '222', '', '5', '189', '18106', '18118', '0'),
('1500', '0', '10', '323', '323', '', '3', '277', '18120', '18199', '0'),
('1501', '0', '1', '143', '151', '', '7', '304', '18145', '18391', '0'),
('1502', '0', '10', '1127', '1127', '', '1', '302', '18150', '20330', '0'),
('1503', '0', '1', '755', '981', '', '9', '579', '18156', '18335', '0'),
('1504', '0', '1', '444', '444', '', '0', '122', '18159', '18159', '0'),
('1507', '0', '1', '257', '257', '', '0', '195', '18185', '18185', '0'),
('1508', '0', '1', '1153', '11', '', '3', '310', '18193', '18207', '1'),
('1509', '0', '14', '104', '104', '', '4', '774', '18198', '18227', '0'),
('1510', '0', '1', '22', '175', '', '44', '1501', '18217', '18500', '0'),
('1511', '0', '1', '419', '38', '', '17', '758', '18229', '18576', '0'),
('1512', '0', '1', '412', '812', '', '1', '305', '18235', '18253', '0'),
('1513', '0', '1', '1153', '981', '', '8', '271', '18241', '18330', '0'),
('1514', '0', '5', '229', '229', '', '0', '165', '18245', '18245', '0'),
('1515', '0', '4', '27', '100', '', '5', '336', '18257', '18637', '0'),
('1516', '0', '4', '1153', '359', '', '2', '373', '18263', '18282', '0'),
('1517', '0', '1', '77', '250', '', '2', '300', '18287', '18316', '0'),
('1518', '0', '1', '394', '1074', '', '44', '1329', '18299', '18880', '0'),
('1519', '0', '4', '265', '200', '', '10', '564', '18315', '19583', '0'),
('1520', '0', '5', '256', '256', '', '15', '261', '18339', '18567', '0'),
('1521', '0', '4', '803', '803', '', '5', '491', '18355', '18441', '0'),
('1522', '0', '1', '333', '353', '', '28', '872', '18357', '18708', '0'),
('1523', '0', '1', '419', '0', '', '12', '480', '18394', '18491', '0'),
('1524', '0', '5', '1072', '222', '', '23', '481', '18421', '19272', '0'),
('1528', '0', '10', '549', '483', '', '11', '1701', '18458', '23476', '0'),
('1529', '0', '1', '143', '38', '', '2', '233', '18463', '18469', '0'),
('1531', '0', '1', '38', '197', '', '20', '591', '18467', '18895', '0'),
('1532', '0', '1', '1139', '447', '', '1', '283', '18477', '18479', '0'),
('1533', '0', '14', '1153', '1153', '', '5', '1083', '18492', '19590', '0'),
('1534', '0', '1', '175', '333', '', '14', '357', '18497', '18663', '0'),
('1535', '0', '5', '554', '297', '', '6', '165', '18512', '18999', '0'),
('1536', '0', '1', '598', '918', '', '54', '3796', '18515', '20622', '0'),
('1537', '0', '14', '39', '34', '', '18', '658', '18516', '25595', '0'),
('1538', '0', '14', '512', '512', '', '8', '911', '18521', '18964', '0'),
('1539', '0', '1', '325', '447', '', '4', '425', '18523', '18675', '0'),
('1540', '0', '10', '1161', '1055', '', '4', '334', '18536', '19456', '0'),
('1541', '0', '5', '21', '297', '', '2', '132', '18537', '18997', '0'),
('1542', '0', '4', '560', '115', '', '6', '536', '18583', '18731', '0'),
('1543', '0', '3', '1164', '512', '', '3', '340', '18592', '18786', '0'),
('1544', '0', '1', '560', '361', '', '38', '877', '18597', '18831', '0'),
('1545', '0', '1', '263', '222', '', '1', '365', '18598', '18954', '0'),
('1546', '0', '1', '870', '870', '', '0', '127', '18600', '18600', '0'),
('1547', '0', '12', '870', '870', '', '2', '529', '18606', '21640', '0'),
('1548', '0', '12', '870', '1251', '', '3', '704', '18607', '28741', '0'),
('1549', '0', '5', '560', '222', '29', '28', '465', '18610', '19348', '0'),
('1550', '0', '1', '98', '45', '', '24', '756', '18620', '18917', '0'),
('1551', '0', '5', '870', '870', '', '2', '136', '18621', '21650', '0'),
('1552', '0', '5', '374', '374', '', '0', '225', '18625', '18625', '0'),
('1553', '0', '4', '1121', '68', '', '12', '534', '18641', '18755', '0'),
('1554', '0', '1', '444', '444', '', '0', '127', '18662', '18662', '0'),
('1555', '0', '1', '444', '297', '', '5', '342', '18666', '19005', '0'),
('1556', '0', '1', '367', '115', '', '35', '1462', '18671', '19138', '0'),
('1557', '0', '10', '297', '483', '', '1', '218', '18724', '21592', '0'),
('1559', '0', '4', '0', '200', '', '4', '643', '18756', '19024', '0'),
('1560', '0', '5', '297', '297', '', '3', '229', '18769', '18792', '0'),
('1561', '0', '1', '1167', '1167', '', '16', '690', '18788', '19584', '0'),
('1562', '0', '3', '512', '100', '', '7', '438', '18796', '21735', '0'),
('1563', '0', '14', '121', '1', '', '9', '1417', '18845', '19211', '0'),
('1564', '0', '4', '1138', '447', '', '9', '407', '18857', '19758', '0'),
('1566', '0', '14', '39', '323', '', '2', '605', '18876', '18961', '0'),
('1568', '0', '14', '30', '21', '', '22', '1391', '18908', '20005', '0'),
('1569', '0', '1', '439', '419', '', '5', '321', '18909', '19115', '0'),
('1570', '0', '1', '30', '30', '', '1', '273', '18911', '19035', '0'),
('1571', '0', '5', '222', '222', '', '7', '143', '18916', '19289', '0'),
('1574', '0', '3', '554', '126', '', '15', '632', '18948', '19580', '0'),
('1575', '0', '1', '377', '1010', '', '18', '568', '18974', '19216', '0'),
('1576', '0', '5', '80', '222', '', '28', '451', '18975', '19485', '0'),
('1577', '1', '7', '1173', '1284', '', '30', '7359', '18978', '54419', '0'),
('1578', '0', '1', '64', '1', '', '1', '272', '18991', '19214', '0'),
('1579', '0', '1', '654', '1', '', '2', '135', '19009', '19212', '0'),
('1580', '0', '5', '256', '222', '', '1', '123', '19011', '19275', '0'),
('1581', '0', '1', '1176', '657', '', '36', '1209', '19014', '19853', '0'),
('1582', '0', '1', '560', '299', '30', '9', '759', '19036', '19520', '0'),
('1583', '0', '14', '121', '197', '', '1', '591', '19086', '19193', '0'),
('1584', '0', '10', '1176', '1176', '', '0', '205', '19089', '19089', '0'),
('1586', '0', '14', '918', '39', '', '15', '1328', '19128', '19368', '0'),
('1587', '0', '1', '501', '803', '', '23', '762', '19061', '19263', '0'),
('1588', '0', '1', '498', '1010', '', '16', '800', '19145', '19336', '0'),
('1590', '0', '1', '21', '45', '', '30', '1493', '19156', '19612', '0'),
('1591', '0', '1', '321', '321', '', '3', '343', '19165', '19610', '0'),
('1592', '0', '1', '100', '498', '', '9', '398', '19175', '19508', '0'),
('1593', '0', '1', '222', '222', '', '2', '179', '19210', '19345', '0'),
('1596', '0', '13', '177', '115', '', '1', '809', '19238', '19648', '0'),
('1597', '0', '1', '560', '280', '', '2', '191', '19251', '19254', '0'),
('1598', '0', '5', '280', '280', '', '1', '158', '19258', '19259', '0'),
('1599', '0', '5', '498', '13', '', '29', '716', '19269', '19844', '0'),
('1600', '0', '4', '289', '692', '', '9', '334', '19274', '20409', '0'),
('1601', '0', '5', '30', '222', '', '22', '617', '19277', '21464', '0'),
('1602', '0', '3', '170', '605', '', '4', '594', '19304', '19992', '0'),
('1603', '0', '1', '512', '762', '', '12', '448', '19306', '19402', '0'),
('1604', '0', '4', '359', '38', '', '52', '1809', '19307', '23458', '0'),
('1607', '0', '3', '554', '306', '', '15', '716', '19331', '22412', '0'),
('1608', '0', '4', '641', '472', '', '1', '269', '19333', '19361', '0'),
('1610', '0', '10', '483', '483', '', '3', '240', '19343', '20266', '0'),
('1611', '0', '10', '98', '98', '', '0', '178', '19362', '19362', '0'),
('1612', '0', '14', '21', '145', '', '12', '918', '19369', '20087', '0'),
('1613', '0', '5', '263', '222', '', '29', '665', '19370', '23735', '0'),
('1614', '0', '1', '143', '115', '', '26', '1562', '19371', '19596', '0'),
('1616', '0', '1', '289', '27', '', '7', '336', '19386', '19423', '0'),
('1617', '0', '1', '433', '649', '', '7', '413', '19397', '19582', '0'),
('1618', '0', '1', '359', '11', '', '2', '270', '19425', '19502', '0'),
('1619', '0', '14', '39', '39', '', '4', '784', '19432', '19446', '0'),
('1620', '0', '3', '512', '1234', '', '4', '451', '19433', '21599', '0'),
('1621', '0', '5', '560', '222', '31', '27', '476', '19452', '21465', '0'),
('1622', '0', '5', '222', '868', '', '4', '164', '19468', '19708', '0'),
('1623', '0', '10', '238', '238', '', '4', '451', '19474', '21570', '0'),
('1624', '0', '1', '693', '1153', '', '15', '544', '19483', '19667', '0'),
('1625', '0', '1', '758', '444', '', '19', '879', '19495', '19807', '0'),
('1626', '0', '10', '1187', '444', '', '26', '952', '19505', '28858', '0'),
('1627', '0', '10', '657', '395', '', '1', '394', '19506', '19640', '0'),
('1628', '0', '10', '1193', '1193', '', '10', '439', '19514', '20821', '0'),
('1629', '0', '13', '512', '512', '', '4', '1163', '19522', '22070', '0'),
('1630', '0', '10', '1189', '1137', '', '2', '250', '19529', '21862', '0'),
('1631', '0', '4', '299', '301', '', '16', '1124', '19549', '20875', '0'),
('1632', '0', '1', '693', '693', '', '1', '246', '19557', '19558', '0'),
('1633', '0', '4', '27', '27', '', '0', '157', '19572', '19572', '0'),
('1634', '0', '1', '325', '981', '', '50', '1782', '19577', '20370', '0'),
('1635', '0', '1', '79', '447', '', '3', '447', '19585', '19756', '0'),
('1636', '0', '1', '1153', '98', '', '9', '732', '19591', '19687', '0'),
('1637', '0', '5', '38', '38', '', '0', '130', '19592', '19592', '0'),
('1638', '0', '4', '80', '279', '', '8', '884', '19599', '19921', '0'),
('1639', '0', '5', '228', '228', '', '12', '273', '19603', '21745', '0'),
('1640', '0', '5', '45', '228', '', '12', '432', '19618', '21127', '0'),
('1641', '0', '4', '297', '297', '', '0', '189', '19632', '19632', '0'),
('1642', '0', '1', '419', '37', '', '5', '491', '19656', '19866', '0'),
('1643', '0', '1', '115', '115', '', '4', '422', '19678', '19959', '0'),
('1644', '0', '3', '296', '37', '', '4', '534', '19680', '19926', '0'),
('1645', '0', '4', '1153', '692', '', '10', '431', '19698', '20405', '0'),
('1646', '0', '1', '367', '37', '', '21', '589', '19703', '19863', '0'),
('1647', '0', '3', '603', '603', '', '0', '252', '19711', '19711', '0'),
('1648', '0', '4', '1121', '498', '', '36', '2723', '19725', '25354', '0'),
('1649', '0', '5', '419', '222', '', '10', '307', '19731', '20253', '0'),
('1650', '0', '5', '228', '228', '', '9', '680', '19736', '20392', '0'),
('1651', '0', '1', '444', '762', '', '14', '507', '19762', '20629', '0'),
('1654', '0', '10', '115', '115', '', '2', '398', '19784', '19808', '0'),
('1655', '0', '1', '80', '27', '', '3', '341', '19796', '19815', '0'),
('1656', '0', '10', '468', '394', '', '4', '641', '19800', '20788', '0'),
('1657', '0', '1', '803', '419', '', '7', '313', '19817', '19936', '0'),
('1658', '0', '1', '115', '38', '', '3', '214', '19827', '19898', '0'),
('1659', '0', '1', '151', '575', '', '9', '305', '19828', '19909', '0'),
('1660', '0', '1', '151', '1124', '32', '20', '1002', '19838', '21318', '0'),
('1661', '0', '1', '272', '38', '', '2', '297', '19856', '19897', '0'),
('1663', '0', '5', '289', '1138', '', '2', '403', '19867', '20236', '0'),
('1664', '0', '4', '0', '359', '', '2', '205', '19876', '19893', '0'),
('1665', '0', '10', '420', '420', '', '1', '267', '19878', '20106', '0'),
('1666', '0', '1', '447', '222', '', '17', '936', '19881', '20222', '0'),
('1667', '0', '1', '498', '605', '', '9', '308', '19912', '19989', '0'),
('1668', '0', '1', '512', '359', '', '2', '330', '19916', '19988', '0'),
('1669', '0', '1', '145', '125', '', '7', '474', '19931', '20229', '0'),
('1670', '0', '1', '1153', '1153', '', '11', '372', '19932', '20162', '0'),
('1671', '0', '5', '229', '229', '', '0', '243', '19937', '19937', '0'),
('1672', '0', '5', '918', '918', '', '0', '519', '19950', '19950', '0'),
('1673', '0', '4', '560', '344', '', '14', '266', '19952', '20352', '0'),
('1674', '0', '5', '256', '222', '', '204', '3542', '19963', '23397', '0'),
('1675', '0', '10', '262', '297', '', '4', '256', '19974', '20443', '0'),
('1676', '0', '1', '377', '42', '', '124', '4712', '19975', '21863', '0'),
('1677', '0', '1', '560', '27', '', '1', '310', '19995', '20010', '0'),
('1678', '0', '1', '21', '21', '', '0', '180', '19996', '19996', '0'),
('1679', '0', '10', '1203', '1203', '', '3', '687', '20036', '20793', '0'),
('1680', '0', '3', '1203', '1203', '', '2', '516', '20038', '20115', '0'),
('1681', '0', '1', '512', '115', '', '40', '1425', '20040', '20389', '0'),
('1682', '0', '1', '419', '692', '', '81', '3030', '20053', '20810', '0'),
('1684', '0', '5', '297', '211', '', '21', '362', '20096', '21725', '0'),
('1685', '0', '1', '498', '1010', '', '8', '384', '20101', '20281', '0'),
('1686', '0', '10', '78', '78', '', '5', '315', '20148', '20868', '0'),
('1687', '0', '1', '1208', '444', '', '9', '401', '20169', '20640', '0'),
('1688', '0', '4', '981', '981', '', '9', '388', '20194', '21139', '0'),
('1689', '0', '1', '201', '30', '', '9', '559', '20202', '20760', '0');
Caused the error:
Duplicate entry '1410' for key 1


Any idea on what needs to be done?

Thanks
Title: Re: [SMF Converter] IPB 2.3.x
Post by: pioner on January 16, 2010, 06:20:12 AM
hello! I use the converter in the begin of topic, but have a problem..
I try convert ipb2.3.1 to smf_1-1-11. there is logs:

"Converting...
...
Converting settings...
Notice: unserialize() [function.unserialize]: Error at offset 119 of 216 bytes in E:\WebServers\home\172.**.**.13\www\convert.php(941) : eval()'d code on line 45
...
Successful.
Recalculating forum statistics... Successful.

Conversion Complete"


new forum work normally, but I doubt of correctness of converting
please help, thanks
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on January 17, 2010, 02:55:54 AM
pioner, the settings aren't converted properly and the converter didn't convert all following steps (attachments, avatars)

I'd recommend to remove this block from invision23_to_smf.sql

/******************************************************************************/
--- Converting settings...
/******************************************************************************/

---# Moving settings...
---{
// We will do all updates once we find them all.
$update_settings = array();

$result = convert_query("
SELECT
conf_key AS config_name,
IF(conf_value = '', conf_default, conf_value) AS config_value
FROM {$from_prefix}conf_settings");
while ($row = mysql_fetch_assoc($result))
{
switch ($row['config_name'])
{
case 'board_name':
$inv_forum_name = $row['config_value'];
break;

case 'offline_msg':
$inv_maintenance_message = str_replace("\n", '<br />', $row['config_value']);
break;

case 'hot_topic':
$update_settings['hotTopicPosts'] = $row['config_value'];
break;

case 'display_max_posts':
$update_settings['defaultMaxMessages'] = $row['config_value'];
break;

case 'display_max_topics':
$update_settings['defaultMaxTopics'] = $row['config_value'];
break;

case 'flood_control':
$update_settings['spamWaitTime'] = $row['config_value'];
break;

case 'allow_online_list':
$update_settings['onlineEnable'] = $row['config_value'];
break;

case 'force_login':
break;

default:
break;
}
}
mysql_free_result($result);

$result = convert_query("
SELECT cs_value
FROM {$from_prefix}cache_store
WHERE cs_key = 'stats'");
list ($inv_stats) = mysql_fetch_row($result);
$inv_stats = unserialize($inv_stats);

if (!empty($inv_stats['most_count']) && !empty($inv_stats['most_date']))
{
$update_settings['mostOnline'] = $inv_stats['most_count'];
$update_settings['mostDate'] = $inv_stats['most_date'];
}

// While we coulddo this in one big batch, lets do it one by one.
foreach ($update_settings as $key => $value)
convert_query("
REPLACE INTO {$to_prefix}settings
(variable, value)
VALUES ('" . addslashes($key) . "', '" . addslashes($value) . "')");

updateSettingsFile(array(
'mbname' => '\'' . addcslashes($inv_forum_name, '\'\\') . '\'',
'mmessage' => '\'' . addcslashes($inv_maintenance_message, '\'\\') . '\''
));
---}
---#

this block only converts some basic settings (forum title and such stuff), therefore you can remove it and all important data such as members, posts, topics and the board structure is still converted. after you removed that block from the conveter file you should restart the conversion from the beginning.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: pioner on January 17, 2010, 12:52:19 PM
TE, thanks for help!  it's work.
Last time when i try to convert ipb2.3.1 to smf1.1.11 I have seen errors about converting avatars, as you say :), but forum is working, just copy avatars to the smf directory...  When i try again, and remove that block from invision23_to_smf.sql - but errors has still :( Then I delete avatars at all users, and begin convert again - it's successful done!

Today I tried convert to smf 2.0rc2, and has more errors. Some of them fixed, but one I can't fix, so it was necessary converting to 1.1.11 and upgrade it to 2.0rc2. Thank you for help again! /sorry for my english
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Domi5 on April 19, 2010, 03:51:11 PM
things seem to run nicely but it stops when it get to posts i guess its caused by Arabic characters

does the converter support latin1 character set?

when the converter asked me for a char set it had a short list .. i chose cp1256

any ideas what to do
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Norv on April 19, 2010, 05:11:08 PM
Can you please tell what is the error when it stops or what does it do?

What is the character set in which the original forum database stores posts?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Domi5 on April 19, 2010, 05:24:22 PM
Converting posts (this may take some time)... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_messages
    (ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, subject, posterName, posterIP, smileysEnabled, modifiedTime, modifiedName, ID_BOARD, body, posterEmail, icon)



original board used latin1_swedish_ci so when i created another database for smf i chose to use the same charset .. but i don't know what's wrong


i just posted the beginning of the error .. the rest has IPs within but here's a sample for the post/msg body

&#1583;&#1610;&#1606;&#1575; &#1576;&#1575;&#1576; &#1581;&#1580;&#1585;&#1577; &#1583;&#1575;&#1604;&#1610;&#1575; &#1576;&#1605;&#1585;&#1581; &#1608; &#1575;&#1593;&#1578;&#1610;&#1575;&#1583; &#1602;&#1575;&#1574;&#1604;&#1577;: &#1583;&#1608;&#1604;&#1610;..&#1575;&#1606;&#1575;.. &#1601;&#1608;&#1580;&#1583;&#1578;&#1607;&#1575; &#1578;&#1602;&#1585;&#1571; &#1575;&#1604;&#1602;&#1585;&#1570;&#1606;
these were arabic characters :D
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Norv on April 19, 2010, 05:26:37 PM
Please note that the error message (started as you say above) also should end in something more - more explanation. Can you please paste that one as well?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Domi5 on April 19, 2010, 05:46:13 PM
Caused the error:

    MySQL server has gone away


that's all .. b4 that there were also some
&#1604;&#1605;&#1588;&#1575;&#1585;&#1603;&#1575;&#1578;&#1603; &#1605;&#1593;&#1575;&#1606;&#1575; &#1601;&#1610; &#1575;&#1604;&#1605;&#1608;&#1575;&#1590;&#1610;&#1593; &#1575;&#1604;&#1605;&#1582;&#1578;&#1604;&#1601;&#1577

and mails / IPs of the posters
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Norv on April 19, 2010, 06:07:22 PM
Quote from: Domi5 on April 19, 2010, 05:46:13 PM
Caused the error:

    MySQL server has gone away

Please check out about this error, perhaps it helps:
MySQL has gone away / Lost connection to server during query (http://docs.simplemachines.org/index.php?topic=1501.msg4941#msg4941)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Domi5 on April 20, 2010, 07:54:55 AM
i still can't go around this limitation .. where to change it ? i checked the my.ini nothing there sets any timeout
beside am testing on my pc now using wamp .. but when i try to convert the original board i wont have access to mysql settings
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Norv on April 26, 2010, 09:57:12 AM
Sorry for the delay.
Please, try: (invision23_to_smf.sql)
Code (find) Select

---* {$to_prefix}messages 200

Code (replace) Select

---* {$to_prefix}messages 100

Title: Re: [SMF Converter] IPB 2.3.x
Post by: xblazenx on October 02, 2010, 10:42:39 AM
Im totally confused  :(
I currently have IPB 3.0.1 and i just got a SMF Forum and my users from my previous board would like all their post to be on the new forum we have now which is SMF. I have downloaded the converter file but I started to get lost from that point on. Could anybody help me on how to convert, thanks:)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: savrip on February 01, 2011, 06:19:00 AM
I'm interested in how the convert works exactly.  I'm hesitant to use it on a live board and have been trying to make a duplicate to run the test on.  If it only reads and exports from the IPB then I don't see any reason I couldn't use it on the live board.  I hope with all the hard work done on this converter that it serves my needs.  I've been wanting to get off of IPB for a long time.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on February 01, 2011, 04:42:28 PM
you can use your live board for the conversion, the converter makes a copy from the source system's data  to SMF. the source system (IPB) will remain untouched.
please check out Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Flamekebab on April 08, 2011, 07:37:51 PM
I'm trying to convert IPB 2.3.1 to SMF (either version) using the relevant converters (http://download.simplemachines.org/?converters;software=invision) locally. I've got my Invision board running on my home server and I've got SMF installed (2.0 RC5) at the moment using the same database.

When I try to run the conversion script it gets to
QuoteConverting...
Successful.
Recalculating forum statistics...
It doesn't go any further or provide any buttons and when I check the SMF forum absolutely nothing has happened. When I view the source code of the page it doesn't finish (there's no end to the body tags/html tags, it just stops at "statistics..."). Observe:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>SMF Converter</title>
<script type="text/javascript" src="Themes/default/scripts/script.js"></script>
<link rel="stylesheet" type="text/css" href="http://simplemachines.org/smf/style.css" />
</head>
<body>
<div id="header">
<div title="Bahamut!">SMF Converter</div>
</div>
<div id="content">
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="padding-top: 1ex;">
<tr>
<td width="250" valign="top" style="padding-right: 10px;">
<table border="0" cellpadding="8" cellspacing="0" class="tborder" width="240">
<tr>
<td class="titlebg">Steps</td>
</tr>
<tr>
<td class="windowbg2">
<span class="stepdone">Select Script</span><br />
<span class="stepdone">Welcome</span><br />
<span class="stepcurrent">Main Conversion</span><br />
<span class="stepwaiting">Recount Totals and Statistics</span><br />
<span class="stepwaiting">Done</span><br />
</td>
</tr>
</table>
</td>
<td width="100%" valign="top">
<div class="panel">
<h2>Converting...</h2> Successful.<br />
Recalculating forum statistics...


I don't know if there are any error logs I should be checking (nowhere seems to document where the converter script logs to). What's going on?

I'd like to add that I had the exact same problem with the 1.x branch of SMF.

What can I do to give you the information you'd need to help me?
Has anyone else encountered something similar?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Aeolus on April 12, 2012, 08:10:44 PM
IPB 2.3.6
smf 2.0.2

Use the convert
Invision 2.3 to SMF 2-0 from here (http://download.simplemachines.org/?converters;software=invision)

Get these errors.
QuoteConverting members...Wrong value type sent to the database. Date expected. (birthdate)

Search the topic (http://www.simplemachines.org/community/index.php?topic=238557.0), but no help.
Thanks. :)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Quexinos on April 24, 2012, 03:05:02 AM
Quote from: Aeolus on April 12, 2012, 08:10:44 PM
IPB 2.3.6
smf 2.0.2

Use the convert
Invision 2.3 to SMF 2-0 from here (http://download.simplemachines.org/?converters;software=invision)

Get these errors.
QuoteConverting members...Wrong value type sent to the database. Date expected. (birthdate)

Search the topic (http://www.simplemachines.org/community/index.php?topic=238557.0), but no help.
Thanks. :)

same problem.... anyone?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: fhsds on May 06, 2012, 08:08:44 PM
Quote from: Quexinos on April 24, 2012, 03:05:02 AM
Quote from: Aeolus on April 12, 2012, 08:10:44 PM
IPB 2.3.6
smf 2.0.2

Use the convert
Invision 2.3 to SMF 2-0 from here (http://download.simplemachines.org/?converters;software=invision)

Get these errors.
QuoteConverting members...Wrong value type sent to the database. Date expected. (birthdate)

Search the topic (http://www.simplemachines.org/community/index.php?topic=238557.0), but no help.
Thanks. :)

same problem.... anyone?
Yes, I have the same problem
Title: Re: [SMF Converter] IPB 2.3.x
Post by: fhsds on May 07, 2012, 11:46:06 PM
is anybody here????? heeeeeeeeeeelp!!!!!
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 01, 2012, 12:13:08 PM
I have an even more basic problem.
Basically, having read the conversion document I'm not exactly clear where I need to specify the from and to paths within convert.php and what path structure it is expecting (do I need to specify the location of the installed forum software or the sql database itself?).
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 02, 2012, 01:48:32 AM
You need to specify the installed forum software for both SMF and IPB. Just upload the converter files to the same directory as SMF was installed, and the path for SMF is automatically detected..
a sample screenshot, hope it helps: http://www.smfportal.de/wiki/Converter.jpg
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 02, 2012, 06:00:31 AM
Thanks Thorsten. I had read the instructions that appeared to suggest the paths had to be input somewhere into the convert.php file itself, which is what threw me.

I have now got past that and have the same error as the posters above me ("Wrong value type sent to the database. Date expected. (birthdate)")

Any ideas? Is this a specific problem with the IPB 2.3 conversion tool?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 02, 2012, 01:23:57 PM
in invision23_to_smf.sql find:
Code (find) Select

$row['signature'] = substr(strtr(strtr($row['signature'], '<>', '[]'), array('[br /]' => '<br />')), 0, 65534);


add after
Code (add after) Select

/* fix invalid birthdates */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';


Hope it helps..
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 03, 2012, 09:28:43 AM
Thanks. I think this could bea  long process. :)

I now have this error:
Converting members...Wrong value type sent to the database. Integer expected. (instant_messages)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 03, 2012, 11:01:25 AM
This "new" bug can be fixed, find:

/* fix invalid birthdates */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';

add after:

$row['instant_messages'] = (int) $row['instant_messages'];


The converter seems to be full of bugs  :o Probably it's better to use the SMF 1.1x converter (that one should be free of bugs) and upgrade to SMF 2.0 at a later stage..
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 03, 2012, 01:42:44 PM
Hmm. You may be right, but I have set up a database using SMF 2.0, I suppose I could set one up using SMF 1.1 and upgrade later. Would that be easier? There doesn't seem to be an upgrade from SMF 1.16 to 2.02, the only upgrade I can see is from 2.01 to 2.02.

I have a new error: -
Converting members...Wrong value type sent to the database. Integer expected. (hide_email)

(sorry about this).
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 03, 2012, 02:07:30 PM
Quote from: quercus on September 03, 2012, 01:42:44 PM
Hmm. You may be right, but I have set up a database using SMF 2.0, I suppose I could set one up using SMF 1.1 and upgrade later. Would that be easier? There doesn't seem to be an upgrade from SMF 1.16 to 2.02, the only upgrade I can see is from 2.01 to 2.02.
You could install SMF1.1 with a different table prefix and use the same database.. Upgrading SMF from 1.1 to 2.0.2 is easy, don't worry.. (http://wiki.simplemachines.org/smf/Upgrading)

But we can fix the converter as well, the errors are related to MySQL beeing in strict mode.. Hopefully we've  found the most ..

in invision23_to_smf.sql find
m.hide_email AS hide_email,
replace it wtih
1 AS hide_email,
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 04, 2012, 11:06:31 AM
Thanks again.

Here is the latest error:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_poll)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 04, 2012, 01:47:10 PM
find
---* {$to_prefix}topics 5
replace with
---* {$to_prefix}topics 10
--{
$row['id_poll'] = (int) $row['id_poll'];
--}
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 05, 2012, 11:50:39 AM
Hmm. That string doesn't appear to exist in the convert.php file.
There is an ---* {$to_prefix}topics 250. Is that what you mean?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 05, 2012, 01:27:20 PM
I believe my ipb23_to_sms.sql is different  :o
But yes, that's the related line in your file..
add after
--{
$row['id_poll'] = (int) $row['id_poll'];
--}
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 06, 2012, 05:48:48 PM
Thanks. A new error:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    --{
    $row['id_poll'] = (int) $row['id_poll']
    LIMIT 0, 250;

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 '--{
    $row['id_poll'] = (int) $row['id_poll']
    LIMIT 0, 250' at line 1
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 07, 2012, 01:25:47 AM
ouch, my mistake..
instead of
--{
$row['id_poll'] = (int) $row['id_poll'];
--}

it needs to be
---{
$row['id_poll'] = (int) $row['id_poll'];
---}
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 07, 2012, 01:34:25 PM
Thanks.
It got further this time:


Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Wrong value type sent to the database. Integer expected. (modified_time)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 07, 2012, 01:56:50 PM
mhh, I'm not sure about the undefined index errors.. does it appear while converting posts?

the second one is easy to fix:

find
$row['body'] = preg_replace("~<img .*?bbc_emoticon' alt='(.+?)' />~ie", '\'$1\'', $row['body']);
add after:
$row['modified_time'] = (int) $row['modified_time'];
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 07, 2012, 03:04:46 PM
That line of code isn't found.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 07, 2012, 03:10:26 PM
mhh, ok.. would you please attach your modified version pf ipb23_to_smf.sql? my version of ipb23_to_smf.sql seems different..
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 08, 2012, 05:11:10 AM
Sure, here it is.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 08, 2012, 02:36:59 PM
I've fixed the two bugs, please try the attached version..
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 10, 2012, 01:25:01 PM
Thanks for that. More errors in the conversion I'm afraid.

There were lots of them so I have removed the duplicate entries:

Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options...
Notice: Undefined index: question in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 11

Notice: Undefined index: choice in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17

Warning: Invalid argument supplied for foreach() in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17

Notice: Undefined index: question in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 11

Notice: Undefined index: choice in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17

Warning: Invalid argument supplied for foreach() in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17

Notice: Use of undefined constant id_poll - assumed 'id_poll' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 31
Notice: Undefined index: question in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 11

Notice: Undefined index: choice in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17

Warning: Invalid argument supplied for foreach() in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17
Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events...Error in convert script - line 560!
Error in convert script - line 561!

Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Wrong value type sent to the database. Date expected. (start_date)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 10, 2012, 02:50:35 PM
Ok, I've fixed another two bugs but it's getting more and more complicated, simply because I don't have an IPB 2.3 database in order to test my fixes  :P Hope this version works..
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 10, 2012, 04:22:36 PM
Hmm. Looks like the same sort of errors again.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events...Error in convert script - line 560!
Error in convert script - line 561!

Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1

Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1

Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Wrong value type sent to the database. Date expected. (start_date)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 13, 2012, 02:15:55 PM
Maybe we need to remove some steps from the converter but try this version first...
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 15, 2012, 08:37:51 PM
Thanks Thorsten. New errors:
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events...Error in convert script - line 560!
Error in convert script - line 561!

Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1

Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1

Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Wrong value type sent to the database. Date expected. (start_date)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 16, 2012, 02:00:19 AM
ok, I've removed the calendar events conversion as well as converting permissions and board permissions. (If permissions are very important for you we can always add it back, later)

please try the attached version  :)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 17, 2012, 02:19:57 PM
Getting there I think:
Converting settings...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/hussars/public_html/forums2/Sources/Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: variable
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 17, 2012, 02:26:42 PM
ok, let's try it without settings (just the forum name and some general information, nothing special)...
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 19, 2012, 04:31:15 PM
*Sigh*
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting smileys... Successful.
Converting attachments...
Notice: Use of undefined constant attachmentUploadDir - assumed 'attachmentUploadDir' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 40

Warning: filesize() [function.filesize]: stat failed for attachmentUploadDir/35_e5a8e6067b12d75363b127c213bc3b2a1e11a16c in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 40
Wrong value type sent to the database. Integer expected. (size)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 20, 2012, 02:39:24 PM
next one, another two bugs fixed  ;)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: quercus on September 23, 2012, 11:04:51 AM
Excellent - that seems to have finally (more or less) cracked it.
The bb code seems a bit messed up and there are lots of custom images and groups that need to be sorted out, but the basic forum has been converted.

Now I just need to figure out how the member groups, permissions and codes within SMF work!
By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on September 23, 2012, 12:17:58 PM
Quote from: quercus on September 23, 2012, 11:04:51 AM
By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?
Not my business but there are a couple of mods for embedding videos:
http://custom.simplemachines.org/mods/index.php?action=search;basic_search=youtube
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Nakto on October 19, 2012, 01:02:17 PM
Quote from: Thorsten Eurich on September 23, 2012, 12:17:58 PM
Quote from: quercus on September 23, 2012, 11:04:51 AM
By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?
Not my business but there are a couple of mods for embedding videos:
http://custom.simplemachines.org/mods/index.php?action=search;basic_search=youtube
why when I update 2.3.6 to smf 2.0 users passwords is changed. it is not good
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on October 19, 2012, 01:09:28 PM
Nakto,
SMF and IPB are using different password encrytions but SMF should be able to read the old IPB passwords. At first time login the password will be updated to SMF's encryption.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Nakto on October 19, 2012, 03:42:28 PM
sorry, but i don't understand you.
after convertation I can't login to my forum with my username and password. and nobody of my users too. what should we do?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on October 20, 2012, 02:21:02 AM
Quote from: Nakto on October 19, 2012, 03:42:28 PM
sorry, but i don't understand you.
after convertation I can't login to my forum with my username and password. and nobody of my users too. what should we do?
no clue, maybe the password_salt in IPB has more than 5 characters..

added a modified version of the converter, please try the attached file.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Nakto on October 20, 2012, 09:27:12 AM
Quotemaybe the password_salt in IPB has more than 5 characters..
yes, my pass have more 5 characters.

Quoteadded a modified version of the converter,
without any changes

when i converted forum to smf , converter have a error :
Notice: Undefined variable: oldAvatarDir in /home/user566952/smf/convert.php(1254) : eval()'d code on line 58

Warning: copy(/av-124.jpg) [function.copy]: failed to open stream: No such file or directory in /home/user566952/smf/convert.php(1254) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Nakto on October 20, 2012, 09:39:42 AM
maybe that can help you : in the table ibf_members_converge i I don't have field password_salt , there is only  а converge_id , converge_email , converge_joined , converge_pass_hash , converge_pass_salt
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on October 21, 2012, 03:06:52 AM
Quote from: Nakto on October 20, 2012, 09:27:12 AM
without any changes
You'd better checked my file:

ALTER TABLE {$to_prefix}members
CHANGE COLUMN passwd passwd varchar(64) NOT NULL default '',
CHANGE COLUMN password_salt password_salt varchar(64) NOT NULL default '';


Quote from: Nakto on October 20, 2012, 09:39:42 AM
maybe that can help you : in the table ibf_members_converge i I don't have field password_salt , there is only  а converge_id , converge_email , converge_joined , converge_pass_hash , converge_pass_salt
password_salt is a field in SMF (table smf_members)

Which charset / language is your forum?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Nakto on October 21, 2012, 04:44:09 AM
Quote from: Thorsten Eurich on October 21, 2012, 03:06:52 AM
Which charset / language is your forum?
IPB and SMF in win-1251 / english
Title: Re: [SMF Converter] IPB 2.3.x
Post by: ThorstenE on October 21, 2012, 01:52:15 PM
Quote from: Nakto on October 21, 2012, 04:44:09 AM
win-1251 / english
That's most likely the reason.

I'm sorry, but you'll have to use the "forgotten password" link.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: Frank496 on October 22, 2012, 12:02:18 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?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: R1cho on December 06, 2012, 04:45:11 PM
hi , where can i download the convert.php file? i tried clicking the link on your first post and i just keep going in circles clicking on links  :o
Title: Re: [SMF Converter] IPB 2.3.x
Post by: 0djvu0 on April 01, 2014, 01:32:52 AM
Hi,
i get this error: Unknown system variable 'SQL_MAX_JOIN_SIZE'
What to do? IPB 2.3.6 use XAMPP
Title: Re: [SMF Converter] IPB 2.3.x
Post by: margarett on April 01, 2014, 07:52:13 AM
Are you using this converter?
http://download.simplemachines.org/index.php?thanks;filename=smf_2-0_invision23_converter.zip

In convert.php you should find:

// Attempt to allow big selects, only for mysql so far though.
if ($smcFunc['db_title'] == 'MySQL')
{
$results = $smcFunc['db_query']('', "SELECT @@SQL_BIG_SELECTS, @@SQL_MAX_JOIN_SIZE", 'security_override');
list($big_selects, $sql_max_join) = $smcFunc['db_fetch_row']($results);

// Only waste a query if its worth it.
if (empty($big_selects) || ($big_selects != 1 && $big_selects != '1'))
$smcFunc['db_query']('', "SET @@SQL_BIG_SELECTS = 1", 'security_override');

// Lets set MAX_JOIN_SIZE to something we should
if (empty($sql_max_join) || ($sql_max_join == '18446744073709551615' && $sql_max_join == '18446744073709551615'))
$smcFunc['db_query']('', "SET @@SQL_MAX_JOIN_SIZE = 18446744073709551615", 'security_override');
}

Remove it.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: martinmike2 on September 18, 2014, 05:26:21 PM
Followed the advice posted earlier in this thread and still getting errors.  Converting IP.Board 2.3.5 to SMF 2.0 using the converter available on the site.

the error is:

Converting calendar events...Error in convert script - line 550!
Error in convert script - line 551!
Wrong value type sent to the database. Date expected. (start_date)
Title: Re: [SMF Converter] IPB 2.3.x
Post by: margarett on September 18, 2014, 07:00:48 PM
I have no way to debug that right now... The easiest way (for now...) is not to convert said calendar events. Are you actively using calendar events in IPB?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: martinmike2 on September 18, 2014, 10:00:09 PM
unfortunately we are, ill skip them for now and figure out some way to get them over.  Thanks though
Title: Re: [SMF Converter] IPB 2.3.x
Post by: margarett on September 19, 2014, 06:54:30 AM
If you really need it, let's try to fix it instead of skipping it. It will be that much complicated to do after you are already running SMF.

If you want to help me helping you :P I need to see the converter in place. Is it OK to you to send me your cPanel login details? That way I can see what's wrong in the converter (or incompatible with your setup), fix it for you and improve the converter in the process :)
BTW: which converter are you using? The one from the first post in this topic?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: martinmike2 on September 19, 2014, 12:54:09 PM
unfortunately im not at liberty to give you cpanel access.  Its not my server.

I am using the converter from http://download.simplemachines.org/?converters  Invision 2.3 to SMF 2.0
Title: Re: [SMF Converter] IPB 2.3.x
Post by: margarett on September 19, 2014, 01:08:36 PM
I understand that. Can you maybe export your database, zip and password-protect it and upload it somewhere so that I can try it locally?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: martinmike2 on September 26, 2014, 02:05:12 PM
Its ok, I got past it, we can re-create the calendar events wthout too much hassle.  Having another problem though.  The conversion completed successfully, however none of the topics have text in them, just the topic title.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: margarett on September 26, 2014, 07:46:10 PM
Can you check in phpmyadmin, table smf_meessages, and check if the content is really there or not?
Title: Re: [SMF Converter] IPB 2.3.x
Post by: kode54 on December 22, 2015, 10:32:26 PM
I am attempting to use this converter with an IP Board version 2.3.6 forum, and while I was able to get it working after applying several integer cast edits (to catch fields which had NULL values), now I'm stumped.

The entire contents of the smf_messages table has empty body fields, and I can verify that the original ibf_posts table contains valid post bodies, although possibly with some control characters in them? When I select them using the mysql command line tool, they emit control codes that affect the terminal.

I already have a convenient compressed and encrypted copy of the database, which I can share via PM, but beware, it's over 200MB compressed using xz -9, or 1.2GB uncompressed.

E: Disregard the duplicate primary keys error I encountered, it was due to resuming a step in the middle of operating on a given table, I just needed to delete everything converted including and following the specified record to resume, after making further edits to the script.

Somehow the script in this topic expects camelCase field IDs, while the 2.0.11 I have expects underscore separated field names.

E2: Now I am getting this error partway through the conversion if I enable debugging support, which would seem to indicate that the PHP session is expiring. I have no idea why it would do that, since I have set the expiration time to 24 hours for the duration of my conversion process.

Notice: Undefined index: convert_script in /var/www/xx/convert.php on line 66
Notice: Function set_magic_quotes_runtime() is deprecated in /var/www/xx/convert.php on line 70

E3: I fixed the session problem by manually transplanting the session variables from the previous session into the "new" one that was spontaneously created when I added the debug variable to the get parameters.

Now it's on to posts, and actually appears to be converting post bodies this time around.

E4: Yes, that duplicate index error. Perhaps it is a VERY BAD IDEA to try to cram multiple conversions into a single step of the convert page? Or at least advance a page load so you're always starting a new step on each page load? That way, a refresh doesn't result in errors like that, where the target data already exists, but the step thinks it needs to finish the job again.
Title: Re: [SMF Converter] IPB 2.3.x
Post by: kode54 on December 22, 2015, 11:58:54 PM
Never mind, it seems I can't just DELETE ranges willy nilly, as the table items are OUT OF ORDER. Goody.

So, the correct action is to add an $ignore = true; line temporarily to a given step of the sql/php script, and/or start over from substep 0 when making changes to the script.