Bug #4810
Reporting engine errors
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
Associated revisions
History
Updated by Yannick Warnier over 8 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
Updated by Julio Montoya over 8 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
Updated by Julio Montoya over 8 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
Updated by Yannick Warnier over 8 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)
Removing course time option in select in order to avoid errors see #4810