Jump to content
TrinityCore

[SOLVED]Error Auth


th3ft
 Share

Recommended Posts

i got this error any help?

 

TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win64, Release) (authserver)
<Ctrl-C> to stop.

Using configuration file authserver.conf.
OpenSSL 1.0.2e 3 Dec 2015 (Library: OpenSSL 1.0.2e 3 Dec 2015)
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.5.9
MySQL server ver: 5.1.50-community 
[WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 12, sql: "UPDATE account SET sessionkey = ?, last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE username = ?"
Unknown column 'os' in 'field list'
MySQL client library: 5.5.9
MySQL server ver: 5.1.50-community 
[WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 18, sql: "SELECT id, sessionkey, last_ip, locked, v, s, expansion, mutetime, locale, recruiter, os FROM account WHERE username = ?"
Unknown column 'os' in 'field list'
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database
 

Link to comment
Share on other sites

53 minutes ago, rampage said:

You need to update your MYSQL Server to 5.6 and also update your auth and other databases. (its all in the Wiki).

 

 

50 minutes ago, dreezydylan said:

Indeed.

TC's mysql requierement is 5.1 or higher. updating to 5.6 won't fix nothing.

 

52 minutes ago, dreezydylan said:

[WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements. could be something to do with this

 

The problem indeed, lies here. He needs mysql client and server to be the same.

  • Thanks 1
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...