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`))')
[23/Jul/2025 12:59:55] "POST /admin/accounts/user/4/change/ HTTP/1.1" 500 241942
! @7 H, v$ a/ @: o$ D* I6 G( j
8 u- r" o! w$ W& a

admin

再settings.py 文件中添加
% a& h, z% h- K
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
! s8 d! p: O2 A$ _        'NAME': 'tripsql',
        'USER': 'tripuser',
. Y* g. C; _5 J5 W- @4 ?+ p6 e        'PASSWORD': 'tPasword',
/ P' c  y3 L% j        'HOST': '192.168.ip',
7 P0 F5 @% N8 }" m        'PORT': '3306',
        'OPTIONS': {
            "init_command": "SET foreign_key_checks =0;",
) A( `9 r5 L! n+ w: X        }
9 d) K6 M' T" @2 ]    }
}
& W) h5 |- G2 O

admin

admin 发表于 2025-7-23 13:50
- P- O; P, m4 w. B1 z再settings.py 文件中添加

DATABASES = {

即可解决报错问题