03-21-2018, 04:32 AM | #1 |
Addict
Posts: 314
Karma: 1093858
Join Date: Mar 2013
Location: Romania (but i'm italian)
Device: Onyx Boox Nova 2, Kingrow K1 (former N96 ML/i86ML Plus/M92)
|
calibre sqlite schema
hello,
i was building myself some command line scripts querying metadata.db As i have the usual extra 'read' column i update that column in calibre once i finish a book. So a "last_read" shell script, for knowing the last books i read, is obtained by ordering by books.last_modified But then i reloaded some metadata from internet fior an old read book and now i would like to bring last_modified back in time for a specific book. If i try something like Code:
sqlite> update books set last_modified = '2016-03-21 06:42:08.025607+00:00' where id = 35; Code:
Error: no such function: title_sort can you please advice? regards |
03-21-2018, 11:24 AM | #2 |
creator of calibre
Posts: 43,778
Karma: 22666666
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Dont use sqlite to edit the database. Use calibredb, https://manual.calibre-ebook.com/gen...calibredb.html
|
Advert | |
|
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
.sqlite in calibre | quarkpott | Calibre | 7 | 07-10-2017 10:06 AM |
SQLite FTS3/4 & Calibre 2.0+ | DaltonST | Development | 6 | 08-28-2014 11:02 AM |
Tag Schema Discussion | unboggling | General Discussions | 0 | 02-06-2011 09:40 PM |
Any database schema changes? | timlegge | Kobo Reader | 6 | 10-19-2010 08:56 PM |