Error In Creature_template Table Mangos
Contents |
Builder smart_scripts What’s new Available Gadgets About Confluence Lightbox Log quest_template in Sign up TrinityCorePagesQuestionsSpace shortcutsCommunity ForumsGithubCode Documentation@TrinityMMoHow-to articlesPage tree Browse pagesConfigureSpace tools Attachments
Cmangos
(0) Page History Page Information Resolved comments Link to this Page… View in Hierarchy View Source Export to PDF Export to Word Pages … TrinityCore Home Databases
Wowhead
World Skip to end of banner JIRA links Go to start of banner creature_template Skip to end of metadata Created by King Pin, last modified by tkrokli on Oct 07, 2016 Go to start of metadata 0x0080Back-to:WorldThe `creature_template` tableThis table contains the description of creatures. Each spawned creature is an instance of a template present in this table, this means every creature MUST be defined in this table.StructureFieldTypeAttributesKeyNullDefaultExtraCommententrymediumint(8)unsignedPRINO0difficulty_entry_1mediumint(8)unsignedNO0difficulty_entry_2mediumint(8)unsignedNO0difficulty_entry_3mediumint(8)unsignedNO0KillCredit1int(11)unsignedNO0KillCredit2int(11)unsignedNO0modelid1mediumint(8)unsignedNO0modelid2mediumint(8)unsignedNO0modelid3mediumint(8)unsignedNO0modelid4mediumint(8)unsignedNO0namechar(100)signedNO0subnamechar(100)signedYESNULLIconNamechar(100)signedYESNULLgossip_menu_idmediumint(8)unsignedNO0minleveltinyint(3)unsignedNO1maxleveltinyint(3)unsignedNO1expsmallint(2)signedNO0factionsmallint(5)unsignedNO0npcflagint(10)unsignedNO0speed_walkfloatsignedNO1Result of 2.5/2.5, most common valuespeed_runfloatsignedNO1.14286Result of 8.0/7.0, most common valuescalefloatsignedNO1ranktinyint(3)unsignedNO0dmgschooltinyint(4)signedNO0BaseAttackTimeint(10)unsignedNO0RangeAttackTimeint(10)unsignedNO0BaseVarianceRangeVarianceunit_classtinyint(3)unsignedNO0unit_flagsint(10)unsignedNO0unit_flags2int(10)unsignedNO0dynamicflagsint(10)unsignedNO0familytinyint(4)signedNO0trainer_typetinyint(4)signedNO0trainer_spellmediumint(8)unsignedNO0trainer_classtinyint(3)unsignedNO0trainer_racetinyint(3)unsignedNO0typetinyint(3)unsignedNO0type_flagsint(10)unsignedNO0lootidmediumint(8)unsignedNO0pickpocketlootmediumint(8)unsignedNO0skinlootmediumint(8)unsignedNO0resistance1smallint(5)signedNO0resistance2smallint(5)signedNO0resistance3smallint(5)signedNO0resistance4smallint(5)signedNO0r
with Google Sign Up Topics All Content This Topic This Forum Advanced Search Home Forums Downloads Tracker wiki Blogs Browse Join Us History Chat Calendar Member Map Staff More Activity All Activity Github Activity Bug Tracker Activity WIKI Activity My Activity Streams Bug Tracker Activity WIKI Activity Search More More All Activity Home Forums getMaNGOS Archives Old Mangos Community Forum OldInstallation, configuration & upgrades creature_template error Sign in to follow this Followers 0 creature_template error Started by Guest Flousedid, April 30, 2011 4 posts in this topic Flousedid https://trinitycore.atlassian.net/wiki/display/tc/creature_template 0 Member Members 0 12 posts Posted April 30, 2011 Hi ! Today, i'm trying to make clean install. I use RSA branch and YTDB. I install clean BDD with ALL updates. And i've got this error on startup : ERROR:Error in creature_template table, probably sql file format was updated (there should be 90 fields in sql). WTF ? There is only 85 fields https://www.getmangos.eu/forums/topic/5820-creature_template-error/ in original mangos.sql !! Here is my Server.log : http://pastebin.com/sUEGffHj Thanks by advance. Share this post Link to post Share on other sites Flousedid 0 Member Members 0 12 posts Posted April 30, 2011 In /sql/mangos.sql : DROP TABLE IF EXISTS `creature_template`; CREATE TABLE `creature_template` ( `entry` mediumint(8) unsigned NOT NULL default '0', `difficulty_entry_1` mediumint(8) unsigned NOT NULL default '0', `difficulty_entry_2` mediumint(8) unsigned NOT NULL default '0', `difficulty_entry_3` mediumint(8) unsigned NOT NULL default '0', `KillCredit1` int(11) unsigned NOT NULL default '0', `KillCredit2` int(11) unsigned NOT NULL default '0', `modelid_1` mediumint(8) unsigned NOT NULL default '0', `modelid_2` mediumint(8) unsigned NOT NULL default '0', `modelid_3` mediumint(8) unsigned NOT NULL default '0', `modelid_4` mediumint(8) unsigned NOT NULL default '0', `name` char(100) NOT NULL default '0', `subname` char(100) default NULL, `IconName` char(100) default NULL, `gossip_menu_id` mediumint(8) unsigned NOT NULL default '0', `minlevel` tinyint(3) unsigned NOT NULL default '1', `maxlevel` tinyint(3) unsigned NOT NULL default '1', `minhealth` int(10) unsigned NOT NULL default '0', `maxhealth` int(10) unsigned NOT NULL default '0', `minmana` int(10) unsigned NOT NULL default '0', `maxmana` int(10) unsigned NOT NULL default '0', `armor` mediumint(8) unsigned NOT NULL default '0', `faction_A` smallint(5) uns
"battleground_events" table "battleground_template" table "battlemaster_entry" table "command" table "conditions" table "creature_addon" http://docs.getmangos.com/en/latest/database/world/creature-template.html table "creature_ai_scripts" table "creature_ai_summons" table "creature_ai_texts" table "creature_battleground" table "creature_equip_template_raw" table "creature_equip_template" table "creature_involvedrelation" table "creature_linking" table "creature_linking_template" http://www.gamers-forum.com/showthread.php?5665-MANGOS-World-of-Warcraft-Private-Server-Help table "creature_loot_template" table "creature_model_info" table "creature_movement" table "creature_movement_template" table "creature_onkill_reputation" table "creature_questrelation" table "creature" table "creature_template_addon" table "creature_template_classlevelstats" error in table "creature_template" table Table structure Fields Entry Name SubName MinLevel MaxLevel ModelId1 ModelId2 FactionAlliance FactionHorde Scale Family CreatureType InhabitType RegenerateStats RacialLeader NpcFlags UnitFlags DynamicFlags ExtraFlags CreatureTypeFlags SpeedWalk SpeedRun UnitClass Rank HealthMultiplier PowerMultiplier DamageMultiplier DamageVariance ArmorMultiplier ExperienceMultiplier MinLevelHealth error in creature_template MaxLevelHealth MinLevelMana MaxLevelMana MinMeleeDmg MaxMeleeDmg MinRangedDmg MaxRangedDmg Armor MeleeAttackPower RangedAttackPower MeleeBaseAttackTime RangedBaseAttackTime DamageSchool MinLootGold MaxLootGold LootId PickpocketLootId SkinningLootId KillCredit1 KillCredit2 MechanicImmuneMask ResistanceHoly ResistanceFire ResistanceNature ResistanceFrost ResistanceShadow ResistanceArcane PetSpellDataId MovementType TrainerType TrainerSpell TrainerClass TrainerRace TrainerTemplateId VendorTemplateId GossipMenuId EquipmentTemplateId Civilian AIName ScriptName "creature_template_spells" table "dbscripts_on_creature_death" table "dbscripts_on_creature_movement" table "dbscripts_on_event" table "dbscripts_on_gossip" table "dbscripts_on_go_template_use" table "dbscripts_on_go_use" table "dbscripts_on_quest_end" table "dbscripts_on_quest_start" table "dbscripts_on_spell" table "db_script_string" table "db_version" table "disenchant_loot_template" table "exploration_basexp" table "fishing_loot_template" table "game_event_creature_data" table "game_event_creature" table "game_event_gameobject" table "game_event_mail" table "game_event_quest" table "game_event" table "game_graveyard_zone" table "gameobject_battleground" table "gameobject_involvedrelation" table "gameobject_loot_template" table "gameobject_questrelation" table "gameobject" table "gameobject_template" table "game_tele" table "game_weather" table "gossip_menu_option" table "gossip_menu" table "instance_template" table "item_enchantment_templ
MANGOS World of Warcraft Private Server Help If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Welcome to Gamers Forum, it seems you are no registered yet, Please take the time to Register and join our great community. If you are having registration problems please use the Contact Us form to send us a message. Welcome to the forum! It seems you have not made your first post yet. Please take the time to introduce yourself in our New Gamers section. Ask all questions there and welcome to the forum. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 12 Thread: MANGOS World of Warcraft Private Server Help Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-07-2008,03:51 PM #1 Dflat Major View Profile View Forum Posts Private Message View Blog Entries Visit Homepage Game Addict Join Date Jan 2008 Location I am Everywhere Posts 242 MANGOS World of Warcraft Private Server Help I'm sure some people know how this works. Anyway, I'm having this problem. My realmd.conf looks like so: # MaNGOS realmd configuration file ConfVersion=2007062001 # Database connection settings for the realm server. # Default: hostname;port;username;password;database # .;somenumber;username;password;database - use named pipes at Windows # Named pipes: mySQL required adding "enable-named-pipe" to [mysqld] section my.ini # .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux # Unix sockets: experimental, not tested LoginDatabaseInfo = "127.0.0.1;3306;mangos;root;realmd" # Logs directory setting. # Important: Logs dir must exists, or all logs be disable # Default: "" - no log directory prefix, if used log names isn't absolute path then logs will be stored in current directory for run program. LogsDir = "" # Settings for maximum database-ping interval (minutes between pings) MaxPingTime = 30 # Default RealmServerPort RealmServerPort = 3724 # Bind Realm Server to IP/hostname BindIP = "0.0.0.0" # realmd daemon PID file # Default: "" - do not create PID file # "./realmd.pid" - create PID file (recommended name) PidFile = "" # Server console level of logging # 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug # Default: 0 LogLevel = 0 #