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

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

View Poll Results: If you have this SQL Error issue, what OS are you using?
Windows 0 0%
MacOS 0 0%
Linux 0 0%
Other 0 0%
Multiple Choice Poll. Voters: 0. You may not vote on this poll

Reply
 
Thread Tools Search this Thread
Old 04-18-2024, 07:57 PM   #1
KSlauson
Junior Member
KSlauson began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Apr 2024
Device: none
SQL Error no such savepoint is still with us...

This error has been cropping up based on other threads for several years now, through various versions of Calibre. It's a great program, but this bug really cripples it use.

I've been trying various suggestions, including exporting the library and reimporting it to a different local drive. My library passes all the check library tests. I can add and edit books, but I cannot delete some books. There's a serious bug in Calibre somewhere. I don't know if it's specific to Windows, but I could test this on Linux if needed.

Here's the error message:
Spoiler:

calibre, version 7.8.0
ERROR: Unhandled exception: <b>SQLError</b>:SQLError: no such savepoint: _apsw-0

calibre 7.8 embedded-python: True
Windows-10-10.0.19045-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.19045')
Python 3.11.5
Windows: ('10', '10.0.19045', '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, 10, 0) && DeDRM (10, 0, 9) && Package KFX (from KFX Input) (2, 10, 0) && Amazon.com Multiple Countries (1, 0, 0) && Baen (1, 1, 0) && Barnes & Noble (1, 5, 4) && Clipboard Search (1, 5, 1) && Comments Cleaner (1, 13, 0) && Count Pages (1, 13, 6) && DOC Input (1, 0, 1) && Ebook Translator (2, 3, 3) && Editor Chains (1, 1, 6) && EpubMerge (2, 18, 0) && EpubSplit (3, 7, 0) && Extract ISBN (1, 6, 2) && FanFicFare (4, 33, 0) && Fantastic Fiction (1, 7, 0) && Fantastic Fiction Adults (1, 3, 1) && Favourites Menu (1, 3, 1) && FictionDB (1, 4, 2) && Find Duplicates (1, 10, 9) && Generate Cover (2, 3, 4) && Goodreads (1, 8, 1) && ISFDB3 (1, 2, 2) && KFX metadata reader (from KFX Input) (2, 10, 0) && From KFX (2, 10, 0) && KFX Input (2, 10, 0) && Kindle hi-res covers (0, 5, 1) && KindleUnpack - The Plugin (0, 83, 1) && Kobo Metadata (1, 5, 0) && Manage Series (1, 5, 2) && Modify ePub (1, 8, 3) && NASA STI Repository (1, 0, 2) && OverDrive Libby (0, 1, 9) && Overdrive Link (2, 57, 0) && Quality Check (1, 13, 10) && Quick Preferences (1, 7, 1) && Resize Cover (1, 2, 1) && Search The Internet (1, 11, 2) && Smashwords Metadata (1, 0, 2) && TTS to MP3 (0, 6, 0) && TextDiff (1, 2, 4) && Walk Search History (1, 5, 4) && Wikidata (2, 0, 0) && ePub Extended Metadata {Writer} (0, 11, 2) && ePub Extended Metadata {Reader} (0, 11, 2) && ePub Extended Metadata (0, 11, 2) && Overdrive Link Metadata Source (2, 57, 0)
Traceback (most recent call last):
File "calibre\db\backend.py", line 1159, in executemany
File "C:\t\t\apsw-42s16m2x\src\cursor.c", line 240, in resetcursor
apsw.ConstraintError: ConstraintError: constraint failed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "calibre\gui2\actions\delete.py", line 459, in delete_books
File "calibre\gui2\actions\delete.py", line 436, in do_library_delete
File "calibre\gui2\library\models.py", line 459, in delete_books_by_id
File "calibre\db\cache.py", line 86, in call_func_with_lock
File "calibre\db\cache.py", line 2220, in remove_books
File "calibre\db\backend.py", line 2292, in remove_books
File "calibre\db\backend.py", line 1158, in executemany
apsw.SQLError: SQLError: no such savepoint: _apsw-0

Last edited by theducks; 04-19-2024 at 02:58 AM. Reason: spoilered log
KSlauson is offline   Reply With Quote
Old 04-19-2024, 03:31 AM   #2
Sirtel
Grand Sorcerer
Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.
 
Sirtel's Avatar
 
Posts: 10,358
Karma: 225099840
Join Date: Jan 2014
Location: Estonia
Device: Kobo Sage & Libra 2
Never have had such an error through 12 years of using Calibre, with the same library, on many different Windows computers.
Sirtel is offline   Reply With Quote
Advert
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
'no savepoint' error Savate Library Management 6 04-18-2024 07:47 PM
SQL error when trying to delete a book richorlin Library Management 6 06-11-2021 04:34 AM
SQL error attempting to remove books from library Aelbfled Calibre 1 12-30-2017 10:49 AM
SQL error: sortconcat() unknown Keltia Development 8 08-05-2014 12:55 PM


All times are GMT -4. The time now is 12:55 PM.


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