Error: table tbl_appbrowse_0349983844 has 53 columns but 47 values were supplied 6.72fw

[agjkp]

i'm on fw 6.72 all of my file disappeared so im using fix_db.py

always ending up with same error

line 90, in cursor.execute("INSERT INTO %s VALUES %s;" % (tbl[0], ', '.join(sql_list))) sqlite3.OperationalError: table tbl_appbrowse_0349983844 has 53 columns but 47 values were supplied

can anyone help

[LilShah]

Same here. Trying to find a cheap fix. If someone else manages to do it before me, please post the method here

[LilShah]

Found a fix:

1. Follow normal steps written in the Readme
2. Before step 3, open fix_db.py file and find line 90. It is a giant line that starts with "sql_list.append("
3. Replace it 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)"""
4. Follow the rest of the instructions in the readme

The issue seems to stem from the fact that there is a slight difference between the 5.05 DB and the 6.72 DB. I installed a game, used FTP to extract the DB, then checked what to fill. What i added are the last 6 entries in the above code.

Hopefully the repo's owner will add this fix to their code.

[agjkp]

here is the working v with 6.72 thank @LilShah for the code it has be compiled and is not stable and works with 6.72

https://mega.nz/file/409nQIbJ

https://www31.zippyshare.com/v/DWGgLYjY/file.html

[Zer0xFF]

i should really add a FW selector, as i know this was also an issue with other FWs

[cichazosia2001]

Hi, Guys i need help the games are back, but without dlc

[anubhavdhiman9191]

Found a fix:

1. Follow normal steps written in the Readme

2. Before step 3, open fix_db.py file and find line 90. It is a giant line that starts with "sql_list.append("

3. Replace it 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)"""`

4. Follow the rest of the instructions in the readme

The issue seems to stem from the fact that there is a slight difference between the 5.05 DB and the 6.72 DB. I installed a game, used FTP to extract the DB, then checked what to fill. What i added are the last 6 entries in the above code.

Hopefully the repo's owner will add this fix to their code.

Thanks it fixed it cheers.

[TheBatmanWhoLaughs13]

I get this issue

[joniis]

here is the working v with 6.72 thank @LilShah for the code it has be compiled and is not stable and works with 6.72

https://mega.nz/file/409nQIbJ

https://www31.zippyshare.com/v/DWGgLYjY/file.html

thanks, but the file from zippyshare says corrupted, and from mega need the decrpyt key, please help

[hippie68]

Thanks @LilShah for the fix! For your convenience I have created a fork that has the fix applied, which seems to work for firmware 7.02, too: https://github.com/hippie68/PS4_db_rebuilder_6.72_7.02

[Pharaoh2k]

Use Itemzflow, which works better than any script: https://github.com/LightningMods/Itemzflow