th3ft Posted April 4, 2016 Report Share Posted April 4, 2016 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 More sharing options...
dreezydylan Posted April 5, 2016 Report Share Posted April 5, 2016 Did you set permission in config file? Link to comment Share on other sites More sharing options...
rampage Posted April 5, 2016 Report Share Posted April 5, 2016 You need to update your MYSQL Server to 5.6 and also update your auth and other databases. (its all in the Wiki). Link to comment Share on other sites More sharing options...
dreezydylan Posted April 5, 2016 Report Share Posted April 5, 2016 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements. could be something to do with this Link to comment Share on other sites More sharing options...
dreezydylan Posted April 5, 2016 Report Share Posted April 5, 2016 2 hours 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). Indeed. Link to comment Share on other sites More sharing options...
Aokromes Posted April 5, 2016 Report Share Posted April 5, 2016 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. 1 Link to comment Share on other sites More sharing options...
Shauren Posted April 5, 2016 Report Share Posted April 5, 2016 No no no no and no. The problem here is that this guy is missing a field in his account table https://github.com/TrinityCore/TrinityCore/blob/3.3.5/sql/base/auth_database.sql#L48 1 Link to comment Share on other sites More sharing options...
th3ft Posted April 5, 2016 Author Report Share Posted April 5, 2016 (edited) Thanks everyone for help Fixed it i miss something in account table:) Edited April 5, 2016 by th3ft Link to comment Share on other sites More sharing options...
Shauren Posted April 5, 2016 Report Share Posted April 5, 2016 --- 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 --- 1 Link to comment Share on other sites More sharing options...
Recommended Posts