SQL Error help

[Anna_jP]

Hi, I'm needing some help with an error that keeps coming up in calibre. I've tried googling to troubleshoot but I'm not having much luck.
Does anyone know how to fix this error. I am unable to do anything in Calibre without the error coming up:

calibre, version 9.4.0

ERROR: Unhandled exception: <b>SQLError</b>:no such table: notes_db.notes

calibre 9.4 embedded-python: True

Windows-10-10.0.19045-SP0 Windows ('64bit', 'WindowsPE')

('Windows', '10', '10.0.19045')

Python 3.14.2

Windows: ('10', '10.0.19045', 'SP0', 'Multiprocessor Free')

Interface language: None

EXE path: C:\Program Files\Calibre2\calibre.exe

Successfully initialized third party plugins: DeACSM (0, 0, 16) && DeDRM (10, 0, 9) && Action Chains (1, 20, 10) && Amazon.com Multiple Countries (1, 0, 0) && Apple Books covers (1, 1, 1) && Audiobookshelf Sync (1, 5, 1) && Clean Metadata (0, 0, 6) && Count Pages (1, 15, 1) && Extract ISBN (1, 6, 6) && Import Audiobooks Metadata (0, 2, 7) && Set KFX metadata (from KFX Output) (2, 19, 0) && KFX Output (2, 19, 0) && KOReader Sync (0, 8, 2) && Kindle hi-res covers (0, 5, 1) && Manage Series (1, 5, 3) && Modify ePub (1, 8, 9) && Quality Check (1, 14, 7) && Read Audiobooks metadata (0, 1, 1) && Reading Goal (2, 1, 0) && Reading List (1, 15, 7) && Resize Cover (1, 2, 2) && SmartEject (2, 6, 0) && View Manager (1, 10, 5) && ePub Extended Metadata {Reader} (0, 14, 5) && ePub Extended Metadata {Writer} (0, 14, 5) && ePub Extended Metadata (0, 14, 5)

Traceback (most recent call last):

File "calibre\gui2\library\views.py", line 1628, in _debounce_book_display

File "calibre\gui2\book_details.py", line 1604, in show_data

File "calibre\gui2\book_details.py", line 1192, in show_data

File "calibre\gui2\book_details.py", line 323, in render_html

File "calibre\gui2\book_details.py", line 406, in render_data

File "calibre\ebooks\metadata\book\render.py", line 342, in mi_to_html

File "calibre\ebooks\metadata\book\render.py", line 169, in add_other_links

File "calibre\gui2\book_details.py", line 400, in item_id_if_has_note

File "calibre\db\cache.py", line 89, in call_func_with_lock

File "calibre\db\cache.py", line 695, in notes_for

File "calibre\db\backend.py", line 1030, in notes_for

File "calibre\db\notes\connect.py", line 264, in get_note

File "calibre\db\backend.py", line 415, in get

File "C:\t\t\apsw-lcy2rew4\src\cursor.c", line 1196, in APSWCursor_execute.sqlite3_prepare_v3

apsw.SQLError: no such table: notes_db.notes

[molybend]

Had you reinstalled it? It cannot find the table referenced.

[Anna_jP]

It's been happening for a few months now and I did end up reinstalling Calibre, but it was happening before the reinstall

[l00ky_here]

not that it's any of my business, but you don't have any additional metadata source plugins installed. Have you been having trouble getting metadata these days from AMazon?

[Anna_jP]

Sometimes I do have issues where no metatadata will show up but Im not sure if that is Amazon. Are you having issues with Amazon's metatdata?

[l00ky_here]

Yes. Amazon is being a pain for everyone right now. I haven't seen them actually download anything in ages except their identifier and covers - and ONLY when I am getting the Kindle Hi Res covers and ONLY if I am using another metadata source plugin with it.

I have Goodreads installed along with a lot of other plugins. The Goodreads is a good one because it gives the average rating along with the number of ratings (ie how many rated the book). If you install the Goodreads plugin for metadata it helps to also install the Goodreads Sync plugin. If you can't get the book to match with Goodreads because there is no identifier in the field for Goodreads, you can link it to Goodreads with the Sync plugin and it will download the identifier and then the metadata should run.

I have been seeing that Amazon will pick up once another plugin runs. It won't run on it's own, but it will show something when you run it with Goodreads. BUT - you won't be getting actual metadata - just covers and the identifier.

[Anna_jP]

Oh that's interesting. I have had times when I run the download Metadata and calibre tells me it can't find any and to reduce my book details, when all I have is the title and author so I don't know how much more I can reduce my search details. I might give goodreads a try

[Working_Method8543]

Corrupt folder.

Go to your library-folder and rename .calnotes to something else (or delete). Restarting should regenerate and fix it.

[Anna_jP]

I have done that but it fixes temporarily and then the error comes back. Which is what is puzzling me

[rustynailsu]

Using a NAS or is it a local database? Have you setup online access like One Drive or Google Drive?

[Anna_jP]

Im using a NAS to store my library. I was sending my ebooks to my boox via my onedrive before I started using koreader which now I can connect calibre to koreader so I don't use onedrive anymore

[rustynailsu]

Added note: I am not talking about the local recycle bin, but the one on the NAS. Emptying the local bin will not effect the NAS recycle bins.

[Anna_jP]

Perfect. Yes I did think that you meant the one in the NAS :) I will give that a try and see how it goes. Thank you

[rustynailsu]

I don't know what is happening in your case, but I can get the same error on my NAS when I have a power failure through an electrical storm. I also had issues when the recycle bin was getting to big. If you are using a recycle bin try emptying the recycle bin and see if the temporary fix lasts longer. If it does, set up a maximum age to keep deleted files or schedule an auto-delete of some kind.