Nachhilfelehrer/innen
Debug-Info: Unknown column 'g.hidepicture' in 'field list'
SELECT DISTINCT e.id, e.approved, e.timecreated, e.timemodified, e.userid, e.groupid, e.status, u.id AS uid ,u.picture,u.firstname,u.lastname,u.firstnamephonetic,u.lastnamephonetic,u.middlename,u.alternatename,u.imagealt,u.email,u.idnumber,u.username,u.institution, g.name AS groupname, g.hidepicture AS grouphidepic, g.picture AS grouppic , er.itemid, er.component, er.ratingarea, er.contextid,
er.numratings, er.avgratings, er.sumratings, er.maxratings, er.minratings,
er.ratingid, er.ratinguserid, er.scaleid, er.usersrating FROM mdl_datalynx_entries e
JOIN mdl_user u ON u.id = e.userid
LEFT JOIN mdl_groups g ON g.id = e.groupid LEFT JOIN
(SELECT r.itemid, r.component, r.ratingarea, r.contextid,
COUNT(r.rating) AS numratings,
AVG(r.rating) AS avgratings,
SUM(r.rating) AS sumratings,
MAX(r.rating) AS maxratings,
MIN(r.rating) AS minratings,
ur.id as ratingid, ur.userid as ratinguserid, ur.scaleid, ur.rating AS usersrating
FROM mdl_rating r
LEFT JOIN mdl_rating ur ON ur.contextid = r.contextid
AND ur.itemid = r.itemid
AND ur.component = r.component
AND ur.ratingarea = r.ratingarea
AND ur.userid = ?
WHERE r.contextid = ?
AND r.component = ?
AND r.ratingarea = ?
GROUP BY r.itemid, r.component, r.ratingarea, r.contextid, ratingid, ur.userid, ur.scaleid
ORDER BY r.itemid) AS er ON er.itemid = e.id WHERE e.dataid = ? AND e.userid <> ? AND (e.approved = ?
OR e.userid = ?) AND (e.status <> ?
OR e.userid = ?) ORDER BY e.timecreated ASC LIMIT 0, 50
[array (
0 => '78',
1 => 3799,
2 => 'mod_datalynx',
3 => 'entry',
4 => '1',
5 => 1,
6 => 1,
7 => '78',
8 => 1,
9 => '78',
)]
Error code: dmlreadexception
SELECT DISTINCT e.id, e.approved, e.timecreated, e.timemodified, e.userid, e.groupid, e.status, u.id AS uid ,u.picture,u.firstname,u.lastname,u.firstnamephonetic,u.lastnamephonetic,u.middlename,u.alternatename,u.imagealt,u.email,u.idnumber,u.username,u.institution, g.name AS groupname, g.hidepicture AS grouphidepic, g.picture AS grouppic , er.itemid, er.component, er.ratingarea, er.contextid,
er.numratings, er.avgratings, er.sumratings, er.maxratings, er.minratings,
er.ratingid, er.ratinguserid, er.scaleid, er.usersrating FROM mdl_datalynx_entries e
JOIN mdl_user u ON u.id = e.userid
LEFT JOIN mdl_groups g ON g.id = e.groupid LEFT JOIN
(SELECT r.itemid, r.component, r.ratingarea, r.contextid,
COUNT(r.rating) AS numratings,
AVG(r.rating) AS avgratings,
SUM(r.rating) AS sumratings,
MAX(r.rating) AS maxratings,
MIN(r.rating) AS minratings,
ur.id as ratingid, ur.userid as ratinguserid, ur.scaleid, ur.rating AS usersrating
FROM mdl_rating r
LEFT JOIN mdl_rating ur ON ur.contextid = r.contextid
AND ur.itemid = r.itemid
AND ur.component = r.component
AND ur.ratingarea = r.ratingarea
AND ur.userid = ?
WHERE r.contextid = ?
AND r.component = ?
AND r.ratingarea = ?
GROUP BY r.itemid, r.component, r.ratingarea, r.contextid, ratingid, ur.userid, ur.scaleid
ORDER BY r.itemid) AS er ON er.itemid = e.id WHERE e.dataid = ? AND e.userid <> ? AND (e.approved = ?
OR e.userid = ?) AND (e.status <> ?
OR e.userid = ?) ORDER BY e.timecreated ASC LIMIT 0, 50
[array (
0 => '78',
1 => 3799,
2 => 'mod_datalynx',
3 => 'entry',
4 => '1',
5 => 1,
6 => 1,
7 => '78',
8 => 1,
9 => '78',
)]
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 1282 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
- line 329 of /mod/datalynx/entries_class.php: call to mysqli_native_moodle_database->get_records_sql()
- line 91 of /mod/datalynx/entries_class.php: call to datalynx_entries->get_entries()
- line 547 of /mod/datalynx/view/view_class.php: call to datalynx_entries->set_content()
- line 754 of /mod/datalynx/classes/datalynx.php: call to datalynxview_base->set_content()
- line 45 of /mod/datalynx/view.php: call to mod_datalynx\datalynx->set_content()