SQL error on download

[garok89]

I have encountered a bug and I can't seem to find any similar errors when searching.

When downloading for offline use, I receive an SQL error message. Occassionally a download will succeed, but this is rare

Book update error 'Avengers Annual 1 (2024)'
e92:
org.sqlite.SQLite Exception:
[SQLITE_CONSTRAINT_PRIMA
RYKEY] A PRIMARY KEY constraint failed (UNIQUE constraint failed:
BOOK_METADATAAUTHOR.b ook_id,
BOOK_METADATAAUTHOR.n ame,
BOOK_METADATAAUTHOR.ro le)

0.19 installed via the Play Store

Happens on both my Pixel 10 Pro XL and Pixel Tablet

Remote access to server via NGINX reverse proxy

[Snd-R]

As the error says there's a constraint on unique author name and role.
You somehow have book with the same author declared twice with the same role.
It's probably set through comicinfo.xml since webui doesn't let you have the same author name twice

I can remove the constraint to match Komga behavior or it might be better to just deduplicate the authors during import

[garok89]

You are right. For some reason a lot of my files have this. I don't know if it's Mylar pulling it from Comicvine or if the files are already like that, but I'll try get a proper look later. Checking a random XML and it has, as an example, <penciller>Alberto foche, Alvaro Lopez, Alberto foche, Alvaro Lopez</penciller> And then the same for <inker>

…

On Sat, 26 Sept 2026, 05:12 Snd-R, ***@***.***> wrote: *Snd-R* left a comment (Snd-R/Komelia#175) <#175 (comment)> As the error says there's a constraint on unique author name and role. You somehow have book with the same author declared twice with the same role. It's probably set through comicinfo.xml since webui doesn't let you have the same author name twice I can remove the constraint to match Komga behavior or it might be better to just deduplicate the authors during import — Reply to this email directly, view it on GitHub <#175?email_source=notifications&email_token=AABZOVAACVS77MRHZCYRRFT5Q463VA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTKOBUGMYDKNZRGE42M4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2KYZTPN52GK4S7MNWGSY3L#issuecomment-5843057119>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABZOVD2Q5UZATA43CUL4P35Q463VAVCNFSNUABFKJSXA33TNF2G64TZHM3TONJQGY2DENBZHNEXG43VMU5TKNJYHEYTCNZUG4ZKC5QC> . Triage notifications, keep track of coding agent tasks and review pull requests on the go with GitHub Mobile for iOS <https://github.com/notifications/mobile/ios/AABZOVFUWH76BX24MG6EXML5Q463VA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTKOBUGMYDKNZRGE42M4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2KUZTPN52GK4S7NFXXG> and Android <https://github.com/notifications/mobile/android/AABZOVFX6B5SDT2QIMJGLAT5Q463VA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTKOBUGMYDKNZRGE42M4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2K4ZTPN52GK4S7MFXGI4TPNFSA>. Download it today! You are receiving this because you authored the thread.Message ID: ***@***.***>