From 84389cd4407ba23e7f441dae1dd1ce4b57a367c2 Mon Sep 17 00:00:00 2001 From: yleclanche Date: Mon, 12 Aug 2019 16:49:22 +0200 Subject: [PATCH] Fix crash when there are more than 61 quotas "MariaDB can only use 61 tables in a join" --- teleforma/views/crfpa.py | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/teleforma/views/crfpa.py b/teleforma/views/crfpa.py index 104b47a4..8b7da0eb 100644 --- a/teleforma/views/crfpa.py +++ b/teleforma/views/crfpa.py @@ -66,10 +66,11 @@ def get_crfpa_courses(user, date_order=False, num_order=False, period=None): types=CourseType.objects.all()) elif quotas and not user.is_staff: - queryset = Course.objects.all() + corrector_courses = set() for quota in quotas: - queryset = queryset.filter(quotas=quota) - courses = format_courses(courses, queryset=queryset, + corrector_courses.add(quota.course) + for course in corrector_courses: + courses = format_courses(courses, course=course, types=CourseType.objects.all()) elif student: -- 2.39.5