[Archive] authserver error

rektbyfaith

11-04-2025, 05:16 PM #1

Archived author: ahmad2020ayyat • Posted: 2025-11-04T18:16:29.641641
Original source

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 :

Quote: 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: 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

Click to expand...

i read them and realized that there is no account table but i don't know how to fix

any ideas on how to retrieve the {table: (account)}?

Reply

rektbyfaith

11-04-2025, 05:16 PM #2

Archived author: ahmad2020ayyat • Posted: 2025-11-04T18:16:29.641641
Original source

Have you opened the MySQL bat? It seems to me that you don't have it open, or you have incorrect databases. (Auth in this case)

Reply

rektbyfaith

11-04-2025, 05:16 PM #3

Archived author: ahmad2020ayyat • Posted: 2025-11-04T18:16:29.641641
Original source

Quote:ExO said:

Have you opened the MySQL bat? It seems to me that you don't have it open, or you have incorrect databases. (Auth in this case)

Click to expand...

This

Perhaps you didn't apply updates?

For me it seems that the auth is there yet the tables ain't.

Reply

Recently Browsing
1 Guest(s)