We are moving to Git Issues for bug tracking in future releases. During transition, content will be in both tools. If you'd like to file a new bug, please create an issue.

Bug 8116 - Bug in _getUnfilteredEditorSubmissions
Bug in _getUnfilteredEditorSubmissions
Product: OJS
Classification: Unclassified
Component: Editors
All All
: P3 normal
Assigned To: PKP Support
Depends on:
  Show dependency treegraph
Reported: 2013-02-12 14:38 PST by Alec Smecher
Modified: 2013-02-12 14:45 PST (History)
0 users

See Also:
Version Reported In:
Also Affects:


Note You need to log in before you can comment on or make changes to this bug.
Description Alec Smecher 2013-02-12 14:38:56 PST
From Bozana:

> I think this part of code in the function _getUnfilteredEditorSubmissions in
> classes/submission/editor/EditorSubmissionDAO.inc.php is now wrong:
>       if ($editorId) {
>           $searchSql .= ' AND ed.user_id = ?';
>           $params[] = $editorId;
>       }
> The 'ed' is only there if somebody searches for an editor. If somebody want's
> to filter by an editor there is an error 'unknown column ed.user_id'. You can
> see it for example if you (as editor) go to submissions archives and try to
> filter by 'me' ('assigned to me'). Thus, I think here there should be:
>       if ($editorId) {
>           $searchSql .= ' AND ea.editor_id = ?';
>           $params[] = $editorId;
>       }
Comment 1 Alec Smecher 2013-02-12 14:45:02 PST
Editor search bug
Comment 2 Alec Smecher 2013-02-12 14:45:03 PST
Editor search bug