[Help]Error 1136 when executing sql file.

[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

[Dubxsion]

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  :)

[vampir]

well yeah, u need to show us how your table looks like.

[Hamscer]

This is my custom_npc table:

 

 

[Tryskell]

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.

[Dubxsion]

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 :)

[Hamscer]

thanks for the help!

[Mhoska]

Problem solved, topic locked.