Project

General

Profile

Bug #1462

Session User list Statistics Reporting : Database errors in attendance

Added by Jan Derriks over 9 years ago. Updated over 8 years ago.

Status:
Bug resolved
Priority:
High
Category:
-
Target version:
Start date:
06/06/2010
Due date:
% Done:

90%

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

Description

New 1.8.7 install, create session with some courses, add some users into the session, click on reporting for a user in the user list.
URL: /main/mySpace/myStudents.php?student=15&origin=resume_session&id_session=1

Result:

DATABASE ERROR #1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id = 0' at line 1
QUERY :
SELECT id, name, attendance_qualify_max FROM `dlo_ADS`.`attendance` WHERE active = 1 WHERE session_id = 0
FILE :
/home/dlo/main/inc/lib/attendance.lib.php
LINE :
71
CLASS :
Attendance
METHOD :
get_attendances_list

DATABASE ERROR #1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id = 0' at line 1
QUERY :
SELECT id, name, attendance_qualify_max FROM `dlo_ADSG`.`attendance` WHERE active = 1 WHERE session_id = 0
FILE :
/home/dlo/main/inc/lib/attendance.lib.php
LINE :
71
CLASS :
Attendance
METHOD :
get_attendances_list

DATABASE ERROR #1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id = 0' at line 1
QUERY :
SELECT id, name, attendance_qualify_max FROM `dlo_DB1`.`attendance` WHERE active = 1 WHERE session_id = 0
FILE :
/home/dlo/main/inc/lib/attendance.lib.php
LINE :
71
CLASS :
Attendance
METHOD :
get_attendances_list

DATABASE ERROR #1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id = 0' at line 1
QUERY :
SELECT id, name, attendance_qualify_max FROM `dlo_SET`.`attendance` WHERE active = 1 WHERE session_id = 0
FILE :
/home/dlo/main/inc/lib/attendance.lib.php
LINE :
71
CLASS :
Attendance
METHOD :
get_attendances_list

DATABASE ERROR #1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id = 0' at line 1
QUERY :
SELECT id, name, attendance_qualify_max FROM `dlo_SIM`.`attendance` WHERE active = 1 WHERE session_id = 0
FILE :
/home/dlo/main/inc/lib/attendance.lib.php
LINE :
71
CLASS :
Attendance
METHOD :
get_attendances_list

DATABASE ERROR #1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id = 0' at line 1
QUERY :
SELECT id, name, attendance_qualify_max FROM `dlo_SM3D`.`attendance` WHERE active = 1 WHERE session_id = 0
FILE :
/home/dlo/main/inc/lib/attendance.lib.php
LINE :
71
CLASS :
Attendance
METHOD :
get_attendances_list

DATABASE ERROR #1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id = 0' at line 1
QUERY :
SELECT id, name, attendance_qualify_max FROM `dlo_WSG`.`attendance` WHERE active = 1 WHERE session_id = 0
FILE :
/home/dlo/main/inc/lib/attendance.lib.php
LINE :
71
CLASS :
Attendance
METHOD :
get_attendances_list

DATABASE ERROR #1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id = 0' at line 1
QUERY :
SELECT id, name, attendance_qualify_max FROM `dlo_DBD`.`attendance` WHERE active = 1 WHERE session_id = 0
FILE :
/home/dlo/main/inc/lib/attendance.lib.php
LINE :
71
CLASS :
Attendance
METHOD :
get_attendances_list

DATABASE ERROR #1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id = 0' at line 1
QUERY :
SELECT id, name, attendance_qualify_max FROM `dlo_PASD`.`attendance` WHERE active = 1 WHERE session_id = 0
FILE :
/home/dlo/main/inc/lib/attendance.lib.php
LINE :
71
CLASS :
Attendance
METHOD :
get_attendances_list

DATABASE ERROR #1064:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE session_id = 0' at line 1
QUERY :
SELECT id, name, attendance_qualify_max FROM `dlo_SETD`.`attendance` WHERE active = 1 WHERE session_id = 0
FILE :
/home/dlo/main/inc/lib/attendance.lib.php
LINE :
71
CLASS :
Attendance
METHOD :
get_attendances_list

History

#1

Updated by Omar Arino over 9 years ago

The error is in line 63 of file attendance.lib.php
where say:

$condition_session = ' WHERE session_id = '.$session_id;

must say:

$condition_session = ' AND session_id = '.$session_id;
#2

Updated by Yannick Warnier over 9 years ago

  • Status changed from New to Assigned
  • Assignee set to Christian Alberto Fasanando Flores
  • Priority changed from Normal to High
  • Target version set to 1.8.7.1
#3

Updated by Christian Alberto Fasanando Flores over 9 years ago

  • Status changed from Assigned to Needs testing
  • Assignee changed from Christian Alberto Fasanando Flores to Curt Ricardo Rodriguez Salazar
  • % Done changed from 0 to 90
#4

Updated by Yannick Warnier over 8 years ago

  • Status changed from Needs testing to Bug resolved

Also available in: Atom PDF