Bug #1579
closedCourses - User: reporting: MDB2 error
100%
Description
I navigated to the reporting of a specific user, then try to view the 'View Publications' of the Course section. Of course this is not possible, but it returns a MDB2 error:
MDB2_Error Object
(
[error_message_prefix] =>
[mode] => 1
[level] => 1024
[code] => -19
[message] => MDB2 Error: no such field
[userinfo] => _doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT DISTINCT alias_wcop.* FROM `weblcms_content_object_publication` AS alias_wcop LEFT JOIN `weblcms_content_object_publication_user` AS alias_wcopu ON alias_wcop.id = alias_wcopu.publication_id LEFT JOIN `weblcms_content_object_publication_course_group` AS alias_wcopcg ON alias_wcop.id = alias_wcopcg.publication_id JOIN `repository_content_object` AS alias_wco ON alias_wcop.content_object_id = alias_wco.id WHERE (alias_wcop.`course_id` = '1' AND alias_wcop.`tool` = 'course_sections' AND (alias_waw.`user_id` IN ('2') OR alias_waw.`user_id` IS NULL))]
[Native code: 1054]
[Native message: Unknown column 'alias_waw.user_id' in 'where clause']
[backtrace] => Array
(
[0] => Array
(
[file] => /Users/Kariboe/WWW/eclipse/chamilo/plugin/pear/MDB2.php
[line] => 1009
[function] => PEAR_Error
[class] => PEAR_Error
[type] => ->
[args] => Array
(
[0] => MDB2 Error: no such field
[1] => -19
[2] => 1
[3] => 1024
[4] => _doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT DISTINCT alias_wcop.* FROM `weblcms_content_object_publication` AS alias_wcop LEFT JOIN `weblcms_content_object_publication_user` AS alias_wcopu ON alias_wcop.id = alias_wcopu.publication_id LEFT JOIN `weblcms_content_object_publication_course_group` AS alias_wcopcg ON alias_wcop.id = alias_wcopcg.publication_id JOIN `repository_content_object` AS alias_wco ON alias_wcop.content_object_id = alias_wco.id WHERE (alias_wcop.`course_id` = '1' AND alias_wcop.`tool` = 'course_sections' AND (alias_waw.`user_id` IN ('2') OR alias_waw.`user_id` IS NULL))]
[Native code: 1054]
[Native message: Unknown column 'alias_waw.user_id' in 'where clause']
)
)
[1] => Array
(
[file] => /Users/Kariboe/WWW/eclipse/chamilo/plugin/pear/PEAR.php
[line] => 574
[function] => MDB2_Error
[class] => MDB2_Error
[type] => ->
[object] => MDB2_Error Object
RECURSION
[args] => Array
(
[0] => -19
[1] => 1
[2] => 1024
[3] => _doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT DISTINCT alias_wcop.* FROM `weblcms_content_object_publication` AS alias_wcop LEFT JOIN `weblcms_content_object_publication_user` AS alias_wcopu ON alias_wcop.id = alias_wcopu.publication_id LEFT JOIN `weblcms_content_object_publication_course_group` AS alias_wcopcg ON alias_wcop.id = alias_wcopcg.publication_id JOIN `repository_content_object` AS alias_wco ON alias_wcop.content_object_id = alias_wco.id WHERE (alias_wcop.`course_id` = '1' AND alias_wcop.`tool` = 'course_sections' AND (alias_waw.`user_id` IN ('2') OR alias_waw.`user_id` IS NULL))]
[Native code: 1054]
[Native message: Unknown column 'alias_waw.user_id' in 'where clause']
)
Updated by Sven Vanpoucke over 13 years ago
- Status changed from New to Needs testing
- % Done changed from 0 to 100
Fixed the reporting in the user tool in
http://code.google.com/p/chamilo/source/detail?r=c4cb96e4d5dfb240948be0a8ea39437750083ebc&repo=chamilo
Updated by Stefaan Vanbillemont over 13 years ago
- Status changed from Needs testing to Bug resolved
Updated by Stefaan Vanbillemont over 12 years ago
- Project changed from Chamilo LCMS Connect to Courses
- Category deleted (
2)
Updated by Stefaan Vanbillemont over 12 years ago
- Target version changed from 2 to 1.0.0