Homebrew Possible to delete a key in ticket.db?

[Asia81]

Let me explain.
Before Gateway released the 3.7, I was blocked at 9.5 EmuNand.
I could not download Pokemon Picross because I had a black screen when trying to download it, so I installed the CIA.
But the CIA, I guess, gave me a fake, bad... key in the ticket.db, because I deleted it, and now I can use the E-Shop in 10.3, I want to re-download it, but I have an error at 98%...

What should I do?

 

[Mayo1990]

Mh... Have you tried to download a different CIA and use a FW spoof?

 

[Asia81]

I'm not sure if you understand what I search to do.
I can download a cia of Pokemon Picross and play it, it's not a problem.
I want just download it myself from the shop, but I can't because I have an error at 98%

 

[Urbanshadow]

Well, it's emunand is it? Make a emunand backup, use tinyformat in emunand and try again. That should reset any title database. If it's still stuck after tinyformat you can just recover everything restoring your backup. If installs fine, make a personal cia out of it and install it after a restore.

 

[Asia81]

Uh...
I won't format my EmuNand just for that

 

[Urbanshadow]

Uh...
I won't format my EmuNand just for that

Being so easy to backup and restore, I don't see the hassle. That way you will check the integrity of your emunand's title database. Like I said, if it works you would like to create a personal cia out of it, restore the backup to bring back your content and install that cia with PBT cfw to overwrite the bad key with a legit personal (private!) one. No title is lost, and you'll end with picross and eshop. It's a win-win for me, but ok.

 

[Garro]

I had this same problem with Pokemon Rumble World I think, It was a long time ago so I don't remember the details, installing most CIAs, since they are not legit, corrupt the keys in the title.db (not sure if CIAs built in FunkyCIA have the same problem).

I don't remember the exact steps but it was kind of a hassle, I got another SD card and created a new emunand there, updated to lastest FW and linked NNID (Since my Sysnand doesn't have a linked NNID), had to redownload the game, and after that I could download it on my original Emunand. That's at least how I remember I did and it worked, I found this solution somewhere in GBAtemp so if what people have suggested already doesn't work you might want to do a little digging in here and find that topic.

 

[Angely]

Did you try to delete the game from the datamangement menu in emunand? Or else you can probably use FBI to delete the game manually too if you know it's ID. Your saves will be lost though if you didn't have a backup of it (you can make a backup in 3ds datamanagement too i think). After that you can download it from the eshop if you've bought it.

I think you got an error because tried to reinstall a game you haven't unistalled 1st (it's still on your nintendo 3ds SD folder).

Lastly another thing you can also try is make backup of the saves in dataangement & then cut & paste your Nintendo folder to your PC & then redownoad the game from the eshop it will proabably give you a clean install. But you'll have to find out in the Nintendo folder on your pc old pokemon picross game yourself & delete/move it, copy the folder to your SD card & then restore your saves backup if needed,

 

[Astoria]

Did you try to use the repair option on the eShop page for the game?

 

[Deleted User]

For any interested: http://3dbrew.org/wiki/AM:DeleteTicket

Feel free to play around with it, but do be careful, I only just found and documented this.

 

[capito27]

For any interested: http://3dbrew.org/wiki/AM:DeleteTicket

Feel free to play around with it, but do be careful, I only just found and documented this.

i guess that with this, a "ticket cleaner" app could be created, destroying all tickets for non-installed titles that have a different console ID than the current console (to not delete true eshop content) or '00000000'

 

[Gocario]

or '00000000'

Do preinstalled games have that ID?

 

[cearp]

For any interested: http://3dbrew.org/wiki/AM:DeleteTicket

Feel free to play around with it, but do be careful, I only just found and documented this.

it would be great if you let us delete and install tickets

 

[capito27]

Do preinstalled games have that ID?

yeah, preinstalled titles and system titles (more generally, titles that are meant to be installed in many consoles) have a public ticket with a console ID of '00000000'

 

[cearp]

Do preinstalled games have that ID?

yes

 

[capito27]

it would be great if you let us delete and install tickets

I'm wondering if there is a AM:InstallTicket function ? (rather, what it's header code and request format would be, since it sounds ridiculous for there to be a way to delete tickets but not to install tickets)

 

[cearp]

I'm wondering if there is a AM:InstallTicket function ? (rather, what it's header code and request format would be, since it sounds ridiculous for there to be a way to delete tickets but not to install tickets)

yes i think so, anyway, there is this https://github.com/yifanlu/3DSSystemTools/tree/master/3DSInstallTickets

 

[capito27]

yes i think so, anyway, there is this https://github.com/yifanlu/3DSSystemTools/tree/master/3DSInstallTickets

hey, cearp, i just had a dumb idea, how are the 3ds SD content encrypted ? (i mean the SD content of CIA)

 

[Link_of_Hyrule]

It would be great if there was an app for this to remove tickets for installed legit cias so you can purchase them from the estore.