PKP Bugzilla – Bug 8517
database error in editor submissions page. DB Error: Unknown column 'ea.user_id' in 'where clause'
Last modified: 2014-08-19 09:02:45 PDT
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.
In the editor submission pages, Unassigned, In Review, or In Editing, when I select: assigned to my. A db error is displayed (DB Error: Unknown column 'ea.user_id' in 'where clause') and the submission page becomes unavailable.
problem solved (well, I think...)
in the _getUnfilteredEditorSubmissions function, change:
$searchSql .= ' AND ea.user_id = ?';
$searchSql .= ' AND ea.editor_id = ?';
*** Bug 8154 has been marked as a duplicate of this bug. ***
Should be marked resolved per https://github.com/pkp/ojs/commit/3d3925d0b58dde6068466601e40083dcce86fb82
Yes -- thanks, Clinton.