IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constrai nt fails (`mxonline

IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`mxonline`.`django_admin_log`, CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`))')

解决方案

settings.py
中
增加

'OPTIONS': {        "init_command": "SET foreign_key_checks = 0;",        }

修改成

# Database# https://docs.djangoproject.com/en/1.9/ref/settings/#databasesDATABASES = {    'default': {        'ENGINE': 'django.db.backends.mysql',        'NAME': 'mxonline',        'USER': 'root',        'PASSWORD': 'root',        'HOST': '127.0.0.1',        'OPTIONS': {        "init_command": "SET foreign_key_checks = 0;",        }    }}