Loading spawn groups failed

narcberry · #1 02-09-2007, 07:10 PM

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** · #2 02-10-2007, 05:08 AM

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:

Code:

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 · #3 02-10-2007, 07:35 AM

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** · #4 02-10-2007, 08:28 AM

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

**WildcardX** · #5 02-10-2007, 08:31 AM

at the very least, if you are going to run the last "official" release, then you should probably not use MySQL 5.0. However, if you really do want to use MySQL 5.0, then you should use the latest build available and make sure your database is current to all the database structure changes that have taken place since..

narcberry · #6 02-10-2007, 10:08 AM

Thanks for the help.

Angelox · #7 02-10-2007, 12:30 PM

Any of the DB will run with MySql 5x.
Probably the most important and only thing you need to know for MySql5 is this line;

Code:

SET PASSWORD FOR eq@localhost = OLD_PASSWORD('eq');

For now, my DB is up to date with all SQL fixes, you can download it at my web.