Hmm, quite unusual. I suppose you likely don’t have access to your MySQL config file to make the recommended change to the SQL_BIG_SELECTS or MAX_JOIN_SIZE values. It’d be interesting to see if you have any way to know what the MAX_JOIN_SIZE value is, at the very least.
A couple things to try:
- In attendance.php, before the offending query (around line 359), you could add the following code:
$pdo->statement("SET SQL_BIG_SELECTS=1");Not an ideal solution, but might work. - Adding an index to the table theoretically could reduce the cartesian estimate of the join size. Try running the following on your system:
ALTER TABLE `gibbonAttendanceLogPerson` ADD INDEX(`context`, `gibbonCourseClassID`);
Hope this helps!