*14:57:22
2
*
500 engine.php checkSession id doesn't exist in SESSION profile

SQL ERROR Line 175 database.php queryError

SELECT at.* ,ans.* ,u.username , u.username as student ,at.atimestamp ,q.qquestion as number ,e.ename as exercise ,c.ccourse as course ,at.apage as webpage ,at.attempt as answer ,FROM_UNIXTIME(at.atimestamp) as attempt_time ,ans.ans_correct as correct ,ans.ans_feedback as feedback ,(CASE WHEN at.attempt = ans.possible_answer THEN 1 ELSE 0 END ) as marked FROM et_question_attempt at LEFT JOIN et_question_answer ans ON (ans.qid = at.qid AND ans.possible_answer = at.attempt AND ans.ans_deleted = 0 ) LEFT JOIN et_question q ON q.id = at.qid JOIN et_exercise e ON e.id = q.eid JOIN et_course c ON c.id = e.cid LEFT JOIN et_user u ON (u.id = at.auid ) ORDER BY at.atimestamp DESC , ans_question

SQL Error

Unknown column 'ans_question' in 'order clause'

Ln 965 courseMethods.php getRecentSubmissions Failed query=> SELECT at.* ,ans.* ,u.username , u.username as student ,at.atimestamp ,q.qquestion as number ,e.ename as exercise ,c.ccourse as course ,at.apage as webpage ,at.attempt as answer ,FROM_UNIXTIME(at.atimestamp) as attempt_time ,ans.ans_correct as correct ,ans.ans_feedback as feedback ,(CASE WHEN at.attempt = ans.possible_answer THEN 1 ELSE 0 END ) as marked FROM et_question_attempt at LEFT JOIN et_question_answer ans ON (ans.qid = at.qid AND ans.possible_answer = at.attempt AND ans.ans_deleted = 0 ) LEFT JOIN et_question q ON q.id = at.qid JOIN et_exercise e ON e.id = q.eid JOIN et_course c ON c.id = e.cid LEFT JOIN et_user u ON (u.id = at.auid ) ORDER BY at.atimestamp DESC , ans_question
Unknown column 'ans_question' in 'order clause'