[SMF Converter] IPB 2.1.x

[techbot]

hmm here's what I'm getting. seems to be a problem converting the polls

Converting poll options...
Notice: Array to string conversion in /mounted-storage/home20a/sub001/sc20038-PLDS/www/forums/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /mounted-storage/home20a/sub001/sc20038-PLDS/www/forums/convert.php(827) : eval()'d code on line 8
Unsuccessful!
This query:
INSERT INTO `trampledelight1`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, SUBSTRING('What kinds of trample would you like to see more of?', 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')' at line 3

I found and deleted each of the polls from the old forums...now I'm getting the same thing as Dark...

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 yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Notice: unserialize() [function.unserialize]: Error at offset 5 of 178 bytes in /mounted-storage/home20a/sub001/sc20038-PLDS/www/forums/convert.php(665) : eval()'d code on line 89

Fatal error: Unsupported operand types in /mounted-storage/home20a/sub001/sc20038-PLDS/www/forums/convert.php(665) : eval()'d code on line 89

[JayBachatero]

What version of IPB are you using?

[techbot]

IPB 2.1.4

[rjscott]

Ok here.

Okay that fixed the size issue. Now the only thing left is the span issue. The odd thing is that the code doesn't look correct in IPB but it works. Some, but not all of the < and ' are represented by their ascii? codes.

One other thing- our IPB forum is using iso-8859-1. I did not select the utf-8 option when I installed SMF but I can't seem to find a place in the admin panel for seeing which is being used. In any case, I'm wondering if that has anything to do with conversion issues at all.

[JayBachatero]

IPB 2.1.4

I think you might be using the wrong converter.  Are you using the converter form this topic?

rjscott try this one.

[rjscott]

I think you might be using the wrong converter.  Are you using the converter form this topic?

rjscott try this one.

If you mean which convert.php I'm using- I am using the one that you have a link to in your first post in this thread.  

[rjscott]

I think you might be using the wrong converter.  Are you using the converter form this topic?

rjscott try this one.

Ooohhh this one broke all kinds of tag things.  Here's what the converted stuff looks like now.

Code Select Expand

[span style=\'font-family:Arial\']<br />David W. Stollberg, Ph.D., P.E.<br />CorpsVets Executive Director \'04-<br />CorpsVets Contra \'98-04, \'06<br />CorpsVets Euphonium \'05<br />CorpsVets Bugle repairman \'05-<br />USNA D&B Instructor \'93-95<br />Geneseo Knights Contra \'82-85<br /><br />[/span]<br />[size=18pt][b][color=#FF0000]Fund-raise[/color], Fund-raise, [color=#FF0000]Fund-raise[/color], Fund-raise,[color=#FF0000]Fund-raise[/color], Fund-raise, [color=#FF0000]Fund-raise[/color], Fund-raise, [color=#FF0000]Fund-raise[/color], Fund-raise, [color=#FF0000]Fund-raise[/color], Fund-raise, [color=#FF0000]Fund-raise[/color], Fund-raise<br />[color=#009900]Recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit[/color][/b][/size]

[JayBachatero]

Sorry that wasn't meant for you.  It was meant for techbot.

Damn it.  Got an example? The sigs with the special chars might have to stay like that .

[rjscott]

Sorry that wasn't meant for you.  It was meant for techbot.

Damn it.  Got an example? The sigs with the special chars might have to stay like that .

Oh, no problem. I'll run the last one again. :-)

[JayBachatero]

I think it might be a rare case with IPB and having sigs like that so it's not really worth going through all this trouble for a few sigs .

[rjscott]

I think it might be a rare case with IPB and having sigs like that so it's not really worth going through all this trouble for a few sigs .

I agree. I ran the other sql file again and it put things back to where we were with the size tags being fixed. Thanks for all of your help. I really appreciate it. If you have any tips on getting the avatars to show up, or can point me to a thread, I would appreciate it.
Thanks!

[techbot]

I think you might be using the wrong converter.  Are you using the converter form this topic?

Edit...

I'm using the one from the converter page http://www.simplemachines.org/download/?converters that says "Invision 2"

Also...I didn't think to mention this...I'm trying to use SMF 1.1.1 instead of 1.1.2

[JayBachatero]

I think it might be a rare case with IPB and having sigs like that so it's not really worth going through all this trouble for a few sigs .

I agree. I ran the other sql file again and it put things back to where we were with the size tags being fixed. Thanks for all of your help. I really appreciate it. If you have any tips on getting the avatars to show up, or can point me to a thread, I would appreciate it.
Thanks!

Is it the uploaded avatars?

I think you might be using the wrong converter.  Are you using the converter form this topic?

Edit...

I'm using the one from the converter page http://www.simplemachines.org/download/?converters that says "Invision 2"

Also...I didn't think to mention this...I'm trying to use SMF 1.1.1 instead of 1.1.2

Use the one on this topic.

[techbot]

That's whats confusing me....in the first post I see an sql file and a link that says "convert.php" ... but that link takes me to another thread with converters.  When I look through those, it has IPB 1.3.x and 2.2...nothing for 2.1.x

[JayBachatero]

You need the .sql in this topic and the convert.php form the other topic.

[techbot]

OK...now I'm really lost. I've just used the convert.php, i haven't used the sql file.  Sorry, I'm used to postnuke and the likes where the sql that they include isn't NEEDED, but you can use it if you like.

Please give me the short dirty version here...I get the sql file from here.  I use the convert.php from the other topic?? The IPB 2.2 one?  

[JayBachatero]

Ok lets start all over.  When you are converting you need two files.  A .sql and convert.php.  convert.php reads the .sql file and does the conversion.  So what you need to do is download http://www.simplemachines.org/community/index.php?action=dlattach;topic=149652.0;attach=27740 and http://www.simplemachines.org/community/index.php?action=dlattach;topic=140741.0;attach=25726.  Upload both of them to the SMF dir.  Then point your browser to convert.php and follow the steps.

[[Dark.Shadow]]

Ok, you are my hero! That one actually worked! Thank you

[rjscott]

Ok, you are my hero! That one actually worked! Thank you

Yeah, JayBachatero rocks! Great job.

[JayBachatero]

Ok updated the first post with the working version.