Simple Machines Community Forum

SMF Support => Converting to SMF => IPB => Topic started by: suboshiyui on February 22, 2010, 11:17:14 PM

Title: Converting from 2.3 to 1.1 - error
Post by: suboshiyui on February 22, 2010, 11:17:14 PM
Hi!

I'm hoping someone can help me.  I'm trying to convert my 2.3.3 IPB database into the SMF 1.1.  I keep getting this error, and I'm not sure what to do about it.

Converting categories... Unsuccessful!
This query:

    INSERT INTO `yakuzarpg`.smf_categories
    (ID_CAT, name, catOrder)
    VALUES ('18', 'Staff Projects', '2'),
    ('19', 'AKIRA SHOCK! Fansubs', '3'),
    ('261', 'Role-Playing', '9'),
    ('24', 'General', '4'),
    ('28', 'Johnny's Entertainment', '7'),
    ('127', 'Fan Stuff', '8'),
    ('276', 'Staff Information', '1'),
    ('429', 'Project: Code Blue 2', '5');

Caused the error:

    Duplicate entry '18' for key 1


Any and all help would be awesome.  Thank you![/s]

fixed!  thanks ^^
Title: Re: Converting from 2.3 to 1.1 - error
Post by: ThorstenE on February 23, 2010, 01:04:04 PM
Mhh, this looks like a broken session.. Can you restart the converter from the beginning? Do you get the same error again?
You should also check this topic:
http://www.simplemachines.org/community/index.php?topic=274252.0

SMF doesn't support categories with a ID higher than 127, therefore you need the "fix high category ids" tool.