Skip to content

Django – no such table exception

In Django, I’ve added some models into After makemigrations, migrate raised this exception:

django.db.utils.OperationalError: no such table: auth_test_usertranslatorprofile

So I’ve removed all old migrations and run makemigrations and migrate again which seemed to work.

Unfortunately, I’ve noticed that it didn’t helped because when I try to click on User customer profiles of User translator profiles it raises exception:


Request Method: GET
Request URL:

Django Version: 1.8.7
Python Version: 2.7.10
Installed Applications:
Installed Middleware:

File "" in get_response
  132.                     response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "" in wrapper
  618.                 return self.admin_site.admin_view(view)(*args, **kwargs)
File "" in _wrapped_view
  110.                     response = view_func(request, *args, **kwargs)
File "" in _wrapped_view_func
  57.         response = view_func(request, *args, **kwargs)
File "" in inner
  233.             return view(request, *args, **kwargs)
File "" in _wrapper
  34.             return bound_func(*args, **kwargs)
File "" in _wrapped_view
  110.                     response = view_func(request, *args, **kwargs)
File "" in bound_func
  30.                 return func.__get__(self, type(self))(*args2, **kwargs2)
File "" in changelist_view
  1550.                 self.list_max_show_all, self.list_editable, self)
File "" in __init__
  82.         self.get_results(request)
File "" in get_results
  177.         result_count = paginator.count
File "" in _get_count
  72.                 self._count = self.object_list.count()
File "" in count
  318.         return self.query.get_count(using=self.db)
File "" in get_count
  466.         number = obj.get_aggregation(using, ['__count'])['__count']
File "" in get_aggregation
  447.         result = compiler.execute_sql(SINGLE)
File "" in execute_sql
  840.             cursor.execute(sql, params)
File "" in execute
  79.             return super(CursorDebugWrapper, self).execute(sql, params)
File "" in execute
  64.                 return self.cursor.execute(sql, params)
File "" in __exit__
  98.                 six.reraise(dj_exc_type, dj_exc_value, traceback)
File "" in execute
  64.                 return self.cursor.execute(sql, params)
File "" in execute
  318.         return Database.Cursor.execute(self, query, params)

Exception Type: OperationalError at /admin/auth_test/usertranslatorprofile/
Exception Value: no such table: auth_test_usertranslatorprofile

I’m attaching my files:


from django.db import models
from django.contrib.auth.models import User

class Language(models.Model):
    shortcut = models.CharField(max_length=6)
    name = models.CharField(max_length=50)
    price_per_sign = models.FloatField()

class UserTranslatorProfile(models.Model):
    user = models.OneToOneField(User)
    languages = models.ManyToManyField(Language)
    price_per_word = models.FloatField()

class UserCustomerProfile(models.Model):
    user = models.OneToOneField(User)


from django import forms
from .models import Language
from django.contrib.auth.models import User
from django.contrib.auth.forms import UserCreationForm
class FreelancerRegistrationForm(forms.Form):
    language = forms.ModelChoiceField(queryset=Language.objects.all().order_by('shortcut'))

Do you know where is the problem? Thanks



I solved the same problem with these steps :

  • Delete your database (db.sqlite3 in my case) in your project directory
  • Remove everything from __pycache__ folder under your project subdirectory
  • For the application you are trying to fix, go to the folder and clear migrations and __pycache__ directories

When you are sure you have cleared all the above files, run:

python makemigrations
python migrate

I hope this helps.

10 People found this is helpful