C:TrinityBuildbinRelease>worldserver
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1g 7 Apr 2014 (library: OpenSSL 1.0.1g 7 Apr 2014
)
Using ACE version: 6.1.4
TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Rel
ease) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/__ _ __ __/ __
/_/ / _ __ /_ ___ /_ , _ __ __
/`'__/ /' _ `/ / / /
/ / / _ _
_ _ _ _ _ _ __/`____
/_//_/ /_//_//_//_//__/ `/___/>
C O R E /___/
http://TrinityCore.org /__/
In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction = ? W
HERE entry = ?"
Unknown column 'faction' in 'field list'
In mysql_stmt_prepare() id: 53, sql: "SELECT name, permission, help FROM command
"
Unknown column 'permission' in 'field list'
In mysql_stmt_prepare() id: 54, sql: "SELECT difficulty_entry_1, difficulty_entr
y_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3,
modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, exp
_unk, faction, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgs
chool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class,
unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_class, tra
iner_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, type_f
lags2, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3,
resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, s
pell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, Move
mentType, InhabitType, HoverHeight, Health_mod, Mana_mod, Mana_mod_extra, Armor_
mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, q
uestItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptNam
e FROM creature_template WHERE entry = ?"
Unknown column 'faction' in 'field list'
DatabasePool world NOT opened. There were errors opening the MySQL connections.
Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;root;ascent;world
C:TrinityBuildbinRelease>
That's the error from worldserver.exe
I'm running the latest from github, compiled myself after 3 days of reading and fighting with it lmao.
I am a newbie at this but i created all the vmaps maps mmaps dbc etc i downloaded a tbc world database (TDB_full_434.05_2013_07_17) mysql is setup i can connect via heidisql, shows everything was imported, windows 7 64bit, all updates, a repack worked for me but i want to learn myself from compiling to setting it up then to scripting, asking as few questions as i have to.
My biggest concern i tried googling it and searching here but failed to find it, where does a world database come from, how can i make one? is it basically a script that has the coordinates of every npc/mob? I want to make my own but if that's the case im going to use someone elses. If I forgot anything I apologize i'll be roaming around here for some time. been working on this today since 2:30pm CST it's currently 6:37pm I didn't want to ask anyone but I am completely stumped.