Jump to content
  • 0

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


lowrider88
 Share

Question

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

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share



×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock