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 » Thu Nov 28, 2024 10:07 am

drei.zehn wrote:
Thu Nov 28, 2024 9:38 am
No reg during the restday
Seems like i got reg everyone is back to fit
Hansa

est. 03.08.2009

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

Re: Database Redesign

Post by flockmastoR » Thu Nov 28, 2024 10:13 am

Hansa wrote:
Tue Nov 26, 2024 11:19 am
Time in Team classement is not in the usual format but possibly in seconds?
Yeah still the case
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 Nov 28, 2024 10:58 am

8 rsv lünen

Umlaute doesnt work in statistics

rookie division only has 35 teams, in the old datatbase its 2919 so some teams missing
Hansa

est. 03.08.2009

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

Re: Database Redesign

Post by drei.zehn » Thu Nov 28, 2024 12:57 pm

Hansa wrote:
Thu Nov 28, 2024 10:07 am
drei.zehn wrote:
Thu Nov 28, 2024 9:38 am
No reg during the restday
Seems like i got reg everyone is back to fit
Had a rider with 50 reg, but started with ca 720

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

Re: Database Redesign

Post by Alkworld » Thu Nov 28, 2024 2:39 pm

Hansa wrote:
Thu Nov 28, 2024 10:58 am
8 rsv lünen

Umlaute doesnt work in statistics

rookie division only has 35 teams, in the old datatbase its 2919 so some teams missing
that's just not migrated data, one step I forgot in the test version

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

Re: Database Redesign

Post by Alkworld » Thu Nov 28, 2024 2:51 pm

drei.zehn wrote:
Thu Nov 28, 2024 12:57 pm
Hansa wrote:
Thu Nov 28, 2024 10:07 am
drei.zehn wrote:
Thu Nov 28, 2024 9:38 am
No reg during the restday
Seems like i got reg everyone is back to fit
Had a rider with 50 reg, but started with ca 720
Important detail: the rider in question is a 20yo, they are excluded from the day change. They will be excluded from signing up as well again.

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

Re: Database Redesign

Post by drei.zehn » Thu Nov 28, 2024 3:21 pm

Alkworld wrote:
Thu Nov 28, 2024 2:51 pm
drei.zehn wrote:
Thu Nov 28, 2024 12:57 pm
Hansa wrote:
Thu Nov 28, 2024 10:07 am
drei.zehn wrote:
Thu Nov 28, 2024 9:38 am
No reg during the restday
Seems like i got reg everyone is back to fit
Had a rider with 50 reg, but started with ca 720
Important detail: the rider in question is a 20yo, they are excluded from the day change. They will be excluded from signing up as well again.
Ah totally forgot about that again xD

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

Re: Database Redesign

Post by Alkworld » Thu Nov 28, 2024 8:22 pm

Fixes for the following bugs with latest version:
- salary during NC
- twice double reg after half stage
- wrong TTT result in news
- No chat refresh on race refresh
- sprint energy set as rider energy after race
- signing up 20yo
- teams missing in stats --> division 6
- counting offline days during tours

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

Re: Database Redesign

Post by Hansa » Fri Nov 29, 2024 10:05 am

I cant test resetting as i cant sell all my riders, the 6 riders left in my team cannot be sold i cant an error for riders are still active in a race (they are not) but probably they are still active in the race where i was able to ride with not enough riders?
Hansa

est. 03.08.2009

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

Re: Database Redesign

Post by Alkworld » Fri Nov 29, 2024 11:42 am

Hansa wrote:
Fri Nov 29, 2024 10:05 am
I cant test resetting as i cant sell all my riders, the 6 riders left in my team cannot be sold i cant an error for riders are still active in a race (they are not) but probably they are still active in the race where i was able to ride with not enough riders?
I'll check that ...

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

Re: Database Redesign

Post by Alkworld » Fri Nov 29, 2024 5:26 pm

Hansa wrote:
Fri Nov 29, 2024 10:05 am
I cant test resetting as i cant sell all my riders, the 6 riders left in my team cannot be sold i cant an error for riders are still active in a race (they are not) but probably they are still active in the race where i was able to ride with not enough riders?
Looks like it was the race where you weren't fully signed up, which at that time produced data, which is now found. I cleaned it up, feel free to try again.

Edit: works fine, I just sold Max

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

Re: Database Redesign

Post by Hansa » Fri Nov 29, 2024 9:53 pm

esc did ride alone at 14h today,

he abandoned the race at km 110 and it seems like race is stuck there
Hansa

est. 03.08.2009

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

Re: Database Redesign

Post by Hansa » Fri Nov 29, 2024 9:55 pm

Alkworld wrote:
Fri Nov 29, 2024 5:26 pm
Hansa wrote:
Fri Nov 29, 2024 10:05 am
I cant test resetting as i cant sell all my riders, the 6 riders left in my team cannot be sold i cant an error for riders are still active in a race (they are not) but probably they are still active in the race where i was able to ride with not enough riders?
Looks like it was the race where you weren't fully signed up, which at that time produced data, which is now found. I cleaned it up, feel free to try again.

Edit: works fine, I just sold Max
Technical Error

Error Code: 0
Error Message: Team Reset is only allowed for lower divisions

can you send me back to div 6 please :D
Hansa

est. 03.08.2009

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

Re: Database Redesign

Post by Hansa » Fri Nov 29, 2024 10:00 pm

Some of my riders sold yesterday, doesnt exist anymore

2024-11-29 Sale Raphael Schlattinger
2024-11-29 Sale Hans Wahli
2024-11-29 Sale Emil Kellenberger

these 3 and Max if i click on their name i get an error code
Hansa

est. 03.08.2009

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

Re: Database Redesign

Post by drei.zehn » Fri Nov 29, 2024 11:06 pm

Is it planned that we already hat a month change on test server?


And I had a problem naming a new rider.
3 of them worked

4th one I had to do it 3 times and still needed to login again before it was shown

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

Re: Database Redesign

Post by Alkworld » Sat Nov 30, 2024 10:33 am

Hansa wrote:
Fri Nov 29, 2024 9:55 pm
Technical Error

Error Code: 0
Error Message: Team Reset is only allowed for lower divisions

can you send me back to div 6 please :D
I tested the month change in the meantime and you were promoted ;)

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

Re: Database Redesign

Post by Alkworld » Sat Nov 30, 2024 10:34 am

Hansa wrote:
Fri Nov 29, 2024 10:00 pm
Some of my riders sold yesterday, doesnt exist anymore

2024-11-29 Sale Raphael Schlattinger
2024-11-29 Sale Hans Wahli
2024-11-29 Sale Emil Kellenberger

these 3 and Max if i click on their name i get an error code
39yo are supposed to be sold automatically, maybe age restriction was wrong

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

Re: Database Redesign

Post by lennylenny » Sat Nov 30, 2024 10:51 am

Alkworld wrote:
Sat Nov 30, 2024 10:34 am
Hansa wrote:
Fri Nov 29, 2024 10:00 pm
Some of my riders sold yesterday, doesnt exist anymore

2024-11-29 Sale Raphael Schlattinger
2024-11-29 Sale Hans Wahli
2024-11-29 Sale Emil Kellenberger

these 3 and Max if i click on their name i get an error code
39yo are supposed to be sold automatically, maybe age restriction was wrong
what happens with 39 yo that are in a tour during the month change? is that tested yet?
Spelling mistakes are Special functions Like bugs that are functions of the game

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

Re: Database Redesign

Post by Hansa » Sat Nov 30, 2024 10:56 am

Alkworld wrote:
Sat Nov 30, 2024 10:34 am
Hansa wrote:
Fri Nov 29, 2024 10:00 pm
Some of my riders sold yesterday, doesnt exist anymore

2024-11-29 Sale Raphael Schlattinger
2024-11-29 Sale Hans Wahli
2024-11-29 Sale Emil Kellenberger

these 3 and Max if i click on their name i get an error code
39yo are supposed to be sold automatically, maybe age restriction was wrong
But they werent sold automatically, i sold them and they werent 39 years
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:15 am

Hansa wrote:
Sat Nov 30, 2024 10:56 am
But they werent sold automatically, i sold them and they werent 39 years
ah, you mean they are not shown as ex riders?

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

Re: Database Redesign

Post by Alkworld » Sat Nov 30, 2024 11:16 am

lennylenny wrote:
Sat Nov 30, 2024 10:51 am
Alkworld wrote:
Sat Nov 30, 2024 10:34 am
Hansa wrote:
Fri Nov 29, 2024 10:00 pm
Some of my riders sold yesterday, doesnt exist anymore

2024-11-29 Sale Raphael Schlattinger
2024-11-29 Sale Hans Wahli
2024-11-29 Sale Emil Kellenberger

these 3 and Max if i click on their name i get an error code
39yo are supposed to be sold automatically, maybe age restriction was wrong
what happens with 39 yo that are in a tour during the month change? is that tested yet?
They'll still be sold (but not yet tested). The change is mainly so riders don't just silently disappear, that way, the teams still get their value

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

Re: Database Redesign

Post by Hansa » Sat Nov 30, 2024 1:39 pm

Alkworld wrote:
Sat Nov 30, 2024 11:15 am
Hansa wrote:
Sat Nov 30, 2024 10:56 am
But they werent sold automatically, i sold them and they werent 39 years
ah, you mean they are not shown as ex riders?
they shouldnt been shown as ex riders, schlattinger is 21 years old :D
Max is 32 years old they both should be on the transfer market but they are not, and if i go on my team on transfer and click on their names there its lead to an error code

Max is even not anymore found in statistics neither as ex riders nor at riders
Hansa

est. 03.08.2009

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

Re: Database Redesign

Post by Hansa » 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.
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 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:

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

Re: Database Redesign

Post by Alkworld » Sat Nov 30, 2024 4:45 pm

fixed the reset, sold all my riders, put myself in Div 6 and did the reset. Bad ide, lost a few millions with it :lol:

Edit: I'll try to setup the DB again from the original. Then there are also more races to choose from.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest