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

One question. What makes you think you need to run world_2013_07_17_2014_03_29.sql after TDB_full_335.53_2014.03.29.sql? (to see if we can fix wiki)

Dunno what makes me to run it, when i saw that something is wrong in world database i try that...I didnt read whole wiki... that was the problem... On wiki there is  clearly ...sqlupdatesworld 

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

Drop world DB

Recreate world DB

Run TDB_full_335.53_2014.03.29.sql to it (or whatever its called). Just the big SQL. No updates.

Navitage to TC Source/sql/updates/world

Run all SQLs in order in that folder.

On windows you can easily merge them with a bat: copy *.sql mrg.sql

 thx Rotchet, the best like always, can u tell me is there way to "copy" custom-creatures/items(dont know is the item table changed) from old creature_table structure to this ? Or i will need to edit and merge manualy "factionA" and "factionH" into "faction"

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

Hello, 

 

i'v pulled trinity source from https://github.com/TrinityCore/TrinityCore.git  and compile it

then i download database from  http://www.trinitycore.org/f/files/file/5-tdb-full-updates/ i'v downloaded TDB_full_335.53_2014.03.29.7zip and execute it into world database which was empty (fresh db)

 

after setting auth and worldserver confing i run server and i got DB errors

Unknown column 'faction' in 'field list'
Unknown column 'BroadcastTextID' in 'field list'

and now i dont know what to do.

i tried to run the world_2013_07_17_2014_03_29.sql from update_only and i got sql error for missing table "creature_ai_scripts"

 

any help?

thx