MobileRead Forums - View Single Post - delete/update of rows in metadata.db always fails ;-(

ShrimpMaster · 02-07-2023, 05:29 AM

HI everybody, I'm new here and this is my 1st post - hope I'm not OT with my question in this forum...

I'm using Calible a lot to organize my ebook and magazine libraries. Because the libs grew quite a bit in the past, I'm trying to find ways to clean-up duplicates from my libs. The find duplicates add-on works but it still leaves a lot behind. I'd like to find a different way and already exported all my books and the related metadata into a separate database. Here I identified a lot of books that I like to remove from one or the other Calibre lib, because they are already stored in another lib....

So, I thought, I can easily use PowerShell, open the Calibre SQLlite DB and to delete a row from the books table... That works fine, when I'm using SQLitebrowser (e.g. "DELETE FROM books WHERE id=1123") - but that always fails when trying this with PowerShell using the same query - here I always getan error: Invoke-SqliteQuery -DataSource $sDatabasePath -Query "DELETE FROM boo … | Exception calling "Fill" with "1" argument(s): "SQL logic error no such module: fts5"... Marking a certain book for deletion by trying to update the corresponding row in the Calibre DB ("Update books set title = 'deleted' WHERE id = 6764") actually fails in both - SQLbrowser and powershell: Exception calling "Fill" with "1" argument(s): "SQL logic error no such function: title_sort"

I'm a bit frustrated and hope maybe someone here in this forum can shed some light on why I'm getting theses errors and why the same query works fine in SQLlitebrowser and fails in PowerShell ;-(

All hints are appreciated ;-) Thanks a lot in advance.

02-07-2023, 05:29 AM	#1
ShrimpMaster Junior Member Posts: 2 Karma: 10 Join Date: Feb 2023 Device: Kindle Paperwhite	delete/update of rows in metadata.db always fails ;-( HI everybody, I'm new here and this is my 1st post - hope I'm not OT with my question in this forum... I'm using Calible a lot to organize my ebook and magazine libraries. Because the libs grew quite a bit in the past, I'm trying to find ways to clean-up duplicates from my libs. The find duplicates add-on works but it still leaves a lot behind. I'd like to find a different way and already exported all my books and the related metadata into a separate database. Here I identified a lot of books that I like to remove from one or the other Calibre lib, because they are already stored in another lib.... So, I thought, I can easily use PowerShell, open the Calibre SQLlite DB and to delete a row from the books table... That works fine, when I'm using SQLitebrowser (e.g. "DELETE FROM books WHERE id=1123") - but that always fails when trying this with PowerShell using the same query - here I always getan error: Invoke-SqliteQuery -DataSource $sDatabasePath -Query "DELETE FROM boo … \| Exception calling "Fill" with "1" argument(s): "SQL logic error no such module: fts5"... Marking a certain book for deletion by trying to update the corresponding row in the Calibre DB ("Update books set title = 'deleted' WHERE id = 6764") actually fails in both - SQLbrowser and powershell: Exception calling "Fill" with "1" argument(s): "SQL logic error no such function: title_sort" I'm a bit frustrated and hope maybe someone here in this forum can shed some light on why I'm getting theses errors and why the same query works fine in SQLlitebrowser and fails in PowerShell ;-( All hints are appreciated ;-) Thanks a lot in advance.