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

Alright now the worldserver.exe is working. All the .conf files are fine but now I'm getting this with my authserver.exe

 

Using configuration file authserver.conf

OpenSSL 1.0.01 6 Jan 2014 (Library: OpenSSL 1.0.01 6 Jan 2014)

Database not specified

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

AGAIN You CAN'T have that error with TDB 53.

I'll try and delete the whole thing and remake it. I'll let you know

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

I've tried everything but I keep getting this error. I already updated Aokromes

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

Like i said TDB 53, there is only one TDB 53.

TDB_full_335.53_2014_03_29.7z

I updated but I'm still getting the errors

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

Like i said TDB 53, there is only one TDB 53.

TDB_full_335.53_2014_03_29.7z

Alright thank you. I use HeidiSQL (since it's my first time), is there a specific way to update that's recommendable? 

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

Get TDB53 to fix your problems.

Which version? There are 8 different versions. The one I'm using right now is the latest one. The client I'm using is the client I used for a 3.5.5a private server.

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

There was a problem connecting, because..

1. MySQL is not setup according to the wiki, or

2. You didn't run the updates.

unknown column 'permission' in field list.

I'm leaning toward number 2.

MySQL will try to read a DB/Table, when it's presented with too many errors than MySQL will dump the connection.

thus the...

Cannot connect to ...

It's not always a permission or "access" issue.

Alright when you say "run the updates" how exactly should I understand that? I mean how should I do that. Thank you!

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

So I'm setting up my own localhost server to practise SQL on. I've follow this guide " http://collab.kpsn.org/display/tc/How-to_Win " but I'm getting a very odd error that I can't seem to fix when I run the worldserver.exe:

 

 

I've filled the following in in my worldserver.conf file:

 

LoginDatabaseInfo     = "127.0.0.1;3306;root;password;auth"

WorldDatabaseInfo     = "127.0.0.1;3306;root;password;world"

CharacterDatabaseInfo = "127.0.0.1;3306;root;password;characters"

 

 

And the following in my authserver.conf file:

 

LogindDatabaseInfo = "127.0.0.1;3306;root;password;auth"

 

 

I can't seem to find the issue, is there anything I'm missing? Any help is appreciated, I'll of course provide any information to you need regarding the tables and columns in my db.

 

Oh and by the way this is my first time ever setting up a trinitycore server and my first time with SQL in general (almost). Thank you!