[SMF Converter] IPB 2.1.x

Started by JayBachatero, February 10, 2007, 02:03:49 PM

Previous topic - Next topic

techbot

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

QuoteConverting 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...
QuoteConverting 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
Any help is appreciated. Scornful comments will be met with a blank stare

JayBachatero

What version of IPB are you using?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

techbot

Any help is appreciated. Scornful comments will be met with a blank stare

rjscott

#43
Quote from: JayBachatero on February 21, 2007, 08:18:34 PM
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.
RJ Scott

JayBachatero

#44
Quote from: techbot on February 21, 2007, 08:39:06 PM
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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

rjscott

Quote from: JayBachatero on February 21, 2007, 08:48:56 PM
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.  
RJ Scott

rjscott

#46
Quote from: JayBachatero on February 21, 2007, 08:48:56 PM
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.
[span style=\'font-family:Arial\']&lt;br /&gt;David W. Stollberg, Ph.D., P.E.&lt;br /&gt;CorpsVets Executive Director \'04-&lt;br /&gt;CorpsVets Contra \'98-04, \'06&lt;br /&gt;CorpsVets Euphonium \'05&lt;br /&gt;CorpsVets Bugle repairman \'05-&lt;br /&gt;USNA D&amp;B Instructor \'93-95&lt;br /&gt;Geneseo Knights Contra \'82-85&lt;br /&gt;&lt;br /&gt;[/span]&lt;br /&gt;[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&lt;br /&gt;[color=#009900]Recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit[/color][/b][/size]
RJ Scott

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 :(.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

rjscott

Quote from: JayBachatero on February 21, 2007, 09:19:42 PM
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. :-)
RJ Scott

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 :(.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

rjscott

Quote from: JayBachatero on February 21, 2007, 09:23:52 PM
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!
RJ Scott

techbot

#51
Quote from: JayBachatero on February 21, 2007, 08:48:56 PM

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
Any help is appreciated. Scornful comments will be met with a blank stare

JayBachatero

Quote from: rjscott on February 21, 2007, 09:28:06 PM
Quote from: JayBachatero on February 21, 2007, 09:23:52 PM
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?

Quote from: techbot on February 21, 2007, 09:39:37 PM
Quote from: JayBachatero on February 21, 2007, 08:48:56 PM

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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

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
Any help is appreciated. Scornful comments will be met with a blank stare

JayBachatero

You need the .sql in this topic and the convert.php form the other topic.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

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?  
Any help is appreciated. Scornful comments will be met with a blank stare

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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

[Dark.Shadow]

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

rjscott

Quote from: Dark Shadow MX on February 21, 2007, 10:52:22 PM
Ok, you are my hero! That one actually worked! :D Thank you :)
Yeah, JayBachatero rocks! Great job.
RJ Scott

JayBachatero

Ok updated the first post with the working version.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: