Purchased books show as unavailable

[wolfsongz]

Describe the bug
There are numerous books that I have purchased but cannot download. The books are greyed out in Libation as though they are no longer available but they are still available to download in the Audible app. The strange thing is that sometimes the titles will show up as available and then when I check again, they aren't and vice-versa.

To Reproduce
Steps to reproduce the behavior:

1. Open the app and let it scan my library
2. Observe the status in the Liberate column
3. Note that "The Girl With All the Gifts" (and other titles) is 'greyed out' in the Liberate column but because I selected it before that, it appears in the Process Queue

Expected behavior
Titles that are still available on Audible show up as available on Libation

Screenshots

Platform

Windows 11

Log Files
The log files fail to upload.

[rmcrackan]

Sorry about this error. I see your note about the log files failing to upload but I'm not sure how to diagnose this without more info. Do you have dropbox, google drive, icloud, etc which might let you share a download link?

[wolfsongz]

Sorry about this error. I see your note about the log files failing to upload but I'm not sure how to diagnose this without more info. Do you have dropbox, google drive, icloud, etc which might let you share a download link?

I can share them on Google Drive. https://drive.google.com/file/d/1OGxgtda_gJ-7_3-oqs2GFlAqvhuZp8b5/view?usp=drive_link

[rmcrackan]

Thanks! This looks like something is fighting for control over these files. Does google drive automatically backup either C:\Users\wolfs\AppData\Local\Temp\Libation or the destination folder where your books are saved to?

I had issues like this with a version of dropbox once -- where an app was trying to download/create/edit files and dropbox was aggressively trying to back them up at the same time. Let's see what happens if you pause any similar services, restart Libation, and try your backup again.

[wolfsongz]

I have OneDrive, Dropbox and Google Drive but none of them backup either location. Since setting up Libation I've actually changed the target folder a couple of times, I don't think any of those were backed up, but I've always had this problem from the first time I used the app.

Consequently, I've gone into Audible to remove titles that are no longer available and when I rescan, they still appear in Libation.

[rmcrackan]

If you go to Settings > Trash Bin, are any of the missing titles in there?

[wolfsongz]

No. I was actually able to download most of the books in between the availability changing.

I left a couple of books to troubleshoot this. I took this screenshots less than 30 seconds apart just now after filtering.

[tkrotchko]

I ran into this yesterday with 11.3.4.

It has to do with sharing the library on OneDrive with multiple PCs attached The application goes a little crazy I think because you store specific information about each PC with the library itself, which seems like a poor choice. Even if it works in this situation, it will show the books are not available, even if you point the application to the library. In fact, if you do, it goes through perhaps 2/3's of the books and won't see the rest.

Interestingly in this situation, I downloaded 3 books with PC #1 and quit the application. I opened the library on PC #2 and not only did it not show the just-downloaded books, it refused to see them.

You may not like it but I think what you need to do it have an option that validates the books & PDFs are downloaded in the library when this happens.

[wtanksleyjr]

Oh no, this would be very bad for Docker users, who need to use a GUI at least occasionally (although I try not to copy the DB back, it sometimes is needed).

[tkrotchko]

Oh no, this would be very bad for Docker users, who need to use a GUI at least occasionally (although I try not to copy the DB back, it sometimes is needed).

I would imagine this would be a function available in the GUI. Put it in the backlog and see if enough people are seeing corruption issues to warrant a repair library function.

[wolfsongz]

I just added a bunch of books to my library today and they are show as duplicates; one available and one that isn't.

Once I download the available book, both show as downloaded.

[rmcrackan]

This feels like something is messed up in your database. Can you email a download link to me?

I recommend email rather than posting it here for all to see. My email is on this page: https://github.com/rmcrackan

The database file is in the same folder as your log files : LibationContext.db

[rmcrackan]

@wolfsongz

It was for sure a messed up database. I'm not sure how it got this way so I can't be confident that it won't happen again. I'm about to email you a download link with my fixed database file. Back yours up and replace it with this. Let's see what it looks like after you do that then do a scan.

If you're running Libation from multiple places at the same time and you have a service trying to sync the database files, this is unsupported and could result in strange data.

[rmcrackan]

@tkrotchko

because you store specific information about each PC with the library itself

Sorry, you lost me. What PC information are you seeing?

If i understand correctly, you're doing this: running Libation in multiple locations at the same time and are using google drive, dropbox, et al. to sync the database. This is unsupported behavior. I have no idea how this single database file would behave. Let me know if I misunderstood your situation.

Regarding the database file you sent: I see no duplicates and one book with a possible download error: The Aviators -- B00EIOM58E. Can you tell me more about what I should be looking for? Again, I might not understand your situation.

[tkrotchko]

Sorry, I did a poor job of explaining my issue. Yes, I accidentally had two PCs at the same time in the database because I'm moving everything to a new PC, and there's no doubt that fubar'd the database. What I was asking is whether there's a way to rebuild the database if you didn't actually lose the library. And if not, I was advocating for that capability because if you screw up the database there's no way to recover at all. You're just kind of stuck at that point. Now you do have the ability to point the program to the directory where the files are located, but when you do that, two issues pop up 1 - it doesn't verify all the books and acknowledge them as downloaded (Green Light) probably only 2/3's to 3/4's of them 2 - For many of the books it shows them "not downloaded", and if you try to download the books again, the program throws an error. You can force them to indicate downloaded, but it's a pain because you can't do multi-select for that. Bottom line, I screwed up, it's not the end of the world, but it would be convenient if you could recover the database. Regardless, I do appreciate you taking the time to look the database.

…

--Tom

________________________________ From: rmcrackan ***@***.***> Sent: Friday, January 24, 2025 2:08 PM To: rmcrackan/Libation ***@***.***> Cc: BookLover ***@***.***>; Mention ***@***.***> Subject: Re: [rmcrackan/Libation] Purchased books show as unavailable (Issue #1118) @tkrotchko<https://github.com/tkrotchko> because you store specific information about each PC with the library itself Sorry, you lost me. What PC information are you seeing? If i understand correctly, you're doing this: running Libation in multiple locations at the same time and are using google drive, dropbox, et al. to sync the database. This is unsupported behavior. I have no idea how this single database file would behave. Let me know if I misunderstood your situation. Regarding the database file you sent: I see no duplicates and one book with a possible download error: The Aviators -- B00EIOM58E. Can you tell me more about what I should be looking for? Again, I might not understand your situation. — Reply to this email directly, view it on GitHub<#1118 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ADMNBPLAIMRMQYF4GU674CL2MKFT3AVCNFSM6AAAAABVPRDTI2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMMJTGIYDMNZXG4>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[wolfsongz]

@rmcrackan that fixed the duplicates. Thanks

It's still showing items that are no longer in my Audible library and the original problem of titles that aren't available.

[rmcrackan]

It's still showing items that are no longer in my Audible library

Libation will not automatically remove titles. You'll have to do that manually. Also, you may want to go to Settings > Trash Bin to clear them out and make sure nothing is there by accident. For ones which aren't available, what happens if you right click and manually set to 'not downloaded' then try to download them again?

[rmcrackan]

Now you do have the ability to point the program to the directory where the files are located, but when you do that, two issues pop up 1 - it doesn't verify all the books and acknowledge them as downloaded (Green Light) probably only 2/3's to 3/4's of them

For each remaining book, you can right-click and manually set status to 'downloaded'. Or, if there are only a few which were not downloaded, you can manually download those and then use the top 'visible books' menu to set all books to 'downloaded'

2 - For many of the books it shows them "not downloaded", and if you try to download the books again, the program throws an error.

This shouldn't happen. What kind of error?

it would be convenient if you could recover the database

I'm not sure what that would mean in this case. The database itself is fine. As I understand it, our problem is that the database is out of sync with books you've already downloaded. If I knew which ones were downloaded, I could mark those as downloaded.