Database Redesign

Moderators: flockmastoR, Gipfelstuermer, Alkworld, systemmods

Hansa
Posts: 1077
Joined: Wed May 19, 2010 8:27 pm
Contact:

Re: Database Redesign

Post by Hansa » Sat Nov 30, 2024 5:32 pm

Alkworld wrote:
Sat Nov 30, 2024 4:02 pm
Hansa wrote:
Sat Nov 30, 2024 1:44 pm
aand reset doesnt work

Team Reset

Do you really want to reset your team Hansa?

if i click here on Yes simply nothing happens.
Kellenberger is still there (if you click on him in transfers), the other two were sold intentionally or with reset? They are indeed lost (even from DB) :shock:
Max wasnt sold by me but he was gone after you fixed the selling issue.

Schlattinger pretty sure was sold by me the day before.

Can you put me in div 6 again? I wanted to try these auto team creation
Hansa

est. 03.08.2009

Alkworld
Posts: 1234
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Sat Nov 30, 2024 11:42 pm

Hansa wrote:
Sat Nov 30, 2024 5:32 pm
Can you put me in div 6 again? I wanted to try these auto team creation
Will do after the month change

Hansa
Posts: 1077
Joined: Wed May 19, 2010 8:27 pm
Contact:

Re: Database Redesign

Post by Hansa » Sat Nov 30, 2024 11:44 pm

And please find the bug for the dissapearing riders from the database, wouldnt like to see riders dissapearing after we migrated to the new database
Hansa

est. 03.08.2009

Hansa
Posts: 1077
Joined: Wed May 19, 2010 8:27 pm
Contact:

Re: Database Redesign

Post by Hansa » Sun Dec 01, 2024 2:42 pm

Test version is extremely slow today
Hansa

est. 03.08.2009

Hansa
Posts: 1077
Joined: Wed May 19, 2010 8:27 pm
Contact:

Re: Database Redesign

Post by Hansa » Sun Dec 01, 2024 2:57 pm

Bought a 73-55-79 21 yo on the div 6 market, i think that he shouldnt be there as the limit is lower kn the div 6 market?
Hansa

est. 03.08.2009

lennylenny
Posts: 491
Joined: Mon Aug 08, 2011 10:22 am
Contact:

Re: Database Redesign

Post by lennylenny » Sun Dec 01, 2024 2:58 pm

82 sprinters in Div 6 market too
and 77 TT too
Spelling mistakes are Special functions Like bugs that are functions of the game

drei.zehn
Posts: 97
Joined: Wed Apr 08, 2015 10:09 am
Contact:

Re: Database Redesign

Post by drei.zehn » Sun Dec 01, 2024 8:07 pm

Hansa wrote:
Sun Dec 01, 2024 2:42 pm
Test version is extremely slow today
Actually not just the test version

Alkworld
Posts: 1234
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Mon Dec 02, 2024 8:32 am

More fixes done
- attacks at certain kms were taken over to the next day
- team classification times as number, not formatted
- old races couldn't be opened
- month change was failing
- nothing happening on reset
- TTT - high energy consumption with low effort - overall weird behaviour
- TTT - last km of replay missing
- background processes with big output failed and were run over and over (5 month changes on the test version)

Alkworld
Posts: 1234
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Mon Dec 02, 2024 8:33 am

Hansa wrote:
Sun Dec 01, 2024 2:57 pm
Bought a 73-55-79 21 yo on the div 6 market, i think that he shouldnt be there as the limit is lower kn the div 6 market?
Next on my list

Bugatti
Posts: 117
Joined: Sat Feb 05, 2011 5:53 pm
Contact:

Re: Database Redesign

Post by Bugatti » Mon Dec 02, 2024 5:30 pm

Km: 168, Steigung: 0, Meters left: 450
Brendon Hoyte(Bugatti) findet kein Hinterrad
Richard Louis(Bugatti) geht ans Hinterrad
Roberto Villanueva(Bugatti) sprintet von vorne und wird blockiert
Elvis Forde(Bugatti) geht ans Hinterrad
Ross Walrond(Bugatti) sprintet von vorne und wird blockiert
Rasheeme Griffith(Bugatti) sprintet von vorne und wird blockiert
Oddur Björnsson(Bugatti) sprintet von vorne und wird blockiert
Arnaldo André(Bugatti) sprintet von vorne und wird blockiert
Vigdís Finnbogadóttir(Bugatti) sprintet von vorne und wird blockiert

hatte alle nur auf mitgehen gestellt, warum werden die auf sprintet von vorne gesetzt und blockiert?
Im sprint stehen aber alle dann wieder auf mitgehen.
Giro d´Italia 2016 - James Müller
La Vuelta 2015 - Mark McCann
La Doyenne - Helge Thomsen

Alkworld
Posts: 1234
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Mon Dec 02, 2024 6:01 pm

Bugatti wrote:
Mon Dec 02, 2024 5:30 pm
Km: 168, Steigung: 0, Meters left: 450
Brendon Hoyte(Bugatti) findet kein Hinterrad
Richard Louis(Bugatti) geht ans Hinterrad
Roberto Villanueva(Bugatti) sprintet von vorne und wird blockiert
Elvis Forde(Bugatti) geht ans Hinterrad
Ross Walrond(Bugatti) sprintet von vorne und wird blockiert
Rasheeme Griffith(Bugatti) sprintet von vorne und wird blockiert
Oddur Björnsson(Bugatti) sprintet von vorne und wird blockiert
Arnaldo André(Bugatti) sprintet von vorne und wird blockiert
Vigdís Finnbogadóttir(Bugatti) sprintet von vorne und wird blockiert

hatte alle nur auf mitgehen gestellt, warum werden die auf sprintet von vorne gesetzt und blockiert?
Im sprint stehen aber alle dann wieder auf mitgehen.
No idea why this happens, but it's no new bug, as far as I know (and we're still on the old version anyway)

User avatar
flockmastoR
Posts: 3435
Joined: Thu Feb 18, 2010 11:42 pm
Contact:

Re: Database Redesign

Post by flockmastoR » Mon Dec 02, 2024 7:38 pm

Alkworld wrote:
Mon Dec 02, 2024 6:01 pm
Bugatti wrote:
Mon Dec 02, 2024 5:30 pm
Km: 168, Steigung: 0, Meters left: 450
Brendon Hoyte(Bugatti) findet kein Hinterrad
Richard Louis(Bugatti) geht ans Hinterrad
Roberto Villanueva(Bugatti) sprintet von vorne und wird blockiert
Elvis Forde(Bugatti) geht ans Hinterrad
Ross Walrond(Bugatti) sprintet von vorne und wird blockiert
Rasheeme Griffith(Bugatti) sprintet von vorne und wird blockiert
Oddur Björnsson(Bugatti) sprintet von vorne und wird blockiert
Arnaldo André(Bugatti) sprintet von vorne und wird blockiert
Vigdís Finnbogadóttir(Bugatti) sprintet von vorne und wird blockiert

hatte alle nur auf mitgehen gestellt, warum werden die auf sprintet von vorne gesetzt und blockiert?
Im sprint stehen aber alle dann wieder auf mitgehen.
No idea why this happens, but it's no new bug, as far as I know (and we're still on the old version anyway)
The "sprintet von vorne" bug is known to have an unknown source
Boaz Trakhtenbrot:
  • Winner Giro 2022
  • 10 GC wins
  • 16.609 Eternal Points
__________________
Schrödinger's Dogs: Alive & Dead

Hansa
Posts: 1077
Joined: Wed May 19, 2010 8:27 pm
Contact:

Re: Database Redesign

Post by Hansa » Thu Dec 05, 2024 10:33 am

Bugatti alone in the tour (or did you deactivate the minimum 2 team limit?)
Hansa

est. 03.08.2009

Alkworld
Posts: 1234
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Thu Dec 05, 2024 8:40 pm

Hansa wrote:
Thu Dec 05, 2024 10:33 am
Bugatti alone in the tour (or did you deactivate the minimum 2 team limit?)
yes, for easier testing

Alkworld
Posts: 1234
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Sun Dec 08, 2024 5:26 pm

Small preview on the migration:
On Dec 16 (after the Dec tour), I'll try to start the migration early in the morning. This will include:
- stopping background processing (race, transfermarket etc)
- disabling login to current C4F version
- copying data from backup to the new database (similar to the current test version)
- creating new tables, migrate data from old to new tables (including some renaming of old riders to avoid duplicates)
- fix the encoding issues (weird looking special characters)
- run day change and weather reports (backup is from before day change)
- switch main URL www.cycling4freaks.com to new version
- enabling login to new C4F version

Notes:
- if the game doesn't automatically forward to the new URL (maybe some dirty browser cache), you can go directly to http://www.cycling4freaks.com/c4f-3.0/c4f-react
- inscription in the current version will be lost, you'll have to inscribe again
- transfermarket will be a few hours behind (how long will depend on when I start ;) )
- first race on Dec 16 starts at 11am and there should be enough time for signing up (race can be postponed, if anything goes wrong)
- if you find any bugs that day, let me know

User avatar
olmania
Posts: 2647
Joined: Thu Feb 11, 2010 8:06 pm
Contact:

Re: Database Redesign

Post by olmania » Sun Dec 08, 2024 8:51 pm

Thanks for the update !

If that's most confortable for you, I think it would be ok to not have races the 16th of December (1 day off in the year :lol: ). Or have only a few races later in the day that are used for testing purposes only if that is still needed.

ATB - Racing
Posts: 292
Joined: Fri May 04, 2012 11:57 am
Contact:

Re: Database Redesign

Post by ATB - Racing » Mon Dec 09, 2024 11:20 am

Yeah great news Alk!

One little thing. Maybe put an information about that on the start page of the game?!? So nearly everyone could / should have seen it by than.
Also everyone can drop that info in there own races?

Cheers. Have a nice (not so cloudy) start into the week.

Alkworld
Posts: 1234
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Mon Dec 09, 2024 11:26 am

ATB - Racing wrote:
Mon Dec 09, 2024 11:20 am
Yeah great news Alk!

One little thing. Maybe put an information about that on the start page of the game?!? So nearly everyone could / should have seen it by than.
Also everyone can drop that info in there own races?

Cheers. Have a nice (not so cloudy) start into the week.
I'll create a news entry. When logging in next week you'll also get an error message pointing to the new version

Robyklebt
Posts: 10212
Joined: Thu Feb 11, 2010 6:50 pm
Contact:

Re: Database Redesign

Post by Robyklebt » Thu Dec 12, 2024 10:50 am

Alkworld wrote:
Mon Nov 25, 2024 11:04 pm
Robyklebt wrote:
Mon Nov 25, 2024 12:51 pm
29 year olds "unnamed" in the auction market. Should go to 27
Also unnamed goes down to 90% (but this bug is there in the online version now too)
The old code is a bit weird here, it randomly generates riders aged 25 to 29, then changes the 28 and 29 to 27 years resulting in lots of 27yo riders. Seems like it was different in the beginning, then changed to have max 27yo.
To get the same behaviour again, I'd need to uglify the code. I can also change it to randomly create 25 - 27 years (resulting in less 27yo, more 25 and 26). Or 25 to 28 in a similar way. I rather guess we should discuss the content of the TM in general.

Bugs which exist in the old / current version already, I'll happily try to fix when the current project is done (should be soon).
Yes, SOME parts of the TM of course need talking about, but ideally after all is done. And after the leftovers from the whole react transition are dealt with too, alphabetization, the 90% bug, and lots of other stuff.
But since I fear the risk is there that this then gets completely forgottten I'd say change it to 25-27 and when the TM discussion (I have a quite a few posts worth of ideas dating back to Buhmann time) it can be changed to something else if that sounds good.

I still don't get licence days. I bought a lifetime licence. Apart from being able to play c4f the big advantage is I know when I'm going to die. In 29'274 days. Without this vital information available at c4f I will have to memorize a date, find it much easier like this!

Also didn't check much, thought I ride a race today, none available, so no. But good job by the testers, while Donks has lots of time, he didn't really have enough time to get into the whole time consuming testing thing! Viva testers and thank you!
Kraftsystemrevision! Include the distance!
Basics reform: Give blue a chance!
Don't punish bugusers. We all have to use bugs, since most of them are declared as "features"!
Got a carrot from FL. But they threaten to take it away now.

User avatar
flockmastoR
Posts: 3435
Joined: Thu Feb 18, 2010 11:42 pm
Contact:

Re: Database Redesign

Post by flockmastoR » Mon Dec 16, 2024 9:12 am

When I inscribe at a race, I come to the rider inscription, but when I don't inscribe riders and click on another tab (home) and then back to inscription, the "my inscription" tab is not active (cannot click on it)
Boaz Trakhtenbrot:
  • Winner Giro 2022
  • 10 GC wins
  • 16.609 Eternal Points
__________________
Schrödinger's Dogs: Alive & Dead

User avatar
flockmastoR
Posts: 3435
Joined: Thu Feb 18, 2010 11:42 pm
Contact:

Re: Database Redesign

Post by flockmastoR » Mon Dec 16, 2024 10:33 am

flockmastoR wrote:
Mon Dec 16, 2024 9:12 am
When I inscribe at a race, I come to the rider inscription, but when I don't inscribe riders and click on another tab (home) and then back to inscription, the "my inscription" tab is not active (cannot click on it)
Ah, need to go on show, sry was my fault
Boaz Trakhtenbrot:
  • Winner Giro 2022
  • 10 GC wins
  • 16.609 Eternal Points
__________________
Schrödinger's Dogs: Alive & Dead

Chemnitz Pro Cycling Team
Posts: 272
Joined: Mon Jul 25, 2022 12:47 pm
Contact:

Re: Database Redesign

Post by Chemnitz Pro Cycling Team » Mon Dec 16, 2024 11:03 am

Not sure if is has to do with the new version, but how can a rider like this have a worth of 2.6 mio?

https://ibb.co/3MgxxPH

Alkworld
Posts: 1234
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Mon Dec 16, 2024 11:16 am

flockmastoR wrote:
Mon Dec 16, 2024 10:33 am
flockmastoR wrote:
Mon Dec 16, 2024 9:12 am
When I inscribe at a race, I come to the rider inscription, but when I don't inscribe riders and click on another tab (home) and then back to inscription, the "my inscription" tab is not active (cannot click on it)
Ah, need to go on show, sry was my fault
Yes, that's a new feature because you can now already inscribe for multiple races right away. I wasn't sure what makes more sense:
- directly open the next race
- start with the overview

Alkworld
Posts: 1234
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Mon Dec 16, 2024 11:18 am

Chemnitz Pro Cycling Team wrote:
Mon Dec 16, 2024 11:03 am
Not sure if is has to do with the new version, but how can a rider like this have a worth of 2.6 mio?

https://ibb.co/3MgxxPH
ok, I'll need to check if the pave skill (high for this rider) is used in the wrong place

Edit: yes, something is wrong there, most expensive newly generated riders on the TM all have high pave skill

Alkworld
Posts: 1234
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Mon Dec 16, 2024 11:50 am

Alkworld wrote:
Mon Dec 16, 2024 11:18 am
Chemnitz Pro Cycling Team wrote:
Mon Dec 16, 2024 11:03 am
Not sure if is has to do with the new version, but how can a rider like this have a worth of 2.6 mio?

https://ibb.co/3MgxxPH
ok, I'll need to check if the pave skill (high for this rider) is used in the wrong place

Edit: yes, something is wrong there, most expensive newly generated riders on the TM all have high pave skill
Found the problem, fixed it now. Those riders still need to be updated or deleted. TM will be refilled automatically, if I delete them.

Post Reply

Who is online

Users browsing this forum: No registered users and 10 guests