auth_user error with Django 1.8 and syncdb / migra

2019-03-09 06:41发布

When upgrading to Django 1.8 (with zc.buildout) and running syncdb or migrate, I get this message:

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

One of my models contains django.contrib.auth.models.User:

user = models.ForeignKey(
    User, related_name='%(app_label)s_%(class)s_user',
    blank=True, null=True, editable=False
)

Downgrading to Django 1.7 removes the error. Do I have to include the User object differently in Django 1.8?

9条回答
相关推荐>>
2楼-- · 2019-03-09 07:15

To fix this problem here is what I did:

1) Find all foreign key relation fields like OneToOneField, ForeignKey and ManyToManyFields in your project, including any reusable apps that are referring to auth.User or import User and set it to settings.AUTH_USER_MODEL as above. At minimum use:

'auth.User'

2) For all the models that have the above, make sure the models have a valid django migration (not south). If they have south migrations, rename the directory to migrations_south and then run the makemigrations command for that app:

./manage.py makemigrations affected_app

Sometimes there is a django migrations folder under a different name, not the default migrations directory. In such cases, reference this via MIGRATION_MODULES in your settings.py:

MIGRATION_MODULES = {'filer': 'filer.migrations_django'}

Since the issue was hard to find on larger projects, I commented out all custom apps in INSTALLED_APPS in settings.py and ran the test command, since it will run migrate and try to re-create the database for you:

./manage.py test

Looks like that fixed it for me. I'm not sure if step 1 is mandatory or just best practice. But you definitely need to convert the apps to migrations.

Cheers!

PS. Be ready for what's coming in Django 1.9. The syncdb command will be removed. The legacy method of syncing apps without migrations is removed, and migrations are compulsory for all apps.

查看更多
Melony?
3楼-- · 2019-03-09 07:16

If you are using heroku like I was run

heroku run python manage.py makemigrations

This will likely give you a message saying there are now changes. Ignore that then run

heroku run python manage.py migrate

this will give you some output suggesting something has been done. Finally run

heroku run python manage.py createsuperuser
查看更多
兄弟一词,经得起流年.
4楼-- · 2019-03-09 07:17

Maybe you have found the answer and resolved the problem, but I wanted to point out that, in my case, the above problem was solved by dropping the database and re-creating it again, with the full privileges of the users. I was able to do this because I'm working on a non-production environment, but doing this on a staging environment is not a good idea, so be careful.

Im using python 2.7.12 and following are the specifications of my virtualenv:

Django==1.10.5
django-crispy-forms==1.6.1
django-registration-redux==1.4
djangorestframework==3.5.3
olefile==0.44
packaging==16.8
Pillow==4.0.0
psycopg2==2.6.2
查看更多
姐就是有狂的资本
5楼-- · 2019-03-09 07:18

Try referring to the User using this

from django.conf import settings
user = models.ForeignKey(settings.AUTH_USER_MODEL, related_name='%(app_label)s_%(class)s_user', blank=True, null=True, editable=False)
查看更多
再贱就再见
6楼-- · 2019-03-09 07:22

I've migrated an old Django 1.6 project to Django 1.8 and previously we've used syncdb to migrate the database and we did not have initial migration steps for all apps in our project. With Django 1.8, you'll need a working database migrations. Running

manage.py makemigrations <app_name>

for all apps in our project fixed our problems.

查看更多
Viruses.
7楼-- · 2019-03-09 07:26

I fix this by running auth first, then the rest of my migrations:

python manage.py migrate auth
python manage.py migrate
查看更多
登录 后发表回答