Debug info: ERROR: column d.usermodifiedleft does not exist
LINE 1: ... ON fa.id = fp.userid JOIN mdl_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, g.visibility AS gvisibility, g.participation AS gparticipation FROM mdl_forum_discussions d JOIN mdl_forum_posts fp ON fp.id = d.firstpost JOIN mdl_user fa ON fa.id = fp.userid JOIN mdl_user la ON la.id = d.usermodifiedLEFT JOIN mdl_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, d.id DESC LIMIT 100
[array (
0 => 7,
1 => -1,
2 => 774,
3 => 1732183030,
4 => 1732183030,
5 => 0,
)]
Error code: dmlreadexception
LINE 1: ... ON fa.id = fp.userid JOIN mdl_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, g.visibility AS gvisibility, g.participation AS gparticipation FROM mdl_forum_discussions d JOIN mdl_forum_posts fp ON fp.id = d.firstpost JOIN mdl_user fa ON fa.id = fp.userid JOIN mdl_user la ON la.id = d.usermodifiedLEFT JOIN mdl_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, d.id DESC LIMIT 100
[array (
0 => 7,
1 => -1,
2 => 774,
3 => 1732183030,
4 => 1732183030,
5 => 0,
)]
Error code: dmlreadexception
Stack trace:
- line 494 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 341 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_slave_query_end()
- line 1027 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 6891 of /mod/forum/lib.php: call to mod_forum\local\vaults\discussion_list->get_from_forum_id_and_group_id()
- line 180 of /mod/forum/classes/local/renderers/discussion_list.php: call to mod_forum_get_discussion_summaries()
- line 259 of /mod/forum/view.php: call to mod_forum\local\renderers\discussion_list->render()