Django报错Cannot query "admin": Must be "ChatMessage" instance求助

错误信息 #

请求方法:GET
请求URL:http://127.0.0.1:8000/inbox/Django
Django版本:4.2.25
异常类型:ValueError
异常信息:Cannot query "admin": Must be "ChatMessage" instance.
异常位置:D:\Socialmedia.venv\lib\site-packages\django\db\models\sql\query.py，第1253行，check_query_object_type函数中
触发位置:core.views.messages.inbox
Python可执行文件:D:\Socialmedia.venv\Scripts\python.exe
Python版本:3.9.13

视图函数代码 #

def inbox(request):
    if request.user.is_authenticated:
        user_id = request.user
        chat_messages = ChatMessage.objects.filter(
            id__in=Subquery(
                User.objects.filter(
                    Q(chat_sender__chat_receiver=user_id) |
                    Q(chat_receiver__chat_sender=user_id)
                ).distinct().annotate(
                    last_msg=Subquery(
                        ChatMessage.objects.filter(
                            Q(sender=OuterRef('id'), receiver=user_id) |
                            Q(receiver=OuterRef('id'), sender=user_id)
                        ).order_by('-id')[:1].values_list('id', flat=True)
                    )
                ).values_list('last_msg', flat=True).order_by('-id')
            )
        ).order_by('-id')

        context = {
            'chat_messages': chat_messages,
        }
        return render(request, 'chat/inbox.html', context)

模型定义 #

class ChatMessage(models.Model):
    user = models.ForeignKey(User, on_delete=models.SET_NULL, null=True, blank=True, related_name='chat_user')
    chat_sender = models.ForeignKey(User, on_delete=models.SET_NULL, null=True, blank=True, related_name='chat_sender')
    chat_receiver = models.ForeignKey(User, on_delete=models.SET_NULL, null=True, blank=True, related_name='chat_receiver')

    message = models.TextField()
    is_read = models.BooleanField(default=False)
    date = models.DateTimeField(auto_now_add=True)
    mid=ShortUUIDField(length=7,max_length=25,alphabet='abcdefghijklmnopqrstuvwxyz')

    # def __str__(self):
    #     return self.user
    class Meta:
        verbose_name_plural = 'Chat messages'

错误原因 #

1. 字段名不匹配：视图中使用了sender和receiver字段，但模型里对应的是chat_sender和chat_receiver，这会导致查询逻辑错误，引发后续类型校验问题。
2. 子查询模型类型不匹配：外层用ChatMessage.objects.filter(id__in=Subquery(...))过滤消息，但内层子查询基于User模型构建，虽然提取了消息ID，但Django的Subquery在嵌套层级中会校验模型类型，最终触发Must be "ChatMessage" instance的错误。

解决方案 #

方案1：修正字段名并优化子查询逻辑 #

先修正字段名错误，再拆分查询步骤，确保子查询返回正确的ChatMessage ID列表：

from django.db.models import OuterRef, Subquery, Q

def inbox(request):
    if request.user.is_authenticated:
        current_user = request.user
        # 获取所有与当前用户有聊天记录的用户
        chat_partners = User.objects.filter(
            Q(chat_sender__chat_receiver=current_user) |
            Q(chat_receiver__chat_sender=current_user)
        ).distinct()
        
        # 为每个聊天伙伴子查询最后一条消息的ID
        last_msg_subquery = ChatMessage.objects.filter(
            Q(chat_sender=current_user, chat_receiver=OuterRef('id')) |
            Q(chat_receiver=current_user, chat_sender=OuterRef('id'))
        ).order_by('-id')[:1].values_list('id', flat=True)
        
        # 提取所有有效最后消息ID
        last_msg_ids = chat_partners.annotate(
            last_msg_id=Subquery(last_msg_subquery)
        ).values_list('last_msg_id', flat=True).exclude(last_msg_id__isnull=True)
        
        # 获取最终的聊天消息列表并按时间倒序
        chat_messages = ChatMessage.objects.filter(id__in=last_msg_ids).order_by('-date')

        context = {
            'chat_messages': chat_messages,
        }
        return render(request, 'chat/inbox.html', context)

方案2：使用窗口函数简化查询（推荐） #

Django 4.2+支持窗口函数，可直接按对话分组获取最新消息，避免复杂嵌套：

from django.db.models import Window, F, Case, When
from django.db.models.functions import RowNumber

def inbox(request):
    if request.user.is_authenticated:
        current_user = request.user
        # 定义对话分组：将发送者和接收者ID按大小排序拼接，确保每个对话唯一
        chat_group_key = Case(
            When(chat_sender__lt=chat_receiver, then=F('chat_sender') + F('chat_receiver')),
            default=F('chat_receiver') + F('chat_sender'),
            output_field=models.CharField()
        )
        
        # 按对话分组，给每条消息添加行号，最新消息行号为1
        chat_messages = ChatMessage.objects.filter(
            Q(chat_sender=current_user) | Q(chat_receiver=current_user)
        ).annotate(
            row_num=RowNumber(
                partition_by=chat_group_key,
                order_by=F('date').desc()
            )
        ).filter(row_num=1).order_by('-date')

        context = {
            'chat_messages': chat_messages,
        }
        return render(request, 'chat/inbox.html', context)

内容的提问来源于stack exchange，提问作者Futurelink Technologies