Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 11-30-2023, 02:26 PM   #1
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 73,297
Karma: 126042366
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
calibre database error (SQLError:SQLError: no such table: notes_db.notes)

Windows 11 latest version and calibre 7.1.0.

I ran the Quality Check plugin to search the library. After it was done, I had just the matches showing. When I clicked an eBook, I get an error. I've not created any notes.

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

calibre 7.1  embedded-python: True
Windows-10-10.0.22631-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.22631')
Python 3.11.5
Windows: ('10', '10.0.22631', 'SP0', 'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: DeDRM (10, 0, 9) && Annotations (1, 17, 13) && Barnes & Noble (1, 5, 2) && BookFusion Plugin (0, 8, 1) && Count Pages (1, 13, 4) && Diaps Editing Toolbag (0, 4, 0) && EpubCheck (0, 2, 5) && EpubSplit (3, 6, 0) && Favourites Menu (1, 3, 0) && Find Duplicates (1, 10, 8) && Hyphenate This! (0, 1, 3) && Set KFX metadata (from KFX Output) (2, 4, 0) && KFX Output (2, 4, 0) && KePub Input (3, 6, 6) && KePub Metadata Reader (3, 4, 3) && KePub Metadata Writer (3, 4, 3) && KePub Output (3, 6, 6) && Kindle hi-res covers (0, 5, 0) && KindleUnpack - The Plugin (0, 83, 1) && Kobo Books (1, 10, 2) && Kobo Metadata (1, 2, 0) && Kobo Utilities (2, 16, 11) && KoboTouchExtended (3, 6, 6) && Modify ePub (1, 8, 2) && Quality Check (1, 13, 6) && Reading List (1, 15, 1) && ScrambleEbook (0, 6, 0) && TextDiff (1, 2, 1) && View Manager (1, 10, 2)
Traceback (most recent call last):
  File "calibre\gui2\book_details.py", line 1401, in show_data
  File "calibre\gui2\book_details.py", line 1058, in show_data
  File "calibre\gui2\book_details.py", line 262, in render_html
  File "calibre\gui2\book_details.py", line 337, in render_data
  File "calibre\ebooks\metadata\book\render.py", line 310, in mi_to_html
  File "calibre\ebooks\metadata\book\render.py", line 134, in add_other_links
  File "calibre\gui2\book_details.py", line 334, in item_id_if_has_note
  File "calibre\db\cache.py", line 88, in call_func_with_lock
  File "calibre\db\cache.py", line 682, in notes_for
  File "calibre\db\backend.py", line 973, in notes_for
  File "calibre\db\notes\connect.py", line 264, in get_note
  File "calibre\db\backend.py", line 376, 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
JSWolf is offline   Reply With Quote
Old 11-30-2023, 04:39 PM   #2
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,360
Karma: 25865246
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Is there a hidden .calnotes directory in the library folder?

I've noticed it gets created first time you open a library, it should have this:

Click image for larger version

Name:	Screenshot 2023-12-01 073523.jpg
Views:	67
Size:	43.8 KB
ID:	204986

Just now was the first time I've opened my "Default" library.

ADDED: and here's the empty notes.db

Click image for larger version

Name:	Screenshot 2023-12-01 074123.jpg
Views:	56
Size:	477.7 KB
ID:	204987

I don't have the QC plugin installed.

BR

Last edited by BetterRed; 11-30-2023 at 04:43 PM.
BetterRed is offline   Reply With Quote
Advert
Old 11-30-2023, 05:43 PM   #3
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 73,297
Karma: 126042366
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Quote:
Originally Posted by BetterRed View Post
Is there a hidden .calnotes directory in the library folder?

I've noticed it gets created first time you open a library, it should have this:

Attachment 204986

Just now was the first time I've opened my "Default" library.

ADDED: and here's the empty notes.db

Attachment 204987

I don't have the QC plugin installed.

BR
Yes, there is a .calnotes. It has all that. So do I do anything with this?
JSWolf is offline   Reply With Quote
Old 11-30-2023, 06:13 PM   #4
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,360
Karma: 25865246
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Nope, leave it be… that's why its hidden

Quote:
Originally Posted by JSWolf View Post
When I clicked an eBook, I get an error. I've not created any notes.
I assume that means click in the book list, what did you expect to happen (I have the relevant Tweaks set to do_nothing). If it was View a format file (e.g. EPUB), try clicking the format file in the Book Details.

I can't understand why anything other than the Notes specific features would be accessing that database.

BR
BetterRed is offline   Reply With Quote
Old 11-30-2023, 06:40 PM   #5
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 73,297
Karma: 126042366
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Quote:
Originally Posted by BetterRed View Post
Nope, leave it be… that's why its hidden


I assume that means click in the book list, what did you expect to happen (I have the relevant Tweaks set to do_nothing). If it was View a format file (e.g. EPUB), try clicking the format file in the Book Details.

I can't understand why anything other than the Notes specific features would be accessing that database.

BR
What are the relevant tweaks? When I close the list, the database seems to be working no problem.
JSWolf is offline   Reply With Quote
Advert
Old 11-30-2023, 07:00 PM   #6
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,360
Karma: 25865246
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by JSWolf View Post
What are the relevant tweaks?
Click image for larger version

Name:	Screenshot 2023-12-01 095914.jpg
Views:	39
Size:	289.5 KB
ID:	204991

Quote:
Originally Posted by JSWolf View Post
When I close the list, the database seems to be working no problem.
Close what list? Does QC produce it's own list?

BR

Last edited by BetterRed; 11-30-2023 at 07:04 PM.
BetterRed is offline   Reply With Quote
Old 11-30-2023, 07:30 PM   #7
Wiggo
Leftutti
Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.
 
Wiggo's Avatar
 
Posts: 362
Karma: 459951
Join Date: Feb 2019
Location: Bavaria
Device: iPad Pro, Kobo Libra 2
Quote:
Originally Posted by JSWolf View Post
Windows 11 latest version and calibre 7.1.0.

I ran the Quality Check plugin to search the library. After it was done, I had just the matches showing. When I clicked an eBook, I get an error. I've not created any notes.

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

calibre 7.1  embedded-python: True
Windows-10-10.0.22631-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.22631')
Python 3.11.5
Windows: ('10', '10.0.22631', 'SP0', 'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: DeDRM (10, 0, 9) && Annotations (1, 17, 13) && Barnes & Noble (1, 5, 2) && BookFusion Plugin (0, 8, 1) && Count Pages (1, 13, 4) && Diaps Editing Toolbag (0, 4, 0) && EpubCheck (0, 2, 5) && EpubSplit (3, 6, 0) && Favourites Menu (1, 3, 0) && Find Duplicates (1, 10, 8) && Hyphenate This! (0, 1, 3) && Set KFX metadata (from KFX Output) (2, 4, 0) && KFX Output (2, 4, 0) && KePub Input (3, 6, 6) && KePub Metadata Reader (3, 4, 3) && KePub Metadata Writer (3, 4, 3) && KePub Output (3, 6, 6) && Kindle hi-res covers (0, 5, 0) && KindleUnpack - The Plugin (0, 83, 1) && Kobo Books (1, 10, 2) && Kobo Metadata (1, 2, 0) && Kobo Utilities (2, 16, 11) && KoboTouchExtended (3, 6, 6) && Modify ePub (1, 8, 2) && Quality Check (1, 13, 6) && Reading List (1, 15, 1) && ScrambleEbook (0, 6, 0) && TextDiff (1, 2, 1) && View Manager (1, 10, 2)
Traceback (most recent call last):
  File "calibre\gui2\book_details.py", line 1401, in show_data
  File "calibre\gui2\book_details.py", line 1058, in show_data
  File "calibre\gui2\book_details.py", line 262, in render_html
  File "calibre\gui2\book_details.py", line 337, in render_data
  File "calibre\ebooks\metadata\book\render.py", line 310, in mi_to_html
  File "calibre\ebooks\metadata\book\render.py", line 134, in add_other_links
  File "calibre\gui2\book_details.py", line 334, in item_id_if_has_note
  File "calibre\db\cache.py", line 88, in call_func_with_lock
  File "calibre\db\cache.py", line 682, in notes_for
  File "calibre\db\backend.py", line 973, in notes_for
  File "calibre\db\notes\connect.py", line 264, in get_note
  File "calibre\db\backend.py", line 376, 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
Why don't you heed your own obtuse comments and downgrade to Win 10 or Calibre 6.29?
Wiggo is offline   Reply With Quote
Old 11-30-2023, 08:21 PM   #8
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,360
Karma: 25865246
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Wiggo View Post
Why don't you heed your own obtuse comments and downgrade to Win 10 or Calibre 6.29?
You've clearly failed to notice that Jon has been spending time in his garden where he's found a new leaf to turn.

BR
BetterRed is offline   Reply With Quote
Old 12-01-2023, 12:21 AM   #9
Wiggo
Leftutti
Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.Wiggo ought to be getting tired of karma fortunes by now.
 
Wiggo's Avatar
 
Posts: 362
Karma: 459951
Join Date: Feb 2019
Location: Bavaria
Device: iPad Pro, Kobo Libra 2
My heart bleeds for you both.
Wiggo is offline   Reply With Quote
Old 12-01-2023, 12:46 AM   #10
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,360
Karma: 25865246
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Wiggo View Post
My heart bleeds for you both.
Bummer, there's no standard treatment for that… sometimes it just goes away. Try some valium and a lie down. If it persists see a cardiologist.

https://www.mayoclinic.org/diseases-...t/drc-20354623
BetterRed is offline   Reply With Quote
Old 12-01-2023, 04:53 AM   #11
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 73,297
Karma: 126042366
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Quote:
Originally Posted by Wiggo View Post
Why don't you heed your own obtuse comments and downgrade to Win 10 or Calibre 6.29?
I've never once suggested anyone downgrade. Upgrade yes, downgrade no.
JSWolf is offline   Reply With Quote
Old 12-01-2023, 06:26 AM   #12
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 43,671
Karma: 22446734
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
That looks like quality check deleted the notes db. You should report the issue in the QC plugin thread hopefully it will get support for the notesdb soonish
kovidgoyal is offline   Reply With Quote
Old 12-01-2023, 07:27 AM   #13
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 11,605
Karma: 6146321
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
It doesn't happen for me. I tried:
  • Using Quality Check to search for some text. It found several books.
  • Clicked on various lines in the book list.
  • No exception.
I tried it on libraries that do and don't have notes.

@JSWolf: any chance your workflow includes copying libraries, skipping hidden files? Or that you might have done that sometime in the past? That would remove the notes folder/database.

EDIT: Never mind. As BR said, opening a library creates the .calnotes folder so my "workflow" idea doesn't explain it.

Last edited by chaley; 12-01-2023 at 01:56 PM.
chaley is offline   Reply With Quote
Old 12-01-2023, 08:34 AM   #14
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,360
Karma: 25865246
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Curious - why would the QC plugin (or any other plugin) need to be aware of the quite separate Notes database.
BetterRed is offline   Reply With Quote
Old 12-01-2023, 08:51 AM   #15
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 43,671
Karma: 22446734
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Need to, no. Inadvertently mess with, possible but unlikely.
kovidgoyal is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
calibre corrupt error corrupt error database disk image is malformed didu812 Calibre 40 04-18-2023 08:46 PM
Calibre database: last_read_positions table ownedbycats Library Management 2 01-05-2021 12:59 AM
Calibre 4.0 Can't open database error rkashyap Devices 3 12-10-2019 01:06 AM
Sqlerror:no such savepoint: _apsw-0 calibre uncletoma Calibre 5 03-22-2018 10:21 AM
Database Exception Error Calibre markyfr Calibre 0 04-16-2012 08:39 AM


All times are GMT -4. The time now is 07:49 PM.


MobileRead.com is a privately owned, operated and funded community.