group member search could result in fatal error message

Bug #1861370 reported by Cecilia Vela Gurovic
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
Medium
Cecilia Vela Gurovic

Bug Description

group member search could result in fatal error message:
A nonrecoverable error occurred. This probably means you have encountered a bug in the system

in mahara.org we can see that by searching group members and adding the parameters on the url
&limit=10&setlimit=77&sortoption=adminfirst&offset=9860

The offset must be higher than the number of group members in order to trigger the error.

this happens because there is a difference between the SQL query we use for counting the results and the one we use for getting the actual results.
The count can be higher than the result numbers

summary: - group member search could result in fatal error message: A
- nonrecoverable error occurred. This probably means you have encountered
- a bug in the system in mahara.org we can see that by searching group
- members and adding the parameters on the url
- id=1&limit=10&setlimit=77&sortoption=adminfirst&offset=9860 this
- happens because there is a difference between the SQL query we use for
- counting the results and the one we use for getting the actual results
+ group member search could result in fatal error message
Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "master" branch: https://reviews.mahara.org/10739

Changed in mahara:
status: New → In Progress
importance: Undecided → Medium
milestone: none → 20.04.0
Changed in mahara:
assignee: nobody → Cecilia Vela Gurovic (ceciliavg)
Rangi Daymond (rangid)
description: updated
Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/10739
Committed: https://git.mahara.org/mahara/mahara/commit/b275d51059815b139660c2b0286e4980c712a4cc
Submitter: Robert Lyon (<email address hidden>)
Branch: master

commit b275d51059815b139660c2b0286e4980c712a4cc
Author: Cecilia Vela Gurovic <email address hidden>
Date: Thu Jan 30 16:49:11 2020 +1300

Bug 1861370: group member search fatal error

Check offset parameter for pagination works in
- Admin menu-> user search
- Normal menu -> Engage -> group search
- group member search in any agroup

behatnotneeded

Change-Id: Iee1e5761cd4121ad18d513173f2c972dd22650ee

Robert Lyon (robertl-9)
Changed in mahara:
status: In Progress → Fix Committed
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.