Server empty of NPC's

TheSalesman · #1 02-17-2003, 02:40 AM

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 · #2 02-17-2003, 05:23 AM

http://cecugfile.net/
Its under downloads

TheSalesman · #3 02-17-2003, 04:03 PM

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:

Quote:

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 · #4 02-17-2003, 04:08 PM

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 · #5 02-17-2003, 04:25 PM

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 · #6 02-17-2003, 07:09 PM

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 · #7 02-17-2003, 08:06 PM

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 · #8 02-17-2003, 08:34 PM

Thanks man, I really appreciate your help.

Arachnid · #9 02-18-2003, 06:21 AM

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?