Calibre-Web has “archived” >1000k books, unprompted.

janeczku / calibre-web

:books: Web app for browsing, reading and downloading eBooks stored in a Calibre database

GNU General Public License v3.0

13.19k stars 1.41k forks source link

Calibre-Web has “archived” >1000k books, unprompted. #3101

Open tonystower opened 4 months ago

tonystower commented 4 months ago

Describe the bug/problem

I love Calibre-Web. Thanks so much for putting in so much hard work to make our lives easier.

Over a 1000k books in my calibre library have somehow ended up in the Calibre-Web archive. This happened some months ago during installation and was not at my request.

I cannot find a way to unarchive them en masse.

To Reproduce

Steps to reproduce the behavior:

Go to my archives books section
Find enormous numbers of archived books.

Logfile

I don’t think the logfile shows anything relevant here.

Expected behavior

A way to archive multiple books at a time, through some sort of “select all”.

Environment (please complete the following information):

OS: DietPi 6.8.1
Python version: 3.11
Calibre-Web version: 0.6.22
Docker container: LinuxServer
Special Hardware: Rasperry Pi 5
Browser: Safari 17.5

Additional context None I can think of

OzzieIsaacs commented 4 months ago

There is indeed no option currently. Workaround is to open the app.db file in the calibre-web root folder with a SQLite editor, do a backup of the file before. Search for the ‚archived_book‘ table and delete all entries in this table.

OzzieIsaacs commented 4 months ago

I started working on a feature like this, but got distracted several month ago

tonystower commented 4 months ago

Thank you both for your help. I ended up just clicking through each title…

appreciate all your hard work!

OzzieIsaacs commented 3 months ago

One thing for the reason: I don't think it came out of nowhere. I assume the following story:

You got sync working, all your books have been synced to kobo reader.
You decided to only sync "books of a certain shelf", added a few books to the shelf
You synced your Kobo reader
Calibre-Web found >1k books on your reader which don't belong to the shelf and therefore should not be on the reader. Calibre-Web requested deletion on the reader and archived the books on calibre-web

This is necessary, because otherwise you would start syncing books of a certain shelf, but all books would stay on the reader. This would lead to the question: "What to do" to remove the books from the reader. Answer: Archive them manually. So the automatic version is the better one, and we need the button unarchive all. There is meanwhile a PR for it on the way: #3113