column company.createdByContext does not exist
Hello,
I was using version 0.40 in self-hosted mode. I wanted to update directly to use version 0.42 because I want to use mail synchronization with Microsoft.
I therefore performed a docker compose down, changed the tag, and finally docker compose up with the latest version.
Once this was done, I properly executed:
docker exec -it twenty-server-1 yarn database:migrate:prod
docker exec -it twenty-server-1 yarn command:prod upgrade-0.42
But I have an error that prevents me from using the CRM correctly:
column company.createdByContext does not exist
Also, the "People, Tasks and Opportunities" tabs no longer display.
Can someone help me?
I hadn't yet started entering my database, so I have no problem starting with a new database.
16 Replies
I have the exact same issue.
Hi @Tonton78 @Andreas, you'll need to upgrade to 0.41 first (just update it in your docker-compose) and then follow the upgrade guide (see link by Thomas below)
Hi, you need to do the upgrade one version at a time
https://twenty.com/developers/section/self-hosting/upgrade-guide#v0.40.0-to-v0.41.0
I try to downgrade to 0.41 but the error still here
Hi @charles @thomast - I went from 0.35.6 to like 0.42. Do I need to downgrade then to 0.40 before I can upgrade again? Or how should I think here?
When I update the TAG to v0.40.0 and then do docker pull I get error also.
twenty-postgres becase twenty-postgres-spilo in 0.40
you can either lock your twenty-postgres on 0.35 or switch to twenty-postgres-spilo
make sure to make database dump before all this, just in case
I think the simpler is to stay on twenty-postgres on version 0.35, there is no change since and we don't plan to make any
I changed the docker-compose.yml to have spilo instead and then did docker compose up -d and got this error.
yep, it might be a bit technical
What's your setup? Is this for production hosting or just play with Twenty?
For production, I would actually recommend migrating to an external managed database, it's safer
so make a backup and re-import it in another database
Using it in my small startup. Do you have time for a short call?
not right now but we can schedule one
Any availability rest of the day? I'm in GMT+1
we can do 4pm (Paris time), would it work for you?
Yes sounds good, I can send an invite? Or should I ping you here? @charles
yes, let's meet in the #voice channel at 4pm
Great!