-
Notifications
You must be signed in to change notification settings - Fork 28
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Fix for "[sponsorblock] database update failed" #31
Comments
The public database is down right now since I switched from sqlite to postgres. I plan to setup something to dump the database soon. Probably postgres -> csv, and csv -> sqlite for legacy use at more infrequent intervals. |
@po5 Please consider adding "https://sb.ltn.fi/database.db" (offical mirror) as a fallback database URI since "https://sponsor.ajay.app/database.db" is unavailable. |
@hl2guide fyi, that one is "frozen" in the last state of the sqlite db. |
This mpv_sponsorblock script can't be used at the time at all as-it-is? I don't happen to have the database stored locally. |
Set |
@po5 Does setting Are there any knockon side effects for setting this? |
Yup. It leaks your watched videos to the sponsorblock server, but |
It's not too hard to adapt the script to use the new CSV dumps but it seems like the last entry is the same as the one in the DB file posted in #31 (comment). I have a local version with initial CSV dump support but I'm not sure if there's a point in using it if the dumps aren't up to date. |
Yep, I still haven't got automatic dumps working yet. |
The above is not true anymore |
The CSV export is now working |
Thanks, I'll look into this when I can. The changing filenames are a bit of a pain, wish there were links that redirect to the latest version of each file but I'll deal with it. |
I now updated it to use redirects. You can now directly request from https://sponsor.ajay.app/database/sponsorTimes.csv, and it will trigger a dump if necessary, and then redirect you to the most recent dump. So, feel free to revert the change to use It will not wait for the triggered dump to complete, if that occurred. |
Happen to have any updates on this? |
How are you supposed to configure the script now? I cleared the database file recently and only see the
|
I'm also having the same issue. |
Since the database format has changed, you can't use local database until someone add the code necessary. |
thnx this thing was helpful! And no script is working (macOS 12.1; homebrew) |
<po5#31 (comment)>: > I now updated it to use redirects. You can now directly request > from https://sponsor.ajay.app/database/sponsorTimes.csv, and it > will trigger a dump if necessary, and then redirect you to the > most recent dump. Apart from not making redundant requests, this change also prevents an issue where you request the dump list but the dump you want to download becomes inaccessible (removed most likely?) even before you start downloading it. This reverts commit 355c8b3.
For me the last time the database update succeeded was: Friday, 26 February 2021, 8:33:45 PM
I'm now getting: "[sponsorblock] database update failed"
The text was updated successfully, but these errors were encountered: