SQL problem, "npc" table

[temple13]

Hey guys,

 

I'm trying to add a custom NPC, when I execute the sql file it says that everything it's correct.

 

But when I open the NPC table, the ID of the new NPC is not there, and if I try to execute it again it gives me the error that the ID its already in use:

 

[Err] 1062 - Duplicate entry '20701' for key 'PRIMARY'
[Err] INSERT INTO npc VALUES ('20701', '25286', 'Venus', '1', 'Buffer', '1', 'Monster.zaken', '15.00', '20.00', '60', 'female', 'L2Npc', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '28', '132', '', '0', '0', '0', 'LAST_HIT');
[Msg] Finished - Unsuccessfully

 

And if I try to spawn it, it says that the ID is incorrect.

 

I tried to add it manually, but when I close table and open it again, it dissapear.

 

Someone know why this happens?

 

Thanks,

 

Regards

 

EDIT: I executed a 'teleport' table and it works correctly, so what's wrong with 'npc' table?

[Necro]

Have you tryed to change tha ID ?

[Fanky]

[Err] 1062 - Duplicate entry '20701' for key 'PRIMARY'

 

means that this idea is already there,you prolly have increse this specific npc already or this id is already taken by other npc.

[temple13]

EDIT: Fixed, i just import it in custom_npc table.

 

Thanks anyways,

 

Regards.

[Fanky]

ah sry.

alright then,check if its on another page.I'm sure that the table that you're trying to put your npc its the npc sql which got every npc,so be sure that you will check every page of this table

[MixMasteR]

Locked.