Error in removing merging

sattahipchris · 01-13-2022, 10:58 PM

When I try to merge books, remove a book I get the following error.

calibre, version 3.48.0
ERROR: Unhandled exception: <b>SQLError</b>:SQLError: no such module: fts5

calibre 3.48 [64bit] embedded-python: True is64bit: True
Windows-7-6.1.7601-SP1 Windows ('64bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.15+
Windows: ('7', '6.1.7601', 'SP1', u'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: Amazon.com Multiple Countries (1, 0, 0) &&

Fantastic Fiction (1, 5, 1) && Resize Cover (1, 1, 0) && Goodreads (1, 5, 3)
Traceback (most recent call last):
File "site-packages\calibre\gui2\actions\edit_metadata.py", line 582, in merge_books
File "site-packages\calibre\gui2\actions\edit_metadata.py", line 632, in

delete_books_after_merge
File "site-packages\calibre\gui2\library\models.py", line 416, in delete_books_by_id
File "site-packages\calibre\db\cache.py", line 62, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1647, in remove_books
File "site-packages\calibre\db\backend.py", line 1676, in remove_books
File "site-packages\calibre\db\backend.py", line 886, in executemany
File "c:\t\t\apsw-mc0now\apsw-3.27.2-r1\src\cursor.c", line 1136, in

APSWCursor_executemany.sqlite3_prepare
File "c:\t\t\apsw-mc0now\apsw-3.27.2-r1\src\statementcache.c", line 386, in sqlite3_prepare
SQLError: SQLError: no such module: fts5

Running windows 7 x64
Any help gratefully received

thiago.eec · 01-14-2022, 04:49 PM

Did you open your library on calibre 5? That is the probable cause.
If that is case, you need to restore your database.

sattahipchris · 01-14-2022, 09:44 PM

Thanks for the answer. That must be the answer.
I live in two locales and carry my data between them in an external drive at home I'm running windows 10 and where I am for the next 3 months its an older computer running windows 7 and as such I have version 3 here and version 5 at home.
How do I restore the database and if I do will it cause problems on the with version 5 that I have at home.

thiago.eec · 01-17-2022, 09:48 AM

Using calibre 3 and 5 on the same database is a bad idea. Restoring the database was a one time solution (maybe you tested calibre 5 and decided to go back to 3).

I'm not an expert, so I will not give any advice for you case, as you might ending up corrupting your database.

01-13-2022, 10:58 PM	#1
sattahipchris Junior Member Posts: 6 Karma: 10 Join Date: Jan 2014 Device: kindle	Error in removing merging When I try to merge books, remove a book I get the following error. calibre, version 3.48.0 ERROR: Unhandled exception: <b>SQLError</b>:SQLError: no such module: fts5 calibre 3.48 [64bit] embedded-python: True is64bit: True Windows-7-6.1.7601-SP1 Windows ('64bit', 'WindowsPE') ('Windows', '7', '6.1.7601') Python 2.7.15+ Windows: ('7', '6.1.7601', 'SP1', u'Multiprocessor Free') Interface language: None Successfully initialized third party plugins: Amazon.com Multiple Countries (1, 0, 0) && Fantastic Fiction (1, 5, 1) && Resize Cover (1, 1, 0) && Goodreads (1, 5, 3) Traceback (most recent call last): File "site-packages\calibre\gui2\actions\edit_metadata.py", line 582, in merge_books File "site-packages\calibre\gui2\actions\edit_metadata.py", line 632, in delete_books_after_merge File "site-packages\calibre\gui2\library\models.py", line 416, in delete_books_by_id File "site-packages\calibre\db\cache.py", line 62, in call_func_with_lock File "site-packages\calibre\db\cache.py", line 1647, in remove_books File "site-packages\calibre\db\backend.py", line 1676, in remove_books File "site-packages\calibre\db\backend.py", line 886, in executemany File "c:\t\t\apsw-mc0now\apsw-3.27.2-r1\src\cursor.c", line 1136, in APSWCursor_executemany.sqlite3_prepare File "c:\t\t\apsw-mc0now\apsw-3.27.2-r1\src\statementcache.c", line 386, in sqlite3_prepare SQLError: SQLError: no such module: fts5 Running windows 7 x64 Any help gratefully received

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error merging libraries	gianni_1	Library Management	1	01-13-2016 07:41 AM
Error when removing DRM in Calibre	tgtindell	Conversion	4	08-06-2015 11:57 PM
About merging Ebooks?	Dullahir	Calibre	2	02-27-2013 08:52 AM
calibre, version 0.8.8 ERROR: Error: Error communicating with device no such column:	e-bookuser	Devices	1	07-03-2011 04:09 PM
help: merging	scarlett_yan	iRex	5	09-22-2007 04:18 PM

01-14-2022, 04:49 PM	#2
thiago.eec Wizard Posts: 1,210 Karma: 1419583 Join Date: Dec 2016 Location: Goiânia - Brazil Device: iPad, Kindle Paperwhite, Kindle Oasis	Did you open your library on calibre 5? That is the probable cause. If that is case, you need to restore your database.

01-14-2022, 09:44 PM	#3
sattahipchris Junior Member Posts: 6 Karma: 10 Join Date: Jan 2014 Device: kindle	Thanks for the answer. That must be the answer. I live in two locales and carry my data between them in an external drive at home I'm running windows 10 and where I am for the next 3 months its an older computer running windows 7 and as such I have version 3 here and version 5 at home. How do I restore the database and if I do will it cause problems on the with version 5 that I have at home.

01-17-2022, 09:48 AM	#4
thiago.eec Wizard Posts: 1,210 Karma: 1419583 Join Date: Dec 2016 Location: Goiânia - Brazil Device: iPad, Kindle Paperwhite, Kindle Oasis	Using calibre 3 and 5 on the same database is a bad idea. Restoring the database was a one time solution (maybe you tested calibre 5 and decided to go back to 3). I'm not an expert, so I will not give any advice for you case, as you might ending up corrupting your database.

Advert