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?