[Help]Error creating a Npc boss

[Agent Orange]

Hi guys im having some difficulties on adding my npc to my server i used a npc/mob maker by wow-v.com WoW Vendetta - Wage Your War and when i add the npc i get a error saying (SQL Error: Unknown column 'can_ranged' in 'field list')

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('95048', "Shadowmeir the Relinquished", "Boss 2", '', '0', '4', '0', '3', '0', '0', '26693', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('95048', '21', '21', '14', '3250', '3700', '1000', '1', '0', '2200', '0', '60', '75', '0', '1', '1', '1', '600', '380', '2', '2', '2', '2', '2', '2', '1.2', '0', "0", '1', '340000', '0', '0', '0.56', '1.12', '1.44', '0', '0', '0', '0', '0', '0', '0');

can anyone show me whats wrong there? Thanks

[barinar]

You database is not compatible with the entry. What repack are you using and what core does it have?

Try this:

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
values ('95048', "Shadowmeir the Relinquished", "Boss 2", '', '0', '4', '0', '3', '0', '0', '26693', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('95048', '21', '21', '14', '3250', '3700', '1000', '1', '0', '2200', '0', '60', '75', '1', '1', '1', '600', '380', '2', '2', '2', '2', '2', '2', '1.2', '0', "0", '1', '340000', '0', '0', '0.56', '1.12', '1.44', '0', '0', '0', '0', '0', '0', '0');


If that didn't work tell me and I can give you another that may work.

[Agent Orange]

it works thanks alot man