Bug Reports

If you identify any API bugs or errors in the data please record them here.

Comments

812 responses to “Bug Reports”

  1. Admin Avatar
    Admin

    Hi,
    Unfortunately, I don’t have any experience with sqlite, so would be unable to test the results.
    Chris

  2. Kai Avatar
    Kai

    Hi, it seems like the Racing Point constructor points have not been updated to reflect the 15 point ‘Tracing Point’ deduction – the API returns 56 points instead of 41 after the 70th Anniversary GP.

    Great API by the way!

  3. Admin Avatar
    Admin

    Hi Kai,
    Thanks for the warning. I hate it when they do that! Now updated.
    Chris

  4. arek Avatar
    arek

    hi my friend, it seems like at 2016 australian gp duration of pit stops take for some teams above 18 minutes if i see well. the same with some pit stop times at 2014 and 2017 year.
    i saw it when i made avg from all pit stops

  5. mkl Avatar
    mkl

    That’s when the entire field was in the pits for the red flag period. The official timing data counts this as a pit stop, but not consistently. You can see the previous discussion on that matter a few comment pages back: https://ergast.com/mrd/bugs/comment-page-3/#comment-14735

  6. Colo Avatar
    Colo

    Hello, there seems to errors in the fastest laps from the 2019 Japan race. The problem is that multiple drivers don’t have their correct fastest laps. An example is Danill Kvyat’s time is reported to be 1:34.921 while the official F1 website says that it is 1:33.239. Not all drivers have the wrong fastest lap associated with them, multiple do.

  7. Admin Avatar
    Admin

    Hi Colo,
    Thanks for the warning – now corrected.
    Chris

  8. TK Avatar
    TK

    Hi Chris,

    Was running some queries and noticed that Kvyat’s “qualifying” record for 2019 Brazil (driverId = 826, qualifyId = 8353, raceId = 1029) has the wrong constructorId. It’s set to to Redbull (9) rather than Toro Rosso (5).

    Regards,
    TK

    BTW, Kvyat’s record for this race in the “results” table looks okay; constructor is set to TR.

  9. Admin Avatar
    Admin

    Hi TK,
    Thanks for the warning – now corrected,
    Chris

  10. PZ Avatar
    PZ

    Hi,

    First of all hats off for this nice database, so much interesting data to look at!

    I was wondering if safety car deployments/laps where safety car was active is anywhere in the data, since I can’t find it anywhere?

    Kind regards

  11. Admin Avatar
    Admin

    Hi PZ,
    Unfortunately not – it’s not easy to find that data.
    Chris

  12. Ab Avatar
    Ab

    Hello,

    I don’t understand the pitstop information from the last race (Mugello). is the ‘red flag’ period not counted?

    http://ergast.com/api/f1/2020/9/drivers/bottas/pitstops

    Great work to collect all this information.
    Ab

  13. G.Letellier Avatar
    G.Letellier

    Application take some times to give all laptimes for a race , example https://ergast.com/api/f1/2020/9/laps.json

    , by adding an index on race table performance increase :

    ALTER TABLE `races` ADD INDEX `inxYearRound` (`year` , `round`);

  14. Miguel Bento Avatar
    Miguel Bento

    Hi Chris,

    When checking the integrity of your database, I detected the following bugs:

    – All URLs in tables circuits, constructors, drivers and races should be https instead of http.

    – The URL for driver 806 (Oscar Gonzallez) is wrong. It should be:
    https://en.wikipedia.org/wiki/%C3%93scar_Gonz%C3%A1lez_(racing_driver)

    – The URL for race 909 (2014 German GP) is wrong. It should be:
    https://en.wikipedia.org/wiki/2014_German_Grand_Prix

    – The time for result 20992 (Hamilton, 2011 German GP) is wrong. It should be:
    ‘1:37:30.334’

    – The time for result 21088 (Vettel, 2011 Singapore GP) is wrong. It should be:
    ‘1:59:06.757’

    – The miliseconds for result 19302 (Hawthorn, 1954 British GP) is wrong. It should be:
    10644000

    – The constructor results for races 784 and 790 (1956 Argentine and German GPs) should be removed, because the constructors championship only started in 1958.

    Thanks, and keep up the good work!

  15. Admin Avatar
    Admin

    Hi Ab,
    Thanks for the warning – they’re now included.
    Chris

  16. Admin Avatar
    Admin

    Hi G.Letellier,
    There is a raceId index on this table so the issue is probably due to an inefficient query – I’ll try to speed it up.
    Chris

  17. Kim Avatar
    Kim

    Hi.

    According to Race Result, Webber should have no lap times in 2008 Italian Grand Prix.
    But there are 52 lap times named Mark Webber in 2008 Italian Grand Prix in DB.

  18. Tiago Avatar

    Is the McLaren info correct? They’re supposed to have 155 fastest laps but i can’t get that number from the query

  19. Admin Avatar
    Admin

    Hi Tiago – fastest lap times are only available from the 2004 season onwards. Does that affect your query?
    Chris

  20. Ab Avatar
    Ab

    Hi Chris,

    Thank you for correcting the information about the pitstops for Mugello (round 9), but could you also correct the info for Monza (round 8). Also this race was suspended and all the cars went in the pit (and changed tyres).

    you can check with this link;

    http://ergast.com/api/f1/2020/8/drivers/stroll/pitstops

    Regards,
    Ab

  21. Admin Avatar
    Admin

    Hi Ab,
    Thanks for the warning – same issue.
    Now updated.
    Chris

  22. Admin Avatar
    Admin

    Hi Kim,
    The race result records 53 laps for Webber:
    http://ergast.com/api/f1/2008/14/drivers/webber/results
    Which matches the number of entries in the laps table:
    http://ergast.com/api/f1/2008/14/drivers/webber/laps
    Have I misunderstood your query?
    Chris

  23. Richard Avatar
    Richard

    Hey,

    It looks like the Mercedes constructor standings is missing after the latest race (raceid 1040) in the csv data.

    Thanks for the great work with this.
    Richard

  24. Admin Avatar
    Admin

    Hi Richard,
    This seems to be a bug in mysql. I’ll check at the weekend but hopefully it will fix itself after the next Grand Prix.
    Chris

  25. TK Avatar
    TK

    Hi Chris,

    Have you ever considered adding something to account for race starts like Hungary this year? Grosjean and KMag pitted after the formation lap and started from the pitlane, instead of their original grid spots.

    https://en.em.wikipedia.org/wiki/2020_Hungarian_Grand_Prix

    Wiki uses an explicit Start Grid column. Maybe adding a record in Pitstops for lap 0, to avoid a schema change?

    Regards,
    TK

  26. TK Avatar
    TK

    Btw, noticed an inconsistency with the results for 2016 Austria.

    Massa and Kvyat started from the pitlane, due to breaking Parc Ferme. But the db still has them in their original grid spots.

    http://ergast.com/api/f1/2016/9/results

    https://en.m.wikipedia.org/wiki/2016_Austrian_Grand_Prix

    TK

  27. Admin Avatar
    Admin

    Hi TK,
    Thanks for the warning – I’ve corrected these now in 2016/9 and 2020/03 using “0” for starting in the pit lane – an approach used elsewhere in the database. With hindsight it should be a string field rather than an integer :-/
    Chris

  28. Wesley Avatar

    Hi Chris,
    The time for the eiffel grand prix race is wrong. It should be 14:10 GMT. Right now it is 15:10 GMT.
    Wesley

  29. Admin Avatar
    Admin

    Hi Wesley, I’m finding it difficult to obtain reliable start times for this year’s amended schedule. Let me know if you find a reliable source (in UTC)
    Chris

  30. Wesley Noordam Avatar

    Hi Chris,
    It is possible to get it from the formula 1 website. You can find the complete schedule here:
    https://www.formula1.com/en/racing/2020.html
    Only downside is that you have to click through the pages. You can press any race and then click on full schedule to see all the start times.
    Wesley

  31. Wesley Noordam Avatar

    Hi Chris,
    I just found something else. Look at this page, you can set it to UTC yourself:
    https://formulaonecalendar.com/
    Wesley

  32. indigo-dev Avatar
    indigo-dev

    Regarding the calendar topic, a very good source is also https://f1calendar.com/.
    They have all session infos, and also an API. They’ve sent me the link as it’s not officially documented on their website. For season 2020 the URL looks like

    https://f1calendar.com/api/year/2020

    Daniel

  33. Wesley Noordam Avatar

    Thanks Daniel! Exactly what I was looking for!

    Wesley

  34. Wesley Noordam Avatar

    Hi Chris,

    The driver standing list of this season has all zeros in the Wins column.
    https://ergast.com/api/f1/current/driverStandings

    Wesley

  35. indigo-dev Avatar
    indigo-dev

    Chris,

    what has happened with the database?
    Suddenly, all of the time-consuming queries like fetching a driver’s lap times and alltime rankings perform as if they would run locally.

    This was causing me so much headache in the past, and now it kinda flies.
    Just how?

  36. Admin Avatar
    Admin

    Hi Indigo,
    I had to move to a new server so updated to MySQL 5.7. It may be faster but several things have stopped working so I’m not as happy as you are!
    Cheers,
    Chris

  37. indigo-dev Avatar
    indigo-dev

    That’s unfortunate!
    I hope you get your problems sorted out. Good luck mate!

  38. Admin Avatar
    Admin

    Hi Wesley,
    Thanks for the warning. Now corrected.
    Chris

  39. Alex South Avatar
    Alex South

    Hello,

    I’ve noticed the positions the Monaco Grand Prix 2019 (1015) particularly are incorrect.

    Real Race Result API Result
    Ham Ham
    Vet Ver
    Bot Vet
    Ver Bot

    There were a few others throughout Monaco, I haven’t checked any other races yet but this was the first one I noticed to be incorrect

  40. theodor Avatar
    theodor

    The race times are wrong? It listed to show UTC times but Bahrain today start 14:10 UTC not 15:10

  41. Admin Avatar
    Admin

    Hi Alex,
    I can’t see a problem with the first four places in this race. However, Kevin Magnussen’s 5 second penalty was missed – I presume that came after I entered the results. Now corrected.
    Thanks
    Chris

  42. Admin Avatar
    Admin

    Hi Theodor,
    Thanks for the alert – now corrected. Not sure why that was wrong.
    Chris

  43. mkl Avatar
    mkl

    Hi,

    The Abu Dhabi ’20 results list gaps for P9 and P10 (Ocon and Stroll) as intervals to the driver in front, not gaps to the winner. This messes up their race times in miliseconds in the database, as well.

  44. Admin Avatar
    Admin

    Hi mkl,
    Thanks for the warning – now corrected.
    Chris

  45. Ab Avatar

    Hi Chris,

    I’ve found a mistake in the data:

    Season 2016 round 18 (US) pitstop information
    – the driversIds for Vettel and Raikkonen have been swapped.

    According to other websites Raikkonen did make one pitstop and Vettel two. Timing info etc are correct.

    Regards
    Ab

  46. Admin Avatar
    Admin

    Hi Ab,
    Which websites are you looking at? According to the data I have they both made 3 stops at the 2016 US Grand Prix.
    Chris

  47. Ab Avatar

    Hi Chris,

    Happy New Year to you.

    Sorry made typing mistake 2017, Sites I’ve been used are:
    – FIA archives https://www.fia.com/events/fia-formula-one-world-championship/season-2017/lap-chart-3
    – motorsport.com https://www.motorsport.com/f1/results/2017/united-states-gp-159709/?st=PT

    Regards,
    Ab

  48. Admin Avatar
    Admin

    Hi Ab,
    Thanks – that matches. I’ve corrected the IDs as suggested.
    Cheers
    Chris

  49. RR Avatar
    RR

    Hi, is it possible to set “\N” in URL for driver Thomas Monarch?
    452,”monarch”,\N,\N,”Thomas”,”Monarch”,”1945-09-03″,”American”,””

  50. Admin Avatar
    Admin

    Hi RR,
    The URL field isn’t nullable and changing this would require changes to the runtime. Instead, I’ve set the URL to the only place he’s mentioned in Wikipedia which is: http://en.wikipedia.org/wiki/Talk:1963_Mexican_Grand_Prix#Who_was_Thomas_Monarch.3F
    Hope that helps.
    Chris

Leave a Reply

Your email address will not be published. Required fields are marked *