BIG NPC problem

[logicd22]

ok when I was updating my server for 3.5 some terrible happend, and the npcs on my server disapperd, I use the query
alter table creature_spawns add column standstate int(10) not null default 0;
Could that of been it?? is there A fix for this?? I really hope there is because like all npcs are gone and I would hate to redo my server

[Steph]

Use:

ALTER TABLE creature_proto ADD COLUMN attacktype INT(4) NOT NULL DEFAULT 0 AFTER attacktime;

[logicd22]

hm still no npcs

[Steph]

Then you've changed something you shouldnt.

If you are using the NCDB SVN, make a fresh install into a fresh database, and it will work fine.

Im uploading 1025 right now for my thread, it should be done in the next 10 minutes.

[logicd22]

Guess I have a bigger problem than I thought, there are no npcs, I cant spawn them, No idea how that happend, Im guessing there no fix to that, is there?

[logicd22]

Thats so wierd, all my npcs are in the creature proto column, but I cant spawn them and there not there, Could this be a char db problem?