["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

It's only hard to see shit when you don't know where to look. I guess trying to learn here is a fucking mistake. Obviously a bunch of pricks and/or immature little bastards. I guess i'll learn elsewhere. 

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

****UPDATE****

 

I got everything compiled but now im doing the world_patches.sql in heidisql and it got a good ways into it and said lost connection to mysql also it says its gonna take 10 hours, i used the merge.bat for windows and did everything as it stated here

 

 

http://collab.kpsn.org/display/tc/How-To_Win+4.3.4#How-To_Win4.3.4-CompilingtheSource

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

I did the complete install and selected windows command prompt, I followed everything the best I could to what I understood.

i think i just seen what you meant, the rev core fix. I dont understand what I did wrong, should i reinstall git and start over?

Fixes "Missing or outdated git - did you forget to install a recent version?" 

 

yes my version is 1.8.3 i didnt read as I should thank you so much and again I am sorry.

[Compile or cmake problems]

I compiled using visual studio 13 express (12 in cmake) on windows 7 64bit, make sure you have  visual C++ redistributable (mines 32 bit x86)

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

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.