User defined function title_sort() missing

[Jeffrey Wong]

Hello.

When trying to change the book title through Calibre, I often end up with the book itself missing from Calibre due to a broken book path.

Anyway, I decided to modify metadata.db through both "DBBrowser for SQLite" and "SQLLite Studio" (both in Windows 10), in order to track down this bog.

Here follow the error message I get with both applications, when I try to alter the book title:

"[14:22:29] An error occurred while committing the data: no such function: title_sort"

It looks to me on first inspection as either the title_sort() C function itself is missing, or the mapping of the title_sort() C function to SQLite is broken.

Please fix the above bug when you get a chance. Thanks.

Regards,
Jeffrey Wong

PS: I am planning now to just export the books table as CSV, edit the titles using an editor, then importing the books table. Do you think this is a good idea? Thanks.

[Kovid Goyal (kovid)]

Do not edit the calibre database directly. The only way that books will
go missing when editing title metadata is if you put the calibre library
on some non-native filesystem such as a networked drive or a folder that
is scanned by a file sync program at the same time as calibre is
running, etc. Move your calibre library to a native filesystem to a
folder that calibrehas exclusive access to and you will be fine.

https://manual.calibre-ebook.com/faq.html#i-am-getting-errors-with-my-calibre-library-on-a-networked-drive-nas

 status invalid