Jump to content
  • 0

navicat error




i downloaded  a gmshop npc  in this forum  that sells all and icarus weapon

it's for l2j and i use l2j but when i open navicat and i do execute batch file it gives an error like:


[Err] 1136 - Column count doesn't match value count at row 1

[Msg] Finished - Unsuccessfully



code is:


DELETE FROM `custom_npc` WHERE `id` = '90000';

INSERT INTO `custom_npc` VALUES ('90000', '25532', 'GM Shop', '1', 'GM Shop', '1', 'NPC.a_traderA_MHuman', '10.00', '27.00', '70', 'male', 'L2Merchant', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '55', '132', null, '0', '1', '0', 'LAST_HIT', '0', '0', '0', 'fighter');


thanks for help


bye bye

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Just add the attributes manually m8.

Press the (+) button in table custom_npc (check down and left) and change only these values :


template ID
ServerSideTitle (set it to 1, just to display your custom title) 


P.S : Next time please post in [Request] Section.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock