Skip to content

[Help]Error 1136 when executing sql file.

Featured Replies

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

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

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

  • Author

This is my custom_npc table:

 

custom_npc_1.jpg

 

custom_npc_2.jpg

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.

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

  • Author

thanks for the help!

Problem solved, topic locked.

Guest
This topic is now closed to further replies.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.