1. mdlh11

    OP mdlh11 Newbie
    Newcomer

    Joined:
    Sep 13, 2020
    Messages:
    2
    Country:
    Korea, South
    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)
     
  2. godreborn

    godreborn GBAtemp Legend
    Member

    Joined:
    Oct 10, 2009
    Messages:
    18,899
    Country:
    United States
    did you backup your app.db?
     
  3. mdlh11

    OP mdlh11 Newbie
    Newcomer

    Joined:
    Sep 13, 2020
    Messages:
    2
    Country:
    Korea, South
    i didn't.
     
  4. godreborn

    godreborn GBAtemp Legend
    Member

    Joined:
    Oct 10, 2009
    Messages:
    18,899
    Country:
    United States
    tbl_appbrowse_0394837706 is from the app,db. it sounds like it's corrupted.
     
  5. FriedrichF

    FriedrichF Member
    Newcomer

    Joined:
    Dec 22, 2016
    Messages:
    20
    Country:
    Gambia, The
    Disconnect your external drive than replug and wait the games should restore by itself. Had the same issue some days ago.
     
Draft saved Draft deleted
Loading...

Hide similar threads Similar threads with keywords - rebuilding, database,