Project

General

Profile

Bug #2625

Admin > User information: SQL error

Added by Ivan Tcholakov almost 9 years ago. Updated almost 9 years ago.

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

100%

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

Description

File: main/admin/user_information.php

DATABASE ERROR #1054:
 Unknown column 'session_rel_course.id_coach' in 'on clause'
QUERY       :
 SELECT DISTINCT id, name, date_start, date_end  FROM `chamilo_main`.`session` as session  INNER JOIN `chamilo_main`.`session_rel_course` as session_rel_course  ON session_rel_course.id_coach = 1  AND (date_start <= NOW() AND date_end >= NOW() OR date_start='0000-00-00')  ORDER BY date_start, date_end, name
FILE        :
 C:\Users\Ivan Tcholakov\workspace\chamilo-classic-test\main\admin\user_information.php
LINE        :
 97

Files

sql_error_user_info.png (91.3 KB) sql_error_user_info.png Ivan Tcholakov, 25/01/2011 10:05

Associated revisions

Revision d2989fcb (diff)
Added by Julio Montoya almost 9 years ago

Fixing query + other security fixes see #2625

History

#1

Updated by Julio Montoya almost 9 years ago

  • Status changed from New to Needs more info
  • % Done changed from 0 to 80
#2

Updated by Ivan Tcholakov almost 9 years ago

Yes, the error disappeared, thank you.

#3

Updated by Julio Montoya almost 9 years ago

  • Status changed from Needs more info to Bug resolved
  • % Done changed from 80 to 100

Also available in: Atom PDF