Question

How to handle migrations in Django project in production (App Platform) ?

Posted May 26, 2021 454 views
DjangoDatabasesDigitalOcean App Platform

I have been using the app platform for almost 2 months. Yesterday, I made some changes in database tables (models) in my Django projects. I pushed those changes to Github and my app successfully redeployed. But When I open the site, I got “ProgrammingError” that some field that I created new in the existing table does not exist. So, I opened the console in App Platform and applied migrations but nothing is changed. I am still facing the error.

*Exception Type: ProgrammingError
Exception Value:

column productssubcategory.description does not exist
LINE 1: …subcategory".“id”, “products
subcategory”.“name”, “products_… *

Can anyone help me with this?

2 comments
  • Hi There!

    That error looks like the migrations may not have completed since the database changes. What migration commands did you run after making those changes?

  • Hi DO Team … I’m sitting with a similar challenge … DO docs are not helping. I have an established Django App … successfully deployed on App Platform. However, I use POSTGRES Schemas … [SaaS] … to separate my tenants data … for this I need to migrate models to specific Schema … in turn I need to create the Schema on db. I realise I need to upgrade the production db … but no docs to help with this process … i.e. create database and update settings.py [?] … and when I have upgraded how to access the database [via console will be ok] to create a Postgres db.schema ? … help will be appreciated.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

Hi @laviscoacc, have you solve it?