Project

General

Profile

Bug #4084

Time spent in course 1500 hours and more

Added by Julio Montoya almost 8 years ago. Updated over 7 years ago.

Status:
Bug resolved
Priority:
Normal
Assignee:
Category:
-
Target version:
Start date:
30/11/2011
Due date:
% Done:

50%

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

Description

When setting $_configuration['session_lifetime'] to 360000 (100 hours) the time spent in course reporting fails

when looking in the student progress the spent time in course we have values like 1500 hours, 500h etc

main/mySpace/myStudents.php

Tracking::get_time_spent_on_the_course()

The problem is in the local.inc.php +818

$sql = "SELECT course_access_id FROM $course_tracking_table
                    WHERE   user_id     = ".intval($_user ['user_id'])." AND
                            course_code = '$course_code' AND 
                            session_id  = ".api_get_session_id()." AND
                            login_course_date > now() - INTERVAL $session_lifetime SECOND
                        ORDER BY login_course_date DESC LIMIT 0,1";


Related issues

Related to Chamilo LMS - Feature #3996: Permit setting the PHP session expiry timeNew21/10/2011

Actions

History

#2

Updated by Julio Montoya over 7 years ago

  • Status changed from New to Needs more info
#3

Updated by Yannick Warnier over 7 years ago

  • Target version set to 1.9 Beta
#4

Updated by Yannick Warnier over 7 years ago

  • Status changed from Needs more info to Bug resolved
  • Assignee set to Julio Montoya

Not sure anybody can confirm this is fixing the issue (because we need data in large quantities) but let's say it should be improved anyway... :-)

Also available in: Atom PDF