converting from ipb 2.2 to smf 1.1.3

[arkay]

I need some help please. I run the convert and this is what I get.:

Code Select Expand

Converting...
Converting members... Successful.
Converting categories... Unsuccessful!
This query:

    INSERT INTO `rocky2_1234`.smf_categories
    (ID_CAT, name, catOrder)
    VALUES ('264', 'Central Division', '4'),
    ('265', 'Southeast Division', '5'),
    ('266', 'Southwest Division', '6'),
    ('174', 'N4L Front Office', '1'),
    ('179', 'N4L Features', '11'),
    ('180', 'Center Court', '2'),
    ('182', 'Media Corner', '10'),
    ('267', 'Northwest Division', '7'),
    ('268', 'Pacific Division', '8'),
    ('263', 'Atlantic Division', '3');

Caused the error:

    Duplicate entry '255' for key 1

[SleePy]

The ID_CAT column is setup to only allow IDs up to 255..

Run this query in phpMyAdmin for the SMF Database and it will allow more, so the conversion can complete.

What is phpMyAdmin?

Code Select Expand

ALTER TABLE smf_categories
CHANGE ID_CAT ID_CAT SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT

[arkay]

The ID_CAT column is setup to only allow IDs up to 255..

Run this query in phpMyAdmin for the SMF Database and it will allow more, so the conversion can complete.

What is phpMyAdmin?

Code Select Expand

ALTER TABLE smf_categories
CHANGE ID_CAT ID_CAT SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT

Aprreciate the help. But where do I run that Query? (in phpmyadmin like what do I click)

edit: found it, testing convert. Worked yay!

[JiGs013]

hmm.. what will i download to convert my IPB 2.3 to SMF 1.1.3?

i already download the convert.php but it seems like the link is dead.

[SleePy]

There is a link at the top of this board in the sticked topic.