Koel fresh install failed

[jlbdrt]

What type of hardware are you using: Old laptop or computer
What YunoHost version are you running: 12.0.17
What app is this about: Koel

Describe your issue

Hello there,

I tried to install Koel (Version: 7.11.0~ynh1) and everything seemed fine. But when trying to login with the default credentials outputs an error (visible on Chomium, not on Firefox…), I’ve got the following message.

I fear that’s an issue with Koel itself but I cannot find a way to execute any diagnostic. I tried running php artisan koel:doctor within /var/www/koel, but it’s prohibited to sudoers.

Thanks for your help.
Ps: I would have liked to tag this topic koel

Share relevant logs or error messages

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘koel.favorites’ doesn’t exist (Connection: mysql, SQL: select songs.*, CASE WHEN favorites.created_at IS NULL THEN false ELSE true END AS favorite, interactions.play_count from songs left join favorites on favorites.favoriteable_id = songs.id and favorites.favoriteable_type = playable and favorites.user_id = 1 left join interactions on interactions.song_id = songs.id and interactions.user_id = 1 where 0 = 1)

[Aleks]

Please share the full logs, not just the specific error message, sometimes the actual error happens before, and we need the technical context in the full logs etc

[jlbdrt]

Thanks for your reply.

And sorry for the very specific log.

I first installed Koel; the full install log is here: https://paste.yunohost.org/raw/emajumativ

I didn’t test on Chromium at the time (only Firefox, so I hadn’t the error message within the web app). So (magical thinking, I guess) I tried to update it. The update log is here: https://paste.yunohost.org/raw/rijemowixu

Thanks for your time and help.

[jarod5001]

@jlbdrt

prohibited to sudoers.

Use sudo yunohost app shell koel to enter the app shell and run commands as user koel. Use exit to exit app shell.

[jlbdrt]

I still lack good reflexes (still learning…).
Thanks!

Running php artisan koel:doctor leads me to this diagnostic: Pasthis

When looking at storage/logs/laravel.log, I find this: Pasthis

Since I found an error with Artifacts directory / is not readable/writable, I also looked at the permissions: Pasthis

Not knowing exactly what I was doing, I ran php artisan koel:init that gave me Installing npm dependencies .... 6.18ms FAIL (full log here: Pasthis)

Nothing in these logs lead me to a clear idea of what’s going wrong –and nothing in doctor told me about a lacking table, as said the error message within the web app. But maybe someone will be able to highlight what’s going wrong.

Thanks a lot!

[jlbdrt]

Alright.

My problem (ok, the main one) may have been linked to a DNS problem. I updated the config at my registrar so that the subdomain on which I wanted to serve Koel is properly registered (instructions on yunohost.local/yunohost/admin/#/domains/sub.doma.in/dns).

Nevertheless, I’ve got a bunch of errors logged within storage/logs/laravel.log and if I successfully logged in, some weird things happen. I close this thread since I guess they are way more related to Koel than to Yunohost.