Django: relation "django_site" does not exist

Question

I am running a test django server on aws and I just installed django-userena and when I try to signup a user upon clicking submit, I get the following message:

relation "django_site" does not exist LINE 1: ..."django_site"."domain", "django_site"."name" FROM "django_si...

I am not really sure what went wrong here. I did some researching and added " 'django.contrib.sites'," to my installed apps, but I am still getting the error. I will there is an extra step I am missing. Any suggestions or advice?

Answer 1

I recently ran into this issue (Django 1.8.7) even with SITE_ID = 1 in my settings. I had to manually migrate the sites app before any other migrations:

./manage.py migrate sites
./manage.py migrate

Answer 2

You may be calling a site object before creating site model(before syncdb or migrate)

ex: site = Site.objects.get(id=settings.SITE_ID)

Answer 3

I have the same problem and fixed it like this:

1. add SITE_ID=1 into settings.py

2. run this command :

   python manage.py migrate