Help plz . Помощь надо

cloud6x

New member
Новичок
Регистрация
25.04.2019
Сообщения
7
Реакции
0
Баллы
0
Возраст
27
Местоположение
Крым
__ __
/\__ \ _ /\ \
\//\ \/ _ _ /\\ __ /\\ \, _\ _ __
\ \ \/\'__\/\ \ /' _ \/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \\ \ \\ \
\ \\ \\ \ \\ \\ \\ \\ \\\/____ \ \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ /_/> \
C O R E /\___/
TrinityCore \/__/

Using configuration file /root/BFACore/build/etc/bnetserver.conf.
Using SSL version: OpenSSL 1.1.1b 26 Feb 2019 (library: OpenSSL 1.1.1b 26 Feb 2019)
Using Boost version: 1.62.0
Automatic database updates are disabled for all databases!
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 10.1.38-MariaDB
MySQL server ver: 10.1.38-MariaDB-0+deb9u1
Connected to MySQL database at 127.0.0.1
MySQL client library: 10.1.38-MariaDB
MySQL server ver: 10.1.38-MariaDB-0+deb9u1
Connected to MySQL database at 127.0.0.1
DatabasePool 'auth' opened successfully. 2 total connections running.
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 13, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 16, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 21, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 28, 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.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 66, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 67, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 72, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 77, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 85, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 92, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 95, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Unknown column 'battlenet_account' in 'field list'
In mysql_stmt_prepare() id: 100, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 101, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
Closing down DatabasePool 'auth'.
Asynchronous connections on DatabasePool 'auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'auth' closed.
Could not prepare statements of the Login database, see log for details.
Closing down DatabasePool 'auth'.
Asynchronous connections on DatabasePool 'auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'auth' closed.




Просьба помочь в чём может быть проблема?
 
Верх Низ