User defined function title_sort() missing
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
calibre |
Invalid
|
Undecided
|
Unassigned |
Bug Description
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.
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