Django django_admin_log表中的外键约束失败 IntegrityError 1452 AbstractBaseUser

Foreign key constraint failure in Django's django_admin_log table IntegrityError 1452 AbstractBaseUser

提问人:Davor_Python 提问时间:11/14/2023 更新时间:11/14/2023 访问量:27

问:

我在处理 Django 项目时遇到与外键约束相关的错误。尝试添加或更新django_admin_log表中的记录时,会出现以下错误:

这是我 model.py:

from django.contrib.auth.models import AbstractBaseUser, BaseUserManager, PermissionsMixin, Permission,Group
from django.db import models
from django.core.validators import EmailValidator
from django.core.exceptions import ValidationError
import re
from phonenumber_field.modelfields import PhoneNumberField
from apps.location.models import City
from django.utils import timezone

class CustomUserManager(BaseUserManager):
    def create_user(self, email, password=None, **extra_fields):
        if not email:
            raise ValueError('The Email field must be set')
        email = self.normalize_email(email)
        user = self.model(email=email, **extra_fields)
        user.set_password(password)
        user.save(using=self._db)
        return user

    def create_superuser(self, email, password=None, **extra_fields):
        extra_fields.setdefault('is_staff', True)
        extra_fields.setdefault('is_superuser', True)

        if extra_fields.get('is_staff') is not True:
            raise ValueError('Superuser must have is_staff=True.')
        if extra_fields.get('is_superuser') is not True:
            raise ValueError('Superuser must have is_superuser=True.')

        return self.create_user(email, password, **extra_fields)

class UserType(models.Model):
    name = models.CharField(max_length=30, unique=True)

    def __str__(self):
        return self.name


def validate_password_strength(value):
    if not re.match(r'^(?=.*[A-Z])(?=.*[!@#$%^&*()_+{}|:;<>,.?/~]).{8,}$', value):
        raise ValidationError("Password must meet the specified requirements.")


class CustomUser(AbstractBaseUser, PermissionsMixin):
    email = models.EmailField(unique=True, validators=[EmailValidator(message="Enter a valid email address.")])
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)
    city = models.ForeignKey(City, on_delete=models.CASCADE, null=True)
    address = models.CharField(max_length=50)# Add the address field
    is_active = models.BooleanField(default=True)
    is_staff = models.BooleanField(default=False)
    user_type = models.ForeignKey(UserType, on_delete=models.CASCADE, null=True, blank=True)
    date_joined = models.DateTimeField(auto_now_add=True)
    last_login = models.DateTimeField(auto_now=True)
    profile_image = models.ImageField(upload_to='user_images/', blank=True, null=True)
    password = models.CharField(max_length=128, validators=[validate_password_strength])
    phone_number = PhoneNumberField(unique=True)
    date_joined = models.DateTimeField(default=timezone.now, editable=False)  # Use 'date_joined' for time of registration

# Additional field for password confirmation
    password_confirmation = models.CharField(max_length=128)
    groups = models.ManyToManyField(Group, blank=True, related_name='customuser_set')
    user_permissions = models.ManyToManyField(Permission, blank=True, related_name='customuser_set')
    USERNAME_FIELD = 'email'
    REQUIRED_FIELDS = ['first_name', 'last_name', 'address', 'phone_number','date_joined']
    objects = CustomUserManager()

    def save(self, *args, **kwargs):
        super().save(*args, **kwargs)

        if self.user_type and self.user_type.name == "Majstor":
            if not hasattr(self, 'majstor_profile'):
                MajstorProfile.objects.create(user=self)
            else:
                self.majstor_profile.save()
        else:
            if hasattr(self, 'majstor_profile'):
                self.majstor_profile.delete()

class MajstorProfile(models.Model):
    user = models.OneToOneField(CustomUser, on_delete=models.CASCADE, related_name='majstor_profile')
    bio = models.TextField(blank=True, null=True)
    education = models.CharField(max_length=100, blank=True, null=True)
    years_of_activity = models.CharField(max_length=50, blank=True, null=True)
    services_role = models.CharField(max_length=50, blank=True, null=True)

    def __str__(self):
        return f"Profile for {self.user.email} - {self.user.user_type.name}"

    class Meta:
        verbose_name = 'Majstor Profile'
        verbose_name_plural = 'Majstor Profiles'

    def save(self, *args, **kwargs):
        if self.user.user_type.name == "Majstor":
            super(MajstorProfile, self).save(*args, **kwargs)
        else:
            # You can choose to not save the profile for other user types
            # or raise an exception or handle it in any other way as needed.
            pass

我在 settings.py 中设置了它:

AUTH_USER_MODEL = 'user.CustomUser'

创建新的超级用户并登录我的管理面板后。它工作正常,但是在我想在我的数据库中添加或更改内容后,显示错误:

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

我尝试删除迁移和数据库,但仍然遇到相同的错误。

问题概述:

  1. 错误消息似乎表明 django_admin_log 表中的 user_id 字段存在问题,引用了auth_user表。
  2. 我已经验证了我尝试插入或更新auth_user表中存在的user_id值。
  3. 我正在使用 Django,并怀疑外键关系或数据完整性可能存在问题。
python mysql django 身份验证 模型

评论


答: 暂无答案