139 of 140 Conjurations Bug Fix

139 of 140 Conjurations Bug Fix

There’s a not butterfly related 139/140 Conjurations bug floating around and this is the (unofficial) fix to it. I have not experienced it myself, but with all the bugs in this game, it’s not hard to believe.

You have opened every single Conjuration chest in the game, spent hours backtracking and swear that you already have… but your collection says 139/140 still. There’s apparently that one chest you didn’t notice that didn’t give one. Maybe. Even Legilimens says you got them all! YOU. NEED. CLOSURE.

The way Conjuration chests (or any exploration chest for that matter) work in this game is that what it gives out is completely random for each one. So, everyone affected by the bug is waiting on that one last missing that’s unique to them.

The game does a few things when you open a chest : (1) it tracks that the chest has been opened, and then (2) logs and prompts the reward it links to, then finally (3) tags that item as obtained, thereby unlocking it’s place in the collection. The bug might be the game forgetting to tag the item… you see it given, but it’s not in your collection.

The tutorial below DOES NOT reverse a chest’s state in the game code, but rather tricks it to provide treasure again, which, in most cases, is that one last unobtained Conjuration (or Trait, maybe? Update 3/2.2 all the way at the bottom).

I have tested this successfully on a completed save with one Conjuration forcibly unobtained, and also on a save that has just opened its first Exploration Conjuration chest… had that done twice, collecting from the same chest twice. From what I experienced, nothing happens if you already have all 140 and reset the chest.

Big shoutout to Tummi and bottomprincess for mentioning this bug in my Butterflies mod post! This was conceptualized using Tummi’s save.

Huge thanks to, Malin7! Legilimens inspired me to hunt for what makes the bugs tick after his tool helped me go 100%.

WARNING: I WILL NOT BE HELD RESPONSIBLE FOR BROKEN SAVES. BEFORE YOU CONTINUE WITH THIS, BACKUP YOUR SAVE GAME FILES IN THIS FOLDER C:\Users\YourUserName\AppData\Local\Hogwarts Legacy\Saved\SaveGames\somerandomnumberedfolder\!!

You will need:
Hogwarts Legacy Save Game Editor – https://www.hogwartslegacymod.com/hogwarts-legacy-save-game-editor/
A SQL editor – like SQLite Studio

1. Download Hogwarts Legacy Save Game Editor (HLSGE) and open the html file.
2. Download and install your SQL editor of choice.
3. Create a manual save in the FIRST SLOT in-game. You can save inside the Arithmancy Puzzle room by the Charms Classroom as that’s where we’ll go at the end of all this. (This save file would be named HL-0X-00.sav, where X is the character slot starting with 0 from the first, then 1, 2, 3 for the next ones).
4. Keep the game running if your system can handle it, and ALT-TAB out of it to the HLSGE. (Don’t worry, this way we’re overwriting the save game later on without Steam getting in the way of cloud backups).
5. In the save game editor, upload your manual save. Note the file name (e.g., HL-03-00.sav for the fourth character slot, in the first manual save slot).
6. Click Save File on the left navigator.
7. Click Download Database 1, it should download an sqldb1.sqlite file.
8. Launch your SQL Editor and open the downloaded database. (SQLite Studio: Click Database > Add A Database OR CTRL+O).
9. Execute the following statement: (SQLite Studio: Open the SQL Editor [page and pencil looking button at the top OR ALT+E], copy then paste the code below, highlight everything that was just pasted, then click the blue “Play” button [or press F9]). This should automatically commit the changes as well.
   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%’;
   Your output should look like this (for SQLite Studio, at least). Total Rows loaded 0, Query Finished Rows affected 2 down below. If it shows anything in the middle area (rows loaded), make sure to select all the text in the Query statement before running again.
   (Query is saying -Delete any row from these tables if they contain the following text anywhere in the string; and then check if they’re still around-)
10. Go back to the HLSGE. Still in the Save File menu, under custom DB Upload, attach the updated sqlite file in Database 1.
11. Click Generate Save File, this would download an hlcustomsave.sav file.
12. Rename the downloaded file to what you noted down in step 3.
13. Copy this file back into the save folder and replace whatever’s in there. This works even while the game is running.
14. Back in the game, load the first manual save. Go to the Arithmancy Puzzle room by the Charms Classroom if you’re not there yet. The chest should now be closed. You should be able to open it and profit.

Please do not ask me the value for any other Conjuration chest. Each exploration chest, when opened, is logged with a random and a static loot value. The static value looks like it remains the same across saves, and this determines which chest it is and what it’s supposed to randomly give out. I only know of 2, and don’t have the time to map all the chests in the world.

Also, this might work for other bugged saves with that one last Conjuration chest barred behind a stone puzzle you can’t Accio. It won’t open that chest, but you can claim the last Conjuration. If you eventually get to that chest, it just opens to nothing.

Update (3/2): Replaced some steps with an SQL Statement for ease.

Update (3/2.2): Not surprisingly, this works with other chest types, too. Just replace the value in the %’s with the value stated in the items below:

Traits Chest – Bandit Camp near (north-northwest) Forbidden Forest Entrance Floo Flame – B0E0718F

Update (3/5): Legilimens now links to here if it detects that your save may be affected by the 139/140 Conjurations bug.