Project

General

Profile

Bug #7231

progression remains at 0% for students

Added by Eric Petitdemange about 5 years ago. Updated about 4 years ago.

Status:
Bug resolved
Priority:
Normal
Assignee:
Category:
Tracking / Reporting
Target version:
Start date:
17/08/2014
Due date:
% Done:

100%

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

Description

Hello to you all,

I encounter a stange issue:
As admin, if I follow a LP in student view, the progress bar is working fine. If I follow the same course/lp as a plain student, the the progress bar reamins at 0% untill the student loggs off and log back in.

After the re-login, the progress is showing fine.
I'm using the latest Github version.

This issue seems related to timestamp, but as the issue is different I open a new issue.
If you feel this is not needed, then you can close/reject it :)

Thanke to you guys!


Files

chamilo_10_suivi_ko.jpg (69.5 KB) chamilo_10_suivi_ko.jpg Eric Petitdemange, 08/04/2015 13:05

Related issues

Related to Chamilo LMS - Bug #7220: Chamilo 1.9.8 - Latest from Github - Issue with followup (time stamp not correct)Bug resolved25/07/2014

Actions

Associated revisions

Revision 231ee629 (diff)
Added by Julio Montoya over 4 years ago

Fix query see #7231

History

#1

Updated by Yannick Warnier almost 5 years ago

  • Target version set to 1.10.0
#2

Updated by Yannick Warnier over 4 years ago

  • Category set to Tracking / Reporting
  • Status changed from New to Needs more info
  • Assignee set to Eric Petitdemange
  • % Done changed from 0 to 10

Could you test this on https://unstable.chamilo.org/ to confirm?

#3

Updated by Eric Petitdemange over 4 years ago

Bad news guys !!

Still 0% on a course I just created...
coursenligne : teacher
Ap Prenant : trainee (student)

#4

Updated by Yannick Warnier over 4 years ago

  • Status changed from Needs more info to Assigned
  • Assignee changed from Eric Petitdemange to Julio Montoya
#5

Updated by Julio Montoya over 4 years ago

  • Status changed from Assigned to Needs more info
  • Assignee changed from Julio Montoya to Eric Petitdemange

I just reinstalled chamilo here:

https://unstable.chamilo.org/

I logged in as an student and the progress moves to 100%

It's working for me ...

#6

Updated by Eric Petitdemange over 4 years ago

Hi, I tried to connect on test123, when I go to Reporting // View my progress, I get the following:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'course_code' in 'field list'' in /var/www/unstable.chamilo.org/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 71 PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'course_code' in 'field list' in /var/www/unstable.chamilo.org/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php on line 104 Call Stack: 0.0004 261200 1. {main}() /var/www/unstable.chamilo.org/www/main/auth/my_progress.php:0 0.3286 16537776 2. MySpace::get_connections_from_course_list() /var/www/unstable.chamilo.org/www/main/auth/my_progress.php:52 0.3336 17008216 3. Database::query() /var/www/unstable.chamilo.org/www/main/inc/lib/myspace.lib.php:155 0.3336 17008216 4. Doctrine\DBAL\Connection->executeQuery() /var/www/unstable.chamilo.org/www/main/inc/lib/database.lib.php:330 0.3336 17008584 5. Doctrine\DBAL\Driver\PDOConnection->query() /var/www/unstable.chamilo.org/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:833 0.3336 17009320 6. PDO->query() /var/www/unstable.chamilo.org/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104 Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'course_code' in 'field list' in /var/www/unstable.chamilo.org/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php on line 106 Call Stack: 0.0004 261200 1. {main}() /var/www/unstable.chamilo.org/www/main/auth/my_progress.php:0 0.3286 16537776 2. MySpace::get_connections_from_course_list() /var/www/unstable.chamilo.org/www/main/auth/my_progress.php:52 0.3336 17008216 3. Database::query() /var/www/unstable.chamilo.org/www/main/inc/lib/myspace.lib.php:155 0.3336 17008216 4. Doctrine\DBAL\Connection->executeQuery() /var/www/unstable.chamilo.org/www/main/inc/lib/database.lib.php:330 0.3336 17008584 5. Doctrine\DBAL\Driver\PDOConnection->query() /var/www/unstable.chamilo.org/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:833 Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT login_course_date, logout_course_date, course_code FROM track_e_course_access WHERE user_id = 1 AND c_id IN ("1") AND session_id = 0 ORDER BY login_course_date ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'course_code' in 'field list' in /var/www/unstable.chamilo.org/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 71 Call Stack: 0.0004 261200 1. {main}() /var/www/unstable.chamilo.org/www/main/auth/my_progress.php:0 0.3286 16537776 2. MySpace::get_connections_from_course_list() /var/www/unstable.chamilo.org/www/main/auth/my_progress.php:52 0.3336 17008216 3. Database::query() /var/www/unstable.chamilo.org/www/main/inc/lib/myspace.lib.php:155 0.3336 17008216 4. Doctrine\DBAL\Connection->executeQuery() /var/www/unstable.chamilo.org/www/main/inc/lib/database.lib.php:330

I can't manage to make it working here :(

#7

Updated by Julio Montoya over 4 years ago

I just fixed that error.

#8

Updated by Yannick Warnier about 4 years ago

  • Status changed from Needs more info to Needs testing

Will be closed in 5 days if no feedback is provided before then...

#9

Updated by Yannick Warnier about 4 years ago

  • Status changed from Needs testing to Bug resolved
  • Assignee changed from Eric Petitdemange to Julio Montoya
  • % Done changed from 10 to 100

Also available in: Atom PDF