1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Stats won't update due to a mysql data collection error

Discussion in 'BF2Statistics discussion' started by marty6, Oct 22, 2011.

  1. marty6

    marty6 Member

    Hi,

    I have the following error that shows up in the "_stats_error.txt" document in the asp/logs folder.

    Here's the error:

    2011-10-21 16:42:08 -- INFO: SNAPSHOT Data File Processed: TST89364ea2035071976-test_map_20060902_2329.txt
    2011-10-21 17:11:44 -- ERROR: ERROR: Duplicate entry '0' for key 1
    Query String: INSERT INTO round_history SET
    `timestamp` = 1157264950.7,
    `mapid` = 999,
    `time` = 2044.86999989,
    `team1` = 0,
    `team2` = 2,
    `tickets1` = 25,
    `tickets2` = 0,
    `pids1` = 1,
    `pids1_end` = 1,
    `pids2` = 0,
    `pids2_end` = 0

    Is there a way to fix this in the phpmyadmin? The "ERROR: ERROR: Duplicate entry '0' for key 1" is the problem.

    Thanks,

    Marty6