django.db.utils.ProgrammingError: relation "auth_user" does not exist - django 2.0.2

Question

I've tried all of the solutions from the top results for this question on Google; none of them work for my situation:

doing python manage.py migrate auth before `python manage.py migrate didn't work (same error)
changing all references to 'auth.User' in my models to AUTH_USER_MODEL didn't work (same error), and neither did get_user_model() (makemigrations detected no changes anyway)
doing python manage.py makemigrations [app_with_user_relation] did not work either (migrations were made, but still got the same error)
have deleted and recreated the database multiple times

Does anyone have any new suggestions?

I hear downgrading to Django 1.7 might work, but that is not an option for me.

If anyone is curious, the app I am trying to migrate is powerdns, from the open source package django-powerdns-manager.

Full traceback: https://dpaste.de/JdT5

The failing migration: https://dpaste.de/rfUn

Custom db router: https://github.com/mike-johnson-jr/django-powerdns-manager/blob/master/src/powerdns_manager/routers.py

Please post the traceback. If you get that error during a migrate call, it's likely that your app is trying to access an User object too early (for example during import time). — AKX
– AKX, Commented Sep 9, 2018 at 18:02
Cheers. What about showmigrations? Does it show the migration containing the user relation to be run? — AKX
– AKX, Commented Sep 9, 2018 at 18:18

Mike Johnson Jr · Accepted Answer · 2018-09-09 19:19:39Z

2

Custom database router routes migrations with app label "auth" to my default database rather than my powerdns database. Because of this, powerdns is making a foreignkey reference to another database, which is not possible in neither postgresql nor mysql, only sqlite. In mysql, error will be "cannot create foreign key constraint"

You can solve this error by only using 1 database or using sqlite for both.

edited Sep 9, 2018 at 19:19

answered Sep 9, 2018 at 18:43

Mike Johnson Jr

7962 gold badges15 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AKX Over a year ago

Glad you got things solved. You may want to add the fact that you have a custom router to the original question and/or the title for added google-fu.

Collectives™ on Stack Overflow

django.db.utils.ProgrammingError: relation "auth_user" does not exist - django 2.0.2

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related