I am trying to test Dataform in Moodle 3.1.
When trying to add an entry a dmreadexception error appears. This is likely caused by me but I am unsure why this is. I am hoping for some assistance in dealing with this. The error is as follows:
Debug info: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
SELECT e.id, e.dataid, e.state, e.timecreated, e.timemodified, e.userid, e.groupid , 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 , c29.itemid AS c29_itemid,c29.component AS c29_component,c29.ratingarea AS c29_ratingarea,c29.contextid AS c29_contextid,c29.numratings AS c29_numratings,c29.avgratings AS c29_avgratings,c29.sumratings AS c29_sumratings,c29.maxratings AS c29_maxratings,c29.minratings AS c29_minratings,c29.ratingid AS c29_ratingid,c29.ratinguserid AS c29_ratinguserid,c29.scaleid AS c29_scaleid,c29.usersrating AS c29_usersrating FROM mdl_dataform_entries e JOIN mdl_user u ON u.id = e.userid LEFT JOIN mdl_dataform_contents c23 ON c23.fieldid = 23 AND c23.entryid = e.id 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 = 5725
WHERE
r.contextid = 124154
AND r.component = 'mod_dataform'
AND r.ratingarea = 'ratingmdl'
GROUP BY
r.itemid,
r.component,
r.ratingarea,
r.contextid,
ratingid,
ur.userid,
ur.scaleid
ORDER BY
r.itemid
) AS c29 ON c29.itemid = e.id WHERE e.dataid = ? ORDER BY CONVERT(varchar(32), c23.content) ASC, CONVERT(varchar(32), u.idnumber) ASC
[array (
0 => '7',
)]
Error code: dmlreadexception