Loading spawn groups failed

[krusher]

Your missing a column in the database table spawnentry called spawnlimit.

[narcberry]

Can I just blindly add the column? Or does there need to be data to populate it with?

Thanks for the help.

[narcberry]

I went ahead and added the column with default data ('0' as per the schema)

ALTER TABLE spawnentry ADD COLUMN spawn_limit tinyint(4) NOT NULL DEFAULT '0';

It took care of the error but I get a new error that seemed to be the same problem revisited:

Error3 in PopulateZoneLists query 'SELECT spawnentry.spawngroupID, npcid, chance,  spawnentry.spawn_limit AS gsl, npc_types.spawn_limit AS sl FROM spawnentry, spawn2 LEFT JOIN npc_types ON spawnentry.npcID = npc_types.id WHERE spawnentry.spawngroupID=spawn2.spawngroupID AND zone='cabeast' ORDER by chance' #1054: Unknown column 'spawnentry.npcID' in 'on clause'

So I went ahead and tried to add that column too:

ALTER TABLE spawnentry ADD COLUMN npcID int(11) NOT NULL DEFAULT '0';
ERROR 1060 (42S21): Duplicate column name 'npcID'

I dont understand why it reports an unknown column when it exists... or why there are multiple database errors with a fresh install.

[narcberry]

Actually this last error is related to a parsing bug in newer versions of mysql. The bug is intentional but it isnt backwards compatable with, oh say, this sql statement.

more info here.

[WildcardX]

A couple things about this error.

1. What version of EQEMu are you running? The latest build of EQEMu, EQEmu-0.7.0-965, has the following sql query for PopulateZoneLists:

MakeAnyLenString(&query, "SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, timeleft, _condition, cond_value FROM spawn2 WHERE zone='%s'", zone_name);

Obviously this query does not match the one your log shows so I have to believe you are running an older version of EQEmu, right?

2. Its not the Spawnentry table that has the 'spawn_limit' column... its Spawngroup table. Well atleast that is how it is now and has been for some time for PEQ database anyway. Again, you must have an older version of EQEmu.

[narcberry]

Im using version EQEmu-0.7.0, since its the latest stable release. I added the column with the sql command above and it works fine now, although its all default data.

Do most people use newer builds without problems? If so, I would like to as well. I stayed up most of last night making the current build mysql5 compatable and Im worried that was a big waste of time.

edit: and as of late last night, my server is up and mostly working.

[WildcardX]

Its up to you.. none of the builds are guaranteed at all to be "stable" or whatever other terms you want to toss around. With that said, a lot of people run on the bleeding edge. If you are already having problems with what you have now, then you likely have little to loose.

Sorry to hear to you probably did waste a lot of time last night fixing items that are already fixed in the latest release