Django error: relation "users_user" does not exist

Question

I'm getting the following error during migration:

django.db.utils.ProgrammingError: relation "users_user" does not exist

  File "/Users/user/Documents/workspace/api/env/lib/python2.7/site-packages/django/db/backends/utils.py", line 79, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "/Users/user/Documents/workspace/api/env/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/Users/user/Documents/workspace/api/env/lib/python2.7/site-packages/django/db/utils.py", line 97, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/Users/user/Documents/workspace/api/env/lib/python2.7/site-packages/django/db/backends/utils.py", line 62, in execute
    return self.cursor.execute(sql)

This is my model:

from django.db import models
from django.contrib.auth.models import AbstractBaseUser, PermissionsMixin
from ..managers.user import UserManager


class User(AbstractBaseUser, PermissionsMixin):
    # Email identifier, primary key, unique identifier for the user.
    email = models.EmailField(verbose_name='email address', max_length=254, unique=True, db_index=True)
    is_admin = models.BooleanField(default=False)
    is_active = models.BooleanField(default=False)
    objects = UserManager()

    USERNAME_FIELD = 'email'
    REQUIRED_FIELDS = []

    class Meta:
        verbose_name = 'User'
        app_label = "users"

    def __unicode__(self):
        return self.email

    @property
    def get_full_name(self):
        return self.email

    @property
    def get_short_name(self):
        return self.email

    def has_module_perms(self, app_label):
        """
        Does the user have permissions to view the app `app_label`
        """
        # Simplest possible answer: Yes, always
        return True

    @property
    def is_staff(self):
        # Simplest possible answer: All admins are staff
        return self.is_admin

Settings:

AUTH_USER_MODEL = 'users.User'

Anything I have missed?

Have you done `./manage.py makemigrations` and `./manage.py migrate`? — Thomas Gak-Deluen, Apr 16 '15 at 10:41
@tgdn Yep so I did ``makemigrations`` which works with no errors, then on doing ``migrate`` I get the above error. — Prometheus, Apr 16 '15 at 10:42
Is it the first time you migrate? As it should be [https://docs.djangoproject.com/en/1.8/topics/auth/customizing/#substituting-a-custom-user-model](https://docs.djangoproject.com/en/1.8/topics/auth/customizing/#substituting-a-custom-user-model) — Thomas Gak-Deluen, Apr 16 '15 at 10:52
Inside your user app, you should have a folder `migrations`. It should only contain `0001_initial.py` and `__init__.py`. Is that correct? Try running `./manage.py sqlmigrate user 0001_initial` and see what it does, because thats where the error comes from — Thomas Gak-Deluen, Apr 16 '15 at 11:01
@tgdn ok I resolved this by removing other apps first and running migrations first on the main user model. thanks for your help. I'm happy to accept your answer if you post one. — Prometheus, Apr 16 '15 at 11:02

score 49 · Accepted Answer · answered Apr 16 '15 at 11:03

49

Inside your user app, you should have a folder migrations. It should only contain 0001_initial.py and __init__.py. Is that correct?

Try running ./manage.py sqlmigrate user 0001_initial and see what it does, because thats where the error comes from

answered Apr 16 '15 at 11:03

Thomas Gak-Deluen

2,759
2
28
38

18

This was my issue - I had never run the actual initial User migration. You might have not run `python manage.py makemigrations appname`yet - once you do that and `migrate` after, everything should be fine. – sofly Jun 20 '16 at 17:17
Running first ./manage.py migrate user 0001_initial worked fine. – André Duarte Mar 20 '20 at 17:37

score 2 · Answer 2 · answered May 21 '19 at 20:43

2

Another issue can also be the fact that you were using the database for another application. So if this can be the case just drop the database before making migrations again

answered May 21 '19 at 20:43

Kelvin Onkundi

139
2
2

I literally sqlflushed my db then dropped it and recreated another one with the same properties and then `./manage.py migrate` worked none of the above answers helped – BGOPC Jan 27 '23 at 12:57

score 0 · Answer 3 · answered Nov 02 '20 at 16:18

0

I had the same issues, and what I did was to run python manage.py makemigrations <app_name> and do not forget to add <app_name> to INSTALLED_APPS in your settings.py file

answered Nov 02 '20 at 16:18

helseroc

1
1

score 0 · Answer 4 · answered Jan 30 '23 at 06:51

I've also encountered with the same issue in Postgres DB.

Steps to follow:

remove previous db and create new one
add migration folder and add init.py empty file inside migration folder of each app having models
now use command python manage.py makemigrations
use command python manage.py migrate

Django error: relation "users_user" does not exist

4 Answers4

Linked