Ikonboard 3.x Converter

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Johnny T
Registered User
Posts: 32
Joined: Thu Sep 23, 2004 7:49 pm

Re: Ikonboard 3.x Converter

Post by Johnny T » Thu May 31, 2007 8:53 am

Hi,

I followed the instructions to convert my forum and it seemed to worked brilliantly. The only problem I have now is where there were posts that were "quoted" in the replies. Go here for an example http://www.biscuitsbrown.com/forum/phpB ... &start=240

If a post on my original board contained a quote from another post it seems to 'break' out of the table and mess up the html formatting. You can see (on the link I posted) that further down another quoted post changes the fonts etc.

I can't see any setting in the vbs script relating to this. Does anyone know where I'm going wrong?

Many thanks for any help you can give me

Cheers

JT :D

PS. Apart from this glitch the script is superb! Well done that man!

vHiker
Registered User
Posts: 333
Joined: Thu Feb 14, 2002 9:59 pm

Re: Ikonboard 3.x Converter

Post by vHiker » Thu May 31, 2007 9:57 pm

Looks like none of the quotes were being translated due to ikonboard recently? changing their quote format. Download the latest version of the converter and see if this fixes it. You shouldn't see any ikonboard html in your posts. If you do, it means something isn't being converted properly.

Johnny T
Registered User
Posts: 32
Joined: Thu Sep 23, 2004 7:49 pm

Re: Ikonboard 3.x Converter

Post by Johnny T » Fri Jun 01, 2007 11:24 am

Hi,

Thanks for the reply. I think I used the latest version of the converter but will re-download and try again as you suggest.

Thanks again for the help

JT ;)

vHiker
Registered User
Posts: 333
Joined: Thu Feb 14, 2002 9:59 pm

Re: Ikonboard 3.x Converter

Post by vHiker » Mon Jun 04, 2007 5:59 am

I had updated the converter based on the html that wasn't converting for you. Let me know if the fix works. I don't have a ikonboard to test any more.

Johnny T
Registered User
Posts: 32
Joined: Thu Sep 23, 2004 7:49 pm

Re: Ikonboard 3.x Converter

Post by Johnny T » Mon Jun 04, 2007 10:13 am

vHiker

I'm planning on converting my board over in the next two weeks (just need to do it at a weekend when I'm off work and also to pluck up the courage to take the plunge..)

Will post back and let you know whether its worked..

Thanks

JT ;)

jonmarkgo
Registered User
Posts: 1
Joined: Sat Jun 09, 2007 7:49 pm

Re: Ikonboard 3.x Converter

Post by jonmarkgo » Sat Jun 09, 2007 7:52 pm

I downloaded the script and ran it on my Ib 3.1.5 backup. It runs fine for a while, creates import.php, phpbb_forums, phpbb_posts,phpbb_posts_text, phpbb_topics,and warnings, but then it gives me this error (no idea what file its working on when it crashes):
converterror.gif
converterror.gif (5.65 KiB) Viewed 2869 times

Johnny T
Registered User
Posts: 32
Joined: Thu Sep 23, 2004 7:49 pm

Re: Ikonboard 3.x Converter

Post by Johnny T » Tue Jun 12, 2007 8:47 am

Yep, mine is giving exactly the same error now with the new 8.22 version. The 8.21 version converted fine (i.e. without crashing).

The problem seems to be around here...

Code: Select all

Ver. 8.21
'convert quote tag
    Do
        BeginSpan = InStr(1, Text, "<!--QuoteBegin--", vbBinaryCompare) 'don't add the trailing > because some old versions insert text between the -- and trailing >
        If BeginSpan = 0 Then Exit Do
        EndSpan = InStr(BeginSpan, Text, "<!--QuoteEBegin-->", vbBinaryCompare) + 18
        BeginText = InStr(BeginSpan, Text & "</b> ", "</b> ", vbBinaryCompare) + 5
        If BeginText > EndSpan Then
            Value = InStrRev(Text, "Quote from ", BeginSpan, vbBinaryCompare) 'old IB style quote
            If Value = 0 Then Value = "" Else BeginText = Value + 11: EndText = BeginSpan: BeginSpan = Value: Value = "=" & Chr(34) & Chop(Mid(Text, BeginText, EndText - BeginText), ", posted on") & Chr(34)
            If EndSpan < BeginSpan Then Exit Do
        Else



            EndText = InStr(BeginText, Text, "</td>", vbBinaryCompare)
            If BeginText = EndText Then Value = "" Else Value = "=" & Chr(34) & Chop(Mid(Text, BeginText + 1, EndText - BeginText - 2), " @") & Chr(34)


        End If
        Text = Left(Text, BeginSpan - 1) & "[quote:" & bbcode_uid & Value & "]" & LTrim(Mid(Text, EndSpan))
    Loop

Code: Select all

Ver. 8.22
'convert quote tag
    Do
'        BeginSpan = InStr(1, Text, "<!--QuoteBegin--", vbBinaryCompare) 'don't add the trailing > because some old versions insert text between the -- and trailing >
        BeginSpan = InStr(1, Text, "<!--QuoteBegin", vbBinaryCompare) 'don't add the trailing -- or > for compatibility with ikonboard 3.1.5 quote
        If BeginSpan = 0 Then Exit Do
        EndSpan = InStr(BeginSpan, Text, "<!--QuoteEBegin-->", vbBinaryCompare) + 18
        BeginText = InStr(BeginSpan, Text & "</b> ", "</b> ", vbBinaryCompare) + 5
        If BeginText > EndSpan Then BeginText = InStr(BeginSpan, Text & "<div><br />(", "<div><br />(", vbBinaryCompare) + 12 - 1 'check for ikonboard 3.1.5 quote
        If BeginText > EndSpan Then
            Value = InStrRev(Text, "Quote from ", BeginSpan, vbBinaryCompare) 'old IB style quote
            If Value = 0 Then Value = "" Else BeginText = Value + 11: EndText = BeginSpan: BeginSpan = Value: Value = "=" & Chr(34) & Chop(Mid(Text, BeginText, EndText - BeginText), ", posted on") & Chr(34)
            If EndSpan < BeginSpan Then Exit Do
        Else


            EndText = InStr(BeginText, Text, "</td>", vbBinaryCompare)
            If BeginText = EndText Or EndText > EndSpan Then EndText = InStr(BeginText, Text, "</div>", vbBinaryCompare) 'ikonboard 3.1.5 quote
            If BeginText = EndText Or EndText > EndSpan Then Value = "" Else Value = "=" & Chr(34) & Chop(Mid(Text, BeginText + 1, EndText - BeginText - 2), " @") & Chr(34)



        End If
        Text = Left(Text, BeginSpan - 1) & "[quote:" & bbcode_uid & Value & "]" & LTrim(Mid(Text, EndSpan))
    Loop
Specifically the difference between these two bits of code...
OLD VERSION
EndText = InStr(BeginText, Text, "</td>", vbBinaryCompare)
If BeginText = EndText Then Value = "" Else Value = "=" & Chr(34) & Chop(Mid(Text, BeginText + 1, EndText - BeginText - 2), " @") & Chr(34)





NEW VERSION
EndText = InStr(BeginText, Text, "</td>", vbBinaryCompare)
If BeginText = EndText Or EndText > EndSpan Then EndText = InStr(BeginText, Text, "</div>", vbBinaryCompare) 'ikonboard 3.1.5 quote
If BeginText = EndText Or EndText > EndSpan Then Value = "" Else Value = "=" & Chr(34) & Chop(Mid(Text, BeginText + 1, EndText - BeginText - 2), " @") & Chr(34)




I don't have any real VB script experience but hopefully someone will be able to spot the error. I'm sure its just a ' in the wrong place or something...

Anyone any ideas?

Cheers

JT :D

vHiker
Registered User
Posts: 333
Joined: Thu Feb 14, 2002 9:59 pm

Re: Ikonboard 3.x Converter

Post by vHiker » Wed Jun 13, 2007 7:03 am

Sorry about that. I don't have a test board any more. I think I've fixed the bug - give the latest version of the converter a try. If that doesn't work feel free to pm me a link to your ikonboard tar backup - it will give me a test board to download.

Johnny T
Registered User
Posts: 32
Joined: Thu Sep 23, 2004 7:49 pm

Re: Ikonboard 3.x Converter

Post by Johnny T » Wed Jun 13, 2007 10:58 pm

vHiker

I'm still getting the same error.

Feel free to have a play with my backup which you can find here **Link removed**
Let me know when you've downloaded it so I can remove it to stop it draining my bandwidth if other folk start downloading it.

Cheers

John :D
Last edited by Johnny T on Thu Jun 14, 2007 11:20 pm, edited 1 time in total.

vHiker
Registered User
Posts: 333
Joined: Thu Feb 14, 2002 9:59 pm

Re: Ikonboard 3.x Converter

Post by vHiker » Thu Jun 14, 2007 7:42 pm

Got it, please remove the link.

Johnny T
Registered User
Posts: 32
Joined: Thu Sep 23, 2004 7:49 pm

Re: Ikonboard 3.x Converter

Post by Johnny T » Thu Jun 14, 2007 11:22 pm

vHiker

Thanks for that. Good luck with sorting it out. I'm sure you'll get it fixed.. if you've got the ability to write such a brilliant script in the first place I've got every faith in you that you'll get the little bugs ironed.

Thanks again for your efforts

Cheers

JT

vHiker
Registered User
Posts: 333
Joined: Thu Feb 14, 2002 9:59 pm

Re: Ikonboard 3.x Converter

Post by vHiker » Fri Jun 15, 2007 6:45 am

Ok, should be fixed in the latest version. Also, I noticed a lot of the html in your ikonboard is screwed up that is leaving some residual html in the conversion. Before running import.php you may want to fix this by editing phpbb_posts_text.wri and...

removing any: <!--emo&
removing the <img src=\" and trailing "...> around any [img.../img...]

Johnny T
Registered User
Posts: 32
Joined: Thu Sep 23, 2004 7:49 pm

Re: Ikonboard 3.x Converter

Post by Johnny T » Fri Jun 15, 2007 12:42 pm

vHiker

Thanks very much for your troubles. Much appreciated. I'll take your advice and try and edit out the corrupted html.

I'll have a go with the converter, see what happens and report back.

Many thanks

JT

Johnny T
Registered User
Posts: 32
Joined: Thu Sep 23, 2004 7:49 pm

Re: Ikonboard 3.x Converter

Post by Johnny T » Fri Jun 15, 2007 5:56 pm

vHiker

Right, I've just finished successfully converting my site and everything has worked brilliantly.

I'd just like to thank you for a fantastic script and all your help in ironing out all the bugs.

It would have been a nightmare to have to lose all my forums and start again from scratch, in fact, it probably would have killed my site. Thanks to your efforts that's not a problem now so... a big thanks.

All the best mate

John

noctua
Registered User
Posts: 1
Joined: Thu Sep 06, 2007 7:05 pm

Re: Ikonboard 3.x Converter

Post by noctua » Fri Sep 14, 2007 4:10 pm

I converted an Ikonboard 3.1.3 to phpBB2. It seemed to work fairly well until I got to the rebuild_search_tables.php part. When I ran this script, I got the following error over and over again until it cycled through all of the posts:

Code: Select all

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\phpbb2\db\mysql4.php on line 318
I searched for info about this in this topic but nothing came up. Then I searched the board in general and found a tip in this post:

Subject: [RC2] Anti Bot Question
aunrea wrote:I had this problem:

Code: Select all

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in \db\mysql4.php on line 302

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in \db\mysql4.php on line 302
so I read this entire thread (a complete waste of my time) and found no solution. So I found the solution myself. When you installed your phpbb if you selected mysql 4/5 you will get that error. You just need to change to mysql 3. To do this go into your config file and remove the 4 after mysql like:

Code: Select all

$dbms = 'mysql';
You should not get that error message anymore.
I made that change and now rebuild_search_tables.php appears to be running smoothly.
-

I also have a couple of other comments. I noticed the script truncated all user names that exceed 25 characters. I found this on line 362 of the readme, which I'm assuming is what causes this action:

Code: Select all

If Len(UserName) > 25 Then ChangedUserName = True: Warn "User name '" & UserName & "' will be truncated to: " & Left(UserName, 25)
Can that be edited to allow for longer user names without causing adverse effects? I'm wondering if that's the limit phpBB allows which is why you set that limit in your converter.
-

I think it's a great feature that your script will convert broken links in posts to the specified path. However, it would be nice to have the option to not convert any of the links without having to click No for each individual link, like a "No to all" option, just as there is a "Yes to all" option. I tried converting by leaving that path field blank but it still wanted to convert the links, just without a specified path prefixing the new links.
-

In my warnings.txt, I got numerous messages such as:

Code: Select all

Warning: No posts found for IB3 forum 4, topic 780: This is the topic title
What does this mean exactly? Did I lose posts?
-

Overall, this is a great converter and our forum was saved because of it. Thank you!!! :D

Locked

Return to “[2.0.x] Convertors”