Error with spawns.sql in 4.1 DB addon

[Tallon Zek]

firstly, eqemu works perfectly, i am able to log on, summon items, etc, but this one problem has me stumped: I can't get any of the spawns to work because of an error when I source spawns.sql to the eq database. This is the error that covers my screen for over 1000 lines-

...<<<runs well for about a minute>>>

Query OK 1 row affected <0.00 sec>

<<<Here is where the problem begins>>>

Error 1062: Duplicate Entry '37843-2275' for key 1
Error 1062: Duplicate Entry '37861-2061' for key 1
Error 1062: Duplicate Entry '37861-2058' for key 1
Error 1062: Duplicate Entry '37861-2062' for key 1
Error 1062: Duplicate Entry '37862-2061' for key 1
........ <<<keeps on going with different number combos, i left it on for 40 minutes and still was giving me errors, so i cancelled out>>>

I have reinstalled everything several times, so im pretty sure the problem comes down to this DB or file in particular. This is the only file in the DB that won't source correctly. Any help would be appreciated, and even a link to a working "spawns.sql" would be appreciated. Thanks in advance :)

[Lurker_005]

Like the readme says, start with an EMPTY database. Create a new DB, source the db.sql file from 4.1 Then run the install.bat be sure to give it the DB name on the command line or it will default to the eq database if it exists.

That last part is my best guess at your problem, it is trying to install in the eq database that isn't an empty one.

Also don't forget the 4.1 DB isn't compatable with 4.2 I'll try to make an upgrade script tonight.

[Tallon Zek]

Yea, i dropped the database every time i did a new install, but that didnt fix it. BUT, i was using it with 4.2, so my bad. previously, the older DB's worked with newer versions, so i assumed wrong. thanks bro, and good luck on that script, i appreciate all your work :)