Problem Getting convert.php for phpbb3

[gs2088]

When I'm in the topic where it talks about downloading the convert.php for phpbb3, it takes me to another page, where down the screen is the stuff for phpbb3, I click on it, and it takes me back to the other page (looping).  Can someone help me please?

[ThorstenE]

convert.php:
http://www.simplemachines.org/community/index.php?topic=140741.0
it's attached (scroll down to the end)

phpbb3_to_smf.sql & phpbb3_login_fix.tgz
http://www.simplemachines.org/community/index.php?topic=218449.0
attached (first post)

or our downloads page:
http://www.simplemachines.org/download/?converters

[Pame]

Could you tell me ?

if... we must use files inclued in smf_1-1-8_phpbb3_converter.zip from
http://download.simplemachines.org/?converters

or... files attached at this topic
http://www.simplemachines.org/community/index.php?topic=218449.0

They seem different !

[Pame]

With files attached at this topic
http://www.simplemachines.org/community/index.php?topic=218449.0

I have got this error :

Code Select Expand

Converting personal messages (step 2)... Unsuccessful!
This query:

    INSERT INTO `XXX`.smf_pm_recipients
    (ID_PM, ID_MEMBER, labels, is_read, deleted)
    VALUES ('201', '346', '-1', '1', '0'),
    ('202', '232', '-1', '1', '0'),
    ('202', '57', '-1', '1', '0'),



    ('510', '70', '-1', '1', '0'),
    ('511', '476', '-1', '1', '0');

Caused the error:

    Duplicate entry '231-232' for key 1

Any help would be appreciated greatly ;-) thanks in advance

A+

[ThorstenE]

edit the phpbb3_to_smf.sql and find

Code Select Expand

---* {$to_prefix}pm_recipients

replace it with:

Code Select Expand


---* {$to_prefix}pm_recipients
---{
$ignore = true;
---}


the re-run the conversion.

[Pame]

Ok, thank to you ;-) I try it now...

[Pame]

I had tried with files from the converter and there is no problem

Buuut all content between 2 smilies is erased with the converter !!!

May be I must try with files from this topic including your modification ?

[SleePy]

Interesting.

Could you provide me with the raw text of that post?
Raw text would be what is stored in the database. You would find the message id on the phpbb3 forum and then go to the phpbb_posts table in your database to find it.
This would help as we can see the message before it gets parsed by any forum parser.