Hamscer Posted September 28, 2012 Posted September 28, 2012 Hey everyone, before you start yelling, I did search, and found a bunch of people with the same question and no normal explanation. So if anybody can please do. [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `custom_npc` VALUES ('99999', '32226', 'Ultra Buffer', '1', '[YourServerName]', '1', 'LineageNPC2.K_F1_grand', '11', '22.5', '80', 'male', 'L2NpcBuffer', '40', '540452.000000000000000', '5243.000000000000000', null, null, '40', '43', '30', '21', '20', '20', '0', '0', '453.00000', '638.00000', '838.00000', '8383.00000', '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'); [Msg] Finished - Unsuccessfully Thanks a bunch! Hamscer
0 Dubxsion Posted September 28, 2012 Posted September 28, 2012 SQL file did not match the Navicat version or whatever platform u use. It just have more columns than "custom_npc" have ! Try contact me im PM to help you in live cause here will be impossible :)
0 vampir Posted September 28, 2012 Posted September 28, 2012 well yeah, u need to show us how your table looks like.
0 Tryskell Posted September 28, 2012 Posted September 28, 2012 Learn to count and all will be ok. I counted 42 in first post on your query, and according your screen you got 39 fields.
0 Dubxsion Posted September 29, 2012 Posted September 29, 2012 One advice - make new SQL file (copy old one and erase everything inside) Copy the first field of you'r "custom_npc" sql located in "sql" folder. Field should look like this one .. INSERT INTO `custom_npc` VALUES ('99999', '31228', 'Roy the Cat', '1', 'Classes Trader', '1', 'Monster.cat_the_cat', '9.00', '16.00', '70', 'male', 'L2ClassMaster', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '490', '10', '1335', '470', '780', '382', '278', '0', '333', '0', '0', '0', '88', '132', null, '0', '0', '0', 'LAST_HIT'); after you copied it , just edit statistic and add you'r one from your npc :)
Question
Hamscer
Hey everyone, before you start yelling, I did search, and found a bunch of people with the same question and no normal explanation.
So if anybody can please do.
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `custom_npc` VALUES ('99999', '32226', 'Ultra Buffer', '1', '[YourServerName]', '1', 'LineageNPC2.K_F1_grand', '11', '22.5', '80', 'male', 'L2NpcBuffer', '40', '540452.000000000000000', '5243.000000000000000', null, null, '40', '43', '30', '21', '20', '20', '0', '0', '453.00000', '638.00000', '838.00000', '8383.00000', '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0');
[Msg] Finished - Unsuccessfully
Thanks a bunch!
Hamscer
7 answers to this question
Recommended Posts