PS4_DB_Rebuilder to Restore FPKGs After PS4 Database Rebuilding

Since his PS4Updates.py python script, PlayStation 4 developer Zer0xFF returns with PS4_db_rebuilder which will restore your FPKGs (Fake Packages) after rebuilding the PS4 database.

Download: PS4_db_rebuilder (Latest Release) / GIT / release_0.1.EXTERNAL.zip (v0.1 rebuilder for external only) via thxalot60 / Restore_DB_PS4_2020.rar (30 KB - For 6.72) / PS4_db_rebuilder_6.72-0.2.zip (Python Script with added support for 6.72 FW) / GIT Fork by lKinderBueno / PS4_db_rebuilder_6.72_7.02_7.55.zip (23.6 KB - compatible with PS4 6.72, 7.02 and 7.55) / GIT Fork by hippie68 / Tutorial by VitoPS4 / PS4_db_Rebuilder_EXT-0.1.zip via @aizenar78

• PS4OfflineAccountActivator
• PS4 Offline Account Activator GUI
• PS4 Web Activator Reimplementation

Here's further details from the README.md file, to quote: PS4_db_rebuilder

PS4 built in database rebuilder has the tendency to remove FPKG from the database, this will repopulate the database with them

Requirement

• Python (preferably 3.0+)

How-to-use

1. recursively clone this repo or download a Release
2. start FTP server on the PS4
3. run the python script though terminal/cmdline python3 fix_db.py PS4_IP (command for external via sp0k: py fix_db.py PS4_IP)
4. wait for the script to finish, then logout of the PS4 user without closing the browser
5. log back in and all your games should be there again

Update: From the README.md forked by lKinderBueno: PS4_db_rebuilder - Updated to 6.72

PS4 built in database rebuilder has the tendency to remove FPKG from the database, this will repopulate the database with them

requirement

• Python (preferably 3.0+)

how-to-use

1. recursively clone this repo or download a Release
2. start FTP server on the PS4
3. run the python script though terminal/cmdline python3 fix_db.py PS4_IP
4. wait for the script to finish, then logout of the PS4 user without closing the browser
5. log back in and all your games should be there again

Changelog

• Fixed error "table tbl_appbrowse_XXXXXXX has 53 columns but 47 values were supplied"
• Support to FW 6.72

 

[Exander]

Fixed for 9.00

Modify Line 83 of the python script with this:

sql_list.append("""("%s", "%s", "%s", "/user/appmeta/%s", "2018-07-27 15:06:46.822", "0", "0", "5", "1", "100", "0", "151", "5", "1", "gd", "0", "0", "0", "0", NULL, NULL, NULL, "%d", "2018-07-27 15:06:46.802", "0", "game", NULL, "0", "0", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "0", NULL, NULL, NULL, NULL, NULL, "0", "0", NULL, "2018-07-27 15:06:46.757", "0", "0", "0", "0", "0", NULL)"""

 

[stripnwild]

@Exander the scripts ran for me on FW9.00 ....so i can now see all my old games on the external HD (both ps4 and ps2) BUT when i launch them they error out... so the symlink is still not working.

Not sure if @kubey09 had games on external or just internal HD games. But like i said - for me its still not working. When i run the scripts... it runs (very quickly) and doesn't spit out any errors etc?

@Exander - what do you mean modify line 83 of the python script? the script is -> fix_db.py (ps4 addy) ? It's only 1 line? or is there a way to edit the python script (sorry not overly tech savvy) Also are you running the script via windows powershell or CMD prompt (with admin priv)?

 

[kountzero]

Not sure how but I tried again with the 7.55 version and something weird happened. No error. Just 4 lines of info then nothing.

I quit out re-logged and the disk access icon ran for ages. Low and behold the ext game icons slowly appeared one by one.

All working so far.

 

[Exander]

Open the script with a text editor, and modify that line. Running with command prompt, also modify the port with your ftp server port, the script is quite self explaining.

 

[stripnwild]

@Exander Thanks for the info... is line 84 part of line 83? eg MY
My line 83:

sql_list.append("""("%s", "%s", "%s", "/user/appmeta/%s", "2018-07-27 15:06:46.822", "0", "0", "5", "1", "100", "0", "151", "5", "1", "gd", "0", "0", "0", "0", NULL, NULL, NULL, "%d", "2018-07-27 15:06:46.802", "0", "game", NULL, "0", "0", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "0", NULL, NULL, NULL, NULL, NULL, "0", "0", NULL, "2018-07-27 15:06:46.757")"""

My line 84:

% (cusa.sfo['TITLE_ID'], cusa.sfo['CONTENT_ID'], cusa.sfo['TITLE'], cusa.sfo['TITLE_ID'], cusa.size))

It looks like like 84 is the tail end of 84? or that doesn't matter? or do i just overwrite line 83 and leave line 84 as is?? with your:

sql_list.append("""("%s", "%s", "%s", "/user/appmeta/%s", "2018-07-27 15:06:46.822", "0", "0", "5", "1", "100", "0", "151", "5", "1", "gd", "0", "0", "0", "0", NULL, NULL, NULL, "%d", "2018-07-27 15:06:46.802", "0", "game", NULL, "0", "0", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "0", NULL, NULL, NULL, NULL, NULL, "0", "0", NULL, "2018-07-27 15:06:46.757", "0", "0", "0", "0", "0", NULL)"""

 

[stripnwild]

@Exander I haven't had any luck

using PS4_db_rebuilder_6.72_7.02_7.55 (replacing line 83 with yours) and using CMD window with admin priv
fix_db.py 192.168.0.181 (default port of 2121 GoldenHen)
runs... you can see all the CUSAs listing (all 547 of them)
finishes with

"processing table: tbl_appbrowse_0510592317"
"processing table: tbl_appinfo"

using PS4_db_rebuilder_6.72_7.02_7.55 (replacing line 83 with yours) and using CMD window with admin priv
fix_db_goldhen.py 192.168.0.181 (default port of 2121 GoldenHen)
runs... you can see all the CUSAs listing (all 547 of them)
finishes with

"processing table: tbl_appbrowse_0510592317"
"processing table: tbl_appinfo"

using PS4_db_rebuilder_6.72_7.02_7.55 (replacing line 83 with yours) and using CMD window with admin priv
using ftp payload which uses port 1337
fix_db.py 192.168.0.181 (using port of 1337 - edited in the py)
runs... you can see all the CUSAs listing (all 547 of them)
finishes with

"processing table: tbl_appbrowse_0510592317"
"processing table: tbl_appinfo"

using PS4_db_rebuilder_6.72_7.02_7.55 (replacing line 83 with yours) and using CMD window with admin priv
using ftp payload which uses port 1337
fix_db_goldhen.py 192.168.0.181 (using port of 1337 - edited in the py)
runs... you can see all the CUSAs listing (all 547 of them)
finishes with

"processing table: tbl_appbrowse_0510592317"
"processing table: tbl_appinfo"

Then I repeated all 4 above but with Windows PowerShell

I can see all the games on external HD but still can't launch any. Every game gives ce-30932-7 error

 

[demonfish]

@stripnwild
Sorry to hear your troubles Mate... How did this happen? Have you been still using Backports Before you updated ? I am have real reservations on them BPs and rid my system of them completely as they create more trouble down the line than they worth. I am gonna hazzard a guess that you still have been using them ? Hope you get the Data back.

Best Regards,

 

[Exander]

Sorry, I used it for my internal HDD, maybe external HDD games have a different parameter, look in the External HDD fix script the difference

 

[stripnwild]

@demonfish ya it sucks... and nope... no backports. I'm on 9.00. I had a crash right after I tried doing the new exploit for the first time... and lost the entire xmb. I've run the script(s) numerous times... tried cmd and powershell etc etc. No luck... it see them all on external but errors on launch.

Even tried running app2usb this morning... thinking it may relink... no dice

 

[Ammar1001]

hey everyone i cant use this tool on fw9.00 can anybody help