79394115

Date: 2025-01-28 14:15:06
Score: 1
Natty:
Report link

Same Issue has happened In my case.

@admin.register(AcademicFee)
class AcademicFeeAdmin(admin.ModelAdmin):
    model = AcademicFee
    list_display = ('academic', 'name', 'fee', 'created_by', 'updated_by')
    search_fields = ('academic__name', 'name', 'created_by')
    readonly_fields = ('created_by', 'created_date', 'updated_by', 'updated_date')

Getting error Operation Error......at most 64 table in a join

Because of field created_by and updated_by they are ForeignKey to User Table adding list_select_related to AcademicFeeAdmin resolve this issue

@admin.register(AcademicFee)
class AcademicFeeAdmin(admin.ModelAdmin):
    model = AcademicFee
    list_display = ('academic', 'name', 'fee', 'created_by', 'updated_by')
    search_fields = ('academic__name', 'name', 'created_by')
    readonly_fields = ('created_by', 'created_date', 'updated_by', 'updated_date')
    #added below line
    list_select_related = ('created_by', 'updated_by')

In your case you need to use select_related to some of those fields which are related ie (FK) also look into this post What's the difference between select_related and prefetch_related in Django ORM?

Reasons:
  • Whitelisted phrase (-1): In your case
  • RegEx Blacklisted phrase (1): Same Issue
  • Long answer (-1):
  • Has code block (-0.5):
  • Ends in question mark (2):
  • Low reputation (0.5):
Posted by: Azhar Uddin Sheikh