Zone.exe Crash [Archive] - EQEmulator Forums

whiteknight33

09-11-2016, 07:28 AM

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:bcryptPri mitives.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_88fef4 c26039fb25\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_88fef4 c26039fb25\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

09-11-2016, 05:15 PM

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

09-11-2016, 05:26 PM

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

09-11-2016, 05:38 PM

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

Uleat

09-11-2016, 05:54 PM

If that's the case...

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

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

Did you re-run shared_memory?

whiteknight33

09-11-2016, 07:28 PM

whiteknight33

09-11-2016, 08:18 PM

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

09-11-2016, 08:40 PM

Run this query and report the results:
SHOW TABLES LIKE 'vw%';

EDIT:

Curious notation..
... AS cLEFT JOIN ...
No space between c and LEFT...

whiteknight33

09-11-2016, 08:46 PM

;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

09-11-2016, 09:02 PM

whiteknight33

09-11-2016, 09:08 PM

I did find the ref at: https://github.com/EQEmu/Server/blob/master/common/guild_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=Pastebin&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

09-11-2016, 09:30 PM

What does
SHOW TABLES LIKE 'bot%';
..show?

whiteknight33

09-11-2016, 09:35 PM

Uleat

09-11-2016, 09:39 PM

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

09-11-2016, 09:48 PM

>>> 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.)

Uleat

09-11-2016, 10:32 PM

Try this...

Manually delete each table that is prefixed with 'bot' - skipping any table that gives an error, then go back through and try deleting those.

There is an order to do it in and it is applied in the drop_bots.sql file.

I'm not sure if the heal rotation tables are in the 'drop' file..so, that may be part of the problem.

Essentially, you do not want any 'bots' tables in your database - though, you can leave the views and functions since they are cleared out by the install script.

Finally, change the value of `bots_version` to '0' in the `db_version` table.

You shouldn't need to re-install everything to get a working server :/

EDIT: Once you manually remove all traces of bots, the installer should work properly.

DanCanDo

09-11-2016, 10:40 PM

I just ran a non-bot windows server using the update script to install bots.
It went smoothly, but something else I did AFTER I installed the bots, I ran
check_bot_db_updates and it pulled a couple in. All works fine.

DanCanDo

09-11-2016, 10:52 PM

This is the updates it grabbed afterwards:
Enter a command #> check_bot_db_updates
[Database] Running Update: 9003 - 2016_04_05_bots_pet_spell_id_field.sql
[Database] Running Update: 9008 - 2016_06_28_bots_inventory_charges_update.sql

whiteknight33

09-11-2016, 11:27 PM

whiteknight33

09-11-2016, 11:32 PM

I did everything you specified. I deleted all of the files and ran the installer. Bots are working on my server, but that error isn't going away and I can't use the guild window. (It won't update and show characters.)

Where does this table come from?
Table 'peq.vw_bot_character_mobs' doesn't exist

Edit: Also, the bots version was already set to 0.

It also won't let me create new bots because it says it can't check name availability... So I'm assuming that missing file had something to do with that.

DanCanDo

09-12-2016, 08:47 AM

The 'vw_bot_character_mobs' is (supposed to be) in the Views part of your database.
That is seperate from 'Tables' You should have a total of 5 tables under Views.
If any of the vw's are missing, I am not sure why the installer didn't insert them for you.
I tested this whole bot installer from the script and it all worked fine for me on a win 7 box.
Did you try running any and all database updates in the update script ?

Uleat

09-12-2016, 02:10 PM

You can manually run the queries found here: https://github.com/EQEmu/Server/tree/master/utils/sql/git/bots/required
(You should have them locally in your source code folder..just match up the paths.)

They should be installed in the order listed in the manifest - starting with 9000: https://github.com/EQEmu/Server/blob/master/utils/sql/git/bots/bots_db_update_manifest.txt

There are a couple of other changes that need to be applied as well..but, until you get all of those in, without errors, we won't address that.