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

Problem fixed

i dont know why SQLyog didn´t copy some tables on the db

i change the program to update db and it works fine ^^

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

hello!

i compile trinity core following the steps of the wiki and i get this error:

Opening databasepool 's0_world'. Async threads: 1, synch threads: 1

MySQL client library: 5.5.10

MySQL server ver: 5.5.10

MySQL client library: 5.5.10

MySQL server ver: 5.5.10

Databasepool opened succesfuly. 2 total connections running.

Opening databasepool 's0_characters'. Async threads: 1, synch threads: 2

MySQL client library: 5.5.10

MySQL server ver: 5.5.10

[ERROR]: In mysql_stmt_prepare() id: 13, sql: "SELECT guid, account, name, race,

class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags,positio

n_x, position_y, position_z, map, orientation, taximask, cinematic, totaltime, l

eveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost,resettal

ents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_sl

ots, at_login, zone, online, death_expire_time, taxi_path, instance_mode_mask,ar

enaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills,

todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk

,health, power1, power2, power3, power4, power5, power6, power7, instance_id, sp

eccount, activespec, exploredZones, equipmentCache, ammoId, knownTitles, actionB

ars FROM characters WHERE guid = ?"

[ERROR]: Unknown column 'instance_mode_mask' in 'field list'

~DatabaseWorkerPool for ''.

~DatabaseWorkerPool for 's0_characters'.

~DatabaseWorkerPool for 's0_world'.

i can only see the error if i start the program by console, if i clik the .exe no logs appear, only that:

2011-03-27 14:04:07 Using configuration file worldserver.conf.

2011-03-27 14:04:07 TrinityCore Rev: 0 Release Hash: Archive (Win32, little-endian) (core-daemon)

2011-03-27 14:04:07 <Ctrl-C> to stop.

2011-03-27 14:04:07 ______ __

2011-03-27 14:04:07 /\__ _\ __ __/\ \__

2011-03-27 14:04:07 \/_/\ \/ _ __ /\_\ ___ /\_\ \ ,_\ __ __

2011-03-27 14:04:07 \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \

2011-03-27 14:04:07 \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \

2011-03-27 14:04:07 \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \

2011-03-27 14:04:07 \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \

2011-03-27 14:04:07 C O R E /\___/

2011-03-27 14:04:07 http://TrinityCore.org \/__/

i get the sql files from

world https://github.com/downloads/TrinityCore/TrinityCore/TDB_335.11.38_2011_03_05.rar

characters and auth from https://github.com/TrinityCore/TrinityCore/zipball/3.3.5a-clientsupport

how can i solve this problem?

thanks!