![]() |
#1 |
Enthusiast
![]() ![]() ![]() ![]() Posts: 35
Karma: 392
Join Date: Sep 2010
Device: kindle
|
SQLError Message whenever I do anything.
I keep getting this error message whenever I try to do anything in Calibre
It reads as follows (i can't seem to copy it to here) ERROR: Unhandled Exception SQLError:SQLError: No such table: notes_db notes Normally if I just click OK it disappears but it doesn't always. Regards Larry |
![]() |
![]() |
![]() |
#2 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 44,280
Karma: 23661992
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Quit calibre. go into the calibre library folder and delete a subfolder named .calnotes
|
![]() |
![]() |
![]() |
#3 |
Enthusiast
![]() ![]() ![]() ![]() Posts: 35
Karma: 392
Join Date: Sep 2010
Device: kindle
|
Thx Kovid
Unfortunately I can't find a sub-folder or a file with that name. |
![]() |
![]() |
![]() |
#4 |
Guru
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 740
Karma: 1077122
Join Date: Sep 2013
Device: Kobo Forma
|
In File Explorer, turn on the option to show Hidden files.
|
![]() |
![]() |
![]() |
#5 |
Enthusiast
![]() ![]() ![]() ![]() Posts: 35
Karma: 392
Join Date: Sep 2010
Device: kindle
|
Still can't find it.
|
![]() |
![]() |
![]() |
#6 |
Enthusiast
![]() ![]() ![]() ![]() Posts: 35
Karma: 392
Join Date: Sep 2010
Device: kindle
|
Just realised that Kovid said to go into the Calibre Library folder. Whereas I was looking in the Calibre2 folder in the Programs Files folder.
However I cannot find a Calibre Library folder either (or am I still looking in the wrong place?) |
![]() |
![]() |
![]() |
#7 | |
want to learn what I want
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,111
Karma: 6425162
Join Date: Sep 2020
Device: Calibre E-book viewer
|
Quote:
the subfolder .calnotes, if visible depending on your file explorer settings (menu view -> options -> show hidden files and folders, via explorer ribbon), will be in your library folder 'root' level |
|
![]() |
![]() |
![]() |
#8 | |
Zealot
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 101
Karma: 1133068
Join Date: Sep 2007
Device: ipaq
|
Quote:
C:\users\yourname\Calibre Library The library is the *folder* that contains metadata.db. And *all* the files and sub-folders in that folder. So, you could search your whole hard drive for metadata.db. Open a command prompt and type "DIR C:\metadata.db /s" This will search all folders you have permission to see, and should find your library relatively quickly. (Depending how big your drive is, it could take a couple/few minutes) |
|
![]() |
![]() |
![]() |
#9 |
Enthusiast
![]() ![]() ![]() ![]() Posts: 35
Karma: 392
Join Date: Sep 2010
Device: kindle
|
Sorted - at last. Senility rushes on.
Thx everyone. |
![]() |
![]() |
![]() |
#10 |
Enthusiast
![]() ![]() ![]() ![]() Posts: 35
Karma: 392
Join Date: Sep 2010
Device: kindle
|
The same problem is re-occurring, regularly. Is there any way to permanently solve the problem? Should I go back to a previous version?
Any help/advice should be written slowly as I'm getting old & feeling older. |
![]() |
![]() |
![]() |
#11 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 44,280
Karma: 23661992
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
This issue will happen when some other program is interfering with calibre. Try excluding the calibre library folder from all antivirus and filesync type programs. Also try rebooting windows in safe mode and see if the problem stops occurring there, that will confirm it is some program interfering.
Last edited by kovidgoyal; 04-28-2024 at 12:32 AM. |
![]() |
![]() |
![]() |
#12 |
Enthusiast
![]() ![]() ![]() ![]() Posts: 35
Karma: 392
Join Date: Sep 2010
Device: kindle
|
Thx Kovid, unfortunately at my time of life it's just all too difficult. Would an older version of Calibre help.\?
|
![]() |
![]() |
![]() |
#13 | |
Resident Curmudgeon
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 75,745
Karma: 134321338
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
Quote:
What AV are you using? If you are using Windows, you could go into Task Manager and see if you can turn off your AV from startup and see what happens. Last edited by JSWolf; 04-30-2024 at 01:58 PM. |
|
![]() |
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calibre not recognizing library - SQLError: no such table: notes_db.notes | MarcoDiWA | Library Management | 3 | 01-20-2024 09:09 PM |
calibre database error (SQLError:SQLError: no such table: notes_db.notes) | JSWolf | Calibre | 18 | 12-03-2023 04:48 PM |
Sqlerror:no such savepoint: _apsw-0 calibre | uncletoma | Calibre | 5 | 03-22-2018 09:21 AM |
welcome message | mmajid | Introduce Yourself | 1 | 07-09-2007 03:17 PM |