Recalculating forum statistics... Unsuccessful!

[MarkoKg]

So after two hours or so from the moment i started conversion I got this message:

Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `php-smf`.smf_topics
    SET id_first_msg = '',
    id_member_started = '0', id_last_msg = '',
    id_member_updated = '0', num_replies = '-1'
    WHERE id_topic = 82052
    LIMIT 1;

Caused the error:

    Duplicate entry '0-37' for key 'last_message'

I have a forum with more than 250.000 posts so it took for a while, and i got that at the end. Any chance to fix it somehow? Forum statistics currently showing:
1 Posts in 1 Topics by 1 Members.

EDIT: Seems like maintenance from admin panel and "Recount forum statistics" helped

[AllanD]

I was just going to recommended that, glad you found it.

[PhuriousGeorge]

You'll also probably be interested in using this:
https://github.com/Spuds/SMF-Admin-Toolbox

This modification adds several new admin maintenance functions including

    Recalculates user post counts
    Merge two users in to a single ID
    Mark inactive users as read all posts
    Rebuild Stats