[Help] Database query

[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.

[BrokeN^WinG]

w8

[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 );

[Kai101a]

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

[Mr_PoP]

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 >.<

[Kai101a]

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.

[Mr_PoP]

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.

[Kai101a]

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

[Zimbolt]

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