Re: ProgrammingError: relation "auth_user" does not exist.

Hi,

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

Collin

On Thursday, December 22, 2016 at 12:25:58 PM UTC-6, Biplab Gautam wrote:

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.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/690fbd83-00b4-47aa-a78d-3e8c61a75dd3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.