Django提交表单遇‘Field 'id' expected a number’错误求助

错误核心原因 #

你遇到的TypeError: Field 'id' expected a number but got <QueryDict: {...}>，本质是将整个请求的QueryDict对象直接赋值给了外键字段。Django的外键字段要求接收对应模型的实例或主键ID（数字类型），而不是包含所有表单数据的字典，因此触发类型错误。

分步解决方法 #

1. 检查模型与表单定义 #

假设你的基础模型结构如下，表单应只暴露需要用户交互的字段（比如completed），外键字段（student/chapter）由视图逻辑自动赋值，不需要放到表单里：

# models.py
from django.db import models
from django.contrib.auth.models import User

class Student(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE)
    # 其他学生相关字段

class Chapter(models.Model):
    title = models.CharField(max_length=200)
    # 其他章节相关字段

class StudentProgress(models.Model):
    student = models.ForeignKey(Student, on_delete=models.CASCADE)
    chapter = models.ForeignKey(Chapter, on_delete=models.CASCADE)
    completed = models.BooleanField(default=False)
    completed_at = models.DateTimeField(null=True, blank=True)

# forms.py
from django import forms
from .models import StudentProgress

class StudentProgressForm(forms.ModelForm):
    class Meta:
        model = StudentProgress
        fields = ['completed']  # 仅保留需要用户操作的字段

2. 修正视图逻辑 #

视图中需要先获取当前用户对应的Student实例，以及目标Chapter实例，再将这些实例赋值给StudentProgress的外键字段，而非直接使用request.POST：

# views.py
from django.shortcuts import get_object_or_404, redirect
from django.contrib.auth.decorators import login_required
from .models import Student, Chapter, StudentProgress
from .forms import StudentProgressForm

@login_required
def mark_chapter_completed(request, chapter_id):
    # 获取当前登录用户对应的Student实例
    student = get_object_or_404(Student, user=request.user)
    # 获取目标章节
    chapter = get_object_or_404(Chapter, id=chapter_id)

    if request.method == 'POST':
        # 用get_or_create避免重复创建进度记录，同时处理创建/更新场景
        progress, created = StudentProgress.objects.get_or_create(
            student=student,
            chapter=chapter,
            defaults={'completed': True}
        )
        # 如果是已存在的记录，更新完成状态
        if not created:
            progress.completed = True
            progress.save()
        return redirect('chapter_detail', chapter_id=chapter_id)
    
    # GET请求渲染表单（如果需要）
    form = StudentProgressForm()
    return render(request, 'mark_completed.html', {'form': form, 'chapter': chapter})

3. 修正HTML表单 #

表单只需提交必要的验证信息，章节ID可通过URL参数传递，或用隐藏字段传入，无需暴露外键输入框：

<!-- mark_completed.html -->
<form method="POST" action="{% url 'mark_chapter_completed' chapter.id %}">
    {% csrf_token %}
    <!-- 若需在表单传章节ID，用隐藏字段 -->
    <input type="hidden" name="chapter_id" value="{{ chapter.id }}">
    <button type="submit">标记章节完成</button>
</form>

更简便的进度追踪方案 #

1. 用get_or_create简化逻辑：自动处理“首次标记完成”和“重复标记更新”的场景，无需手动判断记录是否存在。
2. 自动填充完成时间：通过Django信号实现当completed设为True时，自动赋值completed_at：

# models.py
from django.db.models.signals import pre_save
from django.dispatch import receiver
from django.utils import timezone

@receiver(pre_save, sender=StudentProgress)
def set_completed_time(sender, instance, **kwargs):
    if instance.completed and not instance.completed_at:
        instance.completed_at = timezone.now()

3. 跳过表单直接处理请求：如果不需要复杂的表单验证，可直接在视图中处理POST请求，省去表单定义的步骤：

@login_required
def mark_chapter_completed(request, chapter_id):
    student = get_object_or_404(Student, user=request.user)
    chapter = get_object_or_404(Chapter, id=chapter_id)
    if request.method == 'POST':
        StudentProgress.objects.update_or_create(
            student=student,
            chapter=chapter,
            defaults={'completed': True, 'completed_at': timezone.now()}
        )
        return redirect('chapter_detail', chapter_id=chapter_id)

内容的提问来源于stack exchange，提问作者Jerome Kambafwile