[GH-ISSUE #638] Duplicate artists in Postgres #459

New issue

Closed

opened 2026-02-26 02:33:16 +03:00 by kerem · 1 comment

kerem commented

2026-02-26 02:33:16 +03:00

Owner

Originally created by @svalo on GitHub (Aug 18, 2017).
Original GitHub issue: https://github.com/koel/koel/issues/638

Configuration:
OS: archlinux
Postgres version:9.6.3
MariaDB version:10.1.26-MariaDB
Php version: 7.1.8
Koel is configured using php-fpm + nginx

When using Postgres if 2 songs are from same artist but name differs for capital characters 2 distinct artists are created, this is different from what happens using mysql.

I read the docs, expecially this part regarding setting the collation to be case insensitive. Unluckily this is not possible in postgres.

An idea could be to insert the first occurrence of an artist as it appears and then do a case-insensitive check to see if the artist is already present in the DB. Is this possible to do or is this something concerning Eloquent?

Originally created by @svalo on GitHub (Aug 18, 2017). Original GitHub issue: https://github.com/koel/koel/issues/638 Configuration: OS: archlinux Postgres version:9.6.3 MariaDB version:10.1.26-MariaDB Php version: 7.1.8 Koel is configured using php-fpm + nginx When using Postgres if 2 songs are from same artist but name differs for capital characters 2 distinct artists are created, this is different from what happens using mysql. I read the docs, expecially [this](https://koel.phanan.net/docs/#/troubleshooting?id=you-receive-an-integrity-constraint-violation-1062-duplicate-entry-for-key-39artists_name_unique39-error-when-scanning) part regarding setting the collation to be case insensitive. Unluckily this is not possible in postgres. An idea could be to insert the first occurrence of an artist as it appears and then do a case-insensitive check to see if the artist is already present in the DB. Is this possible to do or is this something concerning Eloquent?

kerem closed this issue

2026-02-26 02:33:16 +03:00

kerem commented

2026-02-26 02:33:16 +03:00

Author

Owner

@phanan commented on GitHub (Aug 19, 2017):

That part in the doc isn't meant for case-sensitivity. I think you can just correct the mp3 tag instead.

@phanan commented on GitHub (Aug 19, 2017): That part in the doc isn't meant for case-sensitivity. I think you can just correct the mp3 tag instead.

kerem referenced this issue

2026-02-26 03:30:21 +03:00

[PR #459] [MERGED] Fix scrollable issue with Firefox. #1258

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

No description provided.

Rows
Columns