Project

General

Profile

Actions

Bug #1579

closed

Courses - User: reporting: MDB2 error

Added by Stefaan Vanbillemont over 13 years ago. Updated over 12 years ago.

Status:
Bug resolved
Priority:
Normal
Assignee:
Sven Vanpoucke
Target version:
Start date:
21/06/2010
Due date:
% Done:

100%

Estimated time:
Complexity:
Normal

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']
)
Actions #1

Updated by Sven Vanpoucke over 13 years ago

  • Assignee set to Sven Vanpoucke
Actions #2

Updated by Sven Vanpoucke over 13 years ago

  • Status changed from New to Needs testing
  • % Done changed from 0 to 100
Actions #3

Updated by Stefaan Vanbillemont over 13 years ago

  • Status changed from Needs testing to Bug resolved
Actions #4

Updated by Stefaan Vanbillemont over 12 years ago

  • Project changed from Chamilo LCMS Connect to Courses
  • Category deleted (2)
Actions #5

Updated by Stefaan Vanbillemont over 12 years ago

  • Target version changed from 2 to 1.0.0
Actions

Also available in: Atom PDF