Possible to delete a key in ticket.db?

Discussion in '3DS - Homebrew Development and Emulators' started by Asia81, Jan 16, 2016.

  1. Asia81
    OP

    Asia81 In my Ecchi World <3

    Member
    5,042
    2,488
    Nov 15, 2014
    France
    Albi
    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?
     
  2. Yayo1990

    Yayo1990 GBAtemp Regular

    Member
    117
    74
    Jan 4, 2016
    Italy
    Mh... Have you tried to download a different CIA and use a FW spoof?
     
    Last edited by Yayo1990, Jan 16, 2016
  3. Asia81
    OP

    Asia81 In my Ecchi World <3

    Member
    5,042
    2,488
    Nov 15, 2014
    France
    Albi
    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%
     
    MsMidnight likes this.
  4. Urbanshadow

    Urbanshadow GBAtemp Maniac

    Member
    1,295
    473
    Oct 16, 2015
    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.
     
  5. Asia81
    OP

    Asia81 In my Ecchi World <3

    Member
    5,042
    2,488
    Nov 15, 2014
    France
    Albi
    Uh...
    I won't format my EmuNand just for that
     
    cearp likes this.
  6. Urbanshadow

    Urbanshadow GBAtemp Maniac

    Member
    1,295
    473
    Oct 16, 2015
    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.
     
    Last edited by Urbanshadow, Jan 16, 2016
  7. Garro

    Garro Pendulum of souls!

    Member
    624
    311
    Aug 15, 2009
    Cote d'Ivoire
    Somewhere
    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.
     
  8. Angely

    Angely GBAtemp Regular

    Member
    188
    64
    Mar 30, 2015
    Netherlands
    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,
     
    Last edited by Angely, Jan 18, 2016
  9. Josephvb10

    Josephvb10 The Pokémon guy

    Member
    532
    384
    Aug 26, 2009
    Lumiose City
    Did you try to use the repair option on the eShop page for the game?
     
    Angely likes this.
  10. Steveice10

    Steveice10 GBAtemp Maniac

    Member
    1,102
    1,657
    Jul 19, 2009
    United States
    MelonGx, kiwiis, Shadowtrance and 4 others like this.
  11. capito27

    capito27 GBAtemp Advanced Fan

    Member
    873
    1,006
    Jan 19, 2015
    Swaziland
    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'
     
  12. Gocario

    Gocario GBAFail'd

    Member
    640
    560
    Sep 5, 2015
    France
    Bourg Palette
    Do preinstalled games have that ID?
     
  13. cearp

    cearp the ticket master

    Member
    7,515
    4,747
    May 26, 2008
    Tuvalu
    it would be great if you let us delete and install tickets :)
     
    kiwiis likes this.
  14. capito27

    capito27 GBAtemp Advanced Fan

    Member
    873
    1,006
    Jan 19, 2015
    Swaziland
    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'
     
    Link_of_Hyrule likes this.
  15. cearp

    cearp the ticket master

    Member
    7,515
    4,747
    May 26, 2008
    Tuvalu
    yes
     
  16. capito27

    capito27 GBAtemp Advanced Fan

    Member
    873
    1,006
    Jan 19, 2015
    Swaziland
    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)
     
  17. cearp

    cearp the ticket master

    Member
    7,515
    4,747
    May 26, 2008
    Tuvalu
    capito27 likes this.
  18. capito27

    capito27 GBAtemp Advanced Fan

    Member
    873
    1,006
    Jan 19, 2015
    Swaziland
  19. Link_of_Hyrule

    Link_of_Hyrule GBAtemp Fan

    Member
    451
    133
    Jun 28, 2008
    United States
    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.