View Single Post
Old 03-15-2025, 10:20 AM   #1
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 11,011
Karma: 75555555
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Question on editing database directly

I accidentally erased timestamps of a few books while working in Calibre. No big deal:

1. Close Calibre.
2. Grab latest db backup open in SQLiteStudio.
3. Go to books table, find book, copy timestamp column.
4. Go to my library db. Paste the timestamp into same book.
5. Commit.

I've done this before with custom column, never directly on books column. It didn't work this time. SQLIteStudio reported on commit:
[11:19:09] An error occurred while committing the data: no such function: title_sort

What does this mean?

I can restore the date through GUI, will lose exact timestamp info though.

Last edited by ownedbycats; 03-15-2025 at 10:25 AM.
ownedbycats is offline   Reply With Quote