Zone crashes

[cavedude]

Yes this issue is without a doubt corrected. PEQ has only seen one zone crash in a week (the fewest I've seen in a very long time), and it was completely unrelated to this.

[KLS]

For crashes with the newer exes make sure the AA stuff is up to date in your DB.. it's very touchy and will crash the server when you load a character if it's not correct.. wont just fail to load like other stuff.

[Wizardanim]

Have double checked AA tables, and still haveing the problem.

Its a new PEQ database, with all the SQL querrys from the changelog, plus your new AA file which has the correct table outlines and data...

i get this nice little message

*edit* reposted as an image LINK lol, was a bit big for forum

http://img137.imageshack.us/img137/9...problemms6.jpg

[Angelox]

Do you have this problem with static zones only? could you try dynamic? I think I might have this also, but since I don't need static zones, I just use dynamic.

[Wizardanim]

yes same problem with dynamic... i know there must be something im missing but not sure what

http://img393.imageshack.us/img393/1252/untitledsg9.jpg

[Wizardanim]

Sry bout double post... cant edit last one.

I do notice one error in the dynamic list here. (above)

>>Store character inventory failed. Query '<null>' #1264: out of range value adjusted for column 'color' at row 1

will mess with this error and the character inventory tables in the next few days... hopefully this fixes the issue. Exact same setup on both ... just one is dynamic and one is static. Strange how one shows the error but not the other, no? with same server versions.

[MysticDeath]

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:

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:

[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

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

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

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?

[Angelox]

Looks like you haven't properly updated your database according to the logs posted with the releases at the EqEmu download.
I just posted a new version of my AX_PEQ database here;
http://eq.ismg.ch/mirkwood/news.php
it contains all updates for the newest EQEmu-0.7.0-988. Should work if that's your problem.

Also , if you have a Linux server, be sure to read this;
http://eqemulator.net/forums/showpos...56&postcount=9

[MysticDeath]

Thanks Ill give your AX a try. :P

[Wizardanim]

Originally Posted by Wizardanim

Sry bout double post... cant edit last one.

I do notice one error in the dynamic list here. (above)

>>Store character inventory failed. Query '<null>' #1264: out of range value adjusted for column 'color' at row 1

will mess with this error and the character inventory tables in the next few days... hopefully this fixes the issue. Exact same setup on both ... just one is dynamic and one is static. Strange how one shows the error but not the other, no? with same server versions.

well this error is confusing... apparently it cant save the characters invintory... where the querry was <NULL> ... heres the default schema for invintory


CREATE TABLE inventory (
charid int(11) unsigned NOT NULL default '0',
slotid mediumint(7) unsigned NOT NULL default '0',
itemid int(11) unsigned default '0',
charges tinyint(3) unsigned default '0',
color int(11) unsigned NOT NULL default '0',
augslot1 mediumint(7) unsigned NOT NULL default '0',
augslot2 mediumint(7) unsigned NOT NULL default '0',
augslot3 mediumint(7) unsigned NOT NULL default '0',
augslot4 mediumint(7) unsigned NOT NULL default '0',
augslot5 mediumint(7) unsigned default '0',
instnodrop tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (charid,slotid)
) TYPE=MyISAM;


and this is what i have (double checked) - any ideas? all the values in the table right now are set to 0, dosent seem to be able to save data there.