Skip to content

Sql Problem

Featured Replies

i try to pass an npc everything is correct and when i execute the sql file always i get an error but i try to pass the same npc to the second l2jdb i got on navicat and everything works fine there .

 

thats the error: [Err] 1136 - Column count doesn't match value count at row 1

[Err] INSERT INTO custom_npc VALUES ('5', '5', 'Hyperion', '0', 'Global Gatekeeper', '0', 'Monster2.ketra_orc_chieftain_20_bi', '17.00', '46.20', '80', 'male', 'L2Teleporter', '40', '300327', '1524', '368.11', '9.81', '60', '57', '73', '76', '70', '80', '3775961', '557272', '2423', '1731', '477', '768', '230', '0', '3819', '6719', '0', '0', '38', '307', '', '0', '0', '0', 'LAST_HIT');
[Msg] Finished - Unsuccessfully

Check the table with values here possible some row missing or maybe you have to many rows... or the order in your sql is different than table order

  • Author

the sql is fine i passed on the other l2jdb2 i got on navicat and works but dont work on this l2jdb1

thats the sql:

INSERT INTO custom_npc VALUES ('5', '5', 'Hyperion', '0', 'Global Gatekeeper', '0', 'Monster2.ketra_orc_chieftain_20_bi', '17.00', '46.20', '80', 'male', 'L2Teleporter', '40', '300327', '1524', '368.11', '9.81', '60', '57', '73', '76', '70', '80', '3775961', '557272', '2423', '1731', '477', '768', '230', '0', '3819', '6719', '0', '0', '38', '307', '', '0', '0', '0', 'LAST_HIT');

Insert the values manually, obviously, there's a difference between your table structure and that SQL script.

  • Author

i forgot i put a code that for drop enchanted item's so my sql got more lines 

So, just add it manually or add that row to your query :P

Create an account or sign in to comment

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.