• 0

Porbl with one sql file..

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

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.

Share on other sites

• 0

Thx a lot for you answer but i just changed the duration of buffs in the old buffer but i dont have bersk :P np my server will be with no bersk :P

If a Mod pass from here Lock it :P

Share on other sites

This topic is now closed to further replies.

• Posts

• My friends have told me about this server numerous amounts of time. Today Im finally here to share some amazing experiences with them😀 I look forward to getting to know this wonderful community and staff members. Good luck to all of us! 🥳
• Great server so far,good rates balances classes awesome player  community and server staff.If you want a balanced gameplay without pay to win and full of bots this is the place!
• For what chronicle can you use that interface?
• New changelog: - Event Freya's Gift started - Changed Compelling Wind cooldown to fixed 7.5s and reduced chance of applying the debuff - Changed Deceptive Blink cooldown to fixed 15s - Changed Wind Blend cooldown to fixed 20s - Old L2Store sales ended - New L2Store sales started - Fixed issue with an account creation - Fixed few RU item descriptions having wrong values - Fixed issue with .offline store - Boosted chance of quest item drop for few low level quests - Adjusted few blacklisted words to be less aggressive
• not interested in trading on this nest scamm site. scammer nr 1 VSignet money sent > but all the time he couldn't get to pc.. just forwarding meeting to fooks know what H.   and scammer nr 2, retard from ukraine sent him 40 euros, he blocks me and never sent money ig.   just be carefull people. I'm out of here.
• Topics

×
×
• Create New...