Django中Cannot resolve keyword 'mem_ev' into field报错的原因与解决

问题背景 #

我有一个小型Django项目，包含Event、mem_ev两个模型，以及auth User和Profile模型，用户与Event通过mem_ev构成多对多关联。目前列出会员参与活动的接口list_member_events运行正常，但列出活动参与会员的接口list_event_members报错，提示FieldError: 无法将'mem_ev'解析为字段。

相关代码 #

models.py #

from django.db import models
from django.utils.text import slugify
from django.contrib.auth.models import User

class Profile(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE) # Delete profile when user is deleted
    event_count = models.IntegerField(default=0)

    def __str__(self):
        return f'{self.user.username} Profile' #show how we want it to be displayed

class Event(models.Model):
    title = models.CharField(max_length=50)
    slug = models.SlugField(max_length=50,default="", null=False)
    description = models.TextField()
    cost = models.DecimalField(max_digits = 5, decimal_places = 2, default = 0.0)
    event_date = models.DateTimeField(null=True,blank=True)
    attendees = models.IntegerField(default=0)

    class Meta:
        ordering = ['event_date']

    def save(self, *args, **kwargs):
        self.slug = slugify(self.title)
        super(Event, self).save(*args, **kwargs)

    def __str__(self):
        return self.title

class mem_ev(models.Model):
    member_id = models.ForeignKey("Profile",on_delete=models.CASCADE)
    event_id = models.ForeignKey("Event",on_delete=models.CASCADE)
    amt_paid = models.DecimalField(max_digits = 5, decimal_places = 2, default = 0.0)
    date_paid = models.DateTimeField(null=True,blank=True)

views.py #

from django.shortcuts import render, redirect
from django.contrib import messages
from django.contrib.auth.models import User
from django.http import HttpResponse
from django.contrib.auth import authenticate, login
from .models import Event, mem_ev, Profile
from .forms import UserRegistrationForm
from django.contrib.auth.decorators import login_required
from django.contrib.auth import get_user_model

...

def list_event_members(request,id):
    User = get_user_model()
    event_members = User.objects.filter(mem_ev__event_id=id)
    return render(request,'wf/list_event_members.html',{'event_members':event_members})

@login_required
def list_member_events(request,id,username):
    member_events = Event.objects.filter(mem_ev__member_id=id)
    user = User.objects.get(username=username)
    return render(request,'wf/list_member_events.html',{'member_events':member_events,'member':user})

错误信息 #

FieldError at /list_event_members/8/

Cannot resolve keyword 'mem_ev' into field. Choices are: date_joined, email, first_name, groups, id, is_active, is_staff, is_superuser, last_login, last_name, logentry, password, profile, user_permissions, username

/home/dconran/django/mysite/wf/views.py, line 33, in list_event_members

        event_members = User.objects.filter(mem_ev__event_id=id)
                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

原因分析 #

• list_member_events正常的原因：Event和mem_ev是直接外键关联（mem_ev的event_id字段指向Event），Django允许通过小写模型名mem_ev进行反向跨表查询，因此Event.objects.filter(mem_ev__member_id=id)可以正确找到关联该会员的所有活动。
• list_event_members报错的原因：User和mem_ev没有直接关联关系——mem_ev关联的是Profile，而Profile通过一对一字段关联User。直接从User模型查询mem_ev字段时，Django无法识别该关联，因此抛出FieldError。

修复方案 #

方案1：通过Profile关联查询 #

利用User与Profile的一对一反向关联（默认名称为profile），间接关联到mem_ev：

def list_event_members(request,id):
    User = get_user_model()
    # 通过Profile的反向关联，再关联到mem_ev，distinct()避免重复用户
    event_members = User.objects.filter(profile__mem_ev__event_id=id).distinct()
    return render(request,'wf/list_event_members.html',{'event_members':event_members})

方案2：从mem_ev模型出发查询 #

先找到该活动对应的所有mem_ev记录，再关联到User：

def list_event_members(request,id):
    # 获取该活动的所有mem_ev记录
    mem_records = mem_ev.objects.filter(event_id=id)
    # 提取对应的User ID列表
    user_ids = [rec.member_id.user.id for rec in mem_records]
    # 查询去重后的User集合
    event_members = User.objects.filter(id__in=user_ids).distinct()
    return render(request,'wf/list_event_members.html',{'event_members':event_members})

优化建议 #

1. 遵循Python类命名规范：将mem_ev改为MemEv（大驼峰命名），提升代码可读性。
2. 设置明确的related_name：在mem_ev的外键字段中添加related_name，让关联查询更清晰：

   class MemEv(models.Model):
       member = models.ForeignKey("Profile", on_delete=models.CASCADE, related_name='event_participations')
       event = models.ForeignKey("Event", on_delete=models.CASCADE, related_name='member_participations')
       amt_paid = models.DecimalField(max_digits=5, decimal_places=2, default=0.0)
       date_paid = models.DateTimeField(null=True, blank=True)
   

   之后查询可以简化为：
   • 会员的活动：Profile.objects.get(id=id).event_participations.all()
   • 活动的会员：Event.objects.get(id=id).member_participations.all()
3. 简化参数传递：list_member_events中username参数可以通过Profile关联获取，无需单独传入：

   @login_required
   def list_member_events(request, profile_id):
       profile = Profile.objects.get(id=profile_id)
       member_events = Event.objects.filter(mem_ev__member_id=profile_id)
       return render(request,'wf/list_member_events.html',{'member_events':member_events,'member':profile.user})
   

内容的提问来源于stack exchange，提问作者Doug Conran