Error during upgrade - Field of type RELATION is a many to one relation but does not have a join col
Hi community! During another attempt to upgrade my Twenty instance, I got stuck at the error described in https://github.com/twentyhq/twenty/issues/14896. Any ideas how to resolve this?
18 Replies
Hey @Ferdi, could you please share your workspace version in database located at core.workspace.version ?
It's
0.53.0Please make sure to have a backup of a functional db dump
Please try running
an re-attempt 0.53.6 upgrade ( not 0.54 ) lets try fixing your instance on 0.53 first
0.53.6 does not exist (as a Docker image), do you mean 0.53.8 ?
Running the command you suggested yields:
are you re-using an instance that you attempted to upgrade to an higher non incremental version ?
It's the same instance that I previously (yesterday) move from 0.53.0 to 0.54.6.
What version are you currently running commands on ?
0.53.0
Has your 0.53 instance been healthy/working before ?
Yes
I assume you've: ( on same pg instance )
0.53.0 -> 0.54.6
0.54.6 -> 0.53.6
0.53.6 -> 0.53.0
Please try going back to 0.54.6 and running
Same error. What I now did though is:
- Drop database and load clean backup corresponding to (non-upgraded) state at 0.53.0
- Run the command you sent
- Upgrade to 0.53.8 -> was successful
Now I tried to go to 0.54.6 and am getting a new error now:
Ok cool checking
please try running
Does this error tell you anything?
Gotta bounce now, will get back here later today. Thanks a lot for your support already!
Unfortunately on mobile atm ! Will investigate tomorrow in what db migrations is introduced this column
Latest attempt could be running an
No worries !
Didn't help, unfortunately.
Ok I will reach back with further information