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

If you are updating a older core you need to apply the auth/characters sqls from the date of your previous core to the current date PLUS the world sqls from the full tdb date to the current core date.

Ah! I get ya! Thank you ima give it a go now! Thanks.

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

 [ERROR]: In mysql_stmt_prepare() id: 154, sql: "INSERT INTO channels(name, team,

 lastUsed) VALUES (?, ?, UNIX_TIMESTAMP())"

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

You forgot to apply some sql.

I used to full TBD. I still need to add the previous world sql???

The other sql in the pack are older versions...Correct?

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

may you have to change your worldserver.conf file but this is trinity?

we just talk about trinity core here

Yes sir! Trinity 11360 and i updated to the new 335.11.38 and i got this. Spent about 5 hours trying to figure it out...Erm..no success....=P

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

______ __

/\__ _\ __ __/\ \__

\/_/\ \/ _ __ /\_\ ___ /\_\ \ ,_\ __ __

\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \

\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \

\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \

\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \

C O R E /\___/

http://TrinityCore.org \/__/

SFMT has been enabled as the random number generator, if worldserver

freezes or crashes randomly, first, try disabling SFMT in CMAKE configuration

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

MySQL client library: 5.5.9

MySQL server ver: 5.5.10

[WARNING] MySQL client/server version mismatch; may conflict with behaviour of p

repared statements.

MySQL client library: 5.5.9

MySQL server ver: 5.5.10

[WARNING] MySQL client/server version mismatch; may conflict with behaviour of p

repared statements.

Databasepool opened succesfuly. 2 total connections running.

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

MySQL client library: 5.5.9

MySQL server ver: 5.5.10

[WARNING] MySQL client/server version mismatch; may conflict with behaviour of p

repared statements.

[ERROR]: In mysql_stmt_prepare() id: 154, sql: "INSERT INTO channels(name, team,

lastUsed) VALUES (?, ?, UNIX_TIMESTAMP())"

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

~DatabaseWorkerPool for ''.

~DatabaseWorkerPool for 'characters'.

~DatabaseWorkerPool for 'world'.