django heroku deployment postgres config

Question

this is my first time deploying a Django app to Heroku I followed the the Django Heroku documentation

the app is deployed successfully but when I open the app I got this error :

relation "products_category" does not exist
LINE 1: ...ory"."image", "products_category"."catogory" FROM "products_...

this is the changes I did to my settings.py after reading the documentation :

import django_heroku
django_heroku.settings(locals())

the database configuration is still running with sqlite3:

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.sqlite3',
    'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
   }
  }

so what do I need to change in my setting to deploy my apps properly ?

stackoverflow.com/questions/31395856/…

iklinac
– iklinac

2021-01-19 20:44:56 +00:00
Commented Jan 19, 2021 at 20:44 — iklinac
– iklinac, Commented Jan 19, 2021 at 20:44

bazzuk123 · Accepted Answer · 2021-02-18 22:17:10Z

1

first of all, in your dashboard, Heroku app go to settings and get rid of this DISABLE_COLLECTSTATIC conf.

in your settings.py add

STATIC_ROOT  = BASE_DIR / 'staticfiles'

create a directory called staticfiles, and add smth to it (eg. tmp.txt) just to make sure that git add . will include this directory. Push everything to Heroku and then use these commands:

heroku run python manage.py makemigrations

heroku run python manage.py migrate

edited Feb 18, 2021 at 22:17

answered Jan 19, 2021 at 20:48

bazzuk123

1911 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

NAS Over a year ago

Thank you I will try that and tell you if it works :)

bazzuk123 Over a year ago

TBH I'm not sure if it will work with your with your settings from heroku tutorial, but what I always do when I upload Django to heroku is follow this tutorial: codementor.io/@jamesezechukwu/… it is a little bit outdated (eg. stuff with whitenoise, read whitenoise.evans.io/en/stable/changelog.html#v4-0 and you will get through it) and additionally to it I will do this part from the answer

NAS Over a year ago

thanks I will create another app and use the tutorial to see if it works

bazzuk123 · Accepted Answer · 2021-01-19 20:26:34Z

0

try

heroku run python manage.py makemigrations

and then

heroku run python manage.py migrate

answered Jan 19, 2021 at 20:26

bazzuk123

1911 silver badge10 bronze badges

3 Comments

NAS Over a year ago

still the same error :django.db.utils.ProgrammingError: relation "products_category" does not exist LINE 1: ...ory"."image", "products_category"."catogory" FROM "products_...

bazzuk123 Over a year ago

when you deployed to Heroku, did you use this command: Heroku config:set DISABLE_COLLECTSTATIC=1

bazzuk123 Over a year ago

That's not good, I also had a hard time uploading my first project to Heroku. What I learned that you shouldn't disable collectstatic, instead try to follow my other answer(i will post it in a sec)

Collectives™ on Stack Overflow

django heroku deployment postgres config

2 Answers 2

3 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related