[DiscordArchive] There is something I have noticed and I would like to ask.
[DiscordArchive] There is something I have noticed and I would like to ask.
Original source
then start worldserver again (not bnetserver until worldserver has finished updating the auth table)
rektbyfaith
11-23-2023, 06:52 PM #11Archived author: Kelpie • Posted: 2023-11-23T18:52:38.562000+00:00
Original source
then start worldserver again (not bnetserver until worldserver has finished updating the auth table)
Original source
(if no such row exists, don't worry about deleting it...you just want to make sure any trace of that update is removed before trying to patch it again)
rektbyfaith
11-23-2023, 06:53 PM #12Archived author: Kelpie • Posted: 2023-11-23T18:53:26.388000+00:00
Original source
(if no such row exists, don't worry about deleting it...you just want to make sure any trace of that update is removed before trying to patch it again)
Original source
the proper SQL queries you want to pass are:
rektbyfaith
11-23-2023, 06:55 PM #13Archived author: Kelpie • Posted: 2023-11-23T18:55:13.003000+00:00
Original source
the proper SQL queries you want to pass are:
Original source
ALTER TABLE `account` DROP COLUMN `timezone_offset`;
rektbyfaith
11-23-2023, 06:55 PM #14Archived author: Kelpie • Posted: 2023-11-23T18:55:38.029000+00:00
Original source
ALTER TABLE `account` DROP COLUMN `timezone_offset`;
Original source
DELETE FROM `updates` WHERE `name`='2023_11_21_00_auth.sql';
rektbyfaith
11-23-2023, 06:57 PM #15Archived author: Kelpie • Posted: 2023-11-23T18:57:25.154000+00:00
Original source
DELETE FROM `updates` WHERE `name`='2023_11_21_00_auth.sql';
Original source
and if you've set bnetserver to automatically update the auth table, turn that off, because that's my biggest guess to what happened (both programs tried to update the same table at the same time causing the same query to attempt to be applied twice).
rektbyfaith
11-23-2023, 07:00 PM #16Archived author: Kelpie • Posted: 2023-11-23T19:00:38.808000+00:00
Original source
and if you've set bnetserver to automatically update the auth table, turn that off, because that's my biggest guess to what happened (both programs tried to update the same table at the same time causing the same query to attempt to be applied twice).
Original source
![[Image: image.png?ex=690c4aa6&is=690af926&hm=24b...4657bc26f&]](https://cdn.discordapp.com/attachments/376457124726702080/1177326126859821238/image.png?ex=690c4aa6&is=690af926&hm=24bc47b1b74a27efb37f1fff81d022754797bf38473cf341cf2a0334657bc26f&)
rektbyfaith
11-23-2023, 07:13 PM #17Archived author: Nap • Posted: 2023-11-23T19:13:42.356000+00:00
Original source
Original source
![[Image: image.png?ex=690c4af0&is=690af970&hm=285...844ad6f62&]](https://cdn.discordapp.com/attachments/376457124726702080/1177326439188672663/image.png?ex=690c4af0&is=690af970&hm=285f2f0fb3790d0ec9125bdb8b274db94c22c48e52cfc4d1b769b25844ad6f62&)
rektbyfaith
11-23-2023, 07:14 PM #18Archived author: Nap • Posted: 2023-11-23T19:14:56.828000+00:00
Original source
Original source
Actually the first one gives errors so i deleted the whole line
rektbyfaith
11-23-2023, 07:16 PM #19Archived author: Nap • Posted: 2023-11-23T19:16:39.944000+00:00
Original source
Actually the first one gives errors so i deleted the whole line
Original source
Yes, finally it worked
rektbyfaith
11-23-2023, 07:24 PM #20Archived author: Nap • Posted: 2023-11-23T19:24:14.207000+00:00
Original source
Yes, finally it worked
1 Guest(s)
1 Guest(s)