[DiscordArchive] I recompiled from the fork but when I try to start worldserver.exe it doesn’t seem to start and the
[DiscordArchive] I recompiled from the fork but when I try to start worldserver.exe it doesn’t seem to start and the
Original source
I recompiled from the fork but when I try to start worldserver.exe it doesn’t seem to start and the logs have the error: the file 2023_04_02_06.sql applied to the database, but is missing in your updates directory now! (Also has _07-__11). Any ideas of what I should check?
rektbyfaith
04-04-2023, 04:09 AM #1Archived author: shroomshade • Posted: 2023-04-04T04:09:50.122000+00:00
Original source
I recompiled from the fork but when I try to start worldserver.exe it doesn’t seem to start and the logs have the error: the file 2023_04_02_06.sql applied to the database, but is missing in your updates directory now! (Also has _07-__11). Any ideas of what I should check?
Original source
I think the fork is a day or two behind, so it is missing some of the latest SQL updates. You can copy the files it says are missing from the data/sql/updates/db_world directory of the non-NPCBots repo and put them in that directory of the NPCBots fork, then it should no longer complain to them.
rektbyfaith
04-04-2023, 04:12 AM #2Archived author: 郑佩茹 • Posted: 2023-04-04T04:12:48.074000+00:00
Original source
I think the fork is a day or two behind, so it is missing some of the latest SQL updates. You can copy the files it says are missing from the data/sql/updates/db_world directory of the non-NPCBots repo and put them in that directory of the NPCBots fork, then it should no longer complain to them.
Original source
Thanks, I think that fixed that...seems I am getting a different error now:
Closing down DatabasePool 'acore_characters'.
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Could not prepare statements of the Character database, see log for details.
Closing down DatabasePool 'acore_world'.
Asynchronous connections on DatabasePool 'acore_world' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_world' closed.
Closing down DatabasePool 'acore_characters'.
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Closing down DatabasePool 'acore_auth'.
Asynchronous connections on DatabasePool 'acore_auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_auth' closed.
I think I am missing a few steps in the NPCBots install
Merge worldserver.conf.dist into your worldserver.conf file (NPCBot mod settings)
Apply SQL files from /TrinityCore/sql/Bots/ to your DB (files starting with characters_ and world_ go into your characters and world DB respectively):
1_world_bot_appearance.sql
2_world_bot_extras.sql
3_world_bots.sql
4_world_generate_bot_equips.sql
5_world_botgiver.sql
characters_bots.sql
Apply SQL update files from /TrinityCore/sql/Bots/updates to your DB
But am a bit confused about this as I don't see these .sql (or that folder presumably since I'm using the AC repo)
rektbyfaith
04-04-2023, 04:25 AM #3Archived author: shroomshade • Posted: 2023-04-04T04:25:16.485000+00:00
Original source
Thanks, I think that fixed that...seems I am getting a different error now:
Closing down DatabasePool 'acore_characters'.
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Could not prepare statements of the Character database, see log for details.
Closing down DatabasePool 'acore_world'.
Asynchronous connections on DatabasePool 'acore_world' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_world' closed.
Closing down DatabasePool 'acore_characters'.
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Closing down DatabasePool 'acore_auth'.
Asynchronous connections on DatabasePool 'acore_auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_auth' closed.
I think I am missing a few steps in the NPCBots install
Merge worldserver.conf.dist into your worldserver.conf file (NPCBot mod settings)
Apply SQL files from /TrinityCore/sql/Bots/ to your DB (files starting with characters_ and world_ go into your characters and world DB respectively):
1_world_bot_appearance.sql
2_world_bot_extras.sql
3_world_bots.sql
4_world_generate_bot_equips.sql
5_world_botgiver.sql
characters_bots.sql
Apply SQL update files from /TrinityCore/sql/Bots/updates to your DB
But am a bit confused about this as I don't see these .sql (or that folder presumably since I'm using the AC repo)
Original source
May have got it…
rektbyfaith
04-04-2023, 04:39 AM #4Archived author: shroomshade • Posted: 2023-04-04T04:39:05.217000+00:00
Original source
May have got it…
Original source
Yeah I don’t understand the scripts to populate. I don’t see the ones mentioned in the install in the folder…so I get further but like it says ‘creature_template_npcbot_appearance doesn’t exist’ which appears to be because I’m missing .sql scripts but in /data/sql/Bots I only have a locales folder and not the scripts the instructions reference
rektbyfaith
04-04-2023, 05:11 AM #5Archived author: shroomshade • Posted: 2023-04-04T05:11:02.509000+00:00
Original source
Yeah I don’t understand the scripts to populate. I don’t see the ones mentioned in the install in the folder…so I get further but like it says ‘creature_template_npcbot_appearance doesn’t exist’ which appears to be because I’m missing .sql scripts but in /data/sql/Bots I only have a locales folder and not the scripts the instructions reference
Original source
Oh seems like the TC build has the SQL scripts so I guess I will grab them from there and try it.
rektbyfaith
04-04-2023, 05:25 AM #6Archived author: shroomshade • Posted: 2023-04-04T05:25:36.732000+00:00
Original source
Oh seems like the TC build has the SQL scripts so I guess I will grab them from there and try it.
1 Guest(s)
1 Guest(s)