Quote:
Originally Posted by Huppy
This is not related to my past issue, but tested it out 3 times today to make sure, before I posted this. It's only happening with the peq daily dump of Aug 13 (today's). I have been performing these steps 100's of times when sourcing in a fresh DB.
1. Source in peqbeta.sql
2. Source in player_tables.sql
3. Source in load_login.sql
4. Run shared_memory
5. Run world.exe for updates ........world crashes.
If I repeat these steps with any previous dumps, (including Aug 12th), it works fine. Everything I have, (server related) is fully updated. VS, source code,(aug 11), etc. The problem is isolated to that Aug 13 daily dump. This was in the crash log, if it's of any use. Only thing that stood out to me:
[08-13-2019 :: 13:08:28] [Crash] e:\source test\common\database.cpp (1058 ): Database::LoadZoneNames
[08-13-2019 :: 13:08:28] [Crash] e:\source test\world\net.cpp (319): main
|
Very interesting, I imported a ton of DoN zones last night and we had a zone entry that was null that must have made it into the dump
Run this
Code:
delete from zone where short_name is null;
These were the zones imported
https://docs.google.com/spreadsheets...it?usp=sharing
I also recorded the import process incase we need to go back and see which one we imported from whether it was Norrath Keepers or Dark Reign
https://www.youtube.com/watch?v=1ZSPkBp6uqQ