django.db.utils.IntegrityError: (1452, 'Cannot add or update a child row: a fore

admin

django.db.utils.IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`tripsql`.`django_admin_log`, CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`))')
, b/ e) h; O5 k, T2 g. Q[23/Jul/2025 12:59:55] "POST /admin/accounts/user/4/change/ HTTP/1.1" 500 241942

$ j9 D, C* s* R: o
$ H* N/ w9 N3 T1 ~; s8 g

admin

再settings.py 文件中添加
  h* t; s' J% J: {/ s
7 Y5 W0 y, z3 ~& `7 }% [3 T. ODATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
+ K+ \2 b" j. d( S( |7 o        'NAME': 'tripsql',
        'USER': 'tripuser',
. v  \% ]( P0 S. d( H0 g: m3 _        'PASSWORD': 'tPasword',
        'HOST': '192.168.ip',
& U  @  K0 U  ~7 n0 x        'PORT': '3306',
/ j0 g0 O4 J0 }2 r        'OPTIONS': {
7 d" @; a. g* Z0 A- h            "init_command": "SET foreign_key_checks =0;",
        }
    }
}
: a% N5 k" m( u* c" G

admin

admin 发表于 2025-7-23 13:50
, }/ ]' J) W# _) a9 B- `再settings.py 文件中添加
- |+ Q* s9 J+ O9 R1 i
DATABASES = {

即可解决报错问题