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