Jump to content
TrinityCore
Sign in to follow this  
th3ft

[SOLVED]Error Auth

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
 

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

--- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

  • Upvote 1

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×