[SMF Converter] IPB 2.1.x

[CrGrBMP]

start converting get this at end/ What i need to repair/

[ctbfourone]

I'm running into this on convert from IPB 2.1.5...

Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_membergroups
    (ID_GROUP, groupName, maxMessages, onlineColor, stars)
    VALUES
    (6 + 3, SUBSTRING('Moderators', 1, 255), 500, '', '');

Caused the error:

    Duplicate entry '9' for key 1

Any suggestions?

[ThorstenE]

have you retried the conversion?  "Duplicate entry" sometimes is a reason for to much queries and cause the server to overload.

[ctbfourone]

have you retried the conversion?  "Duplicate entry" sometimes is a reason for to much queries and cause the server to overload.

I did, same thing each time. :/

[SleePy]

Open the .sql file
Find:

Code Select Expand

                INSERT INTO {$to_prefix}membergroups

Replace:

Code Select Expand

                INSERT IGNORE INTO {$to_prefix}membergroups

[ctbfourone]

Open the .sql file
Find:

Code Select Expand

                INSERT INTO {$to_prefix}membergroups

Replace:

Code Select Expand

                INSERT IGNORE INTO {$to_prefix}membergroups

Now it just hangs at the permissions step, but no error message...

Code Select Expand


Converting...
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...


No continue button or anything. Should I assume it hit an error?

[SleePy]

Is the continue button disabled?
Is it attempting to go to a page such as your browser showing its loading?

[ctbfourone]

It's not even there. And it definitely didn't finish successfully, since going to the main index of the forum shows nothing.

[SleePy]

The file was upload corrupt.
Try a different program to edit the file and upload it. You can't use MS Word to edit the file.

[ctbfourone]

The file was upload corrupt.
Try a different program to edit the file and upload it. You can't use MS Word to edit the file.

The SQL file? I didn't use MS Word, I used emacs. I'm on Linux.

[SleePy]

Ahh sorry, Just most people when they need to edit something they open it in ms word and don't realize that it will mes up the file :|

Try this one:

[ctbfourone]

Thanks again, but still no dice. It stops at the same point. :/

Is there a way I could tweak or simplify the permissions on my IPB install to help it out?

[SleePy]

Is there error different or did it make it to a different section this time?

The permission system is complicated and it attempts to convert it, while its not needed to convert the permission system it is sometimes nice
Just some times the converter gets in a loop while doing error checking to prevent missed inserts and sometimes duplicate ids get inserted.

[ctbfourone]

Is there error different or did it make it to a different section this time?

The permission system is complicated and it attempts to convert it, while its not needed to convert the permission system it is sometimes nice
Just some times the converter gets in a loop while doing error checking to prevent missed inserts and sometimes duplicate ids get inserted.

Nope, same thing, gets to that same spot. Is there any way to enable logging that might help?

[SleePy]

Does the original work if you try that one again?

It seems quiet odd that it suddenly breaks :|
Does clearing your cookies and having it start over work or does it produce worse errors?

[ctbfourone]

Does the original work if you try that one again?

It seems quiet odd that it suddenly breaks :|
Does clearing your cookies and having it start over work or does it produce worse errors?

With the original SQL (without the IGNORE) I now get:

Code Select Expand



Converting...
Error in convert script - line 3!
Error in convert script - line 5!
Error in convert script - line 6!
Error in convert script - line 7!
Error in convert script - line 8!
Error in convert script - line 9!
Error in convert script - line 12!
Converting members... Unsuccessful!
This query:

    * ATTENTION: You don't need to run or use this file! The convert.php script does everything for you! */
    TRUNCATE `smf`.smf_members;

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 '* ATTENTION: You don't need to run or use this file! The convert.php script doe' at line 1

[SleePy]

Have you tried another browser to download the file?
Is your FTP client sent to use auto for the mode of transfer?

That comment right there is at the top of all the converter .sql files. By seeing that it says the file is corrupted and isnt' able to be read properly.

[ctbfourone]

Have you tried another browser to download the file?
Is your FTP client sent to use auto for the mode of transfer?

That comment right there is at the top of all the converter .sql files. By seeing that it says the file is corrupted and isnt' able to be read properly.

Weird. I copied it using scp to the server initially. When I went back to the original SQL file like you suggested I just opened it in emacs and removed the IGNORE part from the SQL query. I'll re-download the original and try it again.

[SleePy]

The ignore part actually needed added to the query :|

[Lotti]

hi all! i'm trying to convert the ipb 2.1.7 to smf 1.1.5 with the latest .sql script attached to reply #110 of this nice topic.

here it is my error:

Converting...
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Fatal error: Cannot redeclare magicmask() (previously declared in E:\Web\smf_convert.php(910) : eval()'d code:41) in E:\Web\smf_convert.php(913) : eval()'d code on line 61

thank you for helping me!