Recalculating forum statistics... Unsuccessful!

[internetbrother]

stops while converting

Recalculating forum statistics... Unsuccessful!



Caused the error:

    Duplicate entry '0-54' for key 2

[internetbrother]

wow!

No reply

[psc]

I am having a similar issue

- Fresh install of SMF 1.1.9, no issues installing.
- Using the correct converter from the downloads page for 1.1.9.
- phpbb is version 3.0.4

Error is:

Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `smf`.smf_topics
    SET ID_FIRST_MSG = '',
    ID_MEMBER_STARTED = '0', ID_LAST_MSG = '',
    ID_MEMBER_UPDATED = '0', numReplies = '-1'
    WHERE ID_TOPIC = 3440
    LIMIT 1;

Caused the error:

    Duplicate entry '0-3' for key 2

Any ideas? Really want to move my forums to smf 

[SleePy]

internetbrother,

Did you remove the query? It doesn't help when I can't see the query that generated the error.
Please start the conversion over and before you start. Add &debug=1 to the end of the url.

psc,
You have a topic (whos id is 3440) that doesn't seem to have any messages related to it. Check your phpbb database to see if there is a topic with messages with the topic id of 3440.