提问人:Davor_Python 提问时间:11/14/2023 更新时间:11/14/2023 访问量:27
Django django_admin_log表中的外键约束失败 IntegrityError 1452 AbstractBaseUser
Foreign key constraint failure in Django's django_admin_log table IntegrityError 1452 AbstractBaseUser
问:
我在处理 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`))')
我尝试删除迁移和数据库,但仍然遇到相同的错误。
问题概述:
- 错误消息似乎表明 django_admin_log 表中的 user_id 字段存在问题,引用了auth_user表。
- 我已经验证了我尝试插入或更新auth_user表中存在的user_id值。
- 我正在使用 Django,并怀疑外键关系或数据完整性可能存在问题。
答: 暂无答案
评论