Fixing the error: django.db.utils.OperationalError: no such table: auth_group

Question

I'm trying to run some simple tests with command: python manage.py test

When I do it, I get the error saying

File "/Users/petka/.local/share/virtualenvs/movie_platform-wu_Kht1X/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 394, in execute return Database.Cursor.execute(self, query) django.db.utils.OperationalError: no such table: auth_group

Anyone knows how to fix this?

movies_app/tests.py

    from django.test import TestCase

    class SmokeTest(TestCase):

    def test_bad_maths(self):
        self.assertEqual(1 + 1, 3)

Have you found a fix? I have the exact same error, but auth_group is no where in my code. — L C
– L C, Commented Jun 28, 2020 at 8:55

L C · Accepted Answer · 2020-06-28 09:16:10Z

I tried deleting my db.sqlite3, migrations & pycache folder then running makemigrations, syncdb...etc as several posts suggest, but it threw the exact same error, sqlite3.OperationalError: no such table: auth_group.

Here's what worked for me: Comment out everything in urls.py and admin.py, the run makemigrations & migrate.

Details: Commenting out urls.py then running makemigrations threw the same error, but in the traceback it pointed to a line of code in admin.py that was trying to access or create a new instance in the db. I then commented out everything in admin.py and re-ran ./manage.py makemigrations & ./manage.py migrate in pipenv and it worked! The migrations folder was present when I did this (pulled it from git after deleting it in other attempts to solve the problem), so I'm guessing there's no need to delete it.

user11558784 · Accepted Answer · 2020-01-08 15:33:29Z

0

have you migrated? if not then run the following commands

python manage.py makemigrations
python manage.py migrate

answered Jan 8, 2020 at 15:33

user11558784

Comments

Shil Nevado · Accepted Answer · 2020-10-13 11:39:56Z

0

My fix was to execute the migration in the database that is used for tests. For some reason, you need to have it updated, even if it recreates everything.

answered Oct 13, 2020 at 11:39

Shil Nevado

7761 gold badge11 silver badges32 bronze badges

Collectives™ on Stack Overflow

Fixing the error: django.db.utils.OperationalError: no such table: auth_group

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related