[GH-ISSUE #2019] [Bug]: playlist_user not created by setup #1065

Open
opened 2026-02-26 02:35:08 +03:00 by kerem · 9 comments
Owner

Originally created by @basteyy on GitHub (Jul 12, 2025).
Original GitHub issue: https://github.com/koel/koel/issues/2019

Originally assigned to: @phanan on GitHub.

Read the Troubleshooting guide.

  • I have read and followed the Troubleshooting guide

Reproduction steps

  1. Install koel (from pre build or custom build)
  2. Run php artisan koel:init --no-assets
  3. Try to login with default login data
Image

Expected behavior

All tables created correctly.

Actual behavior

Login failed, error message is shown:

`Table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner)`

Logs

 % cat storage/logs/laravel.log
[2025-07-12 20:27:46] production.ERROR: PDOException: SQLSTATE[HY000] [1698] Access denied for user 'forge'@'localhost' in /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:66
Stack trace:
#0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(66): PDO->__construct()
#1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(44): Illuminate\Database\Connectors\Connector->createPdoConnection()
#2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
#3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(185): Illuminate\Database\Connectors\MySqlConnector->connect()
#4 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1231): call_user_func()
#6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(512): Illuminate\Database\Connection->getPdo()
#7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): Illuminate\Database\Connection->getPdoForSelect()
#8 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#9 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#10 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run()
#11 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(385): Illuminate\Database\Connection->select()
#12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(58): Illuminate\Database\Connection->selectFromWriteConnection()
#13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\MySqlBuilder->getTables()
#14 /var/www/virtual/basteyy/example.org/app/Console/Commands/InitCommand.php(234): Illuminate\Support\Facades\Facade::__callStatic()
#15 /var/www/virtual/basteyy/example.org/app/Console/Commands/InitCommand.php(55): App\Console\Commands\InitCommand->maybeSetUpDatabase()
#16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle()
#17 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#19 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call()
#21 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#22 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#24 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#25 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#26 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\Foundation\Console\Kernel->handle()
#29 /var/www/virtual/basteyy/example.org/artisan(16): Illuminate\Foundation\Application->handleCommand()
#30 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000] [1698] Access denied for user 'forge'@'localhost' (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'forge' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name) in /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
Stack trace:
#0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run()
#2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(385): Illuminate\Database\Connection->select()
#3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(58): Illuminate\Database\Connection->selectFromWriteConnection()
#4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\MySqlBuilder->getTables()
#5 /var/www/virtual/basteyy/example.org/app/Console/Commands/InitCommand.php(234): Illuminate\Support\Facades\Facade::__callStatic()
#6 /var/www/virtual/basteyy/example.org/app/Console/Commands/InitCommand.php(55): App\Console\Commands\InitCommand->maybeSetUpDatabase()
#7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle()
#8 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#9 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#10 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#11 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call()
#12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#13 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#15 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#16 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#17 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#19 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\Foundation\Console\Kernel->handle()
#20 /var/www/virtual/basteyy/example.org/artisan(16): Illuminate\Foundation\Application->handleCommand()
#21 {main}
[2025-07-12 20:31:13] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) at /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
[stacktrace]
#0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run()
#2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select()
#3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(811): Illuminate\\Database\\Query\\Builder->get()
#7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(887): Illuminate\\Database\\Eloquent\\Builder->getModels()
#8 /var/www/virtual/basteyy/example.org/app/Repositories/PlaylistRepository.php(21): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get()
#9 /var/www/virtual/basteyy/example.org/app/Http/Controllers/API/FetchInitialDataController.php(43): App\\Repositories\\PlaylistRepository->getAllAccessibleByUser()
#10 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(47): App\\Http\\Controllers\\API\\FetchInitialDataController->__invoke()
#11 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\Route->runController()
#13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\\Routing\\Route->run()
#14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#15 /var/www/virtual/basteyy/example.org/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\ForceHttps->handle()
#17 /var/www/virtual/basteyy/example.org/app/Http/Middleware/HandleDemoMode.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\HandleDemoMode->handle()
#19 /var/www/virtual/basteyy/example.org/app/Http/Middleware/RestrictPlusFeatures.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\RestrictPlusFeatures->handle()
#21 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#25 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then()
#27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\\Routing\\Router->runRouteWithinStack()
#28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\\Routing\\Router->runRoute()
#29 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\\Routing\\Router->dispatchToRoute()
#30 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\\Routing\\Router->dispatch()
#31 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#32 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#34 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#35 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#37 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#38 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#39 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\ValidatePostSize->handle()
#40 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#42 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\HandleCors->handle()
#44 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#46 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle()
#48 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Pipeline\\Pipeline->then()
#50 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#51 /var/www/virtual/basteyy/example.org/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#52 {main}

[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist at /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407)
[stacktrace]
#0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): PDO->prepare()
#1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run()
#4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select()
#5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(811): Illuminate\\Database\\Query\\Builder->get()
#9 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(887): Illuminate\\Database\\Eloquent\\Builder->getModels()
#10 /var/www/virtual/basteyy/example.org/app/Repositories/PlaylistRepository.php(21): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get()
#11 /var/www/virtual/basteyy/example.org/app/Http/Controllers/API/FetchInitialDataController.php(43): App\\Repositories\\PlaylistRepository->getAllAccessibleByUser()
#12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(47): App\\Http\\Controllers\\API\\FetchInitialDataController->__invoke()
#13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\Route->runController()
#15 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\\Routing\\Route->run()
#16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#17 /var/www/virtual/basteyy/example.org/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\ForceHttps->handle()
#19 /var/www/virtual/basteyy/example.org/app/Http/Middleware/HandleDemoMode.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\HandleDemoMode->handle()
#21 /var/www/virtual/basteyy/example.org/app/Http/Middleware/RestrictPlusFeatures.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\RestrictPlusFeatures->handle()
#23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#25 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then()
#29 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\\Routing\\Router->runRouteWithinStack()
#30 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\\Routing\\Router->runRoute()
#31 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\\Routing\\Router->dispatchToRoute()
#32 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\\Routing\\Router->dispatch()
#33 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#34 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#36 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#37 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#39 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#40 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\ValidatePostSize->handle()
#42 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#44 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\HandleCors->handle()
#46 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#48 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle()
#50 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Pipeline\\Pipeline->then()
#52 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#53 /var/www/virtual/basteyy/example.org/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#54 {main}
"}
[2025-07-12 20:31:14] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) at /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
[stacktrace]
#0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run()
#2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select()
#3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(811): Illuminate\\Database\\Query\\Builder->get()
#7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(887): Illuminate\\Database\\Eloquent\\Builder->getModels()
#8 /var/www/virtual/basteyy/example.org/app/Repositories/PlaylistRepository.php(21): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get()
#9 /var/www/virtual/basteyy/example.org/app/Http/Controllers/API/FetchInitialDataController.php(43): App\\Repositories\\PlaylistRepository->getAllAccessibleByUser()
#10 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(47): App\\Http\\Controllers\\API\\FetchInitialDataController->__invoke()
#11 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\Route->runController()
#13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\\Routing\\Route->run()
#14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#15 /var/www/virtual/basteyy/example.org/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\ForceHttps->handle()
#17 /var/www/virtual/basteyy/example.org/app/Http/Middleware/HandleDemoMode.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\HandleDemoMode->handle()
#19 /var/www/virtual/basteyy/example.org/app/Http/Middleware/RestrictPlusFeatures.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\RestrictPlusFeatures->handle()
#21 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#25 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then()
#27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\\Routing\\Router->runRouteWithinStack()
#28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\\Routing\\Router->runRoute()
#29 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\\Routing\\Router->dispatchToRoute()
#30 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\\Routing\\Router->dispatch()
#31 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#32 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#34 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#35 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#37 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#38 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#39 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\ValidatePostSize->handle()
#40 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#42 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\HandleCors->handle()
#44 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#46 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle()
#48 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Pipeline\\Pipeline->then()
#50 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#51 /var/www/virtual/basteyy/example.org/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#52 {main}

[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist at /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407)
[stacktrace]
#0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): PDO->prepare()
#1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run()
#4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select()
#5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(811): Illuminate\\Database\\Query\\Builder->get()
#9 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(887): Illuminate\\Database\\Eloquent\\Builder->getModels()
#10 /var/www/virtual/basteyy/example.org/app/Repositories/PlaylistRepository.php(21): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get()
#11 /var/www/virtual/basteyy/example.org/app/Http/Controllers/API/FetchInitialDataController.php(43): App\\Repositories\\PlaylistRepository->getAllAccessibleByUser()
#12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(47): App\\Http\\Controllers\\API\\FetchInitialDataController->__invoke()
#13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\Route->runController()
#15 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\\Routing\\Route->run()
#16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#17 /var/www/virtual/basteyy/example.org/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\ForceHttps->handle()
#19 /var/www/virtual/basteyy/example.org/app/Http/Middleware/HandleDemoMode.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\HandleDemoMode->handle()
#21 /var/www/virtual/basteyy/example.org/app/Http/Middleware/RestrictPlusFeatures.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\RestrictPlusFeatures->handle()
#23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#25 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then()
#29 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\\Routing\\Router->runRouteWithinStack()
#30 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\\Routing\\Router->runRoute()
#31 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\\Routing\\Router->dispatchToRoute()
#32 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\\Routing\\Router->dispatch()
#33 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#34 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#36 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#37 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#39 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#40 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\ValidatePostSize->handle()
#42 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#44 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\HandleCors->handle()
#46 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#48 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle()
#50 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Pipeline\\Pipeline->then()
#52 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#53 /var/www/virtual/basteyy/example.org/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#54 {main}
"}
[2025-07-12 20:32:40] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) at /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
[stacktrace]
#0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run()
#2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select()
#3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(811): Illuminate\\Database\\Query\\Builder->get()
#7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(887): Illuminate\\Database\\Eloquent\\Builder->getModels()
#8 /var/www/virtual/basteyy/example.org/app/Repositories/PlaylistRepository.php(21): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get()
#9 /var/www/virtual/basteyy/example.org/app/Http/Controllers/API/FetchInitialDataController.php(43): App\\Repositories\\PlaylistRepository->getAllAccessibleByUser()
#10 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(47): App\\Http\\Controllers\\API\\FetchInitialDataController->__invoke()
#11 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\Route->runController()
#13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\\Routing\\Route->run()
#14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#15 /var/www/virtual/basteyy/example.org/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\ForceHttps->handle()
#17 /var/www/virtual/basteyy/example.org/app/Http/Middleware/HandleDemoMode.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\HandleDemoMode->handle()
#19 /var/www/virtual/basteyy/example.org/app/Http/Middleware/RestrictPlusFeatures.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\RestrictPlusFeatures->handle()
#21 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#25 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then()
#27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\\Routing\\Router->runRouteWithinStack()
#28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\\Routing\\Router->runRoute()
#29 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\\Routing\\Router->dispatchToRoute()
#30 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\\Routing\\Router->dispatch()
#31 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#32 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#34 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#35 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#37 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#38 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#39 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\ValidatePostSize->handle()
#40 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#42 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\HandleCors->handle()
#44 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#46 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle()
#48 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Pipeline\\Pipeline->then()
#50 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#51 /var/www/virtual/basteyy/example.org/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#52 {main}

Koel version

7.10.2

How did you install Koel?

Pre-compiled tar/zip archive

Additional information

  • Server OS: Ubuntu 24.04
  • PHP version: 8.4
  • Database: 0.11.13-MariaDB-0ubuntu0.24.04.1-log - Ubuntu 24.04
Originally created by @basteyy on GitHub (Jul 12, 2025). Original GitHub issue: https://github.com/koel/koel/issues/2019 Originally assigned to: @phanan on GitHub. ### Read the Troubleshooting guide. - [x] I have read and followed the Troubleshooting guide ### Reproduction steps 1. Install koel (from pre build or custom build) 2. Run `php artisan koel:init --no-assets` 3. Try to login with default login data <img width="1920" height="891" alt="Image" src="https://github.com/user-attachments/assets/bd9a0a6d-0a67-44e2-bf13-f3c678632fac" /> ### Expected behavior All tables created correctly. ### Actual behavior Login failed, error message is shown: ``` `Table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner)` ``` ### Logs ``` % cat storage/logs/laravel.log [2025-07-12 20:27:46] production.ERROR: PDOException: SQLSTATE[HY000] [1698] Access denied for user 'forge'@'localhost' in /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:66 Stack trace: #0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(66): PDO->__construct() #1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(44): Illuminate\Database\Connectors\Connector->createPdoConnection() #2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection() #3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(185): Illuminate\Database\Connectors\MySqlConnector->connect() #4 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}() #5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1231): call_user_func() #6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(512): Illuminate\Database\Connection->getPdo() #7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): Illuminate\Database\Connection->getPdoForSelect() #8 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database\{closure}() #9 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback() #10 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run() #11 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(385): Illuminate\Database\Connection->select() #12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(58): Illuminate\Database\Connection->selectFromWriteConnection() #13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\MySqlBuilder->getTables() #14 /var/www/virtual/basteyy/example.org/app/Console/Commands/InitCommand.php(234): Illuminate\Support\Facades\Facade::__callStatic() #15 /var/www/virtual/basteyy/example.org/app/Console/Commands/InitCommand.php(55): App\Console\Commands\InitCommand->maybeSetUpDatabase() #16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle() #17 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure() #19 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod() #20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call() #21 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call() #22 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute() #23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run() #24 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run() #25 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand() #26 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun() #27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run() #28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\Foundation\Console\Kernel->handle() #29 /var/www/virtual/basteyy/example.org/artisan(16): Illuminate\Foundation\Application->handleCommand() #30 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000] [1698] Access denied for user 'forge'@'localhost' (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'forge' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name) in /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825 Stack trace: #0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run() #2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(385): Illuminate\Database\Connection->select() #3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(58): Illuminate\Database\Connection->selectFromWriteConnection() #4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\MySqlBuilder->getTables() #5 /var/www/virtual/basteyy/example.org/app/Console/Commands/InitCommand.php(234): Illuminate\Support\Facades\Facade::__callStatic() #6 /var/www/virtual/basteyy/example.org/app/Console/Commands/InitCommand.php(55): App\Console\Commands\InitCommand->maybeSetUpDatabase() #7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle() #8 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #9 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure() #10 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod() #11 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call() #12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call() #13 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute() #14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run() #15 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run() #16 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand() #17 /var/www/virtual/basteyy/example.org/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun() #18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run() #19 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\Foundation\Console\Kernel->handle() #20 /var/www/virtual/basteyy/example.org/artisan(16): Illuminate\Foundation\Application->handleCommand() #21 {main} [2025-07-12 20:31:13] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) at /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825) [stacktrace] #0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run() #2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select() #3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\\Database\\Query\\Builder->runSelect() #4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\\Database\\Query\\Builder->onceWithColumns() #6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(811): Illuminate\\Database\\Query\\Builder->get() #7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(887): Illuminate\\Database\\Eloquent\\Builder->getModels() #8 /var/www/virtual/basteyy/example.org/app/Repositories/PlaylistRepository.php(21): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get() #9 /var/www/virtual/basteyy/example.org/app/Http/Controllers/API/FetchInitialDataController.php(43): App\\Repositories\\PlaylistRepository->getAllAccessibleByUser() #10 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(47): App\\Http\\Controllers\\API\\FetchInitialDataController->__invoke() #11 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\\Routing\\ControllerDispatcher->dispatch() #12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\Route->runController() #13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\\Routing\\Route->run() #14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #15 /var/www/virtual/basteyy/example.org/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\ForceHttps->handle() #17 /var/www/virtual/basteyy/example.org/app/Http/Middleware/HandleDemoMode.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\HandleDemoMode->handle() #19 /var/www/virtual/basteyy/example.org/app/Http/Middleware/RestrictPlusFeatures.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\RestrictPlusFeatures->handle() #21 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Auth\\Middleware\\Authenticate->handle() #25 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then() #27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\\Routing\\Router->runRouteWithinStack() #28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\\Routing\\Router->runRoute() #29 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\\Routing\\Router->dispatchToRoute() #30 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\\Routing\\Router->dispatch() #31 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #32 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #35 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #37 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #38 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #40 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #42 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\HandleCors->handle() #44 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\TrustProxies->handle() #46 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #48 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #49 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Pipeline\\Pipeline->then() #50 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #51 /var/www/virtual/basteyy/example.org/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle() #52 {main} [previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist at /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407) [stacktrace] #0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): PDO->prepare() #1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run() #4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select() #5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\\Database\\Query\\Builder->runSelect() #6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\\Database\\Query\\Builder->onceWithColumns() #8 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(811): Illuminate\\Database\\Query\\Builder->get() #9 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(887): Illuminate\\Database\\Eloquent\\Builder->getModels() #10 /var/www/virtual/basteyy/example.org/app/Repositories/PlaylistRepository.php(21): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get() #11 /var/www/virtual/basteyy/example.org/app/Http/Controllers/API/FetchInitialDataController.php(43): App\\Repositories\\PlaylistRepository->getAllAccessibleByUser() #12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(47): App\\Http\\Controllers\\API\\FetchInitialDataController->__invoke() #13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\\Routing\\ControllerDispatcher->dispatch() #14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\Route->runController() #15 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\\Routing\\Route->run() #16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #17 /var/www/virtual/basteyy/example.org/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\ForceHttps->handle() #19 /var/www/virtual/basteyy/example.org/app/Http/Middleware/HandleDemoMode.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\HandleDemoMode->handle() #21 /var/www/virtual/basteyy/example.org/app/Http/Middleware/RestrictPlusFeatures.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\RestrictPlusFeatures->handle() #23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #25 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Auth\\Middleware\\Authenticate->handle() #27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then() #29 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\\Routing\\Router->runRouteWithinStack() #30 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\\Routing\\Router->runRoute() #31 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\\Routing\\Router->dispatchToRoute() #32 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\\Routing\\Router->dispatch() #33 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #34 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #37 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #39 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #40 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #42 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #44 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\HandleCors->handle() #46 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\TrustProxies->handle() #48 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #49 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #50 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #51 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Pipeline\\Pipeline->then() #52 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #53 /var/www/virtual/basteyy/example.org/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle() #54 {main} "} [2025-07-12 20:31:14] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) at /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825) [stacktrace] #0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run() #2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select() #3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\\Database\\Query\\Builder->runSelect() #4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\\Database\\Query\\Builder->onceWithColumns() #6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(811): Illuminate\\Database\\Query\\Builder->get() #7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(887): Illuminate\\Database\\Eloquent\\Builder->getModels() #8 /var/www/virtual/basteyy/example.org/app/Repositories/PlaylistRepository.php(21): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get() #9 /var/www/virtual/basteyy/example.org/app/Http/Controllers/API/FetchInitialDataController.php(43): App\\Repositories\\PlaylistRepository->getAllAccessibleByUser() #10 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(47): App\\Http\\Controllers\\API\\FetchInitialDataController->__invoke() #11 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\\Routing\\ControllerDispatcher->dispatch() #12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\Route->runController() #13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\\Routing\\Route->run() #14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #15 /var/www/virtual/basteyy/example.org/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\ForceHttps->handle() #17 /var/www/virtual/basteyy/example.org/app/Http/Middleware/HandleDemoMode.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\HandleDemoMode->handle() #19 /var/www/virtual/basteyy/example.org/app/Http/Middleware/RestrictPlusFeatures.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\RestrictPlusFeatures->handle() #21 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Auth\\Middleware\\Authenticate->handle() #25 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then() #27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\\Routing\\Router->runRouteWithinStack() #28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\\Routing\\Router->runRoute() #29 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\\Routing\\Router->dispatchToRoute() #30 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\\Routing\\Router->dispatch() #31 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #32 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #35 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #37 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #38 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #40 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #42 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\HandleCors->handle() #44 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\TrustProxies->handle() #46 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #48 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #49 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Pipeline\\Pipeline->then() #50 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #51 /var/www/virtual/basteyy/example.org/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle() #52 {main} [previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist at /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407) [stacktrace] #0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): PDO->prepare() #1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run() #4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select() #5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\\Database\\Query\\Builder->runSelect() #6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\\Database\\Query\\Builder->onceWithColumns() #8 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(811): Illuminate\\Database\\Query\\Builder->get() #9 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(887): Illuminate\\Database\\Eloquent\\Builder->getModels() #10 /var/www/virtual/basteyy/example.org/app/Repositories/PlaylistRepository.php(21): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get() #11 /var/www/virtual/basteyy/example.org/app/Http/Controllers/API/FetchInitialDataController.php(43): App\\Repositories\\PlaylistRepository->getAllAccessibleByUser() #12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(47): App\\Http\\Controllers\\API\\FetchInitialDataController->__invoke() #13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\\Routing\\ControllerDispatcher->dispatch() #14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\Route->runController() #15 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\\Routing\\Route->run() #16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #17 /var/www/virtual/basteyy/example.org/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\ForceHttps->handle() #19 /var/www/virtual/basteyy/example.org/app/Http/Middleware/HandleDemoMode.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\HandleDemoMode->handle() #21 /var/www/virtual/basteyy/example.org/app/Http/Middleware/RestrictPlusFeatures.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\RestrictPlusFeatures->handle() #23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #25 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Auth\\Middleware\\Authenticate->handle() #27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then() #29 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\\Routing\\Router->runRouteWithinStack() #30 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\\Routing\\Router->runRoute() #31 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\\Routing\\Router->dispatchToRoute() #32 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\\Routing\\Router->dispatch() #33 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #34 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #37 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #39 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #40 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #42 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #44 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\HandleCors->handle() #46 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\TrustProxies->handle() #48 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #49 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #50 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #51 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Pipeline\\Pipeline->then() #52 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #53 /var/www/virtual/basteyy/example.org/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle() #54 {main} "} [2025-07-12 20:32:40] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel_bayteyy.playlist_user' doesn't exist (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner) at /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825) [stacktrace] #0 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run() #2 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select() #3 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\\Database\\Query\\Builder->runSelect() #4 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\\Database\\Query\\Builder->onceWithColumns() #6 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(811): Illuminate\\Database\\Query\\Builder->get() #7 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(887): Illuminate\\Database\\Eloquent\\Builder->getModels() #8 /var/www/virtual/basteyy/example.org/app/Repositories/PlaylistRepository.php(21): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get() #9 /var/www/virtual/basteyy/example.org/app/Http/Controllers/API/FetchInitialDataController.php(43): App\\Repositories\\PlaylistRepository->getAllAccessibleByUser() #10 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(47): App\\Http\\Controllers\\API\\FetchInitialDataController->__invoke() #11 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(266): Illuminate\\Routing\\ControllerDispatcher->dispatch() #12 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\Route->runController() #13 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\\Routing\\Route->run() #14 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #15 /var/www/virtual/basteyy/example.org/app/Http/Middleware/ForceHttps.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #16 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\ForceHttps->handle() #17 /var/www/virtual/basteyy/example.org/app/Http/Middleware/HandleDemoMode.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\HandleDemoMode->handle() #19 /var/www/virtual/basteyy/example.org/app/Http/Middleware/RestrictPlusFeatures.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #20 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): App\\Http\\Middleware\\RestrictPlusFeatures->handle() #21 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #23 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Auth\\Middleware\\Authenticate->handle() #25 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\\Pipeline\\Pipeline->then() #27 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\\Routing\\Router->runRouteWithinStack() #28 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\\Routing\\Router->runRoute() #29 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\\Routing\\Router->dispatchToRoute() #30 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\\Routing\\Router->dispatch() #31 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(170): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #32 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #35 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #37 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #38 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #40 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #42 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\HandleCors->handle() #44 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Http\\Middleware\\TrustProxies->handle() #46 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(209): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #48 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #49 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Pipeline\\Pipeline->then() #50 /var/www/virtual/basteyy/example.org/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #51 /var/www/virtual/basteyy/example.org/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle() #52 {main} ``` ### Koel version 7.10.2 ### How did you install Koel? Pre-compiled tar/zip archive ### Additional information - **Server OS**: Ubuntu 24.04 - **PHP version**: 8.4 - **Database**: 0.11.13-MariaDB-0ubuntu0.24.04.1-log - Ubuntu 24.04
Author
Owner

@basteyy commented on GitHub (Jul 12, 2025):

All other tables created succesfully

Image
<!-- gh-comment-id:3066034371 --> @basteyy commented on GitHub (Jul 12, 2025): All other tables created succesfully <img width="1593" height="830" alt="Image" src="https://github.com/user-attachments/assets/545b6a3a-e2b0-4686-85eb-e51db671bb06" />
Author
Owner

@phanan commented on GitHub (Jul 12, 2025):

I don't know how other tables were created, but your database credentials were wrong, as clearly reported in the log.

<!-- gh-comment-id:3066224293 --> @phanan commented on GitHub (Jul 12, 2025): I don't know how other tables were created, but your database credentials were wrong, as clearly reported in the log.
Author
Owner

@basteyy commented on GitHub (Jul 13, 2025):

The wrong credentials must pre setup attempts. All tables created by the setup routine. Actually I attached the log only, because it was required. When you look into the migrations, you won't find a corresponding for the missing table.

<!-- gh-comment-id:3066694250 --> @basteyy commented on GitHub (Jul 13, 2025): The wrong credentials must pre setup attempts. All tables created by the setup routine. Actually I attached the log only, because it was required. When you look into the migrations, you won't find a corresponding for the missing table.
Author
Owner

@phanan commented on GitHub (Jul 13, 2025):

There is, it's 2025_06_03_121538_modify_playlist-user_relationship.php:

        Schema::table('playlist_collaborators', static function (Blueprint $table): void {
            $table->rename('playlist_user');
        });

Without such table, there's no way the tests have been passing :)

<!-- gh-comment-id:3066708487 --> @phanan commented on GitHub (Jul 13, 2025): There is, it's `2025_06_03_121538_modify_playlist-user_relationship.php`: ```php Schema::table('playlist_collaborators', static function (Blueprint $table): void { $table->rename('playlist_user'); }); ``` Without such table, there's no way the tests have been passing :)
Author
Owner

@basteyy commented on GitHub (Jul 15, 2025):

I see. The table playlist_collaborators was created by the setup successfully. The migration is marked as batched successfully. But obviously, the table was not renamed. I'm not familiar with Laravel and so I have no idea what's wrong with the migration. I can reproduce the failed renaming on different systems.

Can you provide a current dump of the schema?

<!-- gh-comment-id:3074669288 --> @basteyy commented on GitHub (Jul 15, 2025): I see. The table `playlist_collaborators` was created by the setup successfully. The migration is marked as batched successfully. But obviously, the table was not renamed. I'm not familiar with Laravel and so I have no idea what's wrong with the migration. I can reproduce the failed renaming on different systems. Can you provide a current dump of the schema?
Author
Owner

@phanan commented on GitHub (Jul 18, 2025):

Hey sorry for the late response. What if you rename the table manually?

Am Di., 15. Juli 2025 um 19:49 Uhr schrieb basteyy @.***

:

basteyy left a comment (koel/koel#2019)
https://github.com/koel/koel/issues/2019#issuecomment-3074669288

I see. The table playlist_collaborators was created by the setup
successfully. The migration is marked as batched successfully. But
obviously, the table was not renamed. I'm not familiar with Laravel and so
I have no idea what's wrong with the migration. I can reproduce the failed
renaming on different systems.


Reply to this email directly, view it on GitHub
https://github.com/koel/koel/issues/2019#issuecomment-3074669288, or
unsubscribe
https://github.com/notifications/unsubscribe-auth/AB5O3UT2COUBNGBPCUEN3CL3IU5KNAVCNFSM6AAAAACBMEFK6SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTANZUGY3DSMRYHA
.
You are receiving this because you were assigned.Message ID:
@.***>

<!-- gh-comment-id:3087521467 --> @phanan commented on GitHub (Jul 18, 2025): Hey sorry for the late response. What if you rename the table manually? Am Di., 15. Juli 2025 um 19:49 Uhr schrieb basteyy ***@***.*** >: > *basteyy* left a comment (koel/koel#2019) > <https://github.com/koel/koel/issues/2019#issuecomment-3074669288> > > I see. The table playlist_collaborators was created by the setup > successfully. The migration is marked as batched successfully. But > obviously, the table was not renamed. I'm not familiar with Laravel and so > I have no idea what's wrong with the migration. I can reproduce the failed > renaming on different systems. > > — > Reply to this email directly, view it on GitHub > <https://github.com/koel/koel/issues/2019#issuecomment-3074669288>, or > unsubscribe > <https://github.com/notifications/unsubscribe-auth/AB5O3UT2COUBNGBPCUEN3CL3IU5KNAVCNFSM6AAAAACBMEFK6SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTANZUGY3DSMRYHA> > . > You are receiving this because you were assigned.Message ID: > ***@***.***> >
Author
Owner

@basteyy commented on GitHub (Jul 21, 2025):

Renaming alone is not working. Schema is:

CREATE TABLE `playlist_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `playlist_id` varchar(36) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `role` varchar(88) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

According to the error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'playlist_user.position' in 'SELECT' (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner)` at least field `position` is missing.

Just thinking that this problem is somehow connected to my config. I tried it again, and still the error. Have you tried to run the setup from scratch?

<!-- gh-comment-id:3097488899 --> @basteyy commented on GitHub (Jul 21, 2025): Renaming alone is not working. Schema is: ``` CREATE TABLE `playlist_user` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `playlist_id` varchar(36) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `role` varchar(88) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; ``` According to the error: ``` SQLSTATE[42S22]: Column not found: 1054 Unknown column 'playlist_user.position' in 'SELECT' (Connection: mysql, SQL: select distinct `playlists`.*, `playlist_playlist_folder`.`folder_id`, `playlist_user`.`user_id` as `pivot_user_id`, `playlist_user`.`playlist_id` as `pivot_playlist_id`, `playlist_user`.`role` as `pivot_role`, `playlist_user`.`position` as `pivot_position`, `playlist_user`.`created_at` as `pivot_created_at`, `playlist_user`.`updated_at` as `pivot_updated_at` from `playlists` inner join `playlist_user` on `playlists`.`id` = `playlist_user`.`playlist_id` left join `playlist_playlist_folder` on `playlists`.`id` = `playlist_playlist_folder`.`playlist_id` where `playlist_user`.`user_id` = 1 and `playlist_user`.`role` = owner)` at least field `position` is missing. ``` Just thinking that this problem is somehow connected to my config. I tried it again, and still the error. Have you tried to run the setup from scratch?
Author
Owner

@phanan commented on GitHub (Jul 21, 2025):

Have you tried to run the setup from scratch?

Yes and the flow is covered in CI with every commit :)
It seems like your whole migration file (2025_06_03_121538_modify_playlist-user_relationship.php) wasn't executed, and I'm not sure why. I would try to undo the renaming, remove the migration record from the migrations table, and run php artisan migrate again.

Btw, is the DB version correct? 0.11.13-MariaDB-0ubuntu0.24.04.1-log looks sus to me.

<!-- gh-comment-id:3097561039 --> @phanan commented on GitHub (Jul 21, 2025): > Have you tried to run the setup from scratch? Yes and the flow is covered in CI with every commit :) It seems like your whole migration file (`2025_06_03_121538_modify_playlist-user_relationship.php`) wasn't executed, and I'm not sure why. I would try to undo the renaming, remove the migration record from the migrations table, and run `php artisan migrate` again. Btw, is the DB version correct? ` 0.11.13-MariaDB-0ubuntu0.24.04.1-log` looks sus to me.
Author
Owner

@basteyy commented on GitHub (Jul 22, 2025):

Btw, is the DB version correct? 0.11.13-MariaDB-0ubuntu0.24.04.1-log looks sus to me.

I cut the 1 at the beginning.

It seems like your whole migration file (2025_06_03_121538_modify_playlist-user_relationship.php) wasn't executed, and I'm not sure why. I would try to undo the renaming, remove the migration record from the migrations table, and run php artisan migrate again.

This helps/fix it (btw, it was needed to perform migrate:fresh and create the first user again via php artisan koel:admin:change-password). So problem solved, but I still have the problem when drafting koel from scratch. I didn't test the docker container. But from source/pre-compiled, the same "error" still appears.

<!-- gh-comment-id:3103020008 --> @basteyy commented on GitHub (Jul 22, 2025): > Btw, is the DB version correct? ` 0.11.13-MariaDB-0ubuntu0.24.04.1-log` looks sus to me. I cut the `1` at the beginning. > It seems like your whole migration file (`2025_06_03_121538_modify_playlist-user_relationship.php`) wasn't executed, and I'm not sure why. I would try to undo the renaming, remove the migration record from the migrations table, and run `php artisan migrate` again. This helps/fix it (btw, it was needed to perform `migrate:fresh` and create the first user again via `php artisan koel:admin:change-password`). So problem solved, but I still have the problem when drafting koel from scratch. I didn't test the docker container. But from source/pre-compiled, the same "error" still appears.
Sign in to join this conversation.
No milestone
No project
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#1065
No description provided.