Jump to content
TrinityCore

mrendoftheline

Plebs
  • Posts

    6
  • Joined

  • Last visited

mrendoftheline's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. That's really odd. My client is 7.3.5.26972, which according to the trinitycore branch is the same exact one.
  2. Is this an indication that the client version is older than the core then? Or vise versa
  3. I'm attempting to get the maps generated for this version of the core but it's running in to errors and can't extract them. Here is a small portion of the errors but they all resemble the same thing. I tried looking around for some answers but couldn't find much on it. Can't read DB2 headers of 'WorldStateExpression.db2': Incorrect file signature in FileDataId: 1332558, expected 'WDC3', got WDC1 Can't read DB2 headers of 'WorldStateZoneSounds.db2': Incorrect file signature in FileDataId: 1266941, expected 'WDC3', got WDC1 Can't read DB2 headers of 'World_PVP_Area.db2': Incorrect file signature in FileDataId: 1310255, expected 'WDC3', got WDC1 Can't read DB2 headers of 'ZoneIntroMusicTable.db2': Incorrect file signature in FileDataId: 1310251, expected 'WDC3', got WDC1 Can't read DB2 headers of 'ZoneLight.db2': Incorrect file signature in FileDataId: 1310253, expected 'WDC3', got WDC1 Can't read DB2 headers of 'ZoneLightPoint.db2': Incorrect file signature in FileDataId: 1310256, expected 'WDC3', got WDC1 Can't read DB2 headers of 'ZoneMusic.db2': Incorrect file signature in FileDataId: 1310254, expected 'WDC3', got WDC1 Can't read DB2 headers of 'ZoneStory.db2': Incorrect file signature in FileDataId: 1797864, expected 'WDC3', got WDC1 Extracted 0 files I've confirmed the game files are complete as well.
  4. Forgive me lack of knowledge on this but per the installation instructions on the trinitycore tutorial it states that the master branch supports Legion. I find this just a tad confusing because all the other documentation for it seem as though the master branch is currently functioning as Shadowlands core. If that is the case, which I assume it is, I'm wondering if there's a way to get previous revisions of the master branch (say 7.3.5) in order to get a functioning Legion server going. And yes, I know there are projects such as ashermane that have their own github, but it doesn't appear functional with ubuntu sadly so I wanted to see if I could obtain previous revisions somehow. Thank you ahead of time, I know it seems like a super rookie question.
  5. So I've created a new tinitycore server from scratch and the only things I've moved from my previous SQL server is the character database. I had to manually link my ID back to the number it was again to get my characters to show up which worked fine and I'm able to login and I still have all my gear/spawned where I last was/ect. The only problem that I can see so far is there seems to be an issue when I go to open up my blacksmithing menu I get Couldn't lod Blizzard_TradeSkillUI: Banned. I don't see any banned addons in my SQL database at the moment. Another problem is the same error message only for achievements and the combat log not being able to load due to "Banned". If anyone has any idea what this could be in relation to it would be very helpful. I would note that the SQL database I was utilizing is based off an earlier version of trinitycore, though I don't think it was too far behind current. I was utilizing this repacks database - https://www.ac-web.org/forums/showthread.php?211443-Official-AC-Web-Ultimate-Repack-(3-3-5a)(Eluna-Engine)
  6. Hi all, Sorry ahead of time if this is a noob-ish question as I'm fairly new to dealing with SQL. I've exported all the data from my Windows SQL server that functions normally and attempted to import to ubuntu after all previous setup. I've ensure I'm operating off the 5.7 revision of MySQL already just to make sure. When I try to kick up the Auth server I'm getting a few errors with the database and I've referred to the old sql database to ensure they match 1 for 1 with the Windows version so I can confirm that the import was at the very least successful in gather all the needed data. This is what I'm currently seeing upon attempting to launch the Auth server and was hoping to get some assistance with this. I can tell it's not liking perhaps some of the format that the db is in or something of that sort but any guidance is helpful. Thank you ahead of time. --- Using configuration file /home/trinitycore/server/etc/authserver.conf. Using SSL version: OpenSSL 1.1.1f 31 Mar 2020 (library: OpenSSL 1.1.1f 31 Mar 2020) Using Boost version: 1.71.0 Automatic database updates are disabled for all databases! Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1. MySQL client library: 10.3.25 MySQL server ver: 5.7.34 Connected to MySQL database at 127.0.0.1 MySQL client library: 10.3.25 MySQL server ver: 5.7.34 Connected to MySQL database at 127.0.0.1 DatabasePool 'auth' opened successfully. 2 total connections running. In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET salt = ?, verifier = ? WHERE id = ?" Unknown column 'salt' in 'field list' In mysql_stmt_prepare() id: 12, sql: "SELECT a.id, a.username, a.locked, a.lock_country, a.last_ip, a.failed_logins, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.SecurityLevel, a.totp_secret, a.salt, a.verifier FROM account a LEFT JOIN account_access aa ON a.id = aa.AccountID LEFT JOIN account_banned ab ON ab.id = a.id AND ab.active = 1 WHERE a.username = ?" Unknown column 'aa.SecurityLevel' in 'field list' In mysql_stmt_prepare() id: 13, sql: "SELECT a.id, UPPER(a.username), a.locked, a.lock_country, a.last_ip, a.failed_logins, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.SecurityLevel, a.session_key_auth FROM account a LEFT JOIN account_access aa ON a.id = aa.AccountID LEFT JOIN account_banned ab ON ab.id = a.id AND ab.active = 1 WHERE a.username = ? AND a.session_key_auth IS NOT NULL" Unknown column 'aa.SecurityLevel' in 'field list' In mysql_stmt_prepare() id: 17, sql: "SELECT a.id, a.session_key_auth, a.last_ip, a.locked, a.lock_country, a.expansion, a.mutetime, a.locale, a.recruiter, a.os, aa.SecurityLevel, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account_access aa ON a.id = aa.AccountID AND aa.RealmID IN (-1, ?) LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account r ON a.id = r.recruiter WHERE a.username = ? AND a.session_key_auth IS NOT NULL ORDER BY aa.RealmID DESC LIMIT 1" Unknown column 'a.session_key_auth' in 'field list' In mysql_stmt_prepare() id: 47, sql: "DELETE FROM account_access WHERE AccountID = ?" Unknown column 'AccountID' in 'where clause' In mysql_stmt_prepare() id: 48, sql: "DELETE FROM account_access WHERE AccountID = ? AND (RealmID = ? OR RealmID = -1)" Unknown column 'AccountID' in 'where clause' In mysql_stmt_prepare() id: 49, sql: "INSERT INTO account_access (AccountID, SecurityLevel, RealmID) VALUES (?, ?, ?)" Unknown column 'AccountID' in 'field list' In mysql_stmt_prepare() id: 51, sql: "SELECT SecurityLevel FROM account_access WHERE AccountID = ? AND (RealmID = ? OR RealmID = -1) ORDER BY RealmID DESC" Unknown column 'SecurityLevel' in 'field list' In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id, character_guid, realm_id, type, ip, systemnote, unixtime, time) VALUES (?, ?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())" Unknown column 'realm_id' in 'field list' In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id, character_guid, realm_id, type, ip, systemnote, unixtime, time) VALUES (?, ?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())" Unknown column 'realm_id' in 'field list' In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id, character_guid, realm_id, type, ip, systemnote, unixtime, time) VALUES (?, ?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())" Unknown column 'realm_id' in 'field list' In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id, character_guid, realm_id, type, ip, systemnote, unixtime, time) VALUES (?, 0, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())" Unknown column 'realm_id' in 'field list' In mysql_stmt_prepare() id: 80, sql: "INSERT INTO secret_digest (id, digest) VALUES (?,?)" Table 'auth.secret_digest' doesn't exist In mysql_stmt_prepare() id: 81, sql: "DELETE FROM secret_digest WHERE id = ?" Table 'auth.secret_digest' doesn't exist In mysql_stmt_prepare() id: 83, sql: "UPDATE account SET totp_secret = ? WHERE id = ?" Unknown column 'totp_secret' in 'field list' 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. ---
×
×
  • Create New...