Synronize media does not work with our custom repository

Help & Support
, ,
1

Hello Support,

i am using v8.0.79-master (Sakuya Splendide, 4242db8f)

I have uploaded some songs with that version and it seems that I also need to synchronize with our repository after that.
When i select only our repository and push on sycnronize following error i get

{
“code”: 500,
“sentry”: true
}

{
“code”: “23502”,
“column”: “name”,
“detail”: “Fehlgeschlagene Zeile enthält (a67c8c02-5c12-409b-b4b9-2c3804fb7fee, null, 26169792, DL_PLANNED, 2025-05-26 14:58:26.74345, repo.eventkoe.de, JPN - Naruto - MV - Pinocchio.mkv, 19f3a431-0f60-49ac-8bb6-42da4dad4be3).”,
“file”: “execMain.c”,
“length”: 389,
“line”: “2009”,
“name”: “error”,
“routine”: “ExecConstraints”,
“schema”: “public”,
“severity”: “FEHLER”,
“table”: “download”
}

And no media has been downloaded.

I can still manually download them from List view.

Best regard

Penn-Jack

2

I can reproduce this issue on kmapp 8.0.79 and kmserver on latest master; Download in general works with “Update all repositories” or when manually clicking on the download button of a song, but the “Synchronize” button causes an error:

05/26/2025 8:49:11 PM - Downloads: Unable to queue new download : error: null value in column "name" of relation "download" violates not-null constraint

{
  "code": "23502",
  "column": "name",
  "detail": "Failing row contains (ae66db14-203a-4fd5-b8d9-805ccedc9ece, null, 5266373, DL_PLANNED, 2025-05-26 20:49:11.38336, repo.eventkoe.de, ENG - Chvrches - IS - Graffiti.mp4, 5956532b-41e6-49e0-ba81-1121672e677f).",
  "file": "execMain.c",
  "length": 374,
  "line": "2003",
  "name": "error",
  "routine": "ExecConstraints",
  "schema": "public",
  "severity": "ERROR",
  "table": "download"
}
3

is the kmserver instance up to date? (with master branch)
It’s remind me of a bug that have been fixed with 🐛 Add repository and songname to medias route (a15ad3a4) · Validations · Karaoke Mugen / Code / Karaoke Mugen Server · GitLab

4

Given the medianame provided I’d say it’s because the karas in the repository haven’t been updated to UUID standards and thus don’t have songnames.

We can probably try to make it optional when the downloader is called, but I think the main issue is that.

5

is the kmserver instance up to date

kmserver is on latest master

karas in the repository haven’t been updated to UUID

Yes currently it’s mixed: A few newer karas have UUIDs but most older ones are still on songname.

Can we switch to UUIDs alltogether (was there a script for that?) without much hassle on user side or would it be easier to make the changes in app and keep going on like that?

6

Having mixed UUIDs/non-UUIDs isn’t the issue. Songnames missing is, though.

I just pushed a commit to next which should allievate that issue except for quizzes, but I’ll have to look into it further and see what can be done. (as of now, quizzes might display a null result to users when displaying the song’s name when revealing the final answer. Perhaps.)

Repos can be converted to UUIDs via the “convert to UUID format” button in the repository settings page in system panel. There’s no way to just fill in the songnames in kara files.

7

Thank you for the quick fix! I tested the commit in the current master and the synchronization works again without errors. Quizzes are not relevant in this case.

Since KOE is in preparation for Dokomi next week, is there another way to download all medias or are there chances to do a release including this fix?

8

8.0.83-master has been released with the fix.