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.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 10-17-2007, 02:52 PM
gernblan
Discordant
 
Join Date: Aug 2006
Posts: 394
Default

I figured this out.. it's because the spawngroup names in your DB are getting longer and longer and are exceeding 30 characters (which is what the field is defined as).

I am NOT sure what changing the field itself would do to the emu.. but it does seem that some are running up against this with long mob names in long named zones.

I changed mine to varchar(50) and I get no more add or create errors and my mobs always stay, but this DOES seem to be affecting performance in a big way.

Can anyone more knowledgeable than me chime in on this please and perhaps suggest a solution now that I have at least defined the problem?

For example... here's one in my DB now...

growthplanea_serene_forest_spirit02654599733

That is longer than 30 chars obviously. And when I try to #npcspawn add another one in game, I get a server error messages in my logs that the query failed. So the spawn did not get added.
__________________
--
Keelyeh
Owner, ServerOp and Developer
Jest 4 Server
Linux (Jest3 runs on Fedora, our Dev servers usually run on Ubuntu and/or Gentoo), OC-12 Connection = Hella Fast

Last edited by gernblan; 10-17-2007 at 10:55 PM..
Reply With Quote
 

Thread Tools
Display Modes

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 08:05 AM.


 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3