[DiscordArchive] you have custom waypoint_data entries right?
[DiscordArchive] you have custom waypoint_data entries right?
Archived author: ModoX • Posted: 2023-04-28T08:38:27.099000+00:00
Original source
you have custom waypoint_data entries right?
Archived author: mUdY • Posted: 2023-04-28T08:38:57.161000+00:00
Original source
Maybe? It is shared source to me from another dev.
Archived author: ModoX • Posted: 2023-04-28T08:39:49.590000+00:00
Original source
its using some insane high value in `id` field which becomes invalid thru the query in question
Archived author: ModoX • Posted: 2023-04-28T08:40:19.466000+00:00
Original source
aka `(current value << 3)` is > 2^32
Archived author: ModoX • Posted: 2023-04-28T08:40:46.326000+00:00
Original source
tl;dr reduce the custom id values you are using
Archived author: mUdY • Posted: 2023-04-28T08:42:02.235000+00:00
Original source
i send pm if i can
Archived author: ModoX • Posted: 2023-04-28T08:42:52.230000+00:00
Original source
Just write here
Archived author: mUdY • Posted: 2023-04-28T08:43:51.893000+00:00
Original source
i found this line if you think this
Archived author: mUdY • Posted: 2023-04-28T08:43:54.066000+00:00
Original source
-- Shift existing rows by 3 bits to reserve space for 3 other tables
UPDATE `waypoint_data` SET `id`=(`id` << 3) ORDER BY `id` DESC;
Archived author: ModoX • Posted: 2023-04-28T08:44:24.221000+00:00
Original source
Yes thats the line causing the issues on your end