advplyr
fd3d4f5fcf
Merge pull request #3978 from sloped/fix/detect-http-https-upgrades
...
fix: allow upgrading HTTP to HTTPS for redirects
2025-02-18 17:18:36 -06:00
advplyr
9f9bee2ddc
Merge pull request #3996 from mikiher/optimize-podcast-queries
...
Improve podcast library page query performance on title, titleIgnorePrefix, and addedAt sort orders
2025-02-18 17:04:45 -06:00
mikiher
568bf0254d
Change migration version to v2.19.4
2025-02-18 07:57:46 +02:00
advplyr
79f4db5ff3
Version bump v2.19.3
2025-02-16 17:01:45 -06:00
mikiher
7038f5730f
Set title[IgnorePrefix] when a podcast libraryItem is created
2025-02-16 14:57:05 +02:00
mikiher
0a8186cbda
Add ANALYZE to database init sequence
2025-02-16 13:38:54 +02:00
mikiher
659164003f
Clear LibraryItemsPodcastFilters count cache after podcast[Episode] is created or destroryed
2025-02-16 13:27:47 +02:00
mikiher
de5d8650e8
Add profiling to podcast library filterdata queries
2025-02-16 12:47:23 +02:00
mikiher
bacefb5f6f
Format PodcastScanner (Pretteier-only changes)
2025-02-16 12:41:47 +02:00
mikiher
0169bf5518
Update podcast.numEpisodes when episodes are created or destroyed
2025-02-16 12:38:44 +02:00
mikiher
8f192b1b17
Add profiling to podcasts and podcast episodes page queries
2025-02-16 09:46:32 +02:00
mikiher
21343b5aa0
Add count cache to libraryItemsPodcastQueries
2025-02-16 09:40:29 +02:00
mikiher
a5508cdc4c
Remove unnecessary 'distinct: true' from podcast episodes page query
2025-02-16 09:32:00 +02:00
mikiher
bd4f48ec39
Add required: true to includes in podcast episodes page query
2025-02-16 09:29:57 +02:00
mikiher
cb9fc3e0d1
Replace numEpisodesIncomplete subquery with cached user progress calculation
2025-02-16 09:22:06 +02:00
mikiher
707533df8f
Remove numEpisodes subquery from podcasst page query
2025-02-16 09:15:54 +02:00
mikiher
2e48ec0dde
Use libraryItem.title[IgnorePrefix] for sorting podcasts page query
2025-02-16 09:08:27 +02:00
mikiher
f1e46a351b
Separate feed query from podcasts page query
2025-02-16 09:05:54 +02:00
mikiher
da8fd2d9d5
Set podcastId when mediaProgress is created
2025-02-16 08:57:10 +02:00
mikiher
f1de307bf9
Update cached user whenever mediaProgress is removed
2025-02-16 08:52:33 +02:00
mikiher
7282afcfde
Add podcastId to mediaProgress model
2025-02-16 08:42:09 +02:00
mikiher
e2f1aeed75
Add numEpisodes to podcast model
2025-02-16 08:38:03 +02:00
mikiher
23a750214f
Add migration in preparation for podcast query optimization
2025-02-16 08:35:51 +02:00
advplyr
6a7418ad41
Fix:Edit book cover tab local images overflowing #3986
2025-02-15 17:55:56 -06:00
advplyr
8b00c16062
Merge pull request #3993 from mikiher/fix-stringify-sequelize-query
...
fix stringifySequelizeQuery and add tests
2025-02-15 17:24:19 -06:00
mikiher
8ee5646d79
fix stringifySequelizeQuery and add tests
2025-02-15 23:57:27 +02:00
advplyr
373551fb74
Merge pull request #3985 from advplyr/fix-quick-match-all-crash
...
Fix server crash when quick match all updates series sequence #3961
2025-02-14 17:22:29 -06:00
advplyr
d9b206fe1c
Fix server crash when quick match all updates existing series sequence #3961
2025-02-14 16:56:37 -06:00
advplyr
fe4e0145c9
Merge pull request #3984 from advplyr/fix-chapter-end-sleep-timer
...
Fix chapter end sleep timer sometimes not stopping #3969
2025-02-14 16:39:26 -06:00
advplyr
c4d99a118f
Fix chapter end sleep timer sometimes not stopping #3969
2025-02-14 16:24:39 -06:00
advplyr
b96226966b
Merge pull request #3980 from advplyr/stringify_sequelize_query
...
Fix count cache by stringify Symbols #3979
2025-02-13 18:24:36 -06:00
advplyr
5ca12eee19
Fix count cache by stringify Symbols #3979
2025-02-13 18:07:59 -06:00
Conner McCall
f460297daf
fix: allow upgrading HTTP to HTTPS for redirects
...
Re: #3142 and #3658
When adding certain podcasts, the server encountered a redirect from an HTTP URL to an HTTPS domain, causing an error that was difficult for end users to diagnose without inspecting logs or HTML.
This issue arose due to SSRF security measures that blocked such redirects. Instead of failing in these cases, we now detect when the error is caused by an HTTP-to-HTTPS upgrade. If confirmed, we upgrade the initial URL to HTTPS and resend the request.
Since this change does not allow cross-protocol or cross-domain redirections, it remains secure while resolving most of the reported issues.
Affected podcasts that are now fixed:
- D&D is for Nerds
- The New Yorker: The Writer's Voice - New Fiction from The New Yorker
- Radiolab
2025-02-13 09:19:02 -06:00
advplyr
ebdf377fc1
Version bump v2.19.2
2025-02-12 10:01:05 -06:00
advplyr
808d23561c
Merge pull request #3972 from advplyr/remove-col-ambiguity
...
Fix server crash remove column name ambiguity #3966
2025-02-12 09:59:54 -06:00
advplyr
a34813b3ab
Fix server crash remove column name ambiguity #3966
2025-02-12 08:52:20 -06:00
advplyr
725192fbc0
Version bump v2.19.1
2025-02-11 17:17:07 -06:00
advplyr
2915c072b5
Merge pull request #3931 from weblate/weblate-audiobookshelf-abs-web-client
...
Translations update from Hosted Weblate
2025-02-11 16:52:14 -06:00
Troja
03a1d7da32
Translated using Weblate (Belarusian)
...
Currently translated at 19.4% (212 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/be/
2025-02-11 22:51:07 +00:00
Mario
1be1ce6f87
Translated using Weblate (German)
...
Currently translated at 99.9% (1088 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/de/
2025-02-11 22:51:07 +00:00
Troja
21b27c432c
Translated using Weblate (Belarusian)
...
Currently translated at 16.0% (175 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/be/
2025-02-11 22:51:06 +00:00
Troja
cbe5e3db8a
Translated using Weblate (Belarusian)
...
Currently translated at 13.0% (142 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/be/
2025-02-11 22:51:05 +00:00
burghy86
08b4d4d7a2
Translated using Weblate (Italian)
...
Currently translated at 100.0% (1089 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/it/
2025-02-11 22:51:04 +00:00
Jan-Eric Myhrgren
ac8324e595
Translated using Weblate (Swedish)
...
Currently translated at 90.1% (982 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/sv/
2025-02-11 22:51:03 +00:00
Pepijn
a14c6a3a8b
Translated using Weblate (Dutch)
...
Currently translated at 99.8% (1087 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/nl/
2025-02-11 22:51:03 +00:00
Jan-Eric Myhrgren
74b35ea9d1
Translated using Weblate (Swedish)
...
Currently translated at 88.7% (966 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/sv/
2025-02-11 22:51:02 +00:00
Jan-Eric Myhrgren
78d8c83e6d
Translated using Weblate (Swedish)
...
Currently translated at 85.9% (936 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/sv/
2025-02-11 22:51:01 +00:00
Jan-Eric Myhrgren
bf795d3662
Translated using Weblate (Swedish)
...
Currently translated at 85.9% (936 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/sv/
2025-02-11 22:51:00 +00:00
Jan-Eric Myhrgren
1fbd090441
Translated using Weblate (Swedish)
...
Currently translated at 85.8% (935 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/sv/
2025-02-11 22:50:59 +00:00
biuklija
70621e72e8
Translated using Weblate (Croatian)
...
Currently translated at 100.0% (1089 of 1089 strings)
Translation: Audiobookshelf/Abs Web Client
Translate-URL: https://hosted.weblate.org/projects/audiobookshelf/abs-web-client/hr/
2025-02-11 22:50:59 +00:00
