Switching edition doesn't work

[pivic]

Describe the bug
This is the same kind of bug that I've written about before, which was closed: #3167

When trying to switch edition from one book to another, I get the

To Reproduce
Steps to reproduce the behavior:

1. I go to https://bookwyrm.social/book/940778/s/precipice

I see this page:

2. I select one of the Switch to this edition buttons.
3. I end up on https://bookwyrm.social/switch-edition and I see this error message:' Server Error
   Something went wrong! Sorry about that.'

Expected behavior
To be able to switch from one book edition to another.

Screenshots
The error page that appears on step 3:

Instance
https://bookwyrm.social

---

Desktop (please complete the following information):
- OS: Windows 11
- Browser: Chrome
- Version 135.0.7049.85 (Official Build) (64-bit)

Smartphone (please complete the following information):
- Device: Nothing 2a
- OS: Android 14
- Browser: Ironfox
- Version 137.0.2

[timothyjrogers]

I'm having trouble reproducing this, in fact the current version doesn't seem to let me have the same book (even with different editions) on multiple shelves at once. In your screenshot it says you have different editions on both Read and To Read. I wonder if it's possible a previous version of Bookwyrm would let you put different editions on different shelves -- which would make sense, people do read multiple editions of things -- but now it doesn't and those books were not migrated properly in the database. I can't say for sure since I haven't been able to reproduce, but my gut says that could easily lead to a constraint error when you later try to switch editions like you are.