|
|
Thread Tools | Search this Thread |
01-04-2020, 06:02 AM | #1 |
Junior Member
Posts: 6
Karma: 10
Join Date: Oct 2019
Location: Karlsruhe
Device: Kindle
|
_mcs_authors_by_book does not reflect the true content of the library
I searched the table _mcs_authors_by_book with DB Browser for SQLite with this query:
SELECT authorname, count(book) AS totalbook because I wanted to know the authors with more books. FROM _mcs_authors_by_book GROUP BY authorname ORDER BY totalbook DESC I discovered that this table does not reflect the true content of the library and all the deleted/moved books are still considered. The field book in this table points to id of books that are no longer in the table books Would it be possible to fix this modifying the TRIGGER books_delete_trg in one of the next versions? |
01-04-2020, 06:44 AM | #2 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
I think you are looking at a table maintained by [GUI Plugin] Multi-Column Search. If so then you should make this request in that plugin's thread.
|
Advert | |
|
01-04-2020, 08:48 AM | #3 | |
Junior Member
Posts: 6
Karma: 10
Join Date: Oct 2019
Location: Karlsruhe
Device: Kindle
|
Quote:
Is there any way to move my post to another thread? Otherwise, I just create a new one there. AM |
|
01-04-2020, 11:21 AM | #4 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Moderator Notice
Original post duplicated in plugins forum. This thread is closed |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Disable Library Selection in content library with version 3.0 | tochill | Calibre | 3 | 06-17-2017 12:39 AM |
Quell Reflect | obsessed2 | enTourage eDGe | 0 | 09-06-2012 10:56 AM |
Sigil 0.5.3 extremely slow to reflect changes | yotzeret | Sigil | 4 | 08-16-2012 06:10 AM |
public library content | rcrh | Sony Reader | 13 | 09-16-2009 12:55 PM |
Unutterably Silly Do your surfing habits reflect your gender? | Dylrob | Lounge | 28 | 09-11-2008 03:09 PM |