Help Sql Problem

[TraineeDreamer]

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

[Machinist]

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

[TraineeDreamer]

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');

[Versus]

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

[TraineeDreamer]

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

[SweeTs]

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