Project

General

Profile

Bug #4810

Reporting engine errors

Added by Yannick Warnier over 7 years ago. Updated over 7 years ago.

Status:
Bug resolved
Priority:
Normal
Assignee:
-
Category:
-
Target version:
Start date:
27/05/2012
Due date:
% Done:

100%

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

Description

In the new reporting engine (right column "Reporting" link in courses homepage), the following errors occur

DATABASE ERROR #1146:
 Table 'chamilo.TABLE_MAIN_REPORTS_KEYS' doesn't exist
QUERY       :
 select r.id as kid, c.title as course from `chamilo`.`TABLE_MAIN_REPORTS_KEYS` r, `chamilo`.`course` c where r.course_id=c.id and r.tool_id is null and r.child_id is null order by c.title
FILE        :
 /var/www/chamilo/main/reports/templates/courseTime.reports.php
LINE        :
 23
FUNCTION    :
 reports_template_courseTime_getSQL

[=no data found: select r.id as kid, c.title as course from `chamilo`.`TABLE_MAIN_REPORTS_KEYS` r, `chamilo`.`course` c where r.course_id=c.id and r.tool_id is null and r.child_id is null order by c.title=]

Related issues

Related to Chamilo LMS - Feature #5559: News featuresNew28/09/2012

Actions

Associated revisions

Revision 389fa6ed (diff)
Added by Julio Montoya over 7 years ago

Removing course time option in select in order to avoid errors see #4810

History

#1

Updated by Yannick Warnier over 7 years ago

  • Status changed from New to Assigned
  • Assignee set to Julio Montoya

Arnaud says we can remove everything related to courseTime (the table needn't be there). We can remove the file (courseTime.reports.php) and its reference in reports.php

#2

Updated by Julio Montoya over 7 years ago

mmm I found a lot of

Dev message: please add the c_id field in this query or report this error in support.chamilo.org 

select l.id as lid, l.name as lname, li.id as liid, li.title as lititle  from `chamilo`.`c_lp` l,  `chamilo`.`c_lp_item` li  where l.id = li.lp_id

#3

Updated by Julio Montoya over 7 years ago

  • Status changed from Assigned to Needs more info
  • Assignee deleted (Julio Montoya)
  • % Done changed from 0 to 80

I just deleted the reference in the reports

#4

Updated by Yannick Warnier over 7 years ago

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

It stills seems something is missing from those reports, but we'll fix that in the run-up to the stable (it's just read-only stuff anyway)

Also available in: Atom PDF