OCS - Error, archived presentations are not displayed


  1. The error occurs, when I try to access the User > Director > Submissions > Archives

  2. When I select the “SESSION TYPE” column, this error is displayed

DB Error: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LÍNEA 28: …de = 3 AND p.submission_progress <> 1)) ORDER BY sts.settin… ^
Stack Trace:
File: /var/www/html/ocsuis/classes/submission/director/DirectorSubmissionDAO.inc.php line 281
Function: DAO->retrieveRange(“SELECT DISTINCT p.*, COALESCE(ptl.setting_value, pptl…”, Array(13), Object(DBResultRange))

File: /var/www/html/ocsuis/classes/submission/director/DirectorSubmissionDAO.inc.php line 408
Function: DirectorSubmissionDAO->_getUnfilteredDirectorSubmissions(“1”, 0, 0, “3”, “contains”, “”, Null, Null, Null, “p.status <> 1 AND p.status <> 3”, Object(DBResultRange), “sessionType”, “1”)

File: /var/www/html/ocsuis/pages/director/DirectorHandler.inc.php line 160
Function: DirectorSubmissionDAO->getDirectorSubmissionsArchives(“1”, 0, 0, “3”, “contains”, “”, Null, Null, Null, Object(DBResultRange), “sessionType”, “1”)

File: /var/www/html/ocsuis/lib/pkp/classes/core/PKPPageRouter.inc.php line 177
Function: DirectorHandler->submissions(Array(1), Object(Request))

File: /var/www/html/ocsuis/lib/pkp/classes/core/Dispatcher.inc.php line 130
Function: PKPPageRouter->route(Object(Request))

File: /var/www/html/ocsuis/lib/pkp/classes/core/PKPApplication.inc.php line 170
Function: Dispatcher->dispatch(Object(Request))

File: /var/www/html/ocsuis/index.php line 65
Function: PKPApplication->execute()

how can I solve that?
Thank you

Hi @drueda,

Try applying this patch.

Alec Smecher
Public Knowledge Project Team