Quote:
Originally Posted by Angelo.Mascaro
I searched the table _mcs_authors_by_book with DB Browser for SQLite with this query:
SELECT authorname, count(book) AS totalbook
FROM _mcs_authors_by_book
GROUP BY authorname
ORDER BY totalbook DESC
because I wanted to know the authors with more books.
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? Or maybe there is a way to realign the table to the library?
|
If you bother to read the MCS icon menu's tooltips, you will discover that the MCS search acceleration tables are automatically maintained by MCS. In other words, you have to actually use MCS to have MCS keep them refreshed and up-to-date.
DaltonST