Project

General

Profile

Bug #5155

fatal error search portal

Added by dominique de guchtenaere over 7 years ago. Updated over 4 years ago.

Status:
Needs testing
Priority:
Normal
Assignee:
-
Start date:
10/07/2012
Due date:
% Done:

90%

Estimated time:
Complexity:
Normal

Description

searching for a Content object via collaboration - search portal, I get a fatal error.

Idem via the block Search portal on the home page. (see screen shot)


Files

search_portal.png (24.7 KB) search_portal.png dominique de guchtenaere, 10/07/2012 15:58

Associated revisions

Revision b86b066c (diff)
Added by Yannick Warnier about 10 years ago

Commented return message to avoid breaking headers (fixes #5155)

History

#1

Updated by dominique de guchtenaere over 7 years ago

works as admin, not as an ordinary user

#2

Updated by Parcifal Aertssen about 7 years ago

Looking at the code, it should also work if you allow all content objects to be searched (administration -> admin -> repository). However, this is currently not the case... enabling this, will prevent an error message, but no search results are shown (you stay on the homepage)

#3

Updated by Parcifal Aertssen about 7 years ago

In total it were 3 bugs. I fixed it now so that the non-admins can search their own objects. But someone should review the code for searching the shared content objects with the user.

#4

Updated by Parcifal Aertssen about 7 years ago

the line I commented out (for searching shared content objects), generates this SQL error:

[Native message: Unknown column 'alias_rcous.user_id' in 'where clause']
[Native code: 1054]
[Last executed query: SELECT COUNT FROM `repository_content_object` AS alias_rco LEFT JOIN `repository_shared_content_object_rel_category` AS alias_rscorc ON `alias_rco`.`id` = `alias_rscorc`.`content_object_id` WHERE (((((`alias_rco`.`title` LIKE '%test%' OR `alias_rco`.`description` LIKE '%test%')) AND `alias_rco`.`state` = 2) AND (`alias_rco`.`owner_id` = '4' OR (`alias_rcous`.`user_id` = '4'))) AND NOT (`alias_rco`.`current` = 0))]
[25/09/2012 - 18:29:00] [Message: MDB2 Error: no such field] [Information: _doQuery: [Error message: Could not execute statement]

#5

Updated by Yannick Warnier over 4 years ago

  • Status changed from New to Needs testing
  • % Done changed from 0 to 90

Applied in changeset chamilo-18:chamilo-lms|commit:b86b066c6d914afcc8c8fda15e9551ec58197dbc.

Also available in: Atom PDF