[SMF Converter] phpBB3

[bobbank]

Hello,

I believe I have followed the instructions correctly, but I am having major issues with the conversion from phpBB3.

During the conversion itself, I get an extremely long error message that looks like it includes pieces of numerous posts that could not convert.  At the bottom, the error message is: "Caused the error: Duplicate entry '11217' for key 1"

Interestingly, the posts that seem to be contained in this error message actually do get converted just fine.  The only readily apparent problems I saw with the posts themselves were [color] tags not working properly at all, and most forums (but not all) had the "last post" information blank.

/edit: I should mention that I do get a screen during post conversion that says it has paused to avoid overloading my server, and asks me to click continue.

So I thought I could live with this and decided to login.

On login attempt I get this:
"Fatal error: Cannot redeclare phpbb3_password_check() (previously declared in /home/sohguild/public_html/forumsnew/Sources/LogInOut.php:490) in /home/sohguild/public_html/forumsnew/Sources/LogInOut.php on line 551"

I had installed the password fix using package manager.

I'm hoping to use SMF instead of phpbb for my gaming guild, but I cannot make the switch if it means losing all our history.  Thanks in advance for your help.

[ThorstenE]

seems like you have installed the login_fix.tgz more than one times.. can you attach your LoginOut.php here?

[bobbank]

Hello and thanks for your reply.  I tried to do a clean install of SMF and re-install the login fix mod.  I notice I'm hitting the same speedbump that I hit last time.  When I tell SMF to install the mob, here's the path in my browser: "MYPATH/index.php?action=packages;sa=install2;package=phpBB3_Login_Fix.tgz" and that page cannot load.  "Internet Explorer cannot load page."

Last time I hit refresh and perhaps you are right that it resulted in duplicate code being inserted.

This time I refrained.  And it works fine!  So thanks for the lead.  (I wonder why I get that browser issue both times tho.. any thoughts?)



Also, I was able to use the convert utility successfully this time.  I found out what I did wrong, and I have a suggestion for the author (and other users - maybe you could clarify this in the instructions).  When you get the screen in which you're told that nothing is wrong but the convertor is pausing to avoid a server overload, you get a continue button that has a 3 second count down.

If you press continue AFTER it has reached zero, it seems you essentially make the convertor start that section over, resulting in a duplicate attempt to import posts.  That was what generated my error.

My suggestion to the author: after the countdown hits zero, and the utility resumes its work, you should disable the Continue button to prevent this error.

Thanks!



/edit: but I spoke too soon.  Now for my new problem.  It did not correctly set me as an Administrator.  (And I can't see private messages but I am assuming perhaps that is disabled and once I'm an admin I can turn it on.)

/edit2: I resolved my Admin problem.. it was quirky but I don't think it was the fault of the utility actually (we had multiple admins and it did correctly assign one of them.. just not me!)  However, my new new problem is smileys - most of them did not convert correctly.. so I've got a lot of broken links.  Any easy way to fix?

/edit3: more feedback for the author - when converting PM's, it seems the phpbb Inbox and Sent folders got merged.  I've just got a big mess of both in my new SMF inbox.

[ThorstenE]

what's going wrong with the smileys? you can enable custom smileys in SMF and add the smileys and code from your former used phpBB..

[bobbank]

what's going wrong with the smileys? you can enable custom smileys in SMF and add the smileys and code from your former used phpBB..

It looks like the convertor had a meltdown on certain smilies.  For example here is the syntax it used for one of them:

Code Select Expand

<!-- s:cry: --><img src="{SMILIES_PATH}/icon_cry.gif" alt=":cry:" title="Crying or Very sad" /><!-- s:cry: -->

This translates into the following path for the graphic:

Code Select Expand

http://mydomain.org/forums/%7BSMILIES_PATH%7D/icon_cry.gif

So I don't think this is anything I can fix by simply uploading the appropriate gif to the corresponding path.  It doesn't create a legitimate path at all.  Would you agree, or does anyone have suggestions for a resolution?

[onyxprop]

[color=#FF0000:2r4lh04x]New accounts that have been neglected, and which have 0 posts after 60 days of registration, will be deactivated.[/color:2r4lh04x]

This is supposed to be red text, and something else, I can't remember, maybe bold too. Don't know what the heck 2r4lh04x is supposed to be.

[u:2r4lh04x]Registration is free[/u:2r4lh04x]

This one is supposed to be underlined, and possibly coloured or enhanced.

After converting from phpbb3, all bbcodes and colors and possibly HTML are just showing up as above.
Other examples also shows as
[i:2r4lh04x]Hello.[/i:2r4lh04x] or it just has [b:][/b] [size=200:2n531i3k]RULES:[/size:2n531i3k]
or italic, color or underline

Looks like it all fused/melted together!

Any quick fix for this? can't edit all 9000 posts of those who've been color-coding their sentences in bold! 

[ThorstenE]

bobbank,
a fix for the smileys issue can be found here:
http://www.simplemachines.org/community/index.php?topic=218449.msg1676430#msg1676430

[ThorstenE]

onyxprop,
you can fix this by using phpMyAdmin and replace all wrong (user based) bbcodes:

Code Select Expand

UPDATE smf_messages SET BODY = replace( BODY, ':2r4lh04x', '' )
change smf_ to your database prefix.

repeat this for every custom bbcode.

if you are able to reconvert the forum (only possible, if it is not used by your users until yet or all data after the conversion will be lost) you can try the phpbb3_to_smf.sql from this post:
http://www.simplemachines.org/community/index.php?topic=250748.msg1623166#msg1623166

[onyxprop]

I don't think I want to go through that nasty process of converting everything again. 

So, go into phpmyadmin and look where exactly to replace the codes? I see Body in smf_messages but don't know where to put that code you gave me.

[ThorstenE]

go to the SQL-Window and execute the code (see screenshot)

[bobbank]

TE - thank you for your help through this process.

(I also had the same issue as onyx so that's two fixes for me to work on when I have time later this week!)

[onyxprop]

WOW 

It worked!

Thank you! 

[onyxprop]

ok,
so how do I set the size=SOME NUMBER HERE now?

Code Select Expand

[size=200]kool[/size]
is it just some mod i can upload with package manager, or no? 

[ThorstenE]

I am not sure what you mean.. would you like to replace your old size tags in the database or only don't know, how to use size tag in SMF?

the size in SMF is used with pt or px as an attribute, the max. size is 99

Code Select Expand

[size=99pt]test[/size]

if you want to replace old BBCODEs in the messages table you can do it with the same solution posted above
example:

Code Select Expand

UPDATE smf_messages SET BODY = replace( BODY, 'size=200', 'size=99pt' )

[Mollesman]

Hi all, First of all, Good work from all of you ... Second.. I have a slide of a prob.. I tryed to convert from PHPbb3 and got this error :

Parse error: syntax error, unexpected ';', expecting ')' in /home/virtual/vardnads-umgangeslagar.se/public_html/smf/convert.php on line 2656

On that line it says: "

The database encountered an error on line (from query), " . $line . "."; // . ", from file, " . $file . ".";

Anybody have a clue? I installed the smf, Set it to UTF8 deleted the Installfiles, And typed hxxp:www.vardnads-umgangeslagar.se/smf/convert.php [nonactive]

I aint soo good at php so.. you might have to explain it like you do to a child..he he 

I have also looked for that : phpBB3_Login_Fix.tgz but couldnt find it anywere.

[ThorstenE]

the convert.php from the packages on our download page is icorrect (and should be fixed soon).. use the version attached to this post: http://www.simplemachines.org/community/index.php?topic=140741.0

[onyxprop]

Well, I managed to fix the broken links concerning the old smilies, but all i have for option in the reply are only a few of the default smilies. I tried to somehow get my phpbb smilies on the set smiley order. In fact, my smileys aren't showing up at all in the admin section, it's weird, but all the broken links have them on the threads?
just baffled that's all. I don't know what to do, and I followede that link above to get my smilies into smf in the first place.

I get this 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 '(code) DESC' at line 2
File: /home/onyxprop/public_html/smf/Sources/ManageSmileys.php
Line: 990

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.6, while your database is at version 1.1.5. The above error might possibly go away if you execute the latest version of upgrade.php.

Now, i looked at DB and apparently the installation is still at 1.14 but on my forum it's up to date at .6. I tred to update but I just got another mysql error.

I dunno.

[ThorstenE]

Common conversion errors.

[Mollesman]

Thnax and ty for ansering my questian, I have sme more questian thoe...

Were am i suppose to put this file:

phpBB3_Login_Fix.tgz

?

does that make the passwords convert also to the new forum? Cuase i have no access at all to it right now, I had before but then i disepeared.. "the admin rights doesnt work either...

[SleePy]

You will have to apply that patch manually if you can not log on or gain access to the admin panel, but it will convert your phpbb3 passwords after the user logs on into the smf one.