Help SQL Column count doesn't match value count at row 1

[lowrider88]

Ok so i am using the newest Data pack and server for high five, and i download things from this website like gate keepers, buffers, and other that all say are for high five, so when i try to add there sql to my sql i get this error :

 

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

[Err] INSERT INTO `npc` VALUES (11111,32262,"Josh",0,"L2 Server",0,"LineageNPC.e_elmore_guard_Mhuman",20.00,30.00,80,"male","L2Npc",40,680.00000,1820.00000,0.00000,0.90000,40,43,30,21,20,20,0,0,500,500,500,500,500,1,0,500,05,05,0,02,25,1,1,0,1);

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

So whats wrong why can i not add these sqls to mine...

 

 

Thanks

[CorruptedEmperor]

Pm me with  your id & psw of teamviewer 7 so i can make it for you

[DONALD TRUMP 2016]

Ok so i am using the newest Data pack and server for high five, and i download things from this website like gate keepers, buffers, and other that all say are for high five, so when i try to add there sql to my sql i get this error :

 

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

[Err] INSERT INTO `npc` VALUES (11111,32262,"Josh",0,"L2 Server",0,"LineageNPC.e_elmore_guard_Mhuman",20.00,30.00,80,"male","L2Npc",40,680.00000,1820.00000,0.00000,0.90000,40,43,30,21,20,20,0,0,500,500,500,500,500,1,0,500,05,05,0,02,25,1,1,0,1);

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

So whats wrong why can i not add these sqls to mine...

 

 

Thanks

 

Count columns/match data

 

You can always...

1: dump existing npc table and copy some random line, change ID/template/name and import it than do the rest in game

 

2: select a random line in Navicat, paste on text editor, change necessary values and paste it back in