Main Navigation
PCM Tools
Pro Cycling Manager 24
Pro Cycling Manager 23
Pro Cycling Manager 22
Pro Cycling Manager 21
Pro Cycling Manager 20
Pro Cycling Manager 19
Pro Cycling Manager 18
Pro Cycling Manager 17
Pro Cycling Manager 16
Pro Cycling Manager 15
Pro Cycling Manager 14
Pro Cycling Manager 13
Pro Cycling Manager 12
Pro Cycling Manager 11
Pro Cycling Manager 10
Pro Cycling Manager 09
Pro Cycling Manager 08
Pro Cycling Manager 07
Pro Cycling Manager 06
· Guests Online: 36
· Members Online: 0
· Total Members: 162,199
· Newest Member: champdaldeia
Oh no! Where's the
JavaScript ?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please
enable JavaScript on your Web browser to properly view this Web site,
or
upgrade to a Web browser that does support JavaScript;
Firefox ,
Safari ,
Opera ,
Chrome or a version of
Internet Explorer newer then version 6.
Adding new Stage race - Quebec stage shows up
Ad Bot
Posted on 23-12-2024 02:03
Bot Agent
Posts: Countless
Joined: 23.11.09
IP : None
cyclertom
Posted on 17-10-2018 19:00
Amateur
Posts: 23
Joined: 21-10-2007
PCM$: 200.00
Hey guys!
I've just created several stages for our local Czech stage race. When I load them as a variant for an existing Stage race, they all work fine. But when I've tried to load them as a part of my own stage race, it didn't work.
Actually, the stage info, profile, etc. is ok. But when you go further, pick the team and get to the point, where you set the team strategy, it shows the Quebec stage...
So there must be something wrong with the DB. I just can't figure out what would that be.
Can anyone help? See the exported tables from the DB below.
STA_race
IDrace 625 gene_sz_race_name East Bohemia Tour gene_sz_abbreviation Bohemia gene_sz_filename t1_bohemia fkIDcountry 33 fkIDUCI_class 11 fkIDfirst_stage 21139 fkIDlast_stage 21143 gene_f_popularity 5 gene_i_number_stages 5 gene_sz_mailOrganisateur gene_ilist_fkIDteam (40,50,51,58,77,108,114,115,122,126,147,176,187,192,198,307,310,199) gene_ilist_objectif_info () fkIDLastRaceLeader 0 CONSTANT bohemia gene_sz_classification_xml cont_22.xml gene_f_organisateur_coeff 0 fkIDtype_tour 5 gene_b_ForceProtourInvitation 0 gene_b_aso 0 gene_sz_currentvariant value_i_prime 0 gene_b_selected 1
STA_stage
IDstage 21139 21140 21141 21142 21143 fkIDrace 625 625 625 625 625 gene_i_day 20 21 22 23 24 gene_i_month 6 6 6 6 6 gene_i_computed_date 0 0 0 0 0 gene_i_stage_number 1 2 3 4 5 gene_b_selected 1 1 1 1 1 CONSTANT gene_sz_variant
Stage itself is named like t1_bohemia_01_2018, etc.
Thanks a lot
Tomas
Selwink
Posted on 17-10-2018 19:02
Grand Tour Champion
Posts: 8856
Joined: 17-05-2012
PCM$: 200.00
Your stage IDs are wrong. They should be 1625-5625. In STA_Race, change the fkID_firststage and laststage accordingly
cyclertom
Posted on 17-10-2018 19:05
Amateur
Posts: 23
Joined: 21-10-2007
PCM$: 200.00
Oh, now I see... It has to be a combination of Stage no. and RaceID... Cool, thanks a lot for your help Selwing. You've saved my day!
Jump to Forum:
PCM 24: General
PCM 24: PCM.daily Projects
PCM 24: Databases, Graphics, Stages
Tour de France 2024
PCM 23: General
PCM 23: Online
PCM23: Technical Issues
PCM 23: Database
PCM 23: PCM.daily Projects
PCM 23: Graphics
PCM 23: Stages
Tour de France 2023
PCM 22: General
PCM 22: Online
PCM 22: Technical Issues
PCM 22: Database
PCM 22: PCM.daily Projects
PCM 22: Graphics
PCM 22: Stages
Tour de France 2022
PCM 21: General
PCM 21: Online
PCM 21: Technical issues
PCM 21: Database
PCM 21: PCM.daily Projects
PCM 21: Graphics
PCM 21: Stages
Tour de France 2021
Pro Cycling Manager 2020
Pro Cycling Manager 2019
Pro Cycling Manager 2018
Pro Cycling Manager 2017
Pro Cycling Manager 2016
Pro Cycling Manager 2015
Pro Cycling Manager 2014
Pro Cycling Manager 2013
Pro Cycling Manager 2012
Pro Cycling Manager 2011
Pro Cycling Manager 2010
Pro Cycling Manager 2009
Pro Cycling Manager 2008
Pro Cycling Manager 2007
Pro Cycling Manager 2006
Cycling
Football
Other sports
Games
Everything else..
PCM.daily Awards 2023
PCM.daily Awards 2022
PCM.daily Awards 2021
PCM.daily Awards 2020
PCM.daily Initiatives
Favourable and critical comments
Hi .. welcome!
PCM Story Section
PCM 20: Stories
PCM 19: Stories
PCM 18: Stories
PCM 17: Stories
PCM 16: Stories
PCM 15: Stories
PCM 14: Stories
PCM 13: Stories
Story Games
[Man-Game] The Rules and Announcements
[Man-Game] Teams HQ
[Man-Game] Transfers: Free Agents
[Man-Game] Transfers: Deals
[Man-Game] Transfers: Adverts
[Man-Game] General
[Cont-Man-Game] General
[Man-Game] Discussion
[Man-Game] Results PT/PTHC
[Cont-Man-Game] HC/C1 Results
[Cont-Man-Game] C2HC/C2 Results
[Man-Game] Other Races
[Man-Game] Race Profiles 2024
[Man-Game] Race Profiles 2023
PCM.daily Awards 2019
PCM.daily Awards 2018
PCM.daily Awards 2017
[Man-Game] 2022 Transfers: Free Agents
[Man-Game] Transfers: Free Agents
[Man-Game] Transfers: Deals
[Man-Game] 2022 Transfers: Deals
[Man-Game] 2022 Transfers: Adverts
[Man-Game] Transfers: Adverts
[Man-Game] Transfers: Adverts
[Man-Game] Transfers: Free Agents
[Man-Game] Transfers: Trades and Loans
[Man-Game] Transfer Discussion
[Man-Game] Transfers: Completed Trades
[Man-Game] Race Profiles 2016
[Man-Game] Race Profiles 2019
[Man-Game] Race Profiles 2015
[Man-Game] Race Profiles 2020
[Man-Game] Race Profiles 2021
[Man-Game] Race Profiles 2017
[Man-Game] Transfers: Free Agents
[Man-Game] Transfers: Deals
[Man-Game] Transfers: Adverts
[Man-Game] Race Profiles 2018
Not a member yet?
Click here to register.
Forgotten your password?
Request a new one
here .
Latest content
Latest downloads
Recommended downloads
Latest stages Latest shirts Latest tips
Screenshots
Fantasy Betting
ManGame Betting