[Help] Database query

So, I'm currently trying to add the +12 npc to my TQ binaries server, and I keep getting an issue with the query when I try to run it.


[SQL] INSERT INTO cq_npc VALUES(0453, 0, 0, "MoonGoddess", 0002, 4053, -1, 5000, 0047, 0074, 1400,
0,0,0,0,0,0,0, 0,0,0,0, "", 0, 00, 00, 0000, 01, 0000 );
[Err] 1136 - Column count doesn't match value count at row 1

that is the error I am receiving so if anyone knows how to fix it please respond.
Also I'm using navicat 8.0.20 lite to edit it.

w8

INSERT INTO `cq`.`cq_npc` VALUES (0453, 0, 0, "MoonGoddess", 0002, 4053, -1, 5000, 0047, 0074, 1400,
0,0,0,0,0,0,0, 0,0,0,0, "", 0, 00, 00, 0000, 01, 0000 );

Quote:

Originally Posted by BrokeN^WinG INSERT INTO `cq`.`cq_npc` VALUES (0453, 0, 0, "MoonGoddess", 0002, 4053, -1, 5000, 0047, 0074, 1400, 0,0,0,0,0,0,0, 0,0,0,0, "", 0, 00, 00, 0000, 01, 0000 );

I tried that and this is what I get.

[Err] 1136 - Column count doesn't match value count at row 1

Quote:

Originally Posted by Kai101a So, I'm currently trying to add the +12 npc to my TQ binaries server, and I keep getting an issue with the query when I try to run it. [SQL] INSERT INTO cq_npc VALUES(0453, 0, 0, "MoonGoddess", 0002, 4053, -1, 5000, 0047, 0074, 1400, 0,0,0,0,0,0,0, 0,0,0,0, "", 0, 00, 00, 0000, 01, 0000 ); [Err] 1136 - Column count doesn't match value count at row 1 that is the error I am receiving so if anyone knows how to fix it please respond. Also I'm using navicat 8.0.20 lite to edit it.

rofl
open cq_npc and find moongoods than delete
the all line, than try to query it again it will work >.<

Quote:

Originally Posted by Mr_PoP rofl open cq_npc and find moongoods than delete the all line, than try to query it again it will work >.<

lol moongoddess hasn't even been entered yet. that's what I'm trying to do.

Quote:

Originally Posted by Kai101a lol moongoddess hasn't even been entered yet. that's what I'm trying to do.

dude the error saying u must use one id by the same number ,so u already have it so,
listen to wat i said , u r using mike's server so its already in cq_npc bt the tasks and the action didnt typied there thats wat u guna do when u will query it.

Quote:

Originally Posted by Mr_PoP dude the error saying u must use one id by the same number ,so u already have it so, listen to wat i said , u r using mike's server so its already in cq_npc bt the tasks and the action didnt typied there thats wat u guna do when u will query it.

not using mikes server. I'm using the chinese server. And I've looked through cq_npc there's no moongoddess

The original binary has 2 added columns, fat or some shit like that.
delete the insert into cq_npc query
and insert your own npc, and import the actions.