-
-
Notifications
You must be signed in to change notification settings - Fork 1.3k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Oops! Database Error: UNIQUE constraint failed. Library is not corrupt #3058
Comments
There is a publish with the same name, but different in the database. I don't know how to give an example form JKC letters but for normal ascii characters it would be something like "Unknown" and "unknown" (Capital letter or not) |
How do you avoid this? Only add books via calibre-web? Reset my library and let calibre-web handle all imports? |
@kanjieater in my particular case, with you same error ( go to "book list" (last item in the left dashboar menu); order by "editor" and look for the publisher name that brings your error; manually edit (click on its name) deleting its value in every book that has this publisher. In my case there were only three. then try to add a new book and it worked for me then manually edit again those previous books adding back its publisher name. I know, this is not how it should work, but at least I could add new books to library |
I‘ll have a look at it |
I am also having this issue, but for I saw that The Cyberiad was under the author Stanisław Lem (with a ł), and the book I was uploading mustn't have had the ł character, because when I renamed the author in The Cyberiad to be Stanislaw, I was then able to upload Solaris. Hope this helps! |
@kaibagley: I can reproduce it |
It's a bit tricky, I need some tests, the solution will show up within next week |
Describe the bug/problem
Books uploaded to Calibre-web fails. Book added to classic calibre succeeds. Ran Library Maintenance, fix and deleted, found no issues, issue persists. Oops! Database Error: UNIQUE constraint failed: publishers.name.
Publisher in question:
株式会社 東京創元社
To Reproduce
Steps to reproduce the behavior:
Not that other books add fine.
Logfile
--- Logging error ---
Expected behavior
Books that can be added to Calibre should be able to be added to Calibre-Web without having to open Calibre
Environment (please complete the following information):
Additional context
Add any other context about the problem here. [e.g. access via reverse proxy, database background sync, special database location]
The text was updated successfully, but these errors were encountered: