Jump to content
  • 0

Can someone fix this SQL please???


Question

Posted

PLease can someone fix this AQl so it can be compatible with L2J Archid????

 

 

INSERT INTO `custom_npc` VALUES ('67221', '30837', '*GM~Shop*', '1', 'L][Destiny', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', 'L2Merchant', '40', '3862', '1493', '13.43', '3.09', '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '0', '0');

4 answers to this question

Recommended Posts

  • 0
Posted

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `npc` VALUES ('67221', '30837', '*GM~Shop*', '1', 'L][Destiny', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', 'L2Merchant', '40', '3862', '1493', '13.43', '3.09', '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Here its the error br0

  • 0
Posted

INSERT INTO `custom_npc` VALUES ('67221', '30837', '*GM~Shop*', '1', 'L][Destiny', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', 'L2Merchant', '40', '3862', '1493', '13.43', '3.09', '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '0', '0', 'LAST_HIT');

 

rdy

Guest
This topic is now closed to further replies.
×
×
  • Create New...