PDA

View Full Version : everything works..except no npc's? help appreciated


Kintudo
12-10-2004, 06:00 PM
i setup today using 0.60-Dr1 precompiled.
followed everything as stated on the guides.
Everything runs fine..doors ,zones..etc.
No errors except the failed to load npc. bad query.
ive checked for hours on the message boards..and only see something about a change in the database..yet I have not been able to figure out how to add it.
suggestions welcome.
Thanks

mattmeck
12-10-2004, 06:33 PM
No errors except the failed to load npc. bad query.
ive checked for hours on the message boards..and only see something about a change in the database..yet I have not been able to figure out how to add it.
suggestions welcome.
Thanks

You run the command in mysql.

Kintudo
12-10-2004, 06:49 PM
yes ive learned that..but what is the command to alter a table..i keep getting wrong syntax.

Kintudo
12-11-2004, 01:37 PM
Ok i used the
ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0;

however i then get this message back....
ERROR 1060: Dduplicate column name `AC`

so any suggestions what step to take next?

Thanks