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`))')
# T& U, e# H& j[23/Jul/2025 12:59:55] "POST /admin/accounts/user/4/change/ HTTP/1.1" 500 241942

. y4 Y" N, a/ d# E7 h% N
# Y& O- M6 F8 }+ h  n

admin

再settings.py 文件中添加

" a' q2 z7 \$ ]% ^DATABASES = {
' j- k9 p2 P( u    'default': {
5 {8 r) ]0 _$ Z( [; O% r" ]        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'tripsql',
4 t- B# n' e- U7 B        'USER': 'tripuser',
        'PASSWORD': 'tPasword',
( Q, O) b; J0 o; E1 R- t% b        'HOST': '192.168.ip',
0 ~9 M8 d. u( }- q* J0 y        'PORT': '3306',
2 _: E* ]$ a+ L4 Z+ M. V' }        'OPTIONS': {
5 d; {9 }. B" p5 y" Q' [% F            "init_command": "SET foreign_key_checks =0;",
, f1 i8 [. W# ^8 I( h3 R1 n  k2 H        }
6 T; c  W$ [0 D/ c+ e5 F& V- ~* p    }
% T5 A; I  Y  m+ e: s6 ^$ Z}

admin

admin 发表于 2025-7-23 13:50
1 r) Q8 M3 M7 ]2 o0 w  r* q再settings.py 文件中添加

DATABASES = {

即可解决报错问题