Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: internetbrother on May 27, 2009, 11:55:53 AM

Title: Recalculating forum statistics... Unsuccessful!
Post by: internetbrother on May 27, 2009, 11:55:53 AM
stops while converting

Recalculating forum statistics... Unsuccessful!



Caused the error:

    Duplicate entry '0-54' for key 2
Title: Re: Recalculating forum statistics... Unsuccessful!
Post by: internetbrother on May 28, 2009, 09:39:49 PM
wow!

No reply
Title: Re: Recalculating forum statistics... Unsuccessful!
Post by: psc on June 02, 2009, 12:44:09 AM
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:
QuoteRecalculating 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  :(
Title: Re: Recalculating forum statistics... Unsuccessful!
Post by: SleePy on June 09, 2009, 06:16:12 PM
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.