mirror of
https://github.com/koel/koel.git
synced 2026-04-26 01:06:00 +03:00
[GH-ISSUE #1776] An error appeared after the update. #978
Labels
No labels
Authentication
Dependencies
Documentation
Feature Request
Flac
Help Wanted
Installation/Setup
Integration
Mobile
PR Welcome
Pending Release
Performance
Playlist
S3
Search
Sync
[Pri] Low
[Pri] Normal
[Status] Keep Open
[Status] Needs Author Reply
[Status] Needs Review
[Status] Stale
[Status] Will Implement
[Type] Blessed
[Type] Bug
[Type] Duplicate
[Type] Enhancement
[Type] Help Request
[Type] Question
[Type] Task
pull-request
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/koel-koel#978
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @VlaK0r on GitHub (Jul 10, 2024).
Original GitHub issue: https://github.com/koel/koel/issues/1776
Hello!
Thank you for your hard work!
Installation via docker.
SQLSTATE[42P10]: Invalid column reference: 7 ERROR: SELECT DISTINCT ON expressions must match initial ORDER BY expressions LINE 1: select distinct on ("songs"."id") "songs"., "albums"."name"... ^ (Connection: pgsql, SQL: select distinct on ("songs"."id") "songs"., "albums"."name", "artists"."name", "interactions"."liked", "interactions"."play_count" from "songs" left join "interactions" on "interactions"."song_id" = "songs"."id" and "interactions"."user_id" = 1 left join "albums" on "songs"."album_id" = "albums"."id" left join "artists" on "songs"."artist_id" = "artists"."id" where "songs"."podcast_id" is null and "songs"."artist_id" = 146 or "albums"."artist_id" = 146 order by "albums"."name" asc, "songs"."disc" asc, "songs"."track" asc, "songs"."title" asc)
@VlaK0r commented on GitHub (Jul 11, 2024):
I changed the database to MariaDB/MySQL.
Now everything is working correctly.
@phanan commented on GitHub (Jul 11, 2024):
Glad it worked! But can you share more details about the error, for example when it occurred and more logs?
@VlaK0r commented on GitHub (Jul 11, 2024):
Please tell me how to get more logs?
@VlaK0r commented on GitHub (Jul 11, 2024):
Docker logs
@VlaK0r commented on GitHub (Jul 11, 2024):
@phanan commented on GitHub (Jul 11, 2024):
Error logs can be found under
storage/logs/laravel.log.@VlaK0r commented on GitHub (Jul 11, 2024):
Please tell me how to do this in the docker?
@phanan commented on GitHub (Jul 11, 2024):
You'll need to SSH into the docker container or use
docker exec, something likedocker exec tail -n 100 /var/www/html/storage/logs/laravel.log. If you've switched to MySQL, however, I'm afraid the PostreSQL error is no more.@VlaK0r commented on GitHub (Jul 11, 2024):
The web interface slows down when there are more than 500 tracks. Is this how it should be?
@VlaK0r commented on GitHub (Jul 11, 2024):
Everything is frozen.
@phanan commented on GitHub (Jul 11, 2024):
I don’t think that’s how it should be. Koel can handle virtually any size
of library, certainly thousands.
On Thu, Jul 11, 2024 at 20:39 VlaK0r @.***> wrote:
@VlaK0r commented on GitHub (Jul 11, 2024):
And then what could be the reason for the freezes?
@phanan commented on GitHub (Jul 11, 2024):
Sorry but you’re literally giving me one still screenshot, saying it’s
frozen, and asking why. I can’t help you debug with literally no
information.
On Thu, Jul 11, 2024 at 21:14 VlaK0r @.***> wrote:
@heldbrendel commented on GitHub (Jul 13, 2024):
I get the error that can be seen in the first comment.
I am running koel in a container, using the docker-compose.yml as template.
Both containers start successful.
I can exec into them with
podman exec --user www-data -it koel_koel_1 bash.After that I run
php artisan koel:init --no-assets.I get the feedback that everything was correctly initialized.
From there logging into the user interface with the default login, I get greeted with the error message.
And also when going to the "All Songs" page the following message appears:
The
laravel.logshows the following message:Also when stopping and starting the container after that the user interface only shows an error 500 and in the logs the following message can be found:
I hope this helps to clarify the problem. Let me know if I should provide further information.
@phanan commented on GitHub (Jul 13, 2024):
@heldbrendel Thanks for the super detailed report. I'll take a look.
@phanan commented on GitHub (Jul 13, 2024):
@heldbrendel If you remote the parameter on
app/Builders/SongBuilder.php:64i.e. replacing the line with->distinct(), how does it go?