[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
There is something I have noticed and I would like to ask.
Whenever I create a repository of the master branch, if I try to run Worldserver.exe it will close immediately unless I delete the three Auth files that are in the update folder of the sql. Is that normal, or do I need these three files?
rektbyfaith
11-23-2023, 06:16 PM #1Archived author: Nap • Posted: 2023-11-23T18:16:11.084000+00:00
Original source
There is something I have noticed and I would like to ask.
Whenever I create a repository of the master branch, if I try to run Worldserver.exe it will close immediately unless I delete the three Auth files that are in the update folder of the sql. Is that normal, or do I need these three files?
Original source
generally you need the files in the update folder. You might want to check the error message you're getting, it should explain exactly which file isn't importing properly and why. It's almost always a result of a confusion in the 'updates' table of your auth database.
rektbyfaith
11-23-2023, 06:18 PM #2Archived author: Kelpie • Posted: 2023-11-23T18:18:16.582000+00:00
Original source
generally you need the files in the update folder. You might want to check the error message you're getting, it should explain exactly which file isn't importing properly and why. It's almost always a result of a confusion in the 'updates' table of your auth database.
Original source
one thing that can cause the problem also is if you start bnetserver and worldserver at the same time (such as through a script), and tell them both to keep the auth db up to date. This is why by default the bnetserver is set to not automatically update the auth db.
rektbyfaith
11-23-2023, 06:19 PM #3Archived author: Kelpie • Posted: 2023-11-23T18:19:58.808000+00:00
Original source
one thing that can cause the problem also is if you start bnetserver and worldserver at the same time (such as through a script), and tell them both to keep the auth db up to date. This is why by default the bnetserver is set to not automatically update the auth db.
Original source
the error message should appear in server.log
rektbyfaith
11-23-2023, 06:21 PM #4Archived author: Kelpie • Posted: 2023-11-23T18:21:34.477000+00:00
Original source
the error message should appear in server.log
Original source
Found it, 2023_11_21_00_auth.sql': Duplicate column name 'timezone_offset
rektbyfaith
11-23-2023, 06:35 PM #5Archived author: Nap • Posted: 2023-11-23T18:35:05.096000+00:00
Original source
Found it, 2023_11_21_00_auth.sql': Duplicate column name 'timezone_offset
Original source
ok, so I just looked up that sql
rektbyfaith
11-23-2023, 06:50 PM #6Archived author: Kelpie • Posted: 2023-11-23T18:50:18.253000+00:00
Original source
ok, so I just looked up that sql
Original source
it's actually the most recent one, so the rollback will be easy
rektbyfaith
11-23-2023, 06:50 PM #7Archived author: Kelpie • Posted: 2023-11-23T18:50:40.004000+00:00
Original source
it's actually the most recent one, so the rollback will be easy
Original source
delete the column 'timezone_offset'...if you use a visual sql editor, it's easy, otherwise you're going to need to pass a query to alter the table
rektbyfaith
11-23-2023, 06:51 PM #8Archived author: Kelpie • Posted: 2023-11-23T18:51:19.862000+00:00
Original source
delete the column 'timezone_offset'...if you use a visual sql editor, it's easy, otherwise you're going to need to pass a query to alter the table
Original source
then after you've done that, find the updates table in the auth db
rektbyfaith
11-23-2023, 06:51 PM #9Archived author: Kelpie • Posted: 2023-11-23T18:51:46.908000+00:00
Original source
then after you've done that, find the updates table in the auth db
Original source
delete the row marked 2023_11_21_00_auth.sql
rektbyfaith
11-23-2023, 06:52 PM #10Archived author: Kelpie • Posted: 2023-11-23T18:52:02.912000+00:00
Original source
delete the row marked 2023_11_21_00_auth.sql