starred/koel-koel
1
0
Fork 0
mirror of https://github.com/koel/koel.git synced 2026-04-25 16:56:02 +03:00
Code Issues 67 Projects Releases 10 Packages Wiki Activity

[GH-ISSUE #1475] Request failed with status code 500 on WebUI #838

New issue
Closed
opened 2026-02-26 02:34:25 +03:00 by kerem · 3 comments
kerem commented 2026-02-26 02:34:25 +03:00
Owner
Copy link

Originally created by @kazukyakayashi on GitHub (Aug 9, 2022).
Original GitHub issue: https://github.com/koel/koel/issues/1475

Describe the bug

Some pages return a 500 error (see screenshot)

Firefox Console return error for :

  • GET https://meowzik.zarchbox.fr/api/overview,
  • GET https://meowzik.zarchbox.fr/api/albums?page=1
  • GET https://meowzik.zarchbox.fr/api/artists?page=1

No problem with other pages

In laravel.log

[2022-08-09 09:45:09] production.ERROR: SQLSTATE[42704]: Undefined object: 7 ERROR:  type "unsigned" does not exist
LINE 1: ..."artists".*, CAST(SUM(interactions.play_count) AS UNSIGNED) ...
                                                             ^ (SQL: select "artists".*, CAST(SUM(interactions.play_count) AS UNSIGNED) AS play_count, COUNT(DISTINCT songs.album_id) AS album_count, (select count(*) from "songs" where "artists"."id" = "songs"."artist_id") as "song_count", (select sum("songs"."length") from "songs" where "artists"."id" = "songs"."artist_id") as "length" from "artists" left join "songs" on "artists"."id" = "songs"."artist_id" left join "interactions" on "interactions"."song_id" = "songs"."id" and "interactions"."user_id" = 1 where "artists"."id" not in (1, 2) group by "artists"."id" order by "artists"."name" asc limit 22 offset 0) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42704): SQLSTATE[42704]: Undefined object: 7 ERROR:  type \"unsigned\" does not exist
LINE 1: ...\"artists\".*, CAST(SUM(interactions.play_count) AS UNSIGNED) ...
                                                             ^ (SQL: select \"artists\".*, CAST(SUM(interactions.play_count) AS UNSIGNED) AS play_count, COUNT(DISTINCT songs.album_id) AS album_count, (select count(*) from \"songs\" where \"artists\".\"id\" = \"songs\".\"artist_id\") as \"song_count\", (select sum(\"songs\".\"length\") from \"songs\" where \"artists\".\"id\" = \"songs\".\"artist_id\") as \"length\" from \"artists\" left join \"songs\" on \"artists\".\"id\" = \"songs\".\"artist_id\" left join \"interactions\" on \"interactions\".\"song_id\" = \"songs\".\"id\" and \"interactions\".\"user_id\" = 1 where \"artists\".\"id\" not in (1, 2) group by \"artists\".\"id\" order by \"artists\".\"name\" asc limit 22 offset 0) at /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:759)
[stacktrace]
#0 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719): Illuminate\\Database\\Connection->runQueryCallback()
#1 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\\Database\\Connection->run()
#2 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2630): Illuminate\\Database\\Connection->select()
#3 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2618): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3154): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(698): Illuminate\\Database\\Query\\Builder->get()
#7 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(682): Illuminate\\Database\\Eloquent\\Builder->getModels()
#8 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(916): Illuminate\\Database\\Eloquent\\Builder->get()
#9 /home/debian/koel/app/Http/Controllers/V6/API/ArtistController.php(24): Illuminate\\Database\\Eloquent\\Builder->simplePaginate()
#10 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\V6\\API\\ArtistController->index()
#11 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#12 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(261): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#13 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(204): Illuminate\\Routing\\Route->runController()
#14 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(725): Illuminate\\Routing\\Route->run()
#15 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#16 /home/debian/koel/app/Http/Middleware/Authenticate.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#17 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Authenticate->handle()
#18 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#19 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#20 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#21 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(62): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest()
#22 /home/debian/koel/app/Http/Middleware/ThrottleRequests.php(14): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle()
#23 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ThrottleRequests->handle()
#24 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#25 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(726): Illuminate\\Pipeline\\Pipeline->then()
#26 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(703): Illuminate\\Routing\\Router->runRouteWithinStack()
#27 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(667): Illuminate\\Routing\\Router->runRoute()
#28 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(656): Illuminate\\Routing\\Router->dispatchToRoute()
#29 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(167): Illuminate\\Routing\\Router->dispatch()
#30 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()#31 /home/debian/koel/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ForceHttps->handle()
#33 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#35 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#36 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#37 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#38 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#39 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#40 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then()
#42 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#43 /home/debian/koel/public/index.php(57): Illuminate\\Foundation\\Http\\Kernel->handle()
#44 {main}

[previous exception] [object] (PDOException(code: 42704): SQLSTATE[42704]: Undefined object: 7 ERROR:  type \"unsigned\" does not exist
LINE 1: ...\"artists\".*, CAST(SUM(interactions.play_count) AS UNSIGNED) ...
                                                             ^ at /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:418)
[stacktrace]
#0 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(418): PDOStatement->execute()
#1 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(752): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719): Illuminate\\Database\\Connection->runQueryCallback()
#3 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\\Database\\Connection->run()
#4 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2630): Illuminate\\Database\\Connection->select()
#5 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2618): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3154): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(698): Illuminate\\Database\\Query\\Builder->get()
#9 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(682): Illuminate\\Database\\Eloquent\\Builder->getModels()
#10 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(916): Illuminate\\Database\\Eloquent\\Builder->get()
#11 /home/debian/koel/app/Http/Controllers/V6/API/ArtistController.php(24): Illuminate\\Database\\Eloquent\\Builder->simplePaginate()
#12 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\V6\\API\\ArtistController->index()
#13 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#14 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(261): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#15 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(204): Illuminate\\Routing\\Route->runController()
#16 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(725): Illuminate\\Routing\\Route->run()
#17 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#18 /home/debian/koel/app/Http/Middleware/Authenticate.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#19 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Authenticate->handle()
#20 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#21 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#22 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#23 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(62): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest()
#24 /home/debian/koel/app/Http/Middleware/ThrottleRequests.php(14): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle()
#25 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ThrottleRequests->handle()
#26 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#27 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(726): Illuminate\\Pipeline\\Pipeline->then()
#28 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(703): Illuminate\\Routing\\Router->runRouteWithinStack()
#29 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(667): Illuminate\\Routing\\Router->runRoute()
#30 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(656): Illuminate\\Routing\\Router->dispatchToRoute()
#31 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(167): Illuminate\\Routing\\Router->dispatch()
#32 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()#33 /home/debian/koel/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ForceHttps->handle()
#35 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#37 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#38 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#39 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#40 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#42 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then()
#44 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#45 /home/debian/koel/public/index.php(57): Illuminate\\Foundation\\Http\\Kernel->handle()
#46 {main}

Screenshots

Firefox Console :
NNMJpyMzMq

Web UI :
firefox_quCaCBjyBH

Environment

  • Koel 6.0.4
  • OS (server): Debian 11
  • Browser Firefox 103.0.1
  • PHP version 8.1
  • Node version 16.16.0
Originally created by @kazukyakayashi on GitHub (Aug 9, 2022). Original GitHub issue: https://github.com/koel/koel/issues/1475 **Describe the bug** Some pages return a 500 error (see screenshot) Firefox Console return error for : - `GET https://meowzik.zarchbox.fr/api/overview`, - `GET https://meowzik.zarchbox.fr/api/albums?page=1` - `GET https://meowzik.zarchbox.fr/api/artists?page=1` No problem with other pages In laravel.log ``` [2022-08-09 09:45:09] production.ERROR: SQLSTATE[42704]: Undefined object: 7 ERROR: type "unsigned" does not exist LINE 1: ..."artists".*, CAST(SUM(interactions.play_count) AS UNSIGNED) ... ^ (SQL: select "artists".*, CAST(SUM(interactions.play_count) AS UNSIGNED) AS play_count, COUNT(DISTINCT songs.album_id) AS album_count, (select count(*) from "songs" where "artists"."id" = "songs"."artist_id") as "song_count", (select sum("songs"."length") from "songs" where "artists"."id" = "songs"."artist_id") as "length" from "artists" left join "songs" on "artists"."id" = "songs"."artist_id" left join "interactions" on "interactions"."song_id" = "songs"."id" and "interactions"."user_id" = 1 where "artists"."id" not in (1, 2) group by "artists"."id" order by "artists"."name" asc limit 22 offset 0) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42704): SQLSTATE[42704]: Undefined object: 7 ERROR: type \"unsigned\" does not exist LINE 1: ...\"artists\".*, CAST(SUM(interactions.play_count) AS UNSIGNED) ... ^ (SQL: select \"artists\".*, CAST(SUM(interactions.play_count) AS UNSIGNED) AS play_count, COUNT(DISTINCT songs.album_id) AS album_count, (select count(*) from \"songs\" where \"artists\".\"id\" = \"songs\".\"artist_id\") as \"song_count\", (select sum(\"songs\".\"length\") from \"songs\" where \"artists\".\"id\" = \"songs\".\"artist_id\") as \"length\" from \"artists\" left join \"songs\" on \"artists\".\"id\" = \"songs\".\"artist_id\" left join \"interactions\" on \"interactions\".\"song_id\" = \"songs\".\"id\" and \"interactions\".\"user_id\" = 1 where \"artists\".\"id\" not in (1, 2) group by \"artists\".\"id\" order by \"artists\".\"name\" asc limit 22 offset 0) at /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:759) [stacktrace] #0 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\\Database\\Connection->run() #2 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2630): Illuminate\\Database\\Connection->select() #3 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2618): Illuminate\\Database\\Query\\Builder->runSelect() #4 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3154): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\\Database\\Query\\Builder->onceWithColumns() #6 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(698): Illuminate\\Database\\Query\\Builder->get() #7 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(682): Illuminate\\Database\\Eloquent\\Builder->getModels() #8 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(916): Illuminate\\Database\\Eloquent\\Builder->get() #9 /home/debian/koel/app/Http/Controllers/V6/API/ArtistController.php(24): Illuminate\\Database\\Eloquent\\Builder->simplePaginate() #10 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\V6\\API\\ArtistController->index() #11 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction() #12 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(261): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(204): Illuminate\\Routing\\Route->runController() #14 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(725): Illuminate\\Routing\\Route->run() #15 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /home/debian/koel/app/Http/Middleware/Authenticate.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Authenticate->handle() #18 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #20 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(62): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #22 /home/debian/koel/app/Http/Middleware/ThrottleRequests.php(14): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #23 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ThrottleRequests->handle() #24 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(726): Illuminate\\Pipeline\\Pipeline->then() #26 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(703): Illuminate\\Routing\\Router->runRouteWithinStack() #27 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(667): Illuminate\\Routing\\Router->runRoute() #28 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(656): Illuminate\\Routing\\Router->dispatchToRoute() #29 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(167): Illuminate\\Routing\\Router->dispatch() #30 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()#31 /home/debian/koel/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ForceHttps->handle() #33 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #34 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #35 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #36 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #38 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #40 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then() #42 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #43 /home/debian/koel/public/index.php(57): Illuminate\\Foundation\\Http\\Kernel->handle() #44 {main} [previous exception] [object] (PDOException(code: 42704): SQLSTATE[42704]: Undefined object: 7 ERROR: type \"unsigned\" does not exist LINE 1: ...\"artists\".*, CAST(SUM(interactions.play_count) AS UNSIGNED) ... ^ at /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:418) [stacktrace] #0 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(418): PDOStatement->execute() #1 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(752): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719): Illuminate\\Database\\Connection->runQueryCallback() #3 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\\Database\\Connection->run() #4 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2630): Illuminate\\Database\\Connection->select() #5 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2618): Illuminate\\Database\\Query\\Builder->runSelect() #6 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3154): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\\Database\\Query\\Builder->onceWithColumns() #8 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(698): Illuminate\\Database\\Query\\Builder->get() #9 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(682): Illuminate\\Database\\Eloquent\\Builder->getModels() #10 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(916): Illuminate\\Database\\Eloquent\\Builder->get() #11 /home/debian/koel/app/Http/Controllers/V6/API/ArtistController.php(24): Illuminate\\Database\\Eloquent\\Builder->simplePaginate() #12 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\V6\\API\\ArtistController->index() #13 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction() #14 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(261): Illuminate\\Routing\\ControllerDispatcher->dispatch() #15 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(204): Illuminate\\Routing\\Route->runController() #16 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(725): Illuminate\\Routing\\Route->run() #17 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #18 /home/debian/koel/app/Http/Middleware/Authenticate.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Authenticate->handle() #20 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(62): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #24 /home/debian/koel/app/Http/Middleware/ThrottleRequests.php(14): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #25 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ThrottleRequests->handle() #26 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #27 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(726): Illuminate\\Pipeline\\Pipeline->then() #28 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(703): Illuminate\\Routing\\Router->runRouteWithinStack() #29 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(667): Illuminate\\Routing\\Router->runRoute() #30 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(656): Illuminate\\Routing\\Router->dispatchToRoute() #31 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(167): Illuminate\\Routing\\Router->dispatch() #32 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()#33 /home/debian/koel/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #34 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\ForceHttps->handle() #35 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #37 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #38 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #40 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #42 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then() #44 /home/debian/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #45 /home/debian/koel/public/index.php(57): Illuminate\\Foundation\\Http\\Kernel->handle() #46 {main} ``` **Screenshots** Firefox Console : ![NNMJpyMzMq](https://user-images.githubusercontent.com/39823221/183594407-9ab20bed-5396-4eb8-a500-0883dc9ad028.png) Web UI : ![firefox_quCaCBjyBH](https://user-images.githubusercontent.com/39823221/183592306-0318ecaa-f865-4a5a-b18f-b1a2cc3f169b.gif) **Environment** - Koel 6.0.4 - OS (server): Debian 11 - Browser Firefox 103.0.1 - PHP version 8.1 - Node version 16.16.0
kerem closed this issue 2026-02-26 02:34:25 +03:00
kerem commented 2026-02-26 02:34:25 +03:00
Author
Owner
Copy link

@phanan commented on GitHub (Aug 10, 2022):

What's your DB and version?

<!-- gh-comment-id:1210201394 --> @phanan commented on GitHub (Aug 10, 2022): What's your DB and version?
kerem commented 2026-02-26 02:34:25 +03:00
Author
Owner
Copy link

@phanan commented on GitHub (Aug 10, 2022):

If you're using PostgesQL, can you try changing UNSIGNED to INTEGER in both Album.php and Artist.php and see if that works? If positive, I'll issue a fix accodingly.

<!-- gh-comment-id:1210215290 --> @phanan commented on GitHub (Aug 10, 2022): If you're using PostgesQL, can you try changing `UNSIGNED` to `INTEGER` in both `Album.php` and `Artist.php` and see if that works? If positive, I'll issue a fix accodingly.
kerem commented 2026-02-26 02:34:25 +03:00
Author
Owner
Copy link

@phanan commented on GitHub (Aug 11, 2022):

Should be fixed in v6.0.5.

<!-- gh-comment-id:1211578635 --> @phanan commented on GitHub (Aug 11, 2022): Should be fixed in v6.0.5.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
dependabot/composer/phpunit/phpunit-12.5.22
dependabot/npm_and_yarn/dompurify-3.4.0
dependabot/npm_and_yarn/vite-plus-0.1.17
dependabot/composer/phpseclib/phpseclib-3.0.51
release
1889-duplicate-upload-detection
test/home-screen-empty-to-content
fix/exclude-songless-albums-from-recently-added
refactor/laravel-prompts
fix/wma-cover-art-exception
fix/remove-redundant-seed-step
chore/upgrade-laravel-13
chore/upgrade-vue-3.5.29
test/phase-7-components
dbg-2142
demo-fix
debug-mysql
trusthosts
seek
fix-equalizer
sentry
invite-user
remove-v6-obsolete
fix/song-list
feat/paths-filter
fix/home
fix/footer
feat/progressive
php81
dev/public-playlists
cy
feat/l7
dependabot/composer/pusher/pusher-php-server-4.1.4
dependabot/composer/laravel/framework-5.8.38
dependabot/composer/jackiedo/dotenv-editor-1.1.1
renovate/pin-dependencies
actions
api-doc
feat/recently-played
fix-tests
fix-cover-page
upload
stylejs-196
compilation
vuex
android-notif
nojquery
demo
vue2
2.0
1.1
v9.1.1
latest
v9.1.0
v9.0.0
v8.3.1
v8.3.0
v8.2.0
v8.1.0
v8.0.0
v7.15.1
v7.15.0
v7.14.0
v7.13.0
v7.12.0
v7.11.0
v7.10.4
v7.10.3
v7.10.2
v7.10.1
v7.10.0
v7.9.0
v7.8.1
v7.8.0
v7.7.1
v7.7.0
v7.6.3
v7.6.2
v7.6.1
v7.6.0
v7.5.2
v7.5.1
v7.5.0
v7.4.2
v7.4.1
v7.4.0
v7.3.1
v7.3.0
v7.2.2
v7.2.1
v7.2.0
v7.1.0
v7.0.12
v7.0.11
v7.0.10
v7.0.9
v7.0.8
v7.0.7
v7.0.6
v7.0.5
v7.0.4
v7.0.3
v7.0.2
v7.0.1
v7.0.0
v6.12.1
v6.12.0
v6.11.5
v6.11.4
v6.11.3
v6.11.2
v6.11.1
v6.11.0
v6.10.0
v6.9.0
v6.8.5
v6.8.4
v6.8.3
v6.8.2
v6.8.1
v6.8.0
v6.7.5
v6.7.4
v6.7.3
v6.7.2
v6.7.1
v6.7.0
v6.6.0
v6.5.3
v6.5.2
v6.5.1
v6.5.0
v6.4.3
v6.4.2
v6.4.1
v6.4.0
v6.3.0
v6.2.2
v6.2.1
v6.2.0
v6.1.0
v6.0.6
v6.0.5
v6.0.4
v6.0.3
v6.0.2
v6.0.1
v6.0.0
v0.0.0-beta
v5.1.14
v5.1.13
v5.1.12
v5.1.11
v5.1.10
v5.1.9
v5.1.8
v5.1.7
v5.1.6
v5.1.5
v5.1.4
v5.1.3
v5.1.2
v5.1.1
v5.1.0
v5.0.2
v5.0.1
v5.0.0
v4.4.0
v4.3.1
v4.3.0
v4.2.2
v4.2.1
v4.2.0
v4.1.1
v4.1.0
v4.0.0
v3.7.2
v3.7.1
v3.7.0
v3.6.2
v3.6.1
v3.6.0
v3.5.5
v3.5.4
v3.5.3
v3.5.2
v3.5.1
v3.5.0
v3.4.1
v3.4.0
v3.3.1
v3.3.0
v3.2.0
v3.1.1
v3.1.0
v3.0.1
v3.0.0
v2.2.1
v2.2.0
v2.1.0
v2.0.2
v2.0.1
v2.0.0
v1.1.2
v1.1.1
1.0.0-beta
Labels
Clear 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

Mirrored from GitHub Pull Request

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
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/koel-koel#838
No description provided.