Server empty of NPC's

[TheSalesman]

I join someone else's server... all the zones are full of NPC's.... mine, all the zones are empty. If its a DB that I need to get, anyone have a link to where I can get a decent one? I just wanna go fight in Seb, maybe kill Trakanon.

[Hardy]

http://cecugfile.net/
Its under downloads

[TheSalesman]

Thanks for the quick reply.... I downloaded the DB, went into mysql, and using the downloaded DB in the directory did:

use eq;
source db.sql

However, after finishing this, and using install.bat, I get a bunch of errors:

ERROR 1136 at line 74518 in file: 'spawns.sql': Column count doesn't match value
count at row 1
ERROR 1136 at line 74519 in file: 'spawns.sql': Column count doesn't match value
count at row 1

For about 20k lines at least. I don't understand.... how can the DB not be compatible with itself? Is there a way to erase the EQ db and start over from scratch?

[TheSalesman]

Oh yes, and the end result is: No NPC types in the database, and all the zones are empty. The Spawn table is full.... but the NPC types is empty. Help!

[Hardy]

There must be something wrong with the install.bat file. Source in the spawns manually, go into the mysql and do the use <database name> and then source spawns.sql, i believe thats the name. That seemed to work for me. I think you need to start back fresh again (I did anyway), install the spawns BEFORE install.bat.

[TheSalesman]

Thanks for all the help yo.... one more question, how to start fresh? Ie, how do I delete the database to start over again?

[Hardy]

You could go into mySQL and type in "drop database eq;" without quotes and then to re-create, type "create database eq;" without quotes. Or you can go into winmysqladmin, right click on the database, click drop database, then right click in the white area and click create database.

[TheSalesman]

Thanks man, I really appreciate your help.

[Arachnid]

ok i just did all this and am getting the 1017 error now =( I redid the patch, all files are good, but keep getting 1017 by adding these db's, any idea why?