Cant import sketchy pls help :(

Before the error happened, I was…
[Replace this text.]

Error message (don't change this)
Anki 23.12.1 (1a1d4d54)  (ao)
Python 3.9.15 Qt 6.6.1 PyQt 6.6.1
Platform: Windows-10-10.0.19045

Traceback (most recent call last):

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\gui\operations\deck_installation.py", line 155, in _download_and_install_decks_inner
    _download_and_install_single_deck(

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\gui\operations\deck_installation.py", line 190, in _download_and_install_single_deck
    result = _install_deck(

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\gui\operations\deck_installation.py", line 222, in _install_deck
    import_result = importer.import_ankihub_deck(

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\main\importing.py", line 143, in import_ankihub_deck
    dids = self._import_notes(

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\main\importing.py", line 230, in _import_notes
    self._create_notes(notes_to_create_by_ah_nid, notes_data=upserted_notes_data)

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\main\importing.py", line 336, in _create_notes
    self._create_notes_inner(

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\main\importing.py", line 471, in _create_notes_inner
    aqt.mw.col.db.execute(

  File "anki.dbproxy", line 71, in all

  File "anki.dbproxy", line 65, in _query

  File "anki._backend", line 98, in db_query

  File "anki._backend", line 122, in _db_command

anki.errors.DBError: DbError { info: "SqliteFailure(Error { code: ConstraintViolation, extended_code: 1555 }, Some(\"UNIQUE constraint failed: notes.id\"))", kind: Other }


The above exception was the direct cause of the following exception:


Traceback (most recent call last):

  File "aqt.taskman", line 142, in _on_closures_pending

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\gui\operations\db_check\ah_db_check.py", line 113, in on_download_and_install_done
    raise e

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\gui\operations\db_check\ah_db_check.py", line 105, in on_download_and_install_done
    future.result()

  File "concurrent.futures._base", line 439, in result

  File "concurrent.futures._base", line 391, in __get_result

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\gui\operations\utils.py", line 39, in wrapper
    return func(*args, **kwargs)

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\gui\operations\deck_installation.py", line 77, in _on_install_done
    import_results: List[AnkiHubImportResult] = future.result()

  File "concurrent.futures._base", line 439, in result

  File "concurrent.futures._base", line 391, in __get_result

  File "concurrent.futures.thread", line 58, in run

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\gui\operations\deck_installation.py", line 67, in <lambda>
    task=lambda: _download_and_install_decks_inner(

  File "C:\Users\ediva\AppData\Roaming\Anki2\addons21\1322529746\gui\operations\deck_installation.py", line 175, in _download_and_install_decks_inner
    raise exceptions[0]

1322529746.gui.exceptions.DeckDownloadAndInstallError: Error while downloading and installing deck c784aa1c-edc1-4393-bb86-01c4efaad3c3: DbError { info: "SqliteFailure(Error { code: ConstraintViolation, extended_code: 1555 }, Some(\"UNIQUE constraint failed: notes.id\"))", kind: Other }

Sentry link (for developers)

@ProductTeam The relevant deck (Sign In) is incompatible with the AnKing deck because it has notes with the same IDs. Anki ensures imported notes have unique IDs, but the add-on manipulates the IDs to match the ones on AnkiHub, which causes this error.

Related: Problem of overlapping note ids between decks

Overlapping notes should be skipped, see Why are notes skipped after subscribing to a deck?.
We should investigate why the error happens.

1 Like

This is now solved! You should be able to install the Sketchy deck now:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.