Chamilo LMS

I think, this task is not for me.

exercice/exercise_result.class.php

Check the line 118:

                    WHERE  tu.user_id=tth.exe_user_id AND tth.exe_cours_id = '" . Database :: escape_string($cid) . " $user_id_and '

exercice/exercise.lib.php

Check the line 793:

                    WHERE  tu.user_id=tth.exe_user_id AND tth.exe_cours_id = '" . Database :: escape_string($_cid) . " $user_id_and  $exercise_where

and the line 874:

                    WHERE  tu.user_id=tth.exe_user_id AND tth.exe_cours_id = '" . Database :: escape_string($_cid)." $user_id_and $exercise_where 

thanks for reporting it

should be fixed with

http://code.google.com/p/chamilo/source/detail?r=e4131e2f4993028d6e8da827358acd61c71ef1d3&repo=classic

After updating the source, I tried the same place (Tests tool, the "Results and feedback" button) and a different SQL error occured:

DATABASE ERROR #1146:
 Table 'chamilo_main.tth' doesn't exist
QUERY       :
 SELECT firstname as col0, lastname col1, tth.exe_name, tth.exe_result , tth.exe_weighting, tth.exe_date
                    FROM  tth, `chamilo_main`.`user` tu
                    WHERE  tu.user_id=tth.exe_user_id AND tth.exe_cours_id = 'TEST'   AND te.exe_exo_id = 2   
                    ORDER BY tth.exe_cours_id ASC, tth.exe_date DESC
FILE        :
 C:\Users\Ivan Tcholakov\workspace\chamilo-classic-test\main\inc\lib\statsUtils.lib.inc.php
LINE        :
 119
FUNCTION    :
 getManyResultsXCol

See the picture too.

Within the file main/exercice/exercise.lib.php there are the functions and get_count_exam_results() and get_exam_results_data().
Inside it the variable $TBL_TRACK_HOTPOTATOES has not been initialized.
I declared (locally in my sources only) the variable $TBL_TRACK_HOTPOTATOES as global at the beginnig of these functions and I got yet another error:

DATABASE ERROR #1054:
 Unknown column 'te.exe_exo_id' in 'where clause'
QUERY       :
 SELECT firstname as col0, lastname col1, tth.exe_name, tth.exe_result , tth.exe_weighting, tth.exe_date
                    FROM `chamilo_main`.`track_e_hotpotatoes` tth, `chamilo_main`.`user` tu
                    WHERE  tu.user_id=tth.exe_user_id AND tth.exe_cours_id = 'TEST'   AND te.exe_exo_id = 2  
                    ORDER BY tth.exe_cours_id ASC, tth.exe_date DESC
FILE        :
 C:\Users\Ivan Tcholakov\workspace\chamilo-classic-test\main\inc\lib\statsUtils.lib.inc.php
LINE        :
 119
FUNCTION    :
 getManyResultsXCol

A am attaching a file a.html (compressed). It comes from herodoto, see the tasks #1339, #2560.

i think there are not more sql errors ?

The last one still stays - "Unknown column 'te.exe_exo_id' in 'where clause'". On a system switched into testing mode click on the icon "Results and feedback" and you will see the error. I am sending a picture.

Ivan Tcholakov wrote:

The last one still stays - "Unknown column 'te.exe_exo_id' in 'where clause'". On a system switched into testing mode click on the icon "Results and feedback" and you will see the error. I am sending a picture.

thanks, here's the fix, need more test when dealing with gradebook ...

http://code.google.com/p/chamilo/source/detail?r=79e383362219728a673e52764d0a1df140da749d&repo=classic

I tried the "Results and feedback" icon against the ordinary sample test. This is what I got:

DATABASE ERROR #1054:
 Unknown column 'propagate_neg' in 'field list'
QUERY       :
 SELECT lastname as col0, firstname as col1, ce.title 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 `chamilo_TESTCOURSE`.`quiz`  AS ce INNER JOIN `chamilo_main`.`track_e_exercices` AS te ON (te.exe_exo_id = ce.id) INNER JOIN  `chamilo_main`.`user`  AS user ON (user.user_id = exe_user_id)
                WHERE te.status != 'incomplete' AND te.exe_cours_id='TESTCOURSE'     AND te.session_id = 0  AND ce.active <>-1 AND orig_lp_id = 0 AND orig_lp_item_id = 0  AND te.exe_exo_id = 1    ORDER BY col1   LIMIT 0, 20
FILE        :
 C:\xampp\htdocs\chamilo-classic\main\exercice\exercise.lib.php
LINE        :
 939
FUNCTION    :
 get_exam_results_data

waiting for more errors :)