Caused the error: Duplicate entry '0-0' for key 1

[oldYabber]

YaBB 2.1 to SMF 1.1.5

Converting topics (part 2)... Unsuccessful!

This query:

    ALTER TABLE `databasename_smf`.smf_log_topics
    ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
    DROP COLUMN tempID;

Caused the error:

    Duplicate entry '0-0' for key 1

[SleePy]

It looks like you have a topic with a duplicate IDs.
If you go into your SMF database.

Then go to smf_log_topics
Search for where the id topic is 0 and id_member is zero.
Remove all of those as it shouldn't be any of those.

If you want you could just empty that table. It would just mean people need to re mark topics read and such as it would clear this out.

[oldYabber]

Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `databasename_smf`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2

   MySQL version 5.0.45

I cant find the upgrade1-1.sql  file to make the changes. Where would this be located?

[SleePy]

Common conversion errors.

[oldYabber]

I'm doing a happy SMF dance.

Thanks a ton SleePy