Project

General

Profile

Bug #4061

SQL error on test result page for teacher, when sorting by date.

Added by Hubert Borderiou almost 8 years ago. Updated almost 8 years ago.

Status:
Feature implemented
Priority:
Normal
Category:
-
Target version:
Start date:
23/11/2011
Due date:
% Done:

100%

Estimated time:
Complexity:
Normal
SCRUM pts - complexity:
?

Description

DATABASE ERROR #1054:
Unknown column 'col6' in 'order clause'
QUERY :

SELECT
user_id,
firstname as col0, lastname col1,
ce.title as col3,
username as col2,
te.exe_result as exresult ,
te.exe_weighting as exweight,
te.exe_date as exdate,
te.exe_id as exid,
email as exemail,
te.start_date as col4,
steps_counter as exstep,
exe_user_id as excruid,
te.exe_duration as exduration,
propagate_neg
FROM
`chamilo19`.`c_quiz` AS ce
INNER JOIN
(SELECT * FROM `chamilo19`.`track_e_exercices` AS tte
WHERE tte.exe_id NOT IN (SELECT DISTINCT exe_id FROM `chamilo19`.`track_e_attempt_recording`)) AS te ON (te.exe_exo_id = ce.id)
INNER JOIN `chamilo19`.`user` AS user ON (user.user_id = exe_user_id)
WHERE
te.status != 'incomplete'
AND te.exe_cours_id='COURS00001' AND te.session_id = 0
AND ce.active <>-1
AND orig_lp_id = 0
AND orig_lp_item_id = 0
AND ce.c_id=1
AND te.exe_exo_id = 3 ORDER BY col6 ASC LIMIT 0, 10
FILE :
/home/chamilo/www/chamilo.classic/main/exercice/exercise.lib.php
LINE :
988
FUNCTION :
get_exam_results_data

Associated revisions

Revision 5e44c266 (diff)
Added by Hubert Borderiou almost 8 years ago

- ref #4061

- ref #4061

History

#1

Updated by Hubert Borderiou almost 8 years ago

  • % Done changed from 0 to 100
#2

Updated by Hubert Borderiou almost 8 years ago

  • Status changed from New to Feature implemented

Also available in: Atom PDF