Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Development

Notices

Reply
 
Thread Tools Search this Thread
Old 03-21-2018, 04:32 AM   #1
underscore
Addict
underscore ought to be getting tired of karma fortunes by now.underscore ought to be getting tired of karma fortunes by now.underscore ought to be getting tired of karma fortunes by now.underscore ought to be getting tired of karma fortunes by now.underscore ought to be getting tired of karma fortunes by now.underscore ought to be getting tired of karma fortunes by now.underscore ought to be getting tired of karma fortunes by now.underscore ought to be getting tired of karma fortunes by now.underscore ought to be getting tired of karma fortunes by now.underscore ought to be getting tired of karma fortunes by now.underscore ought to be getting tired of karma fortunes by now.
 
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;
i get back
Code:
Error: no such function: title_sort
i just tried to change 2018 with 2016.

can you please advice?
regards
underscore is offline   Reply With Quote
Old 03-21-2018, 11:24 AM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
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
kovidgoyal is offline   Reply With Quote
Advert
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 12:50 AM.


MobileRead.com is a privately owned, operated and funded community.