View Single Post
Old 01-04-2020, 10:31 AM   #271
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Read the Menu ToolTips

Quote:
Originally Posted by Angelo.Mascaro View Post
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

Last edited by DaltonST; 01-04-2020 at 11:28 AM.
DaltonST is offline   Reply With Quote