-
Bug
-
Resolution: Fixed
-
Minor
-
2.0.5, 2.1.2, 2.2
-
None
-
MySQL
-
MOODLE_20_STABLE, MOODLE_21_STABLE, MOODLE_22_STABLE
-
MOODLE_20_STABLE, MOODLE_21_STABLE
-
-
Going to site "Site administration ► Reports ► Logs" runs out of memory on our Moodle installation.
Our site:
- PHP memory limit: 128M
- ~ 75 000 rows in users table.
Little debugging shows, that the problem is in:
#0 /home/moodle/public_html/lib/accesslib.php(3259): mysqli_native_moodle_database->get_records_sql('SELECT u.id, u....', Array, 0, 0)
|
#1 /home/moodle/public_html/course/report/log/lib.php(353): get_enrolled_users(Object(stdClass), '', 0, 'u.id, u.firstna...', 'lastname ASC, f...')
|
#2 /home/moodle/public_html/course/report/log/index.php(157): print_log_selector_form(Object(stdClass), 0, '1318712400', '', '', '', 0, 0, 1, 'showashtml')
|
#3 {main}
|