ahmad2020ayyat
Trial Member
- 2
- 2016
- 0
Hello when I launch the authserver it crashes instantly I have maps/vmaps/dbc in my repack directory and i made sure that MySQL is running but it keeps crashing here are the auth logs :
any ideas on how to retrieve the {table: (account)}?
i read them and realized that there is no account table but i don't know how to fixTrinityCore 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: 11, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 12, sql: "UPDATE account SET sessionkey = ?, last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "UPDATE account SET failed_logins = failed_logins + 1 WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO account(username, sha_pass_hash, joindate) VALUES(?, ?, NOW())"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 64, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
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: 6, sql: "SELECT account.id, username FROM account, account_banned WHERE account.id = account_banned.id AND active = 1 GROUP BY account.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "SELECT account.id, username FROM account, account_banned WHERE account.id = account_banned.id AND active = 1 AND username LIKE CONCAT('%%', ?, '%%') GROUP BY account.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "SELECT a.sessionkey, a.id, aa.gmlevel FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 13, sql: "SELECT a.sha_pass_hash, a.id, a.locked, a.last_ip, aa.gmlevel, a.v, a.s FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 15, sql: "SELECT id, failed_logins FROM account WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 16, sql: "SELECT id FROM account WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "SELECT id, username FROM account WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "SELECT id, sessionkey, last_ip, locked, v, s, expansion, mutetime, locale, recruiter, os FROM account WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 19, sql: "SELECT id, username FROM account WHERE email = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 21, sql: "SELECT id, username FROM account WHERE last_ip = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "SELECT 1 FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 48, sql: "SELECT id FROM account WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 51, sql: "SELECT username FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 52, sql: "SELECT 1 FROM account WHERE id = ? AND sha_pass_hash = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 53, sql: "SELECT 1 FROM account WHERE username = ? AND sha_pass_hash = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 54, sql: "SELECT a.username, aa.gmlevel, a.email, a.last_ip, DATE_FORMAT(a.last_login, '%Y-%m-%d %T'), a.mutetime FROM account a LEFT JOIN account_access aa ON (a.id = aa.id AND (aa.RealmID = ? OR aa.RealmID = -1)) WHERE a.id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 56, sql: "SELECT a.username, aa.gmlevel FROM account a, account_access aa WHERE a.id=aa.id AND aa.gmlevel >= ? AND (aa.realmid = -1 OR aa.realmid = ?)"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 57, sql: "SELECT a.username, a.last_ip, aa.gmlevel, a.expansion FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 59, sql: "SELECT a.id, aa.gmlevel, aa.RealmID FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 60, sql: "SELECT 1 FROM account WHERE recruiter = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "SELECT username, email, last_ip FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database
any ideas on how to retrieve the {table: (account)}?
Last edited: