[Help request] Custom vendors.....

[Ellenor]

i need a complete guide on how to make a custom vendor.... dont tell me about wow vendeta cause it doesnt work.... /cry



[ There was an error while executing a query.
The query and the error message has been logged at:
C:\Documents and Settings\Chris\Application Data\SQLyog\sqlyog.err.
Please click on "Open Error File..." to open the error file. ]

And the error file is

[Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`accountdata0` text NOT NULL,
`accountdata1` text NOT NULL,
`accountdata2` text NOT NULL,
`accountdata3` text NOT NULL,
`accountdata4` text NOT NULL,
`accountdata5` text NOT NULL,
`accountdata6` text NOT NULL,
`accountdata7` text NOT NULL,
PRIMARY KEY (`acct`),
UNIQUE KEY `ind` (`acct`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Error occured at:2008-01-16 19:09:14
Line no.:26
Error Code: 1050 - Table 'account_data' already exists

Query:
INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (40001,2,7,-1,"Soul Warglaive","Soul Warglaive","Soul Warglaive","Soul Warglaive",32837,5,0,2000000000,0000,13,-1,-1,500,254,0,0,0,0,0,0,0,2,1,0, 3,2000, 7,2000, 31,500, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,2140,3980,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,34696,2,0,0,0,0,1 8060,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"To obtain the power of the fallen soul god u have to gather the 300 lost pieces....",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0)

Error occured at:2008-01-18 12:46:05
Line no.:2
Error Code: 1054 - Unknown column 'name' in 'field list'

Query:
INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (40001,2,7,-1,"Soul Warglaive","Soul Warglaive","Soul Warglaive","Soul Warglaive",32837,5,0,2000000000,0000,13,-1,-1,500,254,0,0,0,0,0,0,0,2,1,0, 3,2000, 7,2000, 31,500, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,2140,3980,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,34696,2,0,0,0,0,1 8060,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"To obtain the power of the fallen soul god u have to gather the 300 lost pieces....",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0)

Error occured at:2008-01-18 12:46:49
Line no.:2
Error Code: 1054 - Unknown column 'name' in 'field list'

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (2, 254, 254, 1604, 99999999, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:29:43
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (2, 254, 1604, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:30:25
Line no.:2
Error Code: 1054 - Unknown column 'level' in 'field list'

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (2, 254, 254, 1604, 99999999, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:31:20
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (2, 254, 1604, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:31:26
Line no.:2
Error Code: 1054 - Unknown column 'level' in 'field list'

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (2, 254, 254, 1604, 99999999, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:34:01
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (2, 254, 254, 1604, 99999999, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:36:09
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (2, 254, 254, 1604, 99999999, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:37:09
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (40002, 254, 254, 1604, 99999999, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:43:10
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (40002, 254, 1604, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:43:37
Line no.:2
Error Code: 1054 - Unknown column 'level' in 'field list'

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (40002, 70, 70, 1604, 99999999, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:51:24
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (40002, 70, 1604, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:51:52
Line no.:2
Error Code: 1054 - Unknown column 'level' in 'field list'

Query:
INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (40002, 70, 1604, 99999999, 99999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 21:51:54
Line no.:2
Error Code: 1054 - Unknown column 'level' in 'field list'

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (90000, 1, 1, 12, 1, 1, 1, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 23:30:42
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (90000, 1, 12, 1, 1, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 23:31:10
Line no.:2
Error Code: 1054 - Unknown column 'level' in 'field list'

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (90001, 1, 1, 814, 1, 1, 1, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 23:33:13
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (90001, 1, 1, 814, 1, 1, 1, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 23:33:32
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (16619, 1, 1, 814, 1, 1, 1, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 23:35:28
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (16619, 1, 1, 814, 1, 1, 1, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 23:37:07
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (16619, 1, 814, 1, 1, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-18 23:37:33
Line no.:2
Error Code: 1054 - Unknown column 'level' in 'field list'

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (16619, 1, 1, 814, 1, 1, 1, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-19 09:45:28
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value

Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (90001, 1, 1, 814, 1, 1, 1, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Error occured at:2008-01-19 17:02:25
Line no.:2
Error Code: 1364 - Field 'invisibility_type' doesn't have a default value]


This is what i get from useing wow vendeta... I apologize for that but i dont get it... any help will be welcome and if i can i will give u +Rep
Thank u all

[Ballwinkle]

update your DB then try