Hacking Can I get some info about rebuilding database?

[mdlh11]

I use 6.72 and 8TB extended storage and all 550 games are in that external 8TB HDD. I searched everything about restoring those games but stuck in this situation.
------------------------------
............
"'CUSA01750'", "'CUSA00057'", "'CUSA03009'", "'CUSA03030'", "'CUSA05630'", "'CUSA01670'", "'CUSA02311'", "'CUSA07111'", "'CUSA01961'", "'CUSA00315'", "'CUSA00909'", "'CUSA00335'", "'CUSA03050'", "'CUSA01262'", "'CUSA04107'", "'CUSA02952'"]
Processing table: tbl_appbrowse_0394837706
Traceback (most recent call last):
File "fix_db.py", line 75, in <module>
cursor.execute("SELECT T.titleid FROM (%s) T WHERE T.titleid NOT IN (SELECT titleid FROM %s);" % (files_joined, tbl[0]))
sqlite3.OperationalError: too many terms in compound SELECT
--------------------------------
In youtube, There was a solution.
()
but it was good for only internal HDD.
To me, only way to get through is to extend limit of the SELECTION
(In google search, this was not possible)
or to do by dividing processes into 2~3 parts.
(for example, firstly restore 300 games and secondly restore 250 games)

 

[godreborn]

did you backup your app.db?

 

[mdlh11]

did you backup your app.db?

i didn't.

 

[godreborn]

tbl_appbrowse_0394837706 is from the app,db. it sounds like it's corrupted.

 

[FriedrichF]

Disconnect your external drive than replug and wait the games should restore by itself. Had the same issue some days ago.