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

lol, guess so.

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

OK tried it and still nothing...

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

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-1ubuntu8.1

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-1ubuntu8.1

Databasepool opened succesfuly. 2 total connections running.

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

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-1ubuntu8.1

[ERROR]: In mysql_stmt_prepare() id: 10, sql: "UPDATE character_banned SET active = 0 WHERE unbandate <= UNIX_TIMESTAMP() AND unbandate <> bandate"

[ERROR]: Table 'characters.character_banned' doesn't exist

~DatabaseWorkerPool for ''.

~DatabaseWorkerPool for 'characters'.

~DatabaseWorkerPool for 'world'.

NVM Re-imported the sql files via ssh and it worked. Guess Navicat is just horrible.

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

You sure you applied all the updates from the trinitycore

Well I used the most current fresh install. I had looked everywhere in the error logs, inc the DB Errors, and nothing. That error shows up in the server.

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

Hey anyone know how I can get this thing up and running? heh, I keep getting this error:

[ERROR]: In mysql_stmt_prepare() id: 0, sql: "DELETE FROM pool_quest_save WHERE pool_id = ?"

[ERROR]: Table 'characters.pool_quest_save' doesn't exist

~DatabaseWorkerPool for ''.

~DatabaseWorkerPool for 'characters'.

~DatabaseWorkerPool for 'world'.

When launching the ./worldserver

using the most up-to-date version of TDB. Does anyone have an idea what's going on?

Trying on a x64 bit install of Ubuntu 10.10.