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

Hi All,

 

I just pulled the latest updates from git and after re-building I got the following error when trying to start authserver:

 

[richard@wow-svr build]$ /data/trinity/server/bin/authserver
TrinityCore rev. 56c168eef5b3 2013-08-27 05:14:18 +0200 (master branch) (Unix, Release) (authserver)
<Ctrl-C> to stop.

Using configuration file /data/trinity/server/etc/authserver.conf.
OpenSSL 1.0.0 29 Mar 2010 (Library: OpenSSL 1.0.0-fips 29 Mar 2010)
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.1.69
MySQL server ver: 5.1.69
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.1.69
MySQL server ver: 5.1.69
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 13, sql: "SELECT a.sha_pass_hash, a.id, a.locked, a.lock_country, a.last_ip, aa.gmlevel, a.v, a.s, a.token_key FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.username = ?"
Unknown column 'a.token_key' in 'field list'
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database
 

Any ideas? I verified that the auth database is up by looking at the realmlist table.

 

Richard.

[Compile or cmake problems]

Thanks, already found it. That !@#$%^&&*( HeidiSQL says it has updated the table, but when I do a select * from realmlist, it isn't updated at all.

[Compile or cmake problems]

Hi All,

 

I had configured the IP-address 192.168.1.17 in the realmlist table in the auth database. For testing purposes (it's running in a Linux VM) I changed the entry to reflect 192.168.226.18 (internal VMware LAN), but when I start authserver it still displays:

 

Using configuration file /data/trinity/server/etc/authserver.conf.
OpenSSL 1.0.0 29 Mar 2010 (Library: OpenSSL 1.0.0-fips 29 Mar 2010)
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connection                                                                                                          s: 1.
MySQL client library: 5.1.69
MySQL server ver: 5.1.69
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.1.69
MySQL server ver: 5.1.69
Connected to MySQL database at 127.0.0.1
DatabasePool 'auth' opened successfully. 2 total connections running.
Started auth database connection pool.
Updating Realm List...
Added realm "Trinity" at 192.168.1.17:8085.
 

Have I missed something somewhere, I cannot find any references to 192.168.1.17 anywhere.

 

Richard.