|
2023 Transfer Discussion
|
| Fabianski |
Posted on 16-08-2023 07:10
|
Grand Tour Specialist
Posts: 4700
Joined: 29-09-2018
PCM$: 185.00
|
First of all: Thanks for making this (provisionally) work again 
Hope a permanent solution can be found quickly, otherwise this forum will be dead soon...
alexkr00 wrote:
I don't think changing the threads IDs will work since I asume the post in the thread are linked to the thread using that ID so you'd also need to make sure you change the thread id in the table with the posts too. I'm just speculating right now though, I have no idea what the structure of the database is.
The first thing that you should probably look into though is if the sequence that generates the thread ids can be modified to support bigger values.
I assume for the posts there's a similar sequence and the we definitely have a lot more posts than threads so the databas should allow for bigger sequence numbers.
If the solution is indeed as easy as just changing the type of the sequence (and maybe ID field), that'd be great. However, would also need to make sure the software (i.e. PHP code) actually supports this - but afaik there's no short int type in PHP, so that should work. But yeah, as a software dev, never say that "it should work", from experience 
In any case, happy to help out with the DB if needed, had some insights already when helping to create the profile threads...
|
| |
|
|
| Ad Bot |
Posted on 21-12-2024 17:08
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| alexkr00 |
Posted on 16-08-2023 07:26
|
World Champion
Posts: 13924
Joined: 05-08-2008
PCM$: 300.00
|
Your post is number 1441942, Fab, so both the software and the database should be able to work with larger numbers than 65535. So, if there's something that works for the posts IDs, I guess it can be done for threads too.
The max number of the threads sequence was probably set to 65535. My hope is that it that this was set as "eh I guess that's big enough, we ain't gonna reach that number pretty soon anyway" or it's just a default value that can be easily modified, rather than it having to do anything with database/software limitations.
I guess changing that should do the trick, or create a new one starting with the latest thread ID + 1 and with a higher max value would do the trick.
But, then again we have no idea what's behind the scenes. I'm sure the guys who take care of the forum on the more technical side know what to do better
|
| |
|
|
| OlegTinkov |
Posted on 16-08-2023 08:52
|
Small Tour Specialist
Posts: 2668
Joined: 31-12-2007
PCM$: 450.00
|
Bump
|
| |
|
|
| cio93 |
Posted on 16-08-2023 18:21
|
World Champion
Posts: 10845
Joined: 29-10-2007
PCM$: 500.00
|
We got a 48th hour one boys!
|
| |
|
|
| cunego59 |
Posted on 16-08-2023 18:23
|
Team Manager
Posts: 6508
Joined: 14-09-2008
PCM$: 1090.00
|
18 minutes is rough ...
|
| |
|
|
| cio93 |
Posted on 16-08-2023 19:12
|
World Champion
Posts: 10845
Joined: 29-10-2007
PCM$: 500.00
|
Kinda happy now that I'm not getting Hessmann, I guess 
|
| |
|
|
| roturn |
Posted on 16-08-2023 19:18
|
Team Manager
Posts: 22247
Joined: 24-11-2007
PCM$: 3900.00
|
cio93 wrote:
Kinda happy now that I'm not getting Hessmann, I guess
 |
| |
|
|
| whitejersey |
Posted on 16-08-2023 19:26
|
Classics Specialist
Posts: 2919
Joined: 07-08-2011
PCM$: 300.00
|
Thouight this was about the fee, then I checked my preferred cycling news site
|
| |
|
|
| DubbelDekker |
Posted on 16-08-2023 20:52
|
Small Tour Specialist
Posts: 2645
Joined: 20-04-2008
PCM$: 200.00
|
I agree that under normal conditions changing the type of the MySQL column storing the thread ID's from an unsigned SMALLINT to an unsigned MEDIUMINT should fix this problem without causing issues. That changes the maximum value from 65535 to 16777215.
https://dev.mysql...types.html
And PHP doesn't care about that difference at all. An integer is an integer.
Even a strongly typed language like Go wouldn't care.
But like Fab and alex correctly pointed out; "it should work" is not good enough in the world of software.
So before you try anything make sure there are at least two up-to-date full database backups stored in different locations.
|
| |
|
|
| SportingNonsense |
Posted on 16-08-2023 23:23
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
DubbelDekker wrote:
I agree that under normal conditions changing the type of the MySQL column storing the thread ID's from an unsigned SMALLINT to an unsigned MEDIUMINT should fix this problem without causing issues. That changes the maximum value from 65535 to 16777215.
https://dev.mysql...types.html
And PHP doesn't care about that difference at all. An integer is an integer.
Even a strongly typed language like Go wouldn't care.
But like Fab and alex correctly pointed out; "it should work" is not good enough in the world of software.
So before you try anything make sure there are at least two up-to-date full database backups stored in different locations.
Yeh, it does look like it "should" work.
In the posts database, thread id is actually already defined as mediumint, alongside post id.
It's just in the threads database, where thread id set as smallint.
But indeed - since the transfers workaround does work for now, we haven't just gone in and made the change straight off.
|
| |
|
|
| OlegTinkov |
Posted on 17-08-2023 04:04
|
Small Tour Specialist
Posts: 2668
Joined: 31-12-2007
PCM$: 450.00
|
|
| |
|
|
| Ulrich Ulriksen |
Posted on 17-08-2023 05:19
|
Directeur Sportif
Posts: 3301
Joined: 02-11-2010
PCM$: 300.00
|
Those are beautiful. Thank you.
Man Game: McCormick Pro Cycling |
| |
|
|
| jandal7 |
Posted on 17-08-2023 05:29
|
World Champion
Posts: 11406
Joined: 17-12-2014
PCM$: 1120.00
|
Wow love it Oleg, great effort from you! I still will use the ones KenL did for us but I appreciate the thought a lot nevertheless 
24/02/21 - kandesbunzler said “I don't drink famous people."
15/08/22 - SotD said "Your [jandal's] humour is overrated"
11/06/24 - knockout said "Winning is fine I guess. Truth be told this felt completely unimportant."
[ICL] Santos-Euskadi | [PT]  Xero Racing
5x  x5
2x  x2
2x  x2 |
| |
|
|
| ivaneurope |
Posted on 17-08-2023 05:54
|
Classics Specialist
Posts: 2938
Joined: 09-05-2011
PCM$: 300.00
|
Great effort to provide bespoke customized wheels for every PT and PCT team. I'll use the custom wheels for this season. Thank you
|
| |
|
|
| tsmoha |
Posted on 17-08-2023 06:11
|
Directeur Sportif
Posts: 11819
Joined: 19-07-2010
PCM$: 300.00
|
Awesome, Oleg. Thanks s lot!
|
| |
|
|
| DubbelDekker |
Posted on 17-08-2023 15:10
|
Small Tour Specialist
Posts: 2645
Joined: 20-04-2008
PCM$: 200.00
|
Looks great Oleg, thanks!
|
| |
|
|
| Scorchio |
Posted on 17-08-2023 15:28
|
Small Tour Specialist
Posts: 2073
Joined: 14-09-2013
PCM$: 4500.00
|
Everything looks fantastic with the graphics presented OT, thanks!
Manager of ISA - Hexacta in the MG |
| |
|
|
| Ollfardh |
Posted on 17-08-2023 15:31
|
World Champion
Posts: 14589
Joined: 08-08-2011
PCM$: 9200.00
|
Wow!
Changed my sig, this was getting absurd.
|
| |
|
|
| Fabianski |
Posted on 17-08-2023 15:34
|
Grand Tour Specialist
Posts: 4700
Joined: 29-09-2018
PCM$: 185.00
|
Cool, thanks a lot!
Do we have to do anything to get them included, or will they be added to the DB by default if we don't object?
|
| |
|
|
| sammyt93 |
Posted on 17-08-2023 15:35
|
Classics Specialist
Posts: 3635
Joined: 03-07-2012
PCM$: 300.00
|
Equipment looks great
And I did try and sell you my Russian rider lol
|
| |
|
