Project

General

Profile

Bug #4051

SQL error in Course Reporting "Documents most downloaded"

Added by Hubert Borderiou almost 8 years ago. Updated over 7 years ago.

Status:
Feature implemented
Priority:
Normal
Assignee:
-
Category:
-
Target version:
Start date:
17/11/2011
Due date:
% Done:

50%

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

Description

Course > Reporting > Course report > Documents most downloaded - See detail

SQL error

DATABASE ERROR #1054:
Unknown column 'c_id' in 'where clause'
QUERY :
SELECT down_doc_path, COUNT, COUNT as count_down
FROM `chamilo19`.`track_e_downloads`
WHERE down_cours_id = 'COURS00001'
AND down_session_id = 0
AND c_id = 1 GROUP BY down_doc_path
ORDER BY count_down DESC
LIMIT 0, 3
FILE :
/home/chamilo/www/chamilo.classic/main/inc/lib/tracking.lib.php
LINE :
1979
CLASS :
Tracking
METHOD :
get_documents_most_downloaded_by_course

History

#1

Updated by Julio Montoya over 7 years ago

  • Status changed from New to Needs more info
  • % Done changed from 0 to 50

I guess this was already fixed it

#2

Updated by Julio Montoya over 7 years ago

  • Status changed from Needs more info to Feature implemented
  • Target version set to 1.9 Stable

Also available in: Atom PDF