To whom it may concern,
I am the administrator of our institution's Moodle site, and we are facing problem after upgrading Moodle 3.3 to Moodle 3.5.1+
The problems that our teachers are facing the following:
1. One of our teacher once trying to access the assignment activity in his course, it takes too much time to load the liste, while other activities are functionning normally,
2. Another teacher once she enters her course, she receives an error reading the database. After activating the debuggin mode, below is the message that we receivied
Debug info: ERROR:
more than one row returned by a subquery used as an expression
SELECT f.id, COUNT(p.id) AS unread
FROM mdl_forum_posts p
JOIN mdl_forum_discussions d ON d.id = p.discussion
JOIN mdl_forum f ON f.id = d.forum
JOIN mdl_course c ON c.id = f.course
LEFT JOIN mdl_forum_read r ON (r.postid = p.id AND r.userid = $1)
LEFT JOIN mdl_forum_track_prefs tf ON (tf.userid = $2 AND tf.forumid = f.id)
WHERE f.course = $3
AND p.modified >= $4 AND r.id is NULL
AND ((f.trackingtype = 1 OR f.trackingtype = 2)
AND tf.id IS NULL
AND (SELECT trackforums FROM mdl_user WHERE id = $5) = 1)
GROUP BY f.id
[array (
0 => '5',
1 => '5',
2 => '479',
3 => 1534935600.0,
4 => '5',
)]
Error code: dmlreadexception
×Stack trace:
· line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
· line 248 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
· line 859 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
· line 6501 of /mod/forum/lib.php: call to pgsql_native_moodle_database->get_records_sql()
· line 6532 of /mod/forum/lib.php: call to forum_tp_get_course_unread_posts()
· line 7486 of /mod/forum/lib.php: call to forum_tp_count_forum_unread_posts()
· line 2095 of /lib/modinfolib.php: call to forum_cm_info_view()
· line 2123 of /lib/modinfolib.php: call to cm_info->call_mod_function()
· line 1424 of /lib/modinfolib.php: call to cm_info->obtain_view_data()
· line 1235 of /lib/modinfolib.php: call to cm_info->get_after_link()
· line 919 of /course/renderer.php: call to cm_info->__get()
· line 846 of /course/renderer.php: call to core_course_renderer->course_section_cm()
· line 1039 of /course/renderer.php: call to core_course_renderer->course_section_cm_list_item()
· line 888 of /course/format/renderer.php: call to core_course_renderer->course_section_cm_list()
· line 57 of /course/format/topics/format.php: call to format_section_renderer_base->print_multiple_section_page()
· line 280 of /course/view.php: call to require()