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

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

Notices

Reply
 
Thread Tools Search this Thread
Old 01-13-2022, 11:58 PM   #1
sattahipchris
Junior Member
sattahipchris began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Jan 2014
Device: kindle
Question 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
sattahipchris is offline   Reply With Quote
Old 01-14-2022, 05:49 PM   #2
thiago.eec
Fanatic
thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.
 
Posts: 578
Karma: 155092
Join Date: Dec 2016
Location: Goiânia - Brazil
Device: iPad, Kindle Paperwhite
Did you open your library on calibre 5? That is the probable cause.
If that is case, you need to restore your database.
thiago.eec is offline   Reply With Quote
Old 01-14-2022, 10:44 PM   #3
sattahipchris
Junior Member
sattahipchris began at the beginning.
 
Posts: 2
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.
sattahipchris is offline   Reply With Quote
Old 01-17-2022, 10:48 AM   #4
thiago.eec
Fanatic
thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.thiago.eec can grok the meaning of the universe.
 
Posts: 578
Karma: 155092
Join Date: Dec 2016
Location: Goiânia - Brazil
Device: iPad, Kindle Paperwhite
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.
thiago.eec 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
Error merging libraries gianni_1 Library Management 1 01-13-2016 08:41 AM
Error when removing DRM in Calibre tgtindell Conversion 4 08-07-2015 12:57 AM
About merging Ebooks? Dullahir Calibre 2 02-27-2013 09:52 AM
calibre, version 0.8.8 ERROR: Error: Error communicating with device no such column: e-bookuser Devices 1 07-03-2011 05:09 PM
help: merging scarlett_yan iRex 5 09-22-2007 05:18 PM


All times are GMT -4. The time now is 12:35 AM.


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