Solved the problem on my own, leaving this up for anyone else with a similiar problem.
Hmm, not sure if this is a related crash.
But I havn't played in a while, and decided to boot up my server yesterday. (After upgrading to the latest emu again; i'm quite familiar with the setup of the server, so I don't think the problem is the server) but everytime my character logs into the server from char select screen, i get a few outputs.
Minilogin reports this:
Code:
1416234 New client from ip: 192.168.1.55 port:1058
Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0003 <OP_Unknown> Size=11]
00000: 00 06 00 00 00 00 00 00 - 00 00 00
World.exe:
Code:
[Debug] [WORLD__CLIENT_ERR] sphinx: Zone bootup timer expired, bootup failed or too slow.
[Debug] [WORLD__CLIENT_ERR] sphinx: Received unknown EQApplicationPacket
[Debug] [WORLD__CLIENT_ERR] [OpCode OP_WorldLogout <0x7186> Size=0]
*sigh* is this related?
Edit:
I opened a static zone.
It seems that the crash is irrelevent whether or not my character connects to it. It crashes when a zone loads. Any and all static zones I loaded crashed immediatly. And any dynamic zones my characters connect to crashes when trying to load.
I get this error
Code:
[Error] Error in GetAASkillVars 'SELECT cost, max_level, hotkey_sid, hotkey_sid2, title_sid, desc_sid, type, prereq_skill, prereq_minpoints, spell_type, spell_refresh, classes, berserker,spellid,class_type,name,cost_inc FROM altadv_vars WHERE skill_id=2': #1054: Unknown column 'cost_inc' in 'field list'
I did a quick search for 'cost_inc' on the forum. I got the "No matches" hehe. :P
Edit 2:
Sourced in some code from changelogs
Zone didn't crash instead gave me a ton of errors about npc_types.see_hide.
Code:
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.see_hide' in 'field list'
Edit 3:
Checked changelog.txt for npc_types sql's found this
Code:
Required SQL:
ALTER TABLE `npc_types` ADD `see_hide` tinyint(4) NOT NULL default '0';
ALTER TABLE `npc_types` ADD `see_improved_hide` tinyint(4) NOT NULL default '0';
Optional SQL:
UPDATE `npc_types` SET `see_hide` = 1 WHERE see_invis = '1';
UPDATE `npc_types` SET `see_hide` = 1 WHERE see_invis_undead = '1';
Isn't that conveniant?