mirror of
https://github.com/koel/koel.git
synced 2026-04-25 08:46:00 +03:00
[GH-ISSUE #1669] Unable to create smart playlist #914
Labels
No labels
Authentication
Dependencies
Documentation
Feature Request
Flac
Help Wanted
Installation/Setup
Integration
Mobile
PR Welcome
Pending Release
Performance
Playlist
S3
Search
Sync
[Pri] Low
[Pri] Normal
[Status] Keep Open
[Status] Needs Author Reply
[Status] Needs Review
[Status] Stale
[Status] Will Implement
[Type] Blessed
[Type] Bug
[Type] Duplicate
[Type] Enhancement
[Type] Help Request
[Type] Question
[Type] Task
pull-request
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/koel-koel#914
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @rxerium on GitHub (Apr 16, 2023).
Original GitHub issue: https://github.com/koel/koel/issues/1669
Describe the bug
I am unable to create a "Smart playlist" with the following error "Something went wrong. Please try again."
To reproduce
Expected behavior
Should be able to create a smart playlist as normal
Screenshots
Environment
Additional context
Tested on a Ubuntu 22.04 VM as well as an LXC container.
Also followed the troubleshooting steps suggested here: https://github.com/koel/koel/issues/1651
@phanan commented on GitHub (Apr 17, 2023):
Can you check out https://github.com/koel/koel/releases/tag/v6.11.1?
@rxerium commented on GitHub (Apr 17, 2023):
Yes just saw that come through now, thanks for looking into this! Can you let me know how I can update Koel using docker compose? Is it just a matter of changing the version in the compose file to 6.11.1?
@rxerium commented on GitHub (Apr 18, 2023):
Ran the below:
The issue persists unfortunately.
@phanan commented on GitHub (Apr 18, 2023):
What's the error in the log file and/or console?
@rxerium commented on GitHub (Apr 18, 2023):
The error in the console is the same:
.
Do you know if it is possible to check the version when inside the Koel container? I'd like to confirm if it is 6.11.1.
@phanan commented on GitHub (Apr 18, 2023):
You can view the version in the About panel on web.
Also the log is under storage/logs/laravel.log.
On Tue 18. Apr 2023 at 16:52 Rishi @.***> wrote:
@rxerium commented on GitHub (Apr 18, 2023):
hmm I'm not on 6.11.1 yet. How would you advise updating the docker container?
@phanan commented on GitHub (Apr 18, 2023):
Does
docker pull phanan/koel:latestnot work?@rxerium commented on GitHub (Apr 20, 2023):
It does but now have this error.
@rxerium commented on GitHub (Apr 22, 2023):
Morning @phanan, I've resolved the other issue and still have issues creating smart playlists. I am currently on version 6.11.2. See logs below:
@phanan commented on GitHub (Apr 22, 2023):
That’s another issue which I think you can search for in the issue list.
On Sat 22. Apr 2023 at 08:10 Rishi @.***> wrote:
@rxerium commented on GitHub (Apr 22, 2023):
Will do thanks. Do you have any updates in regards to the Smart Playlist issue?
@rxerium commented on GitHub (Apr 28, 2023):
Hello, do you have any updates on this bug? Thanks
@phanan commented on GitHub (Apr 28, 2023):
Sorry I missed the second error. I'm actually not sure why "fc32-4975-4e7c-97a2-a56e0c2fd7dc" was generated. Please send the request payload when you create the playlist.
@rxerium commented on GitHub (May 3, 2023):
Apologies for the delayed reply, here is the request:
Here is the response:
@rxerium commented on GitHub (May 3, 2023):
I've just tried this on a few containers/VMs all with the same issue. Perhaps its an issue you can replicate when first setting it up? Might be a bug in a recent release.
@neoczr commented on GitHub (Jun 16, 2023):
I've got the same problem. Could not creat playlist and not even log in when update to the latest version.
@fluxor99232 commented on GitHub (Apr 26, 2024):
Same issue for me on every instance I‘ve spun up so far. Using Ubuntu.
@phanan commented on GitHub (Apr 26, 2024):
Please supply the error.
On Fri, Apr 26, 2024 at 23:41 fluxor99232 @.***> wrote:
@fluxor99232 commented on GitHub (May 6, 2024):
This is the error message I get when running “docker logs koel”:
@phanan commented on GitHub (May 6, 2024):
Please check storage/logs/laravel.log
On Mon, May 6, 2024 at 18:01 fluxor99232 @.***> wrote:
@fluxor99232 commented on GitHub (May 6, 2024):
I seem to get loads of these exceptions:
[2024-05-06 11:11:10] production.ERROR: Failed attempt {"error":"[object] (Intervention\\Image\\Exception\\NotWritableException(code: 0): Can't write image data to path (/var/www/html/public/img/covers/2a7389e08d10c1c781e21ce1f18f281551a0485a.jpeg) at /var/www/html/vendor/intervention/image/src/Intervention/Image/Image.php:150) [stacktrace] #0 /var/www/html/app/Services/ImageWriter.php(38): Intervention\\Image\\Image->save() #1 /var/www/html/app/Services/MediaMetadataService.php(38): App\\Services\\ImageWriter->write() #2 /var/www/html/app/Helpers.php(50): App\\Services\\MediaMetadataService->App\\Services\\{closure}() #3 /var/www/html/app/Services/MediaMetadataService.php(46): attempt() #4 /var/www/html/app/Services/FileSynchronizer.php(119): App\\Services\\MediaMetadataService->writeAlbumCover() #5 /var/www/html/app/Helpers.php(50): App\\Services\\FileSynchronizer->App\\Services\\{closure}() #6 /var/www/html/app/Services/FileSynchronizer.php(131): attempt() #7 /var/www/html/app/Services/FileSynchronizer.php(94): App\\Services\\FileSynchronizer->tryGenerateAlbumCover() #8 /var/www/html/app/Services/MediaSyncService.php(54): App\\Services\\FileSynchronizer->sync() #9 /var/www/html/app/Http/Controllers/API/SettingController.php(22): App\\Services\\MediaSyncService->sync() #10 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\API\\SettingController->update() #11 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #12 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #14 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #15 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /var/www/html/app/Http/Middleware/Authenticate.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Authenticate->handle() #18 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #20 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(62): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #22 /var/www/html/app/Http/Middleware/ThrottleRequests.php(14): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #23 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ThrottleRequests->handle() #24 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #26 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #27 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #28 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #29 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch() #30 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #31 /var/www/html/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ForceHttps->handle() #33 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #34 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #35 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #36 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #38 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #40 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then() #42 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #43 /var/www/html/public/index.php(57): Illuminate\\Foundation\\Http\\Kernel->handle() #44 {main} "}@phanan commented on GitHub (May 6, 2024):
Looks like you're running into some permission issue per the log.
@fluxor99232 commented on GitHub (May 6, 2024):
Which permissions does Koel expect? Haven't had any permission issues with my other docker containers so far.
@phanan commented on GitHub (May 6, 2024):
Please check if your PHP is allowed to write there and the path
/var/www/html/public/img/coversexists.@fluxor99232 commented on GitHub (May 6, 2024):
Not quite sure what I did wrong. All the folders in the compose file exist and were created by the Koel container itself when initializing the container.
@phanan commented on GitHub (May 6, 2024):
To be fair I'm not 100% sure if this error is related to what you reported originally. Creating a smart playlist doesn't involve writing any images. Can you try creating a smart playlist again and see what the relevant error is?
@fluxor99232 commented on GitHub (May 6, 2024):
I have similar issues for search and creating any kind of playlist, e.g.:
[2024-05-06 12:50:03] production.ERROR: Failed attempt {"error":"[object] (PDOException(code: 14): SQLSTATE[HY000] [14] unable to open database file at /var/www/html/vendor/teamtnt/tntsearch/src/Indexer/TNTIndexer.php:178) [stacktrace] #0 /var/www/html/vendor/teamtnt/tntsearch/src/Indexer/TNTIndexer.php(178): PDO->__construct() #1 /var/www/html/vendor/teamtnt/tntsearch/src/TNTSearch.php(68): TeamTNT\\TNTSearch\\Indexer\\TNTIndexer->createIndex() #2 /var/www/html/vendor/teamtnt/laravel-scout-tntsearch-driver/src/Engines/TNTSearchEngine.php(321): TeamTNT\\TNTSearch\\TNTSearch->createIndex() #3 /var/www/html/vendor/teamtnt/laravel-scout-tntsearch-driver/src/Engines/TNTSearchEngine.php(55): TeamTNT\\Scout\\Engines\\TNTSearchEngine->initIndex() #4 /var/www/html/vendor/laravel/scout/src/Searchable.php(62): TeamTNT\\Scout\\Engines\\TNTSearchEngine->update() #5 /var/www/html/vendor/laravel/scout/src/Searchable.php(41): App\\Models\\Artist->queueMakeSearchable() #6 /var/www/html/vendor/laravel/framework/src/Illuminate/Macroable/Traits/Macroable.php(124): Illuminate\\Database\\Eloquent\\Collection->Laravel\\Scout\\{closure}() #7 /var/www/html/vendor/laravel/scout/src/Searchable.php(169): Illuminate\\Support\\Collection->__call() #8 /var/www/html/vendor/laravel/scout/src/ModelObserver.php(109): App\\Models\\Album->searchable() #9 /var/www/html/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(441): Laravel\\Scout\\ModelObserver->saved() #10 /var/www/html/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\\Events\\Dispatcher->Illuminate\\Events\\{closure}() #11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasEvents.php(189): Illuminate\\Events\\Dispatcher->dispatch() #12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1177): Illuminate\\Database\\Eloquent\\Model->fireModelEvent() #13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1150): Illuminate\\Database\\Eloquent\\Model->finishSave() #14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(991): Illuminate\\Database\\Eloquent\\Model->save() #15 /var/www/html/app/Services/MediaMetadataService.php(44): Illuminate\\Database\\Eloquent\\Model->update() #16 /var/www/html/app/Helpers.php(50): App\\Services\\MediaMetadataService->App\\Services\\{closure}() #17 /var/www/html/app/Services/MediaMetadataService.php(46): attempt() #18 /var/www/html/app/Services/FileSynchronizer.php(119): App\\Services\\MediaMetadataService->writeAlbumCover() #19 /var/www/html/app/Helpers.php(50): App\\Services\\FileSynchronizer->App\\Services\\{closure}() #20 /var/www/html/app/Services/FileSynchronizer.php(131): attempt() #21 /var/www/html/app/Services/FileSynchronizer.php(94): App\\Services\\FileSynchronizer->tryGenerateAlbumCover() #22 /var/www/html/app/Services/MediaSyncService.php(54): App\\Services\\FileSynchronizer->sync() #23 /var/www/html/app/Http/Controllers/API/SettingController.php(22): App\\Services\\MediaSyncService->sync() #24 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\API\\SettingController->update() #25 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #26 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #27 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #28 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #29 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #30 /var/www/html/app/Http/Middleware/Authenticate.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #31 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Authenticate->handle() #32 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #34 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(62): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #36 /var/www/html/app/Http/Middleware/ThrottleRequests.php(14): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #37 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ThrottleRequests->handle() #38 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #40 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #41 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #42 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #43 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch() #44 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #45 /var/www/html/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ForceHttps->handle() #47 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #49 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #50 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #51 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #52 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #53 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #54 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #55 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then() #56 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #57 /var/www/html/public/index.php(57): Illuminate\\Foundation\\Http\\Kernel->handle() #58 {main} "}@phanan commented on GitHub (May 6, 2024):
Yeah, you have a permission issue there somehow.
@fluxor99232 commented on GitHub (May 6, 2024):
I've been able to resolve all issues by wiping my koel containers and directories and running the following commands on the parent directory of my db and covers directories:
sudo chown -R www-data koelsudo chmod -R 775 koelNot sure if this will cause other problems in the long run. I suspect the permissions issue to stem from the dockerfile, but I'm no expert on this.
@phanan commented on GitHub (May 6, 2024):
You might very well be right, but currently I'm too busy to debug Docker stuff (and I'm no Docker expert, either). Either way: Great that you solved the issue! Thanks for the patience, and enjoy Koel!
@L3v3L commented on GitHub (May 17, 2024):
@phanan this issue was closed but the initial issue still occurs, the uuid is cut wrong here:
github.com/koel/koel@44345753fa/resources/assets/js/utils/crypto.ts (L11)the length of
window.URL.createObjectURL(new Blob([]))can vary leading to the wrong uuid being produced.maybe better solution:
window.URL.createObjectURL(new Blob([])).split('/').pop()