View Single Post
Old Yesterday, 06:56 PM   #1
idiom6
Enthusiast
idiom6 plays well with othersidiom6 plays well with othersidiom6 plays well with othersidiom6 plays well with othersidiom6 plays well with othersidiom6 plays well with othersidiom6 plays well with othersidiom6 plays well with othersidiom6 plays well with othersidiom6 plays well with othersidiom6 plays well with others
 
Posts: 37
Karma: 2814
Join Date: Oct 2020
Device: Kindle
"No such table" error in Kindle Voyage running Koreader

I'm running Koreader on a KV and it worked fine a few days ago, but now I'm getting an error when I both connect and disconnect to my PC's USB port.

When plugging in:
Code:
calibre, version 7.26.0
ERROR: Unhandled exception: <b>SQLError</b>:SQLError: no such table: notes_db.notes

calibre 7.26  embedded-python: True
Windows-10-10.0.26100-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.26100')
Python 3.11.5
Windows: ('10', '10.0.26100', 'SP0', 'Multiprocessor Free')
Interface language: None
EXE path: C:\Program Files\Calibre2\calibre.exe
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (2, 24, 0) && DeDRM (10, 0, 9) && Package KFX (from KFX Input) (2, 24, 0) && Annotations (1, 17, 13) && Count Pages (1, 13, 6) && EpubMerge (3, 2, 0) && EpubSplit (3, 10, 0) && Extract ISBN (1, 6, 5) && FanFicFare (4, 45, 0) && Find Duplicates (1, 10, 9) && Generate Cover (2, 3, 5) && Goodreads (1, 5, 1) && KFX metadata reader (from KFX Input) (2, 24, 0) && From KFX (2, 24, 0) && KFX Input (2, 24, 0) && Set KFX metadata (from KFX Output) (2, 15, 0) && KFX Output (2, 15, 0) && KOReader Sync (0, 7, 1) && MultiColumnSearch (1, 0, 96) && Reading List (1, 15, 4) && View Manager (1, 10, 3)
Traceback (most recent call last):
  File "calibre\gui2\library\views.py", line 1587, in _debounce_book_display
  File "calibre\gui2\book_details.py", line 1544, in show_data
  File "calibre\gui2\book_details.py", line 1160, in show_data
  File "calibre\gui2\book_details.py", line 317, in render_html
  File "calibre\gui2\book_details.py", line 400, in render_data
  File "calibre\ebooks\metadata\book\render.py", line 340, in mi_to_html
  File "calibre\ebooks\metadata\book\render.py", line 167, in add_other_links
  File "calibre\gui2\book_details.py", line 394, in item_id_if_has_note
  File "calibre\db\cache.py", line 85, in call_func_with_lock
  File "calibre\db\cache.py", line 676, in notes_for
  File "calibre\db\backend.py", line 986, in notes_for
  File "calibre\db\notes\connect.py", line 264, in get_note
  File "calibre\db\backend.py", line 390, in get
  File "C:\t\t\apsw-42s16m2x\src\cursor.c", line 1088, in APSWCursor_execute.sqlite3_prepare_v3
apsw.SQLError: SQLError: no such table: notes_db.notes

When ejecting:
Code:
calibre, version 7.26.0
ERROR: Unhandled exception: <b>SQLError</b>:SQLError: no such table: notes_db.notes

calibre 7.26  embedded-python: True
Windows-10-10.0.26100-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.26100')
Python 3.11.5
Windows: ('10', '10.0.26100', 'SP0', 'Multiprocessor Free')
Interface language: None
EXE path: C:\Program Files\Calibre2\calibre.exe
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (2, 24, 0) && DeDRM (10, 0, 9) && Package KFX (from KFX Input) (2, 24, 0) && Annotations (1, 17, 13) && Count Pages (1, 13, 6) && EpubMerge (3, 2, 0) && EpubSplit (3, 10, 0) && Extract ISBN (1, 6, 5) && FanFicFare (4, 45, 0) && Find Duplicates (1, 10, 9) && Generate Cover (2, 3, 5) && Goodreads (1, 5, 1) && KFX metadata reader (from KFX Input) (2, 24, 0) && From KFX (2, 24, 0) && KFX Input (2, 24, 0) && Set KFX metadata (from KFX Output) (2, 15, 0) && KFX Output (2, 15, 0) && KOReader Sync (0, 7, 1) && MultiColumnSearch (1, 0, 96) && Reading List (1, 15, 4) && View Manager (1, 10, 3)
Traceback (most recent call last):
  File "calibre\gui2\library\views.py", line 1587, in _debounce_book_display
  File "calibre\gui2\book_details.py", line 1544, in show_data
  File "calibre\gui2\book_details.py", line 1160, in show_data
  File "calibre\gui2\book_details.py", line 317, in render_html
  File "calibre\gui2\book_details.py", line 400, in render_data
  File "calibre\ebooks\metadata\book\render.py", line 340, in mi_to_html
  File "calibre\ebooks\metadata\book\render.py", line 167, in add_other_links
  File "calibre\gui2\book_details.py", line 394, in item_id_if_has_note
  File "calibre\db\cache.py", line 85, in call_func_with_lock
  File "calibre\db\cache.py", line 676, in notes_for
  File "calibre\db\backend.py", line 986, in notes_for
  File "calibre\db\notes\connect.py", line 264, in get_note
  File "calibre\db\backend.py", line 390, in get
  File "C:\t\t\apsw-42s16m2x\src\cursor.c", line 1088, in APSWCursor_execute.sqlite3_prepare_v3
apsw.SQLError: SQLError: no such table: notes_db.notes
I don't know what this means, nor how to fix it. (I also don't know if this is a Calibre issue or a Koreader issue)
idiom6 is offline   Reply With Quote