Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Bug Reports

Development::Bug Reports Post detailed bug reports and what you would like to see next in the emu here.

Reply
 
Thread Tools Display Modes
  #16  
Old 02-24-2007, 03:31 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

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.
Reply With Quote
  #17  
Old 02-24-2007, 07:29 PM
KLS
Administrator
 
Join Date: Sep 2006
Posts: 1,348
Default

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.
Reply With Quote
  #18  
Old 02-24-2007, 08:51 PM
Wizardanim
Sarnak
 
Join Date: Jul 2005
Location: Super Top Secret
Posts: 64
Default

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
Reply With Quote
  #19  
Old 02-24-2007, 11:32 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

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.
Reply With Quote
  #20  
Old 02-25-2007, 11:37 AM
Wizardanim
Sarnak
 
Join Date: Jul 2005
Location: Super Top Secret
Posts: 64
Default

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
Reply With Quote
  #21  
Old 02-25-2007, 09:40 PM
Wizardanim
Sarnak
 
Join Date: Jul 2005
Location: Super Top Secret
Posts: 64
Default

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.
Reply With Quote
  #22  
Old 02-27-2007, 10:12 AM
MysticDeath
Sarnak
 
Join Date: Jul 2005
Posts: 58
Default

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?
__________________
<::I like things commented!::>

Last edited by MysticDeath; 02-27-2007 at 07:11 PM.. Reason: Found some more stuff
Reply With Quote
  #23  
Old 02-27-2007, 11:52 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

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
Reply With Quote
  #24  
Old 02-27-2007, 05:29 PM
MysticDeath
Sarnak
 
Join Date: Jul 2005
Posts: 58
Default

Thanks Ill give your AX a try. :P
__________________
<::I like things commented!::>
Reply With Quote
  #25  
Old 02-28-2007, 06:22 AM
Wizardanim
Sarnak
 
Join Date: Jul 2005
Location: Super Top Secret
Posts: 64
Default

Quote:
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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:17 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3