EQEmulator Forums - Magicians crashing after dying

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Magicians crashing after dying (https://www.eqemulator.org/forums/showthread.php?t=34958)

Check out these two links:

http://dev.mysql.com/doc/refman/5.1/...onnection.html

http://dev.mysql.com/doc/refman/5.1/...cked-host.html

I'm not saying these are the causes, but it gives you a good starting point.

Okay I created a completely new database, sourced in the updates after rev2214 (most recent db). Changed my config file to point to new database, blam server fires right up (minus queryserv, it still can't connect).

Any ideas why queryserv is still erroring out?

How do I merge the customizations from my previous database into the new one?

Quote:

Originally Posted by chrsschb (Post 215189)

Any ideas why queryserv is still erroring out?

I am shocked to think someone as talented as yourself would need to be told to go RTFM

Quote:

Originally Posted by changelog.txt

==11/27/2012==
Sorvani: fix for newly created items with unlmiited charges to actually be usable.
Sorvani: (Uleat) Lore check is now made for items inside bags being trade before the trade completes.
Akkadius: Started first works of implementing QueryServ for what it was meant to be used
Akkadius: Moved QueryServ to it's own configuration block in the eqemu_config.xml (example):
<qsdatabase>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>password</password>
<db>queryserv</db>
</qsdatabase>
Akkadius: QueryServ can now be used on a separate server and can use an entirely separate database as it was meant to
Akkadius: Added 'loottable_id` to NPC::ModifyNPCStat which also changes quest::ModifyNPCStat(identifier, newValue); as well
Akkadius: Fixed heap corruption in quest_globals that would occur if a value over 64 bytes was created
Akkadius: Changed value size in qglobals from 64 bytes to 128 bytes
Akkadius: Added #reloadworld - This command will reload every single zones Perl quests and repop them
Secrets: Minor code fix for qglobals. Since we removed the id field from qglobals, I suppose we shouldn't use it in code.
Secrets: Warning fix for a quest function.
Secrets: Fixed a crash issue where player corpses did not exist at all in a function (ie; they were disabled) yet we are trying to use an invalid pointer
Secrets: durp, i'm retarded. memleak fix.

Quote:

Originally Posted by chrsschb (Post 215189)

How do I merge the customizations from my previous database into the new one?

Toad for MySQL

Quote:

Originally Posted by sorvani (Post 215191)

I am shocked to think someone as talented as yourself would need to be told to go RTFM

I'm extremely frustrated with this issue and dealing with a load in real life, pretty easy to miss simple stuff.

I've narrowed it down to something inside my database is either corrupted or set to a value that is causing a crash. When using a fresh database everything works, when using an old database everything works, and after merging changes into a fresh database I get a crash.

Going to try sourcing in an older version of my current database. Still not sure what I changed that's causing issues though. Standard item and npc edits is all I've done lately.

Save the Toad script and put pieces in slowly till you find the part that's screwed up

Quote:

Originally Posted by sorvani (Post 215201)

Save the Toad script and put pieces in slowly till you find the part that's screwed up

It's something I changed between the 10th and the 11th, I know that much. So, going to compare those databases for differences and see.

How are you progressing with this?

I'm not, lol. Haven't had time.