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
* t$ Y: b) P4 D
. o9 B4 k$ \2 @  @$ [
' o2 q$ U# P6 k1 b

admin

再settings.py 文件中添加

3 |( U' L' y2 J  ^* RDATABASES = {
& `+ ]$ Z! V; \* @1 N6 X, E    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'tripsql',
2 i3 e6 Q& S3 q( c. L0 @        'USER': 'tripuser',
* A) H, s( j0 F; K6 u, @. _        'PASSWORD': 'tPasword',
        'HOST': '192.168.ip',
        'PORT': '3306',
        'OPTIONS': {
. {8 n9 E: E& S            "init_command": "SET foreign_key_checks =0;",
1 w* ]5 {; u; g2 N/ N3 b        }
/ L& u% R$ [5 Y! ?2 ?    }
) K) u# g; T, ?. ^$ {& T}

admin

admin 发表于 2025-7-23 13:50
! N5 @( v, h1 E0 M再settings.py 文件中添加
+ u& l2 J* @% S3 B
4 I2 E4 Z% ^6 g3 Z+ R; |2 w( J0 JDATABASES = {

即可解决报错问题