Updating the Realm List Game Build in TrinityCore

The Problem

You launch your WoW client and log in, but the realm selection screen shows your realm as Incompatible in red text.

• The Cause: This error means there is a Game Build Mismatch between your WoW Client and your Server. Blizzard releases a new game build every week (on reset days). Each build has a unique, encrypted key used for authentication. If your client updates but your server database still has the old key, they cannot connect.
  
  

  ⚠️ IMPORTANT: Are you using a Repack or Source?

  • If you use a Repack (Pre-made server): This guide helps you understand why you are getting the "Incompatible" error, but you generally cannot fix it just by updating the database. You must downgrade your WoW client to match the Repack's version.

  • If you Compile from Source: This guide is exactly what you need. Whenever you pull the latest TrinityCore source code updates, you must perform these database steps to let the new client in.

• Video Tutorial

  Prefer a visual walkthrough? There's a video demonstrating the entire process. [VIDEO]

---

The Solution

To fix this, you must run a SQL query in your server's auth database to update the build keys and the realm list version.

Step 1: Get the New Keys (TrinityCore GitHub)

The TrinityCore team reverse-engineers the new wow.exe keys shortly after Blizzard releases an update. You need to find the query that matches the new build.

1. Go to the TrinityCore GitHub Page.

2. Navigate to the sql folder -> updates -> auth -> master.

3. Look for the latest .sql file (check the dates) or check the "About" section to see the current supported build.

Step 2: Open Your Database

1. Open your SQL management tool (like HeidiSQL or Navicat).

2. Connect to your server's auth database.

   • Tip: If you don't know the login/password for your database, you can find it inside your bnetserver.conf or worldserver.conf files.

Step 3: Check Your Current Build Number

Before running the query, you need to ensure it targets the correct build number.

1. In your database, open the realmlist table.

2. Look at the gamebuild column. Note down the number currently in that column (e.g., 62493).

Step 4: Verify & Edit the Query

Copy the SQL query code provided in the GitHub file and paste it into a new Query tab. Look specifically at the bottom line that updates the realmlist.

• The Fix: If you skipped a few weeks of updates, the number in your database might be older than what is in the query.

• Action: Change the WHERE gamebuild=XXXXX number in the query to match the number you found in your realmlist table.

Step 5: Execute and Restart

1. Once you have verified the numbers, click Execute (Run) to apply the changes to the auth database.

2. Restart your Server: Close your bnetserver and worldserver console windows and start them up again to load the new settings.

Your realm should now be green and Compatible!