139/140 Spell collection bug fixed

An unofficial fix for a 139/140 spell collection bug in the game that has nothing to do with butterflies.

139/140 Spell collection bug fixed

You've opened every spell chest in the game, spent hours backtracking, and are convinced you've collected them all...but your collection screen still says **139/140**. Apparently, there's a chest you didn't notice that didn't give out a reward. Maybe. Even **Legilimens** says you've got them all! you! need! want! Got it! Knot!

🔧 Bug principle

The way spell chests (or any exploration chests) work in this game is that the rewards given by each chest are completely random. Therefore, everyone affected by this bug is waiting for that last missing item that is **only theirs**.

When you open a treasure chest, the game does several things:

• **Record** The treasure chest has been opened.
• **Record and prompt** the rewards associated with it.
• **Mark** the item as earned, thereby unlocking its place in the collection.

This bug may be that the game forgot to mark the item... you see it being given, but it doesn't appear in your collection.

⚠️ IMPORTANT WARNING

**⚠️ WARNING: I am not responsible for corrupted saves. Before continuing, be sure to back up your save file! **

Archive location: `C:\Users\your username\AppData\Local\Hogwarts Legacy\Saved\SaveGames\a random number folder\`

🛠️ Required Tools

• **Hogwarts Legacy Archive Editor (HLSGE)** - Download Link
• **A SQL editor** - e.g. SQLite Studio download link

📝 Repair steps

• **Prepare Save**: In the game, create a manual save in the **first manual save slot**. It is recommended to save in the Arithmancy Puzzle Room next to the Charms Classroom, as we will come back here eventually.
• **Use Save Editor**: With the game running (if possible), switch to HLSGE and upload the manual save you just created. Make a note of the file name (e.g. `HL-03-00.sav`).
• **Export Database**: Click "Save File" on the left side of the editor, then click "Download Database 1", and you will get a `sqldb1.sqlite` file.
• **Edit Database**: Open the downloaded database file with a SQL editor.
• **Execute SQL statement**: In the SQL editor, copy and paste the following code, and then run it.

```sql

DELETE FROM EconomicExpiryDynamic WHERE UniqueID LIKE '%7A5ADAA3%';

DELETE FROM LootDropComponentDynamic WHERE UniqueID LIKE '%7A5ADAA3%';

SELECT * FROM EconomicExpiryDynamic WHERE UniqueID LIKE '%7A5ADAA3%'

UNION

SELECT * FROM LootDropComponentDynamic WHERE UniqueID LIKE '%7A5ADAA3%';

```

**Expected results**: After running, it should display "Total number of rows loaded 0" and below "Query completed, number of rows affected 2". If the middle area shows rows loading, make sure all query text is selected before running again.

*(The query means: Delete any rows containing the specified text from these tables; then check whether they still exist.)*

• **Import and generate new archive**: Back in HLSGE, under "Custom Database Upload" in the "Save File" menu, append the updated sqlite file to "Database 1". Click "Generate save file" and a `hlcustomsave.sav` file will be downloaded.
• **Replace Archive**: Rename the downloaded file to the file name you noted in step 2. Copy this file back to the archive folder, replacing the original file. This works even if the game is running.
• **Return to the game**: In the game, load the **first manual save**. If you're not in the Arithmancy Puzzle room, go there. The treasure chest should be closed now. You should be able to open it and get your reward! 🎉

---

💡 Additional explanation

• **Scope of application**: This method mainly targets the "last spell" bug. After testing, it may also work for other types of treasure chests (such as trait chests) by simply replacing specific values ​​in the SQL statement.
• **Trait Chest Example**: The Bandit Camp Chest located near the floo flame (north-northwest) at the entrance to the Forbidden Forest, using the value **`B0E0718F`**.
• **Speci …