Jump to content
  • 0

Porbl with one sql file..


sweetparanoid

Question

Well i try add one buffer to my server...and i see error in MySql

>>Column count doesn't match value count at row 1<<

I saw that many people have this probl..

 

this is the sql>>

INSERT INTO custom_npc
   (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`, `absorb_type`, `ss`, `bss`, `ss_rate`, `AI`)
VALUES
   (40000, 32174, 'Buff Master', 1, 'Your Title', 1, 'LineageNPC2.K_F1_guard', 13.00, 22.50, 70, 'female', 'L2Npc', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 35, 10, 5879, 590, 1314, 470, 780, 382, 278, 0, 349, 0, 0, 0, 80, 120, '', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'fighter');

If you can fix it so i can use it it will be welcome :D

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

INSERT INTO `custom_npc`  (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`, `absorb_type`, `ss`, `bss`, `ss_rate`, `AI`)

VALUES

  (40000, 32174, 'Buff Master', 1, 'Your Title', 1, 'LineageNPC2.K_F1_guard', 13.00, 22.50, 70, 'female', 'L2Npc', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 35, 10, 5879, 590, 1314, 470, 780, 382, 278, 0, 349, 0, 0, 0, 80, 120, '', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'fighter');If you can fix it so i can use it it will be welcome 

 

 

 

You can add "`"  at custom_npc.

 

Now  complette  `custom_npc`. hope work.

 

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.


×
×
  • Create New...