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

Now you forget some SQL updates.

Ive run through the SQL updates so many times that I accidentally skipped 1 this time xD.

or jumped over 1.

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

Issue Fixed... Thank you from your support

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

Just delete the folder where you have the sources, and follow the wiki to get again the sources from the repo and compile it.

Or if you don't want to follow and learn that "boring" stuff, check my signature.

Alright, Thanks from the help. Ill try it out and see if it works.

p.s

I want to learn the stuff but I doubt I can resist your post

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

Delete your repo and get the sources from the official git.

That TrinityCore status as changed some time ago.

I'm not sure what you mean, I believe I don't know any other git's than the one at the wikipedia.

My debian skills are lame, so only way for me to compile a core is to go step by step with wiki.

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

Heh... getting rather irritated with this problem >_<, every time I manage to solve it... It just pops out of no where to greet me.

OS: Debian 6.0 -64bits

DB Ver: TDB 335.11.39

- All Updates included

Core Rev: 13e85f861f61340b23afd1e919846a153a1bdfea (git rev-list --max-count=1 HEAD)

git pull origin master

From https://github.com/TrinityCoreOrg/TrinityCore

 * branch            master     -> FETCH_HEAD

Already up-to-date.

Using configuration file /home/trinity/server//etc/worldserver.conf.

TrinityCore Rev: 0 Release Hash: Archive (Unix, little-endian) (core-daemon)

<Ctrl-C> to stop.


 ______                       __

/\__  _\       __          __/\ \__

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

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

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

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

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

                                 C O R E  /\___/

http://TrinityCore.org                    \/__/


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

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-3

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-3

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-3

[ERROR]: In mysql_stmt_prepare() id: 33, sql: "SELECT map, zone, position_x, position_y, position_z FROM character_homebind WHERE guid = ?"

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

~DatabaseWorkerPool for ''.

~DatabaseWorkerPool for 'characters'.

~DatabaseWorkerPool for 'world'.

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

You're missing some SQL updates between your current DB revision and the Core revision. They need to match..

Wasn't the chase. I thought I made it pretty clear earlier.

But got it working. Topic can be closed.

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

Operating System: Debian 6 x64

Core Rev: Can be Honest here that I'm not 100% sure, The core was Compiled 5.5.2011 around 1AM GMT 0

DataBase Rev: The DB was pulled and updated at the same time.

[ERROR]: In mysql_stmt_prepare() id: 33, sql: "SELECT map, zone, position_x, position_y, position_z FROM character_homebind WHERE guid = ?"

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

As far as I understand, Its trying to find Data from wrong named Columns?

I did everything by the TC2 wiki and went it through step by step and I even did it twice. So I'm kinda running out of ideas?

I guess I could Alter the Columns into new names. but wanted to ask what would you suggest?