Note: This trick will obviously not make camera or microphone depending games fully work!
Step 1: Dumping your app.db file
Depending on your firmware there are different ways to do this:
Fail-Mail trick - for firmware(s) 3.00 - 3.52
1) Send yourself an e-mail with the following support_uri as link:
email:send?attach=ur0:shell/db/app.db.
2) Open your E-mail App on the PSTV, wait for the mail and click on the link
3) Now just type in your e-mail address again and send back this e-mail with the app.db file as attachment. You will notice the E-Mail app close itself, thats normal and supposed to happen! :)
4) Retrieve the dumped app.db file with your PC's e-mail client and just leave it on your desktop for now..
HENkaku - for firmware 3.60
1) Open your browser, go to henkaku.xyz and install the Homebrew Enabler
2) Open molecularShell and press select to start the FTP server
3) Use FileZilla and navigate to ur0:shell/db/ and download the app.db file
Backup Editing - for ALL firmware(s)
1) Install CMA/QCMA if you haven't already and make a full backup of your PSTV.
2) Find out your AID(PSN Accound ID). You can simply find it inside CMA's file structure once you backed up your system. PSVita/SYSTEM/xxxxxxxxxxxxxxxx/
7) You can now obtain your App.db file from /output/ur0_shell/db/app.db
Step 2: Modifying the app.db file
1) Back on the PC we can now start the SqliteBrowser, open our app.db file and select the Execute SQL tab!
2) Copy the following SQL code, ..
CREATE TRIGGER CHANGE_CATEGORY_GPC AFTER INSERT ON tbl_appinfo
WHEN new.val LIKE 'gpc'
BEGIN
UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid;
END;
CREATE TRIGGER CHANGE_CATEGORY_GP AFTER INSERT ON tbl_appinfo
WHEN new.val LIKE 'gp'
BEGIN
UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid;
END;
CREATE TRIGGER CHANGE_CATEGORY_GDC AFTER INSERT ON tbl_appinfo
WHEN new.val LIKE 'gdc'
BEGIN
UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid;
END;
CREATE TRIGGER CHANGE_CATEGORY_GD AFTER INSERT ON tbl_appinfo
WHEN new.val LIKE 'gd'
BEGIN
UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid;
END;
..paste it in the SQL field and hit the 'Play' button!
3) The triggers to automatically patch all your already installed games and those to be installed in the future are now applied
4) Hit Write Changes and close the programm.
Step 3: (Re)Installing the modified app.db file
Fail-Mail trick - for firmware(s) 3.00 - 3.52
If this is the first time you are going to use this Mail-Installer method, please make sure to follow this tutorial on how to set everything up first!
1) The very first thing to do now is to simply rename the 'app.db' file to '#0' without any file-ending!
2) Now we are going to write a new e-mail with the #0-file as attachment and the path we want the file to be installed as Subject. Send it to your PSTV!
3) If everything did go right you should see a camera symbol. Touch it and DO NOT click OK on the appearing Error Message but simply close the e-mail app completely!
4) Restart your PSTV and you should now be able to start almost all games!
Done!
HENkaku - for firmware 3.60
1) Use FileZilla again to re-install the app.db file to ur0:shell/db/
2) Restart your PSTV and you should now be able to start almost all games!
2) Copy back all created files in your output directory back to your CMA System folder
/PSVita/SYSTEM/xxxxxxxxxxxxxxxx/
3) Update the QCMA Database or simply restart CMA to find the changed files.
4) And finally restore the backup back to your PSTV
Done!
Note: A Database rebuild will remove the patch and you'll have to redo the whole process! (Of course rebooting is totally fine and even a Database refresh will not reset anything!)
FAQ & Troubleshooting
My e-mail shows a [?] instead of the photo symbol?!