[SMF Converter] IPB 2.1.x

Started by JayBachatero, February 10, 2007, 02:03:49 PM

Previous topic - Next topic

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

Quote from: ThorstenE on June 25, 2008, 02:08:34 AM
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:
                INSERT INTO {$to_prefix}membergroups

Replace:
                INSERT IGNORE INTO {$to_prefix}membergroups
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ctbfourone

Quote from: SleePy on June 25, 2008, 01:35:29 PM
Open the .sql file
Find:
                INSERT INTO {$to_prefix}membergroups

Replace:
                INSERT IGNORE INTO {$to_prefix}membergroups


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


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?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ctbfourone

Quote from: SleePy on June 25, 2008, 03:04:13 PM
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:
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ctbfourone

Quote from: SleePy on June 26, 2008, 01:17:49 AM
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?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ctbfourone

Quote from: SleePy on June 27, 2008, 02:45:23 AM
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:



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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ctbfourone

Quote from: SleePy on June 28, 2008, 12:56:35 AM
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 :|
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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! :)

Advertisement: