MobileRead Forums - View Single Post - Library count not matching the number of books

aleyx · 12-13-2013, 04:09 PM

His (her?) screenshot tends to show that there are only 358 book in the collection/library/virtual library. Since the tag browser lists 359 ISBNs, either a book has two ISBNs, or the identifiers table has an orphan record (a record whose 'book' field has an ID not in the `books`table).

If the former, your search query (I didn't know that one, thanks) should show which book.

If the latter, a query like 'SELECT * FROM identifiers WHERE book NOT IN (SELECT id FROM books)' should list the record in error.

edit: identifiers:isbn:#>0 returns no book, so I don't know if identifiers:isbn:#>1 would work after all...

Oh, and my query is, of course, an SQL query and should be run from an sqlite explorer program. Running it in Calibre would have no useful effect.

12-13-2013, 04:09 PM	#11
aleyx Addict Posts: 250 Karma: 20386 Join Date: Sep 2010 Location: France Device: Bookeen Diva, Kobo Clara BW	His (her?) screenshot tends to show that there are only 358 book in the collection/library/virtual library. Since the tag browser lists 359 ISBNs, either a book has two ISBNs, or the identifiers table has an orphan record (a record whose 'book' field has an ID not in the `books`table). If the former, your search query (I didn't know that one, thanks) should show which book. If the latter, a query like 'SELECT * FROM identifiers WHERE book NOT IN (SELECT id FROM books)' should list the record in error. edit: identifiers:isbn:#>0 returns no book, so I don't know if identifiers:isbn:#>1 would work after all... Oh, and my query is, of course, an SQL query and should be run from an sqlite explorer program. Running it in Calibre would have no useful effect. Last edited by aleyx; 12-13-2013 at 04:14 PM.