ProgrammingError: relation "auth_user" does not exist.

[Biplab Gautam]

I tried to set up custom user model by inheriting from AbstractBaseUser as instructed in django documentation, but I am encountering relation "auth_user" does not exist error.

#models.py

from django.db import models

from django.contrib.auth.models import (BaseUserManager, AbstractBaseUser)

class MyUserManager(BaseUserManager):

def create_user(self, email, date_of_birth, password=None):

"""Creates and saves the user with the given email, DOB and password"""

if not email:

raise ValueError('Users must have an email address')

user = self.model(email=self.normalize_email(email),date_of_birth=date_of_birth,)

user.set_password(password)

user.save(using=self._db)

return user

def create_superuser(self, email, date_of_birth, password):

"""Creates and saves a superuser with the given email, date of birth and password."""

user = self.create_user(email, password=password, date_of_birth=date_of_birth)

user.is_admin = True

user.save(using=self._db)

return user

class MyUser(AbstractBaseUser):

email = models.EmailField(verbose_name='email address', max_length=255, unique=True,)

date_of_birth = models.DateField()

is_active = models.BooleanField(default=True)

is_admin = models.BooleanField(default=False)

objects = MyUserManager()

USERNAME_FIELD = 'email'

REQUIRED_FIELDS = ['date_of_birth']

def get_full_name(self):

return self.email

def get_short_name(self):

return self.email

def __str__(self):

return self.email

def has_perm(self, perm, obj=None):

return True

def has_module_perms(self, app_label):

return True

@property

def is_staff(self):

return self.is_admin

#admin.py

from django import forms

from django.contrib import admin

from django.contrib.auth.models import Group

from django.contrib.auth.admin import UserAdmin as BaseUserAdmin

from django.contrib.auth.forms import ReadOnlyPasswordHashField

from user.models import MyUser

class UserCreationForm(forms.ModelForm):

"""A form for creating new users. Includes all the required fields, plus a repeated password."""

password1 = forms.CharField(label='Password', widget=forms.PasswordInput)

password2 = forms.CharField(label='Password confirmation', widget=forms.PasswordInput)

class Meta:

model = MyUser

fields = ('email', 'date_of_birth')

def clean_password2(self):

"""Check that the two password entries match"""

password1 = self.cleaned_data.get("password1")

password2 = self.cleaned_data.get("password2")

if password1 and password2 and password1 != password2:

raise forms.ValidationError("Passwords don't match")

return password2

def save(self, commit=True):

#Save the provided password in hashed format

user = super(UserCreationForm, self).save(commit=False)

user.set_password(self.cleaned_data["password1"])

if commit:

user.save()

return user

class UserChangeForm(forms.ModelForm):

"""A form for updating users. Includes all the fields on the user, but replaces the password field with admin's password hash display field."""

password = ReadOnlyPasswordHashField()

class Meta:

model = MyUser

fields = ('email', 'password', 'date_of_birth', 'is_active', 'is_admin')

def clean_password(self):

return self.initial["password"]

        # Regardless of what the user provides, return the initial value.

        # This is done here, rather than on the field, because the

        # field does not have access to the initial value

class UserAdmin(BaseUserAdmin):

    # The forms to add and change user instances

    form = UserChangeForm

    add_form = UserCreationForm

    # The fields to be used in displaying the User model.

    # These override the definitions on the base UserAdmin

    # that reference specific fields on auth.User.

    list_display = ('email', 'date_of_birth', 'is_admin')

    list_filter = ('is_admin',)

    fieldsets = (

        (None, {'fields': ('email', 'password')}),

        ('Personal info', {'fields': ('date_of_birth',)}),

        ('Permissions', {'fields': ('is_admin',)}),

    )

    # add_fieldsets is not a standard ModelAdmin attribute. UserAdmin

    # overrides get_fieldsets to use this attribute when creating a user.

    add_fieldsets = (

        (None, {

            'classes': ('wide',),

            'fields': ('email', 'date_of_birth', 'password1', 'password2')}

        ),

    )

    search_fields = ('email',)

    ordering = ('email',)

    filter_horizontal = ()

# Now register the new UserAdmin...

admin.site.register(MyUser, UserAdmin)

# ... and, since we're not using Django's built-in permissions,

# unregister the Group model from admin.

admin.site.unregister(Group)

#views.py

from django.shortcuts import render

from django.http import HttpResponseRedirect

from django.core.urlresolvers import reverse

from django.contrib.auth import login, authenticate, logout

from django.contrib.auth.forms import UserCreationForm

def logout_view(request):

"""Log the user out """

logout(request)

return HttpResponseRedirect(reverse('home_page:subject_select'))

def register(request):

"""Registers a new user"""

if request.method != 'POST':

#Display blank registration form.

form = UserCreationForm()

else:

#Process completed form.

form = UserCreationForm(data=request.POST)

if form.is_valid():

new_user = form.save()

#Log the user in and then redirect to the home page

authenticated_user = authenticate(email = new_user.email, password = request.POST['password1'])

login(request, authenticated_user)

return HttpResponseRedirect(reverse('home_page:subject_select'))

context = {'form': form}

return render(request, 'user/register.html', context)

#register.html

<!-- User registration page -->

<form method="post" action="{%url 'user:register' %}">

{% csrf_token %}

{{ form.as_p }}

<button name="submit">register</button>

<input type="hidden" name="next" value="{% url 'home_page:subject_select' %}"/>

</form>

################

I have also configured settings.py as instructed in the documentation.

Please help.

[Collin Anderson]

Hi,

Have you tried running ./manage.py makemigrations and then ./manage.py migrate? That's needed to actually create the table.

Collin