Debug info: ERROR: column d.usermodifiedleft does not exist LINE 1: ...a.id = fp.userid JOIN myschool_user la ON la.id = d.usermodi... ^ SELECT d.id AS did, d.course AS dcourse, d.forum AS dforum, d.name AS dname, d.firstpost AS dfirstpost, d.userid AS duserid, d.groupid AS dgroupid, d.assessed AS dassessed, d.timemodified AS dtimemodified, d.usermodified AS dusermodified, d.timestart AS dtimestart, d.timeend AS dtimeend, d.pinned AS dpinned, d.timelocked AS dtimelocked, fp.id AS p_id, fp.discussion AS p_discussion, fp.parent AS p_parent, fp.userid AS p_userid, fp.created AS p_created, fp.modified AS p_modified, fp.mailed AS p_mailed, fp.subject AS p_subject, fp.message AS p_message, fp.messageformat AS p_messageformat, fp.messagetrust AS p_messagetrust, fp.attachment AS p_attachment, fp.totalscore AS p_totalscore, fp.mailnow AS p_mailnow, fp.deleted AS p_deleted, fp.privatereplyto AS p_privatereplyto, fp.wordcount AS p_wordcount, fp.charcount AS p_charcount, fa.id AS fauserpictureid, fa.picture AS fauserrecordpicture, fa.firstname AS fauserrecordfirstname, fa.lastname AS fauserrecordlastname, fa.firstnamephonetic AS fauserrecordfirstnamephonetic, fa.lastnamephonetic AS fauserrecordlastnamephonetic, fa.middlename AS fauserrecordmiddlename, fa.alternatename AS fauserrecordalternatename, fa.imagealt AS fauserrecordimagealt, fa.email AS fauserrecordemail, fa.deleted AS fauserrecorddeleted, la.id AS lauserpictureid, la.picture AS lauserrecordpicture, la.firstname AS lauserrecordfirstname, la.lastname AS lauserrecordlastname, la.firstnamephonetic AS lauserrecordfirstnamephonetic, la.lastnamephonetic AS lauserrecordlastnamephonetic, la.middlename AS lauserrecordmiddlename, la.alternatename AS lauserrecordalternatename, la.imagealt AS lauserrecordimagealt, la.email AS lauserrecordemail, la.deleted AS lauserrecorddeleted, g.id AS gid, g.courseid AS gcourseid, g.idnumber AS gidnumber, g.name AS gname, g.description AS gdescription, g.descriptionformat AS gdescriptionformat, g.enrolmentkey AS genrolmentkey, g.picture AS gpicture, g.timecreated AS gtimecreated, g.timemodified AS gtimemodified FROM myschool_forum_discussions d JOIN myschool_forum_posts fp ON fp.id = d.firstpost JOIN myschool_user fa ON fa.id = fp.userid JOIN myschool_user la ON la.id = d.usermodifiedLEFT JOIN myschool_groups g ON g.id = d.groupid WHERE d.forum = $1 AND (d.groupid = $2 OR d.groupid = $3) AND ((d.timestart <= $4 AND (d.timeend = 0 OR d.timeend > $5)) OR d.userid = $6) ORDER BY d.pinned DESC , gname DESC LIMIT 100 [array ( 0 => 1, 1 => -1, 2 => 2, 3 => 1714165972, 4 => 1714165972, 5 => 0, )] Error code: dmlreadexception
Stack trace:
line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
line 338 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_slave_query_end()
line 986 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 471 of /mod/forum/classes/local/vaults/discussion_list.php: call to pgsql_native_moodle_database->get_records_sql()
line 6874 of /mod/forum/lib.php: call to mod_forum\local\vaults\discussion_list->get_from_forum_id_and_group_id()
line 177 of /mod/forum/classes/local/renderers/discussion_list.php: call to mod_forum_get_discussion_summaries()
line 254 of /mod/forum/view.php: call to mod_forum\local\renderers\discussion_list->render()