Zone.exe Crash

[whiteknight33]

I had my server up and running well, then out of nowhere I'm getting zone.exe crashes left and right.

This happened while I was attempting to add a buffing NPC to poknowledge. Can someone tell me what is wrong and how to fix this please?

[09-11-2016 :: 07:25:46] [Crash] EXCEPTION_ACCESS_VIOLATION
[09-11-2016 :: 07:25:46] [Crash] SymInit: Symbol-SearchPath: '.;C:\EQ\EQEmuServer;C:\EQ\EQEmuServer;C:\WINDOWS;C:\WINDOWS\system32;SRV*C:\websymbols*http://msdl.microsoft.com/download/symbols;', symOptions: 530, UserName: 'fatty' 
[09-11-2016 :: 07:25:46] [Crash] OS-Version: 6.2.9200 () 0x100-0x1 
[09-11-2016 :: 07:25:46] [Crash] C:\EQ\EQEmuServer\zone.exe:zone.exe (009B0000), size: 9719808 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEmuServer\zone.exe' 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\SYSTEM32\ntdll.dll:ntdll.dll (76ED0000), size: 1581056 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ntdll.dll', fileVersion: 6.2.14393.103 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\KERNEL32.DLL:KERNEL32.DLL (769B0000), size: 917504 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\KERNEL32.DLL', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\KERNELBASE.dll:KERNELBASE.dll (75220000), size: 1708032 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\KERNELBASE.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\WS2_32.dll:WS2_32.dll (753D0000), size: 405504 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\WS2_32.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\sechost.dll:sechost.dll (768B0000), size: 266240 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\sechost.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\EQ\EQEmuServer\LIBMYSQL.dll:LIBMYSQL.dll (6D800000), size: 2924544 (result: 0), SymType: '-exported-', PDB: 'C:\EQ\EQEmuServer\LIBMYSQL.dll' 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\RPCRT4.dll:RPCRT4.dll (761D0000), size: 790528 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\RPCRT4.dll', fileVersion: 6.2.14393.82 
[09-11-2016 :: 07:25:46] [Crash] C:\EQ\EQEmuServer\zlib1.dll:zlib1.dll (62E80000), size: 139264 (result: 0), SymType: '-exported-', PDB: 'C:\EQ\EQEmuServer\zlib1.dll', fileVersion: 1.2.8.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\SspiCli.dll:SspiCli.dll (73A10000), size: 122880 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\SspiCli.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\CRYPTBASE.dll:CRYPTBASE.dll (73A00000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\CRYPTBASE.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\msvcrt.dll:msvcrt.dll (75740000), size: 778240 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\msvcrt.dll', fileVersion: 7.0.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\bcryptPrimitives.dll:bcryptPrimitives.dll (76E70000), size: 368640 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\bcryptPrimitives.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\EQ\EQEmuServer\lua51.dll:lua51.dll (6E440000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\EQ\EQEmuServer\lua51.dll' 
[09-11-2016 :: 07:25:46] [Crash] C:\Perl\bin\perl512.dll:perl512.dll (28000000), size: 1273856 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\bin\perl512.dll', fileVersion: 5.12.3.1204 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\ADVAPI32.dll:ADVAPI32.dll (75F60000), size: 487424 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\ADVAPI32.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\USER32.dll:USER32.dll (75800000), size: 1437696 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\USER32.dll', fileVersion: 6.2.14393.5 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\win32u.dll:win32u.dll (761B0000), size: 86016 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\win32u.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\GDI32.dll:GDI32.dll (75960000), size: 176128 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\GDI32.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\SYSTEM32\VERSION.dll:VERSION.dll (73030000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\VERSION.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\SYSTEM32\MSVCR110.dll:MSVCR110.dll (6E360000), size: 876544 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSVCR110.dll', fileVersion: 11.0.51106.1 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\gdi32full.dll:gdi32full.dll (75FE0000), size: 1421312 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\gdi32full.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.14393.0_none_88fef4c26039fb25\COMCTL32.dll:COMCTL32.dll (6E2C0000), size: 606208 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.14393.0_none_88fef4c26039fb25\COMCTL32.dll', fileVersion: 5.82.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\IMM32.DLL:IMM32.DLL (76A90000), size: 151552 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\IMM32.DLL', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\system32\napinsp.dll:napinsp.dll (6F990000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\napinsp.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\system32\pnrpnsp.dll:pnrpnsp.dll (6F970000), size: 90112 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\pnrpnsp.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\system32\NLAapi.dll:NLAapi.dll (6F950000), size: 81920 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\NLAapi.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\mswsock.dll:mswsock.dll (719B0000), size: 319488 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\mswsock.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\SYSTEM32\DNSAPI.dll:DNSAPI.dll (706A0000), size: 507904 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\DNSAPI.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\NSI.dll:NSI.dll (76900000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\NSI.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL:IPHLPAPI.DLL (734A0000), size: 192512 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\winrnr.dll:winrnr.dll (6FF30000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\winrnr.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\Windows\System32\rasadhlp.dll:rasadhlp.dll (70210000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\rasadhlp.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\fwpuclnt.dll:fwpuclnt.dll (701C0000), size: 299008 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\fwpuclnt.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\SYSTEM32\bcrypt.dll:bcrypt.dll (729A0000), size: 110592 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\bcrypt.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\SYSTEM32\dbghelp.dll:dbghelp.dll (71710000), size: 1331200 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\dbghelp.dll', fileVersion: 6.2.14321.1024 
[09-11-2016 :: 07:25:46] [Crash] C:\WINDOWS\System32\ucrtbase.dll:ucrtbase.dll (73CA0000), size: 917504 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\ucrtbase.dll', fileVersion: 6.2.14393.0 
[09-11-2016 :: 07:25:46] [Crash] c:\eqemu\master\zone\bot_command.cpp (128): BCSpells::Load 
[09-11-2016 :: 07:25:46] [Crash] c:\eqemu\master\zone\bot_command.cpp (1457): bot_command_init 
[09-11-2016 :: 07:25:46] [Crash] c:\eqemu\master\zone\net.cpp (368): main 
[09-11-2016 :: 07:25:46] [Crash] f:\dd\vctools\crt\vcstartup\src\startup\exe_common.inl (255): __scrt_common_main_seh 
[09-11-2016 :: 07:25:46] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 769C62C4) 
[09-11-2016 :: 07:25:46] [Crash] 769C62C4 (KERNEL32): (filename not available): BaseThreadInitThunk 
[09-11-2016 :: 07:25:46] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 76F30609) 
[09-11-2016 :: 07:25:46] [Crash] 76F30609 (ntdll): (filename not available): RtlSubscribeWnfStateChangeNotification 
[09-11-2016 :: 07:25:46] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 76F305D4) 
[09-11-2016 :: 07:25:46] [Crash] 76F305D4 (ntdll): (filename not available): RtlSubscribeWnfStateChangeNotification

[Uleat]

You definitely need to provide more information as to what you are/were doing.

From that stack trace, it looks like something is wrong with a crt calling convention...

Do you have all of the appropriate run-time libraries installed?


I wrote that code myself and have never had that error come up during any of my server up-time, nor has it been reported by the many people who run bots servers.

[whiteknight33]

I was trying to add an NPC to the Plane of Knowledge that you could Hail, then respond to him and he would cast some buffs on you.

Rather than using typical player buffs, I was attempting to have him cast a couple of buffs that appeared to be unused but were in the same vein as player spells. (I was trying to edit them to have ridiculous durations.)

The two spells, specifically, were Endeavor (10152) and Refraction of Light (8464).

When I had the NPC casting them, there was something wrong. He would put a type of Engulfing Darkness and Bard HP/Mana Regen song on my character that would last 27 minutes. And I could click them both off, despite the Engulfing Darkness type one being red and damaging my character.

I tried for a little while to figure out what was wrong with the buffs because I didn't see anything different with them than with typical player spells... Then I tried copying them in the database and giving them new spell ID numbers. After I did that, I updated the ID numbers in my NPC's quest to buff.

After that, I tried rebooting the server and found out that I couldn't zone into PoK. That's when I checked everything and realized that zone.exe was now crashing every time it started. Naturally, I tried undoing everything that I'd just done, but it didn't fix anything.

Everything was working flawlessly before this.

[joligario]

Bots were trying to load your custom spell(s) and crashed the zone.

[Uleat]

If that's the case...

Not real sure as to why this would cause a crash: https://github.com/EQEmu/Server/blob...mmand.cpp#L128

Spells should have valid entries up to SPDAT_RECORDS..unless, I'm missing something.

Did you re-run shared_memory?

[whiteknight33]

Originally Posted by Uleat

If that's the case...

Not real sure as to why this would cause a crash: https://github.com/EQEmu/Server/blob...mmand.cpp#L128

Spells should have valid entries up to SPDAT_RECORDS..unless, I'm missing something.

Did you re-run shared_memory?

I didn't know to do that. Running shared_memory.exe appears to have fixed the problem. Thank you!

[whiteknight33]

Okay, so the server is running again, but now I'm experiencing a new problem.

The guild window no longer works and upon logging into the game, I'm getting...

[MySQL Error] 1146: Table 'peq.vw_bot_character_mobs' doesn't exist
--- SELECT c.`id', c.'name', c.'class', c.'level', c.'last_login', c.'zone_id', g.'guild_id',
g.'rank', g.'tribute_enable', g.'total_tribute', g.'last_tribute', g.'banker', g.'public_note',
g.'alt' FROM 'vw_bot_character_mobs' AS cLEFT JOIN 'vw_guild_members' AS g ON
c.'id' = g.'char_id' AND c.'mob_type' = g.'mob_type' WHERE g.guild_id=2

If someone can guide me in fixing this, I should be all set.

[Uleat]

Run this query and report the results:

SHOW TABLES LIKE 'vw%';

EDIT:

Curious notation..

... AS cLEFT JOIN ...

No space between c and LEFT...

[whiteknight33]

;MariaDB [peq]> SHOW TABLES LIKE 'vw%';
+---------------------+
| Tables_in_peq (vw%) |
+---------------------+
| vwmercnpctypes      |
+---------------------+
1 row in set (0.00 sec)

MariaDB [peq]>

The lack of a space was probably because I typed that one by hand, from eyeballing it in the EQ chat window.

[Uleat]

I did find the ref at: https://github.com/EQEmu/Server/blob..._base.cpp#L869

..and it does appear to be correct.


You don't appear to have any views in place..much less the proper ones.

And since those are missing, you're probably missing the functions as well.


I hate giving manual instructions because of the many nuances involved..and they're not things easily scripted...

But, assuming that everything else is up-to-date..you can try running this: http://wiki.eqemulator.org/i?Module=...Paste=V9CISaf7

[whiteknight33]

Originally Posted by Uleat

I did find the ref at: https://github.com/EQEmu/Server/blob..._base.cpp#L869

..and it does appear to be correct.


You don't appear to have any views in place..much less the proper ones.

And since those are missing, you're probably missing the functions as well.


I hate giving manual instructions because of the many nuances involved..and they're not things easily scripted...

But, assuming that everything else is up-to-date..you can try running this: http://wiki.eqemulator.org/i?Module=...Paste=V9CISaf7

I tried the copy and paste method and this is what it gave me:

MariaDB [peq]> DROP VIEW IF EXISTS `vwbotcharactermobs`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP VIEW IF EXISTS `vwbotgroups`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP VIEW IF EXISTS `vwgroups`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP VIEW IF EXISTS `vwguildmembers`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]>
MariaDB [peq]> DROP VIEW IF EXISTS `vwBotCharacterMobs`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP VIEW IF EXISTS `vwBotGroups`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP VIEW IF EXISTS `vwGroups`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP VIEW IF EXISTS `vwGuildMembers`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]>
MariaDB [peq]> DROP VIEW IF EXISTS `vw_bot_character_mobs`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP VIEW IF EXISTS `vw_bot_groups`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP VIEW IF EXISTS `vw_groups`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP VIEW IF EXISTS `vw_guild_members`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]>
MariaDB [peq]> DROP FUNCTION IF EXISTS `GetMobType`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP FUNCTION IF EXISTS `GetMobTypeByName`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]> DROP FUNCTION IF EXISTS `GetMobTypeByID`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [peq]>
MariaDB [peq]>
MariaDB [peq]> DELIMITER $$
MariaDB [peq]>
MariaDB [peq]> CREATE FUNCTION `GetMobType` (mob_name VARCHAR(64)) RETURNS CHAR(1)
    -> BEGIN
    -> DECLARE Result CHAR(1);
    ->
    -> SET Result = NULL;
    ->
    -> IF ((SELECT COUNT(*) FROM `character_data` WHERE `name` = mob_name) > 0) THEN
    -> SET Result = 'C';
    -> ELSEIF ((SELECT COUNT(*) FROM `bot_data` WHERE `name` = mob_name) > 0) THEN
    -> SET Result = 'B';
    -> END IF;
    ->
    -> RETURN Result;
    -> END$$
Query OK, 0 rows affected (0.00 sec)

MariaDB [peq]>
MariaDB [peq]> CREATE FUNCTION `GetMobTypeById` (mob_id INTEGER UNSIGNED) RETURNS CHAR(1)
    -> BEGIN
    -> DECLARE Result CHAR(1);
    ->
    -> SET Result = NULL;
    ->
    -> IF ((select `id` from `character_data` where `id` = mob_id) > 0) THEN
    -> SET Result = 'C';
    -> ELSEIF ((select `bot_id` from `bot_data` where `bot_id` = mob_id) > 0) THEN
    -> SET Result = 'B';
    -> END IF;
    ->
    -> RETURN Result;
    -> END$$
Query OK, 0 rows affected (0.00 sec)

MariaDB [peq]>
MariaDB [peq]> DELIMITER ;
MariaDB [peq]>
MariaDB [peq]>
MariaDB [peq]> CREATE VIEW `vw_bot_character_mobs` AS
    -> SELECT
    -> _utf8'C' AS mob_type,
    -> c.`id`,
    -> c.`name`,
    -> c.`class`,
    -> c.`level`,
    -> c.`last_login`,
    -> c.`zone_id`
    -> FROM `character_data` AS c
    -> UNION ALL
    -> SELECT _utf8'B' AS mob_type,
    -> b.`bot_id` AS id,
    -> b.`name`,
    -> b.`class`,
    -> b.`level`,
    -> b.`last_spawn` AS last_login,
    -> b.`zone_id`
    -> FROM `bot_data` AS b;
Query OK, 0 rows affected (0.02 sec)

MariaDB [peq]>
MariaDB [peq]> CREATE VIEW `vw_bot_groups` AS
    -> SELECT
    -> g.`groups_index`,
    -> g.`group_name`,
    -> g.`group_leader_id`,
    -> b.`name` AS group_leader_name,
    -> b.`owner_id`,
    -> c.`name` AS owner_name
    -> FROM `bot_groups` AS g
    -> JOIN `bot_data` AS b ON g.`group_leader_id` = b.`bot_id`
    -> JOIN `character_data` AS c ON b.`owner_id` = c.`id`
    -> ORDER BY b.`owner_id`, g.`group_name`;
ERROR 1146 (42S02): Table 'peq.bot_groups' doesn't exist
MariaDB [peq]>
MariaDB [peq]> CREATE VIEW `vw_groups` AS
    -> SELECT
    -> g.`groupid` AS group_id,
    -> GetMobType(g.`name`) AS mob_type,
    -> g.`name` AS name,
    -> g.`charid` AS mob_id,
    -> IFNULL(c.`level`, b.`level`) AS level
    -> FROM `group_id` AS g
    -> LEFT JOIN `character_data` AS c ON g.`name` = c.`name`
    -> LEFT JOIN `bot_data` AS b ON g.`name` = b.`name`;
Query OK, 0 rows affected (0.01 sec)

MariaDB [peq]>
MariaDB [peq]> CREATE VIEW `vw_guild_members` AS
    -> SELECT
    -> 'C' AS mob_type,
    -> cm.`char_id`,
    -> cm.`guild_id`,
    -> cm.`rank`,
    -> cm.`tribute_enable`,
    -> cm.`total_tribute`,
    -> cm.`last_tribute`,
    -> cm.`banker`,
    -> cm.`public_note`,
    -> cm.`alt`
    -> FROM `guild_members` AS cm
    -> UNION ALL
    -> SELECT
    -> 'B' AS mob_type,
    -> bm.`bot_id` AS char_id,
    -> bm.`guild_id`,
    -> bm.`rank`,
    -> bm.`tribute_enable`,
    -> bm.`total_tribute`,
    -> bm.`last_tribute`,
    -> bm.`banker`,
    -> bm.`public_note`,
    -> bm.`alt`
    -> FROM `bot_guild_members` AS bm;
ERROR 1146 (42S02): Table 'peq.bot_guild_members' doesn't exist

[Uleat]

What does

SHOW TABLES LIKE 'bot%';

..show?

[whiteknight33]

MariaDB [peq]> SHOW TABLES LIKE 'bot%';
+---------------------------+
| Tables_in_peq (bot%)      |
+---------------------------+
| bot_command_settings      |
| bot_data                  |
| bot_heal_rotation_members |
| bot_heal_rotation_targets |
| bot_heal_rotations        |
+---------------------------+
5 rows in set (0.00 sec)

[Uleat]

It looks like you haven't had bots going at all yet..if so...


Run eqemu_server.pl manually..

Go into database, then run the drop bots schema..

Exit back to main..

And re-run the setup bots schema..

..and see what that gives you.

[whiteknight33]

>>> Database Menu

 [backup_database]              Back up database to backups/ directory
 [backup_player_tables]         Back up player tables to backups/ directory
 [backup_database_compressed]   Back up database compressed to backups/ directory

 [check_db_updates]             Checks for database updates manually
 [check_bot_db_updates]         Checks for bot database updates

 [aa_tables]                    Downloads and installs clean slate AA data from PEQ
 [remove_duplicate_rules]       Removes duplicate rules from rule_values table
 [drop_bots_db_schema]          Removes bot database schema

> main - go back to main menu
Enter a command #> drop_bots_db_schema
[Database] Fetching drop_bots.sql...
[Download] Saved: (db_update/drop_bots.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bots/drop_bots.sql
ERROR 1217 (23000) at line 68: Cannot delete or update a parent row: a foreign key constraint fails
[Database] Removing bot database tables...
[Database] Done...

>>> Database Menu

 [backup_database]              Back up database to backups/ directory
 [backup_player_tables]         Back up player tables to backups/ directory
 [backup_database_compressed]   Back up database compressed to backups/ directory

 [check_db_updates]             Checks for database updates manually
 [check_bot_db_updates]         Checks for bot database updates

 [aa_tables]                    Downloads and installs clean slate AA data from PEQ
 [remove_duplicate_rules]       Removes duplicate rules from rule_values table
 [drop_bots_db_schema]          Removes bot database schema

> main - go back to main menu
Enter a command #> main
Returning to main menu...

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>> EQEmu Server Main Menu >>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

 [database]     Enter database management menu
 [assets]       Manage server assets
 [new_server]   New folder EQEmu/PEQ install - Assumes MySQL/Perl installed
 [setup_bots]   Enables bots on server - builds code and database requirements

 exit

Enter a command #> setup_bots
[Update] Fetching Latest Windows Binaries with Bots...
[Download] Saved: (updates_staged/master_windows_build_bots.zip) from https://raw.githubusercontent.com/Akkadius/EQEmuInstall/master/master_windows_build_bots.zip
[Update] Fetched Latest Windows Binaries with Bots...
[Update] Extracting...
[Unzip] Extracting...
[Install] Installing :: common.lib
[Install] Installing :: eqlaunch.exe
[Install] Installing :: eqlaunch.ilk
[Install] Installing :: eqlaunch.pdb
[Install] Installing :: export_client_files.exe
[Install] Installing :: export_client_files.ilk
[Install] Installing :: export_client_files.pdb
[Install] Installing :: import_client_files.exe
[Install] Installing :: import_client_files.ilk
[Install] Installing :: import_client_files.pdb
[Install] Installing :: loginserver.exe
[Install] Installing :: loginserver.ilk
[Install] Installing :: loginserver.pdb
[Install] Installing :: luabind.lib
[Install] Installing :: queryserv.exe
[Install] Installing :: queryserv.ilk
[Install] Installing :: queryserv.pdb
[Install] Installing :: shared_memory.exe
[Install] Installing :: shared_memory.ilk
[Install] Installing :: shared_memory.pdb
[Install] Installing :: ucs.exe
[Install] Installing :: ucs.ilk
[Install] Installing :: ucs.pdb
[Install] Installing :: world.exe
[Install] Installing :: world.ilk
[Install] Installing :: world.pdb
[Install] Installing :: zone.exe
[Install] Installing :: zone.ilk
[Install] Installing :: zone.pdb
[Update] Done...
[Database] Retrieving latest bots database manifest...
[Download] Saved: (db_update/db_update_manifest.txt) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bots/bots_db_update_manifest.txt
[Database] Reading manifest...
[Database] has update: 9008 - '2016_06_28_bots_inventory_charges_update.sql'
[Database] missing update: 9007 '2016_06_23_bots_camel_case_name_rule.sql'
[Download] Saved: (db_update/2016_06_23_bots_camel_case_name_rule.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bots/required/2016_06_23_bots_camel_case_name_rule.sql
[Database] has update: 9006 - '2016_04_12_bots_inventory_window.sql'
[Database] has update: 9005 - '2016_04_08_bots_heal_rotations.sql'
[Database] has update: 9004 - '2016_04_07_bots_heal_override_target.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.bot_pets' doesn't exist
[Database] has update: 9003 - '2016_04_05_bots_pet_spell_id_field.sql'
[Database] missing update: 9002 '2016_03_24_bots_command_rules.sql'
[Download] Saved: (db_update/2016_03_24_bots_command_rules.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bots/required/2016_03_24_bots_command_rules.sql
[Database] has update: 9001 - '2016_03_24_bots_command_settings.sql'
[Database] has update: 9000 - '2015_09_30_bots.sql'

[Database] Running Update: 9002 - 2016_03_24_bots_command_rules.sql
[Database] Running Update: 9007 - 2016_06_23_bots_camel_case_name_rule.sql
[Database] has update: 9008 - '2016_06_28_bots_inventory_charges_update.sql'
[Database] has update: 9007 - '2016_06_23_bots_camel_case_name_rule.sql'
[Database] has update: 9006 - '2016_04_12_bots_inventory_window.sql'
[Database] has update: 9005 - '2016_04_08_bots_heal_rotations.sql'
[Database] has update: 9004 - '2016_04_07_bots_heal_override_target.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.bot_pets' doesn't exist
[Database] has update: 9003 - '2016_04_05_bots_pet_spell_id_field.sql'
[Database] has update: 9002 - '2016_03_24_bots_command_rules.sql'
[Database] has update: 9001 - '2016_03_24_bots_command_settings.sql'
[Database] has update: 9000 - '2015_09_30_bots.sql'

[Database] No updates need to be run...
[Database] Setting Database to Bots Binary Version (9008) if not already...

Bots should be setup, run your server and the #bot command should be available in-game
Returning to main menu...

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>> EQEmu Server Main Menu >>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

 [database]     Enter database management menu
 [assets]       Manage server assets
 [new_server]   New folder EQEmu/PEQ install - Assumes MySQL/Perl installed
 [setup_bots]   Enables bots on server - builds code and database requirements

 exit

I had bots running on the server a couple days ago. I tried removing them with the prompts like you said, but it looks like that had trouble. Reinstalling afterward didn't fix the error.

Is there a way to backup all of the changes I've made to the server and reinstall? So far I've added a few new race/class combos and a couple of starter quest NPC/Guildmasters. (Nothing too major.)