starred/koel-koel

Fork 0

mirror of https://github.com/koel/koel.git synced 2026-04-26 01:06:00 +03:00

[GH-ISSUE #2005] [Bug]: koel.playlist_user' doesn't exist #1057

New issue

Closed

opened 2026-02-26 02:35:07 +03:00 by kerem · 3 comments

kerem commented

2026-02-26 02:35:07 +03:00

Owner

Originally created by @darkspadez on GitHub (Jul 6, 2025).
Original GitHub issue: https://github.com/koel/koel/issues/2005

Originally assigned to: @phanan on GitHub.

Read the Troubleshooting guide.

I have read and followed the Troubleshooting guide

Reproduction steps

Fresh install
Go to login page and try to login and will not be able to throws this sql error

Expected behavior

To not have error and be able to login

Actual behavior

Not able to login or do anything

Logs

[2025-07-06 05:42:43] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel.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.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 /app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)

Koel version

7.9.0

How did you install Koel?

Pre-compiled tar/zip archive

Additional information

Server OS: debian bookworm
PHP version: 8.4.10
Database: Mariadb 10.11
Node version: N/A
Browser & device: Vivaldi
Additional context:

Originally created by @darkspadez on GitHub (Jul 6, 2025). Original GitHub issue: https://github.com/koel/koel/issues/2005 Originally assigned to: @phanan on GitHub. ### Read the Troubleshooting guide. - [x] I have read and followed the Troubleshooting guide ### Reproduction steps 1. Fresh install 2. Go to login page and try to login and will not be able to throws this sql error ### Expected behavior To not have error and be able to login ### Actual behavior Not able to login or do anything ### Logs ``` [2025-07-06 05:42:43] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'koel.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.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 /app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825) ``` ### Koel version 7.9.0 ### How did you install Koel? Pre-compiled tar/zip archive ### Additional information - **Server OS**: debian bookworm - **PHP version**: 8.4.10 - **Database**: Mariadb 10.11 - **Node version**: N/A - **Browser & device**: Vivaldi - **Additional context**:

kerem closed this issue

2026-02-26 02:35:07 +03:00

kerem commented

2026-02-26 02:35:07 +03:00

Author

Owner

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

Have you run the init command?

On Sun, Jul 6, 2025 at 12:50 Jon Kagan @.***> wrote:

Assigned #2005 https://github.com/koel/koel/issues/2005 to @phanan
https://github.com/phanan.

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

@phanan commented on GitHub (Jul 6, 2025): Have you run the init command? On Sun, Jul 6, 2025 at 12:50 Jon Kagan ***@***.***> wrote: > Assigned #2005 <https://github.com/koel/koel/issues/2005> to @phanan > <https://github.com/phanan>. > > — > Reply to this email directly, view it on GitHub > <https://github.com/koel/koel/issues/2005#event-18489946930>, or > unsubscribe > <https://github.com/notifications/unsubscribe-auth/AB5O3URM5AIVBSYA7ER5YOT3HC2K7AVCNFSM6AAAAACA3Z74V6VHI2DSMVQWIX3LMV45UABCJFZXG5LFIV3GK3TUJZXXI2LGNFRWC5DJN5XDWMJYGQ4DSOJUGY4TGMA> > . > You are receiving this because you were assigned.Message ID: > ***@***.***> >

kerem commented

2026-02-26 02:35:07 +03:00

Author

Owner

@darkspadez commented on GitHub (Jul 6, 2025):

Hi,

Yes I have run php artisan koel:init --no-assets multiple times and even php artisan koel:doctor and everything checks out ok.

@darkspadez commented on GitHub (Jul 6, 2025): Hi, Yes I have run `php artisan koel:init --no-assets` multiple times and even `php artisan koel:doctor` and everything checks out ok.

kerem commented

2026-02-26 02:35:07 +03:00

Author

Owner

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

I can't reproduce this problem at all (which only makes sense, because all
the tests, which cover playlist use cases, pass).
Try dropping your database and try again.

Am So., 6. Juli 2025 um 13:54 Uhr schrieb Jon Kagan <
@.***>:

darkspadez left a comment (koel/koel#2005)
https://github.com/koel/koel/issues/2005#issuecomment-3041036089

Hi,

Yes I have run php artisan koel:init --no-assets multiple times and even php
artisan koel:doctor and everything checks out ok.

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

@phanan commented on GitHub (Jul 6, 2025): I can't reproduce this problem at all (which only makes sense, because all the tests, which cover playlist use cases, pass). Try dropping your database and try again. Am So., 6. Juli 2025 um 13:54 Uhr schrieb Jon Kagan < ***@***.***>: > *darkspadez* left a comment (koel/koel#2005) > <https://github.com/koel/koel/issues/2005#issuecomment-3041036089> > > Hi, > > Yes I have run php artisan koel:init --no-assets multiple times and even php > artisan koel:doctor and everything checks out ok. > > — > Reply to this email directly, view it on GitHub > <https://github.com/koel/koel/issues/2005#issuecomment-3041036089>, or > unsubscribe > <https://github.com/notifications/unsubscribe-auth/AB5O3UUHGCUBEKYAANZUN7L3HDBY3AVCNFSM6AAAAACA3Z74V6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTANBRGAZTMMBYHE> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> >

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#1057

No description provided.

Rows
Columns