Pedagog

Błąd odczytu z bazy danych

Debug info: Unknown column 'd.usermodifiedLEFT' in 'on clause'
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.visibility AS gvisibility, g.participation AS gparticipation, g.timecreated AS gtimecreated, g.timemodified AS gtimemodified FROM forum_discussions d JOIN forum_posts fp ON fp.id = d.firstpost JOIN user fa ON fa.id = fp.userid JOIN user la ON la.id = d.usermodifiedLEFT JOIN `groups` g ON g.id = d.groupid WHERE d.forum = ? AND ((d.timestart <= ? AND (d.timeend = 0 OR d.timeend > ?)) OR d.userid = ?) ORDER BY d.pinned DESC , gname DESC LIMIT 0, 100
[array (
0 => 231,
1 => 1713489433,
2 => 1713489433,
3 => 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 1371 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
line 419 of /mod/forum/classes/local/vaults/discussion_list.php: call to mysqli_native_moodle_database->get_records_sql()
line 6878 of /mod/forum/lib.php: call to mod_forum\local\vaults\discussion_list->get_from_forum_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()