If I erase all stages from some race in sta_stage without erasing the races in sta_race, will it cause any problem? Other than the races don't happen, of course, which is exactly the objective.
I just want to delete some problematic races (including all their entries in dyn_team_race) before they happen in the season, but I don't want them to disappear from cyclist palmares. I don't want the career tabs to look ugly with the dyn_palmares lose its references in sta_race.
I know I can just try, but sometimes problems don't happen right away at the date of changes, and only kick in when it's too late to roll back the db..
Thanks in advance.
Edited by gunara on 04-06-2021 20:21
There's a column in STA_race called gene_b_selected, I never thought much about it because it just has a 1 for every race, but you could try to simply put a 0 in there and see if the race disappears (and if so, if it only disappears from the calendar or also from everything else like the palmares).
Other than that, I would probably advise you to at least delete the participating teams in gene_ilist_fkIDteam, I could see that being a potential source of problems, and maybe set the gene_i_number of stages and perhaps the first and last stage to 0 as well, although I could imagine that would trigger a ModCheck fail. But at least that's something you'll see right away. Generally, I haven't tried this so no guarantees, but these are at least some thoughts I had on this question.
Also, another thing: You say these races are problematic, maybe there's another way to fix that other than deleting them outright to avoid the issue?
cunego59 wrote:
There's a column in STA_race called gene_b_selected, I never thought much about it because it just has a 1 for every race, but you could try to simply put a 0 in there and see if the race disappears (and if so, if it only disappears from the calendar or also from everything else like the palmares).
Other than that, I would probably advise you to at least delete the participating teams in gene_ilist_fkIDteam, I could see that being a potential source of problems, and maybe set the gene_i_number of stages and perhaps the first and last stage to 0 as well, although I could imagine that would trigger a ModCheck fail. But at least that's something you'll see right away. Generally, I haven't tried this so no guarantees, but these are at least some thoughts I had on this question.
Also, another thing: You say these races are problematic, maybe there's another way to fix that other than deleting them outright to avoid the issue?
Thanks for the very good reply, I will try the suggestions.
As for the original problem, first I have to admit that I posted in a wrong forum, my problem is for the 2019 version, I apologize.
But I hope it doesn't change that much, anyway, here's the problem:
I changed the national teams for the 2nd season, matching the the DYN_national_team and STA_country. I think I should have changed it before January but I forgot so I changed it after the season start, but in the previous PCM it didn't cause any problem.
However, in PCM 2019, it crashed the U23 nation cup races. The log showed the last activities before the crashed pointed to the wrong key "66" in STA_region, but I didn't know what it referred to. I rolled back several days and updated DYN_team_race, but it still crashed. Any idea?
cunego59 wrote:
There's a column in STA_race called gene_b_selected, I never thought much about it because it just has a 1 for every race, but you could try to simply put a 0 in there and see if the race disappears (and if so, if it only disappears from the calendar or also from everything else like the palmares).
Other than that, I would probably advise you to at least delete the participating teams in gene_ilist_fkIDteam, I could see that being a potential source of problems, and maybe set the gene_i_number of stages and perhaps the first and last stage to 0 as well, although I could imagine that would trigger a ModCheck fail. But at least that's something you'll see right away. Generally, I haven't tried this so no guarantees, but these are at least some thoughts I had on this question.
Also, another thing: You say these races are problematic, maybe there's another way to fix that other than deleting them outright to avoid the issue?
Thanks for the very good reply, I will try the suggestions.
As for the original problem, first I have to admit that I posted in a wrong forum, my problem is for the 2019 version, I apologize.
But I hope it doesn't change that much, anyway, here's the problem:
I changed the national teams for the 2nd season, matching the the DYN_national_team and STA_country. I think I should have changed it before January but I forgot so I changed it after the season start, but in the previous PCM it didn't cause any problem.
However, in PCM 2019, it crashed the U23 nation cup races. The log showed the last activities before the crashed pointed to the wrong key "66" in STA_region, but I didn't know what it referred to. I rolled back several days and updated DYN_team_race, but it still crashed (which at the second crashes, the game picked the riders from the correct updated nations as I checked). It may crash the Worlds, too, but I haven't got to that time of the year. Any idea?
PS:
I believe there is no typical problem about the races & stages, no file missing/wrong variants/fallback etc..
Edited by gunara on 05-06-2021 08:22
