Advertisement:

Author Topic: [SMF Converter] IPB 2.1.x  (Read 229443 times)

Offline techbot

  • Jr. Member
  • **
  • Posts: 125
  • Gender: Male
    • Hometown-Directories.com
Re: [SMF Converter] IPB 2.1.x
« Reply #40 on: February 21, 2007, 08:36:09 PM »
hmm here's what I'm getting. seems to be a problem converting the polls

Quote
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...
Quote
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
« Last Edit: February 21, 2007, 08:38:49 PM by techbot »
Any help is appreciated. Scornful comments will be met with a blank stare

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.1.x
« Reply #41 on: February 21, 2007, 08:37:42 PM »
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

Offline techbot

  • Jr. Member
  • **
  • Posts: 125
  • Gender: Male
    • Hometown-Directories.com
Re: [SMF Converter] IPB 2.1.x
« Reply #42 on: February 21, 2007, 08:39:06 PM »
IPB 2.1.4
Any help is appreciated. Scornful comments will be met with a blank stare

Offline rjscott

  • Jr. Member
  • **
  • Posts: 134
  • Gender: Male
    • Atlanta CorpsVets Drum and Bugle Corps
Re: [SMF Converter] IPB 2.1.x
« Reply #43 on: February 21, 2007, 08:41:12 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.
« Last Edit: February 21, 2007, 08:45:24 PM by rjscott »
RJ Scott

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.1.x
« Reply #44 on: February 21, 2007, 08:48:56 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.
« Last Edit: February 21, 2007, 09:19:00 PM by JayBachatero »
Follow me on Twitter

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

Offline rjscott

  • Jr. Member
  • **
  • Posts: 134
  • Gender: Male
    • Atlanta CorpsVets Drum and Bugle Corps
Re: [SMF Converter] IPB 2.1.x
« Reply #45 on: February 21, 2007, 09:09:54 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

Offline rjscott

  • Jr. Member
  • **
  • Posts: 134
  • Gender: Male
    • Atlanta CorpsVets Drum and Bugle Corps
Re: [SMF Converter] IPB 2.1.x
« Reply #46 on: February 21, 2007, 09:18:44 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.
Code: [Select]
[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]
« Last Edit: February 21, 2007, 09:20:38 PM by rjscott »
RJ Scott

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.1.x
« Reply #47 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 :(.
Follow me on Twitter

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

Offline rjscott

  • Jr. Member
  • **
  • Posts: 134
  • Gender: Male
    • Atlanta CorpsVets Drum and Bugle Corps
Re: [SMF Converter] IPB 2.1.x
« Reply #48 on: February 21, 2007, 09:21:18 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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.1.x
« Reply #49 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 :(.
Follow me on Twitter

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

Offline rjscott

  • Jr. Member
  • **
  • Posts: 134
  • Gender: Male
    • Atlanta CorpsVets Drum and Bugle Corps
Re: [SMF Converter] IPB 2.1.x
« Reply #50 on: February 21, 2007, 09:28:06 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

Offline techbot

  • Jr. Member
  • **
  • Posts: 125
  • Gender: Male
    • Hometown-Directories.com
Re: [SMF Converter] IPB 2.1.x
« Reply #51 on: February 21, 2007, 09:39:37 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
« Last Edit: February 21, 2007, 10:06:17 PM by techbot »
Any help is appreciated. Scornful comments will be met with a blank stare

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.1.x
« Reply #52 on: February 21, 2007, 10:13:05 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?


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

Offline techbot

  • Jr. Member
  • **
  • Posts: 125
  • Gender: Male
    • Hometown-Directories.com
Re: [SMF Converter] IPB 2.1.x
« Reply #53 on: February 21, 2007, 10:18:27 PM »
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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.1.x
« Reply #54 on: February 21, 2007, 10:19:28 PM »
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

Offline techbot

  • Jr. Member
  • **
  • Posts: 125
  • Gender: Male
    • Hometown-Directories.com
Re: [SMF Converter] IPB 2.1.x
« Reply #55 on: February 21, 2007, 10:23:15 PM »
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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.1.x
« Reply #56 on: February 21, 2007, 10:27:16 PM »
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

Offline [Dark.Shadow]

  • Jr. Member
  • **
  • Posts: 289
  • Gender: Male
  • SMF Support Specialist *still* Wannabe T-T
    • DarkShadowMX
Re: [SMF Converter] IPB 2.1.x
« Reply #57 on: February 21, 2007, 10:52:22 PM »
Ok, you are my hero! That one actually worked! :D Thank you :)

Offline rjscott

  • Jr. Member
  • **
  • Posts: 134
  • Gender: Male
    • Atlanta CorpsVets Drum and Bugle Corps
Re: [SMF Converter] IPB 2.1.x
« Reply #58 on: February 22, 2007, 05:15:16 AM »
Ok, you are my hero! That one actually worked! :D Thank you :)
Yeah, JayBachatero rocks! Great job.
RJ Scott

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.1.x
« Reply #59 on: February 22, 2007, 12:07:03 PM »
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